mysqldump output rejected by mysql client
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.
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.