Timeline for 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?
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 18 at 18:32 | vote | accept | Cloud Strifes | ||
| May 2 at 9:23 | answer | added | j4nd3r53n | timeline score: 1 | |
| May 2 at 7:26 | history | became hot network question | |||
| May 1 at 18:45 | answer | added | Rick James | timeline score: 4 | |
| May 1 at 16:14 | comment | added | Akina |
Destination server is in the same network. Think about INSERT INTO federated_table SELECT * FROM local_table; - see mariadb.com/kb/en/federatedx-storage-engine
|
|
| May 1 at 16:14 | answer | added | Kondybas | timeline score: 6 | |
| May 1 at 16:10 | comment | added | Charlieface |
Maybe pipe the output to ssh then pipe it back in on the other side? But I don't think you can do that using mariabackup because you need to use --prepare first. Maybe rsync?
|
|
| May 1 at 14:19 | history | edited | Cloud Strifes | CC BY-SA 4.0 |
added 2 characters in body
|
| S May 1 at 14:19 | review | First questions | |||
| May 1 at 18:52 | |||||
| S May 1 at 14:19 | history | asked | Cloud Strifes | CC BY-SA 4.0 |