BACKING UP AND RESTORING DATABASES USING PHPMYADMIN (LEGACY) - Aug 4th, 2010

***NOTE: The facility for automatic database backup was incorporated in version 1.34 which was released on September 8, 2009. See the section GIVE YOUR CLIENTS A SECURE FEELING WITH AUTOMATIC BACKUPS in the Best Practices section for more specific information on this topic. This example was written for a database called “web_cms ” which is stored on a server at IXWebhosting.com, so your specifics will differ, but the basic approach is the same. It is here for informational purposes only. IXWebhosting.com offers a utility program called “phpMyAdmin” to create database backups. It is important to follow all of the instructions below since phpMyAdmin can also be used to make changes that will make the data unusable on the web site. To back up the databases: 1) Log on to the IXWebhosting control panel at https://manage.ixwebhosting.com with the username and e-mail address given to you by the administrator. 2) Click the “Manage” icon under “Hosting Products”. 3) Scroll down to the “Databases” section and click the “phpMyAdmin” icon 4) Login to phpMyAdmin by clicking on the “launch” icon to the right of the user web_abcdadm. You will be backing up the 2 databases that store the web site’s information. They must be backed up one at a time. One database is named “web_cms ” and the other is named ”information_schema“. 5) On the pull down menu on the left, select the web_cms 6) Click the 'export' tab located near the top of the screen. 7) In the left “export” section, click “select all” 8) Check the format type “SQL” (if it is not already checked) 9) On the right, in the “structure” section check the “Add DROP TABLE / DROP VIEW” box 10) Leave all other options at their default settings 11) At the bottom, check 'Save as File'. You do not have to change the file name template information. 12) Click the “go” button Depending on your browser's settings, the backup file may automatically download or your browser may prompt you to save the file. If prompted, click “save” and “OK”. After the backup has been saved to your computer, select the ”information_schema“ database from the pull down menu on the left, and repeat steps 6 through 12 That’s it, you can close the browser window for phpMyAdmin. Your database has been backed up. Here’s a link to a video tutorial that will walk you through the process. Some of the screens may be slightly different due to software upgrades, and the details of navigating to your phpMyAdmin may differ, but the tutorial is very detailed. http://www.ixwebhosting.com/index.php/v2/pages.Tutorial_02

Terms of Service