How to import a big database on phpmyadmin

How to import a big database on phpmyadmin (1 Replies, Read 38152 times)

peopleinside	October 17, 2019, 8:08 am
Group: Member Post Group: Super Member Posts: 1394 Status: Open source, web and security passionate	Hi to all, different times i had issues when i need to migrate from a server to another in particular when i need import a database that is bigger than 50 MB This post may help me in the future and can be useful also to other users.Centos 7 You need use SFTP than locate /usr/local/webuzo/enduser/webuzo/phpmyadmin/ Edit config.inc.php find Code $cfg['UploadDir'] = ''; than compile likle this: Code $cfg['UploadDir'] = 'upload'; Create the folder upload on /usr/local/webuzo/enduser/webuzo/phpmyadmin/ by SSH go to /usr/local/webuzo/enduser/webuzo/phpmyadmin/upload/ Type in this command: mysql -p -u user_name database_name < file.sql (replace 'user_name', 'database_name', and 'file.sql' with the actual name.) You will be prompted for your database user password, and then your database will be imported. ----------------------- PeopleInside Web, security, open source passionate.
IP: --

Users viewing this topic
	1 guests, 0 users.