List:General Discussion« Previous MessageNext Message »
From:John Millaway Date:September 27 1999 4:31pm
Subject:Knit-picking questions about mysqldump...
View as plain text  
Hi,
1. Is this the preferred way to transfer a mysql db?
  (pseudo-code)
   mysqldump host1 >somefile
   mysql host2 <somefile

2. If so... mysqldump doesn't place "create database" and "use database"
at the beginning of the dump script. It also has no flag for the "IF
EXISTS" syntax. Will I have to edit the dump script before feeding it
into the other database? This is slightly annoying. How can I do a
dump/import such that it will always overwrite an existing database of
the same name if it exists, or create a new one if it doesn't exists
already? 

Thanks,
John
Thread
Knit-picking questions about mysqldump...John Millaway27 Sep
  • Knit-picking questions about mysqldump...Michael Widenius29 Sep