X-Cart forums

[shan]

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

 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

mysql -umyusername -pmypassword mydatabasename < myfilename.sql

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

mysql -umyusername -pmypassword mydatabasename > myfilename.sql