MySQL Forums
Forum List  »  Other Migration

moving database from (win 32bit) MySql 4.0.20a to (redhat 64bit) MySql 5.1.61
Posted by: Florin P
Date: November 14, 2012 09:19AM

I have received a very old system running MySql 4.0.20a on a Windows Server 2003 Standard 32bit.

mysql> status
--------------
mysql Ver 12.22 Distrib 4.0.20a, for Win95/Win98 (i32)

Connection id: 19
Current database:
Current user: root@localhost
SSL: Not in use
Server version: 4.0.20a-debug
Protocol version: 10
Connection: localhost via TCP/IP
Client characterset: latin1
Server characterset: latin1
TCP port: 3306

I would like to be able to transfer/move the database to a CentOS 6.3 64it server, running MySql 5.1.61;

mysql> status
--------------
mysql Ver 14.14 Distrib 5.1.61, for redhat-linux-gnu (x86_64) using readline 5.1

Connection id: 3
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.61 Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock

The engine used is MyISAM.

Are there any howtos anyone can point me to?

Someone was mentioning about "changing the decimal definitions in databases structure dump". Do I need to do it? How is it done?

Show I update to the latest GA version on MySql [ Red Hat/Oracle Enterprise Linux ver. 6 (x86, 64-bit), RPM Package MySQL Server 5.5.28 (MySQL-server-5.5.28-1.el6.x86_64.rpm) ] before attempting to do the transfer/move?

This is my first encounter with the MySql stuff (or any sql server) and I would appreciate all the advice I would get!

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
moving database from (win 32bit) MySql 4.0.20a to (redhat 64bit) MySql 5.1.61
6157
November 14, 2012 09:19AM


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.