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]