Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls
 

How to import a big database when xcart / phpmyadmin cant

 
Reply
   X-Cart forums > Forum FAQs and guides
 
Thread Tools Search this Thread
  #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
Reply
   X-Cart forums > Forum FAQs and guides



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 10:49 PM.

   

 
X-Cart forums © 2001-2020