PerconaDB

Iš Žinynas.
Peršokti į: navigacija, paiešką

Backup[keisti]

xtrabackup --backup --target-dir=backup_dir/

Restore[keisti]

xtrabackup --prepare --target-dir=backup_dir/
rsync -avrP backup_dir/ /var/lib/mysql/
chown -R mysql:mysql /var/lib/mysql

Klaidų sprendimas[keisti]

Vienos DB backup/restore[keisti]

backup[keisti]

innobackupex --databases="duombaze" backupas/
innobackupex --apply-log --export backupas/2017-04-05_16-53-54/
tar cfpz backupas.tar.gz backupas/
scp -r backupas.tar.gz root@remote:

restore[keisti]

systemctl stop mysql
tar xzf backupas.tar.gz
rsync -avrP backupas/2017-04-05_17-07-09/ /var/lib/mysql/
chown -R mysql:mysql /var/lib/mysql
systemctl start mysql

InnoDB: Cannot calculate statistics for table `clients`.`blah` because the .ibd file is missing.[keisti]

ALTER TABLE clients IMPORT TABLESPACE; show warnings;