X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Forum FAQs and guides (https://forum.x-cart.com/forumdisplay.php?f=30)
-   -   How to import a big database when xcart / phpmyadmin cant (https://forum.x-cart.com/showthread.php?t=15033)

shan 07-06-2005 12:06 PM

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 "<".
Replace "[Username]" with the database username (generally controlpaneluser_databaseuser). Replace "[Password]" with the database password and replace "[Database Name]" with the database name. Finally change "filename.sql" to the correct filename/location.


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 ">".
Replace "[Username]" with the database username (generally controlpaneluser_databaseuser). Replace "[Password]" with the database password and replace "[Database Name]" with the database name. Finally change "filename.sql" to the correct filename/location.


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:55 AM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.