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 37574 times)
peopleinside
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
  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:

Web, security, open source passionate.
IP: --   

How to import a big database on phpmyadmin
peopleinside
Group: Member
Post Group: Super Member
Posts: 1394
Status:

Open source, web and security passionate
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.
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 28, 2024, 5:48 pm.

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