Difference between revisions of "MySQL/porting/data"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
Line 29: Line 29:
backup, then click '''Go'''.
backup, then click '''Go'''.
Good luck :E
Good luck :E
==Related Resources==
*[http://members.lycos.co.uk/wipe_out/automysqlbackup/ AutoMySQLBackup]

Revision as of 19:19, 20 April 2005

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

Related Resources