I appreciate the suggestion, but I'm not looking to drop anything. I only want it as a safety net in the event that the table doesn't already exist. I'm doing syncing of sorts, and I want the CREATE TABLE IF NOT EXISTS so as not to throw errors in the event that the table already exists, and to add if it's the first time a particular DB is syncing, etc. I never want to drop.

Regards,
Michael

On Jan 16, 2006, at 6:22 PM, Jake Peavy wrote:

DROP TABLE IF NOT EXISTS?

On 1/16/06, Michael Williams <[EMAIL PROTECTED]> wrote:
Hi All,

Having a bit of mysqldump trouble again.  I've looked over the
documentation (again) and can't seem to find the flag to make
'mysqldump' out put   "CREATE TABLE IF NOT EXISTS".  Any ideas?

Regards,
Michael


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED]



Reply via email to