MySQL Forums
Forum List  »  Other Migration

mysqldump output rejected by mysql client
Posted by: John Nietzsche
Date: July 26, 2008 07:16AM

Dear friends,

i am in need to migrate a database between two mysql server. The server source is running mysql 4.0.18-log, the destination server is running mysql 5.0.51a-log.

I dumped the database (in the server source) using mysqldump utility. The command i issued in de source sever was:
robigo$ mysqldump -u root -probigoroot genweb > s.sql

It worked alright, but when i try to restore (s.sql) in the server i, mysql (client utility) complains on error and exit, here is the output.

robigo$ mysql -u jpaulo -paivALF genweb < genweb
ERROR 1005 (HY000) at line 11: Can't create table './genweb/contigs.frm' (errno: 150)
robigo$


I am very confused, because the output generated by mysqldump it is refused to be loaded in a new server.

What is my fault??

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqldump output rejected by mysql client
4386
July 26, 2008 07:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.