copy database

[DePhillips, Michael P]

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

 

 

# mysqldump --opt db1  | mysql db2 

ERROR 1065 at line 23: Query was empty

 

Any insight would be very helpful

 

Thanks

 

Michael