MySQL/migration

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< MySQL
Revision as of 00:17, 16 April 2005 by Woozle (talk | contribs)
Jump to navigation Jump to search

K, here's how I do it:

Backing up

  1. Make sure you've got PHPMyAdmin running

and that's all happy. I won't cover this part here as it varies with your set up.

  1. Login and choose Export from the main page
  2. Leave most of the default options. Specifically,
    • Format: SQL
    • Select the database(s) you want in the listbox
    • etc.
  3. Checkmark 'Add DROP TABLE'. This will make sure that when you restore

from a backup, it will delete existing tables before restoring from the backed up ones.

  1. Checkmark 'Save to file' at the bottom, or it will just dump it to

your browser window, and that's no fun.

    • You probably also want to use compression. These won't be huge files,

but a 1.5mb database compresses to about 150kb. So, y'know, whatever. Wiggy recommends BZIP.

  1. Click Go.

Restoring from backup

I'm writing this from memory, so I might be wrong, but I think it's right.

  1. Click Databases from the PHPMyAdmin main page
  2. Click the name of your databse (it should already exist; have you

[re]installed MediaWiki yet? Do that first.)

  1. Click the SQL tab
  2. Where it says Location of textfile:, browse to your latest

backup, then click Go. Good luck :E