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