Hi,
yes, the create database succeeds. It's in a show databases. The error
message is complaining about "`db1`" (i.e. quotes followed by backtick).
I'm actually using rsync to copy the file (faster than ftp for some
reason). But it also failed when I originally ftp'd it.
I've also tried the mys
Ian, those backticks are standard stuff for mysqldump.
A couple of thoughts -
1, are you sure your 'create database' succeeds?
2, long shot, but are you FTPing in ASCII mode? This *might* mess up
the backtick character.
3, instead of cat file.sql | mysql, try this
mysql -u root -p < file.sql
HT
Hi,
I have 2 identical Linux machines setup with identical my.cnf files
(except for server-id) and both running 5.0.26.
On server A, I run,
mysqldump -h localhost -u root -p... --single-transaction --flush-logs
--delete-master-logs --master-data=1 --databases db1 db2 > dumpfile
I copy dumpf
