Skip to main content
Share Your Experience: Take the 2024 Developer Survey
6 votes

MariaDB / MariaBackup : What is the best way to export/migrate a 700GB table to another server, but with only 200GB of free space at the origin?

You can stream your dump directly from one host to another with no temporary files on disk at all: mysqldump -u user -ppass dbname tablename \ | gzip --stdout \ | ssh ...
Kondybas's user avatar
  • 4,448
4 votes
Accepted

MariaDB / MariaBackup : What is the best way to export/migrate a 700GB table to another server, but with only 200GB of free space at the origin?

Assuming the bandwidth is high, do this on the destination server: $ mysqldump -u ... -p... -h source_host dbname tablename | mysql -u ... -p... dbname (If the bandwidth is low, ...
Rick James's user avatar
  • 78.3k
1 vote

MariaDB / MariaBackup : What is the best way to export/migrate a 700GB table to another server, but with only 200GB of free space at the origin?

You can, certainly in Linux/UNIX, mount a network filesystem from your target system - say, your DB is on src and you want to copy to tgt. In linux you can use NFS (install NFS server on tgt, NFS ...
j4nd3r53n's user avatar
  • 231
1 vote
Accepted

Does MySQL invalidate or amend a cached table when rows are added, updated or deleted?

InnoDB is a journaled engine that allow transactions. Each write to the InnoDB-backed table is a single atomic transaction. When cached table is written, all changes are written to the journal first, ...
Kondybas's user avatar
  • 4,448

Only top scored, non community-wiki answers of a minimum length are eligible