VDS Sphera Knowledge Base

Main / Browse Categories / MySQL / Having problems backing up your X-cart database?

Print article Print Article    Email article Email Article

Having problems backing up your X-cart database?

You might experience problems trying to utilize X-cart's backup utility if your database has become large or your website is busy.

A better alternative to backing up your database over Apache and PHP is to schedule the backup using the mysqldump command along with a cron job.

The basic syntax for the mysqldump command is as follows:

mysqldump -u [USER] -p[PASSWORD] [DATABASE] > /your/directory/backup.sql
Where:

[USER] = MySQL user name
[PASSWORD] = MySQL Password
[DATABASE] = MySQL Database ie.. xcart

and

/your/directory/backup.sql is the path and filename to the backup file.

Notes:

If you must supply a password then make sure that there is NO space between -p and [PASSWORD]

You may need to supply the full path to mysqldump. You can find the full path by executing the following command via the command line:
which mysqldump

Click here to see how to set up a cron job - "How do I use Cron in my VDS"

Disclaimer:
If you are uncomfortable using the command line via ssh or would just like some help with this. Hardhat charges a nominal fee for this service.

User Comments
Having problems backing up your X-cart database?  
There are no user comments for this topic.
 

Attachments
No attachments.

Related Articles
 How can I connect to MySQL using SSH?
 How can I dump a MySQL database from the command line?
 My Disk Quota is unusually high. What can I do?
 Where is MySQL located?
 Where is the MySQL log file?

Why Choose Our Hosting?

  • Unmatched Customer Support!
  • Virtual Private Server technology provides a rich, dedicated-like environment for every account.
  • We are known for our superb quality, performance and flexible hosting environment. We manage the server, software, and network you do the rest.
Continue reading »

Featured Hosting Plan


Learn more about our VPS Extreme

What is Included?

  • PHP 5/MySQL 5
  • Parallels® Plesk Panel 10
  • Unique IP Address
  • Daily VPS Backups (Off Server)
  • SAS Hardware Raid diskspace
  • CentOS 5 x86_64 bit
  • Multi-homed Tier 1 Bandwidth
  • Full Upgrade capabilities
Continue reading »