Re: how to migrate data from mysql 4.1 to mysql 5.0
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
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.