Re: how to migrate data from mysql 4.1 to mysql 5.0
Posted by: kanchan thukral
Date: July 14, 2005 09:32PM

hello all
i got the solution

but where we want to migrate data.there must be database with the
name in which we want to shift

mysqldump -h localhost -P <port number of mysql 4.1> <database name of 4.1> | mysql -u root -p -h localhost -P <port number of mysql 5.0> -C <database name of 5.0>

how i run actually

1) create the database

create database if not exist Address

mysqldump -h localhost -P 3306 OldAddress | mysql -u root -p -h localhost -P 3307 -C Address

we have to run this in the command promt but not in mysql.
we can run this directly.on the command prompt

Options: ReplyQuote


Subject
Written By
Posted
Re: how to migrate data from mysql 4.1 to mysql 5.0
July 14, 2005 09:32PM


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.