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. Hope this helps. Tony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
