Tuesday, May 17, 2011

backing up wordpress database with phpMyAdmin 2.10.3

To backup the fle4 WordPress sites requires 2 steps, first is the backup of the database of comments etc.  The second is the back up of all of the files on the server which are inside the database folder, in my case, "blog".

Backing up the database with phpMyAdmin 2.10.3
  1. Go to the dashboard of the base site, go to Tools menu on the side and select phpMyAdmin.
  2. Scroll to the top, click on the "export" button.
  3. On the next page in the "Structure" section check the 2 boxes: "Add DROP TABLE" and "Add IF NOT EXISTS"
  4. At the bottom make sure the "Save as File" box is checked.
  5. If the database is very large use some kind of compression method otherwise simply click, "Go" and the backup file will be downloaded and saved onto your local computer.  
  6. The name of the backup is "database name.sql"  since my database name is "blog" the backup was called, "blog.sql".  The name of the database is perhaps the name of the directory that holds all of the files for the instance.
Step 2: Scroll to the top and select the "Export" tab.
Steps 3 and 4: Check the additional boxes as described and shown above.

Backing up the files in the database:
  1. Find the location of the directory that holds all of the database files on the server--my were in: /var/www/html/blog/.
  2. So then I downloaded them: scp -r username@ipaddressofserver:/var/www/html/blog ~/Desktop
  3. And 1,802 files later they were in the folder "blog" on my desktop!
I got the base of this info from: http://codex.wordpress.org/WordPress_Backups#Simple_Backup

    No comments:

    Post a Comment