Re: mysqldump quotes in MySQL 5.0.26

2006-10-11 Thread Ian Collins
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

Re: mysqldump quotes in MySQL 5.0.26

2006-10-11 Thread Dan Buettner
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