Database Migration

[krizag]

What's the fast way of copying a large database (size is around 150Gb) onto another server? Both old and new servers are cPanel ones and mariadb 10.5 version. I only need to move the db to another server.

 

[ffeingol]

Pretty much the only "safe" way to move it is:

• CLI MysQL dump on the old server
• Transfer the dump from old to new
• CLI MysQL load

I know in the past people have tired to copy the files that make up the DB, but with most DB's having innodb tables now, that's virtually impossible.

 

[HostNoc]

Hello,

First take mysqldump
mysqldump XYZ > XYZ.sql

second scp the dump file from old server to new server

third on new server create DB and user

lastly mysql command on new server
mysql -u abc -p abc_blog < XYZ.sql


Regards,