How to import a big database when xcart / phpmyadmin cant
If your trying to import your database via xcart admin or by using phpmyadmin and its too big and times out then use this
http://www.ozerov.de/bigdump.php pretty straight forward Alternativly if you have SSH access then you can use the following commands to backup / restore databases Code:
mysql -u[Username] -p[Password] [Database Name] < filename.sql - Dump a SQL file into a MySQL database. Note the "<". eq.. to be done from the folder where you want the file to be saved Code:
mysql -umyusername -pmypassword mydatabasename < myfilename.sql Code:
mysql -u[Username] -p[Password] [Database Name] > filename.sql - Dump a MySQL database to a SQL file. Note the ">". eg.. to be done from the folder where the sql file is Code:
mysql -umyusername -pmypassword mydatabasename > myfilename.sql |
All times are GMT -8. The time now is 07:20 AM. |
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.