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 HTH, Dan On 10/11/06, Ian Collins <[EMAIL PROTECTED]> wrote:
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 dumpfile to server B and extract with, mysqladmin -u root -p... create db1 mysqladmin -u root -p... create db2 cat dumpfile | mysql -u root -p... I get the error, ERROR 1049 at line 25: Unknown database '`db1`' Note the backticks around the database name. Looking at dumpfile, I see, use `db1` I tried doing the mysqldump with --compatible=ansi which changes the backticks to double quotes, but get the same error, ERROR 1049 at line 25: Unknown database '"db1"'. I can't edit dumpfile as it is 8Gb (ok, I can split it and stuff like that ... but come on!!) What am I missing here? Has anyone else seen this? Regards, Ian Collins.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
