In a message dated 9/30/03 1:33:07 PM Eastern Daylight Time, [EMAIL PROTECTED] writes:
HI List,
Using version 4.0.15
I'm trying to copy a database. Copy db1 to (new) db2.
So I created db2.
And then tried the following and got the subsequent errors.
# mysqldump --add-drop-table db1 | mysql db2
ERROR 1064 at line 399: You have an error in your SQL syntax near 'count(count),
KEY dataID(dataID)
) TYPE=MyISAM' at line 15
Why not just copy the [MySQL-data-dir]\DB1 to [MySQL-data-dir]\DB2? That
works for me, even when I am moving/copying a database from a Windows machine to
a Linux machine.
What if you have InnoDB tables?
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
