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 10000000 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]
