use the --opt option for mysqldump.
--opt Same as --add-drop-table --add-locks --all
--extended-insert --quick --lock-tables
Other than that, it's the method I use.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-----Original Message-----
From: Jesse Sheidlower [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 11:30 AM
To: [EMAIL PROTECTED]
Subject: Stupid backup/restore question
I have a working server and a development server. From time to time
I'd like to "refresh" the content of my development server with what's
on my working server. So I take one of my regular backups, that I get
by doing "mysqldump database > dbbackupJuly1-02". Then I gzip this,
ftp it over to my development server, gunzip it, and try "mysql
database < dbbackupJuly1-02", and immediately get an "ERROR 1050 at
line 11: Table 'firsttable' already exists" message.
What should I be doing instead? The docs don't seem to specify this,
and there doesn't seem to be an "ignore" or "replace" option for the
mysql command. Do I actually have to drop all the tables on my
development box before loading in from the backup?
Jesse Sheidlower
<[EMAIL PROTECTED]>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
