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)