Database Migration

krizag

• July 29, 2022 10:30

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

  • July 29, 2022 17:12

  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.

  0
• 

  HostNoc

  • August 20, 2022 02:33

  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,

  0

Please sign in to leave a comment.