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