Welcome Guest. Please Login or Register  


You are here: Index > Webuzo > General Support > Topic : How to import a big database on phpmyadmin



Threaded Mode | Print  

 How to import a big database on phpmyadmin (1 Replies, Read 155 times)
peopleinside
Group: Member
Post Group: Super Member
Posts: 1272
Status:
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
  1. You need use SFTP than locate /usr/local/webuzo/enduser/webuzo/phpmyadmin/
  2. Edit config.inc.php find
    Code
    $cfg['UploadDir'] = '';
    than compile likle this:
    Code
    $cfg['UploadDir'] = 'upload';
  3. Create the folder upload on  /usr/local/webuzo/enduser/webuzo/phpmyadmin/
  4. by SSH go to /usr/local/webuzo/enduser/webuzo/phpmyadmin/upload/
  5. 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:
Passionate Webuzo User
IP: --   

How to import a big database on phpmyadmin
peopleinside
Group: Member
Post Group: Super Member
Posts: 1272
Status:
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:
Passionate Webuzo User
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is November 20, 2019, 4:33 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.159