Category: Articles
Posted: Feb 2, 2010
Synopsis: The x-cart DB Backup/Restore functionality no longer backups up your entire database.
In your x-cart admin section you have an x-cart admin area called DB Backup/Restore, which theoretically should let you backup your entire x-cart database, and then easily restore it.
The backup tool however does not backup your entire x-cart database, and instead only backs up the default xcart tables. If you have any custom tables, which are common when installing x-cart mods/addons or creating customizations, they will not be backed up. This means if you backup using the DB Backup/Restore x-cart section, drop your database, and then restore from the x-cart DB Backup/Restore section, you will lose your non-default x-cart tables and all of the associated data. Additionally, if you've made permission changes to your default x-cart tables, such as adding full text indexes, they may not restore correctly.
Instead of using the x-cart backup/restore, we recommend that you instead use mysql or a program such as phpmyadmin to backup your x-cart database. See Moving X-Cart Database in our X-Cart Tutorials section.