Re: mysqldump quotes in MySQL 5.0.26
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 mysql -u root -p < file.sql as well with no difference. I actually got the database in by doing a "split -b 1000 dumpfile" as I can edit a 10Mb file, but not a 10Gb one - and then joining them back together - bit of a hack but it worked. Strange. Regards, Ian. Dan Buettner wrote: 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]
Re: mysqldump quotes in MySQL 5.0.26
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]
mysqldump quotes in MySQL 5.0.26
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]