Backup and restore a database

From GeeklogWiki
Revision as of 17:25, 10 May 2009 by Dirk (talk | contribs) (Some minor additions and corrections)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Intro

It is advisable to create a backup of your database regularly (or after major changes to your site). With these backups, you can restore all of the data on your site.

Creating A Database Backup In Geeklog

  1. Log into your site.
  2. In the Admins Only block on the left, click the "DB Backups" link. Any previously created backups will be listed here.
  3. Click the "Create New" link.
  4. If you want to store a copy of the backup on your computer, you can click on the name of the backup file to download it. Alternatively, you can download it via FTP (or however you access your site to upload and download files). The backups are stored in the backups/ folder.

Note: The "DB Backups" option is only available when your site is running on MySQL.

Restoring A Database In phpMyAdmin

These instructions are for use with website hosts who provide phpMyAdmin for the administration of databases. Please contact your website host for information on how to access phpMyAdmin (if available) or to determine what is available for you to manage your database.

Delete your existing database

Before you can restore your database, you will need to delete the existing one. Before you delete your database, make sure you have created a backup! There is no Undo button.

  1. Log into phpMyAdmin .
  2. Select your database from the dropdown list on the left.
  3. In the main window (the large one on the right), scroll to the bottom and click "Check All".
  4. In the "With selected" dropdown box, select "Drop".
  5. Click the "Yes" button to confirm that you want to drop the tables.

Restore a database

  1. Log into phpMyAdmin if you haven't already.
  2. Select your database from the dropdown list on the left.
  3. Click the "SQL" tab at the top of the main window.
  4. Click the "Browse" button. Find and select your database-backup file.
  5. Click the second "Go" button.