List:General Discussion« Previous MessageNext Message »
From:UpFront Technology Date:February 5 2004 4:46pm
Subject:migrating mysql database
View as plain text  
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



Thread
migrating mysql databaseUpFront Technology5 Feb
  • Re: migrating mysql databasevpendleton5 Feb