Softaculous

Topic : How to import a big database on phpmyadmin

Posted By: peopleinside on October 17, 2019, 8:08 am

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 :angel:

Web, security, open source passionate.

Posted By: peopleinside on October 17, 2019, 8:10 am | Post: 1

The up procedure is because phpmyadmin get errors if you simply create the upload folder, edit the config file than try to import using the web interface of phpmyadmin
webuzo team told to me this:
You can change the PHPmyadmin import file size with the following steps:

Increase SQL import file size in PHPmyadmin:

You need to change the values of the following variables in /usr/local/emps/etc/php.ini binary file:

upload_max_filesize

post_max_size

Once done, restart webuzo service by executing the following command as root:

service webuzo restart
than try to import from the web interface of phpmyadmin.
I never tried this as the solution in my first post works well and is really fast.. however is good to have more information as possibile.

-----------------------
PeopleInside :angel:

Web, security, open source passionate.