View Single Post
  #1  
Old 07-06-2005, 12:06 PM
  shan's Avatar 
shan shan is offline
 

X-Guru
  
Join Date: Sep 2002
Location: Birmingham, UK
Posts: 6,163
 

Default 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
__________________
Looking for a reliable X-cart host ?
You wont go wrong with either of these.

EWD Hosting
Hands On Hosting
Reply With Quote