Re: Transfer a few data databases
Posted by:
Zhen Qu
Date: January 12, 2022 02:37AM
mysqldump and xtrabackup can both do the job you required.
mysqldump can generate sql scripts of creating tables and inserting data but it's slower in the case of moving and restoring big database to another machine.
xtrabackup can be used to create physical backup files exactly as what you can find in mysql data directory. For the convenience of transferring file, you can also backup mysql data files in tarball with the help of xtrabackup.
If you choose xtrabackup, you need to use the correct version.
Subject
Views
Written By
Posted
959
March 02, 2021 04:05AM
529
March 02, 2021 11:29AM
634
March 02, 2021 04:34PM
517
March 02, 2021 04:42PM
508
March 02, 2021 04:51PM
520
March 02, 2021 04:56PM
500
March 02, 2021 06:43PM
497
March 02, 2021 06:49PM
Re: Transfer a few data databases
393
January 12, 2022 02:37AM
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.