Try using the actual MySQL dump command mysqldump --B<database> --tables<optional> -u<username> --opt -p<password> -h<host> | mysql -u<username> -p<password> -h<host>
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/5/04, 10:46:21 AM, UpFront Technology <[EMAIL PROTECTED]> wrote regarding migrating mysql database: > Hello, > I am trying to copy the "mysql" database to a new MySQL server. I have > tried the mysql dump method: > dump data into a file > mysql2.sql > move file to the new server > execute: > mysql -u root -p -e "source mysql2.sql" mysql -on the new server > I continue to get the following error: > ERROR 1062 at line 16 in file: 'mysql2.sql': Duplicate entry '%-test-' for > key 1 > I was successful with a database that did not already exist on the new > server, I assume the fact that "mysql" already exists is the issue. How > would I get around it. > thanks > Joe > UpFront Technology > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]