Guest ColeFlournoy Posted November 12, 2005 Share Posted November 12, 2005 Hi, I am wondering if anybody has any tips on backing up (and then restoring) the database for your store, just in case your hosting company disappears off the face of the earth. Thanks! Cole Flournoy Quote Link to comment Share on other sites More sharing options...
Guest Andrew T. Posted November 12, 2005 Share Posted November 12, 2005 It shouldn't be too hard to do that. If you have access to PHPMyAdmin, you can get into there, find the DB your store uses and export it. In the Export options, tell it to be gzipped and it will automatically check to save it as a file. It will then let you download it in a compressed unix archive. Or if you use cpanel, you can go into the backup section and select which data base you wish to back up. Restoring it from the Backup section is as easy as backing it. I've done that lots of times when transferring PHP-Nuke site since they are all DB powered. I offer very affordable and very extensive cpanel hosting so I've dealt with alot of DB backing up and restoring. If I can be of any other help, please let me know. My web-site is http://www.computer-e-sources.com Quote Link to comment Share on other sites More sharing options...
Guest Gryphon Posted November 12, 2005 Share Posted November 12, 2005 A lot of competent web services off phpMyAdmin which will allow you to manipulate the database. Check your admin panel for it, there is an export option. If you have ssh access you can type mysqldump --opt -Q -uUSERNAME -p DATABASENAME > /PATH/TO/DUMP.SQL to restore mysql -uUSERNAME -p NEWDBNAME < /PATH/TO/NEW/DUMP.SQL *edit, didn't see the other reply had my compose window open for a very long time :D Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.