[Mediawiki-l] Dumping and restoring database

Wed Oct 6 17:36:55 UTC 2004

Hi,

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

bash-2.05b$ mysqldump -u root -p wikidb > /tmp/wikidb.sql

Enter password:

bash-2.05b$ ls -la /tmp/wikidb.sql

-rw-r--r--  1 wikiuser wikiuser 377369 Oct  6 13:34 /tmp/wikidb.sql

bash-2.05b$ mysql -u root -p wikidb < /tmp/wikidb.sql

Enter password: 

ERROR 1050 at line 11: Table 'archive' already exists

bash-2.05b$

How can I restore the database?  Also, are there any other files which
should be backed up?

Thanks,

Chuck Bishop

**********************************************************************
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
**********************************************************************