Dirk: Some minor additions and corrections

2009-05-10T17:25:26Z

Some minor additions and corrections

Julianna at 16:42, 14 April 2006

2006-04-14T16:42:50Z

New page

== 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 ===

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

=== 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. <b>Before you delete your database, make sure you have created a backup! There is no Undo button.</b>

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

==== Restore a database ====

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

@@ Line 6: / Line 6: @@
 # Log into your site.
-# In the <b>Admins Only</b> block on the left, click the "DB Backups" link. Any previously created backups will be listed here.
+# In the [[Admins Block|Admins Only]] block on the left, click the "DB Backups" link. Any previously created backups will be listed here.
 # Click the "Create New" link.
-# If you want to store a copy of the backup on your computer, you will need to download it via FTP (or however you access your site to upload and download files). The backups are stored in the backups/ folder.
+# 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.
 === 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.
+These instructions are for use with website hosts who provide [http://www.phpmyadmin.net/ 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 ====

Backup and restore a database - Revision history

Dirk: Some minor additions and corrections

Julianna at 16:42, 14 April 2006