Mailing List Archive

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)

Thanks Brion. I was trying to restore over an existing database and
your suggestion seemed to work fine.

Is there any potential problems importing a backup database over an
existing one?

Thanks,
Chuck

-----Original Message-----
From: mediawiki-l-bounces@Wikimedia.org
[mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of Brion Vibber
Sent: Wednesday, October 06, 2004 2:20 PM
To: MediaWiki announcements and site admin list
Subject: Re: [Mediawiki-l] Dumping and restoring database

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)


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************