How to copy MySQL 1:1 from one server to another

D

docenta

Well-Known Member
May 9, 2006
64
0
156
Hello old server do not have CPanel and it is 4.0.x MySQL version and new one is with CPanel and 4.1.x MySQL version.



Thanks in advance.
 
S

spector

Well-Known Member
Jun 27, 2005
51
0
156
you can safely copy databases from mysql 4.0 to 4.1. I did it. Just copy all database files including "mysql" database. Be sure that you want upgrade mysql. Your users can expect many problems after upgrading so I advice keeping old databases intact (it will be modified after copying to 4.1 and running server - especialy "mysql" internal database). You wont be able to downgrade from 4.1 to 4.0 if you will not keep not modified "mysql" internal database (at least its not easy).
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
N Advanced install, I need to make an exact copy of a cPanel server, but how to do the MySQL version? Databases 6
N Use Remote MySQL but keep a slave copy on main cpanel web server. Databases 0
G Copy account from other server - mysql Store Procedures Problem Databases 0
M Copy account fron another server will retrieve also mysql passwords? Databases 1
F "The MySQL server is currently offline" after copying mysql data dir Databases 3
Similar threads
Advanced install, I need to make an exact copy of a cPanel server, but how to do the MySQL version?
Use Remote MySQL but keep a slave copy on main cpanel web server.
Copy account from other server - mysql Store Procedures Problem
Copy account fron another server will retrieve also mysql passwords?
"The MySQL server is currently offline" after copying mysql data dir
Top Bottom