On Oct 6, 2004, at 10:36 AM, Chuck Bishop wrote:
I found some information on http://meta.wikimedia.org/wiki/How_to_move_a_MediaWiki_Database regarding dumping and restoring the sql database. The dump seems to work fine. However, when I try to restore the database, I receive the error, ERROR 1050 at line 11: Table 'archive' already exists
Were you restoring into a blank, newly created database or one that already had a wiki in it?
If the latter, you need to either manually remove the old tables or make your dump with the --add-drop-tables or --opt options to mysqldump.
How can I restore the database? Also, are there any other files which should be backed up?
Uploaded images and any config or customized code files that you want to keep.
-- brion vibber (brion @ pobox.com)