1
vote
1answer
81 views

MySQL InnoDB Backup: are dump files enough?

What exactly does the default ibdata1 file store that does not exist in a mysqldump? I've got a backup/rsync job that stores dump files of a MySQL 5.5 database on a remote server for rotating ...
1
vote
3answers
274 views

MySQL Backup and Recover

I have been running mysqldump on my set of MySQL databases (MyISAM and INNDOB). Recently I wanted to restore the databases to another server, and so I created the databases and imported the dump file. ...
2
votes
1answer
149 views

How do I backup a database to a .sql statement?

How do I backup a database to a single SQL file? After it's backed up, how can I load it/restore the database with InnoDB? It must be InnoDB.
4
votes
6answers
5k views

Is there any equivalent of mysqlhotcopy for InnoDB?

Currently I'm using mysqldump to make backups which is slow, but OKish. The big problem is restoring database, which takes a few days. The dump is around 7GB gzipped, so it's not a tiny database, but ...
2
votes
1answer
676 views

What are reasonable values for --throttle on xtrabackup?

Percona's xtrabackup utility has a --throttle option to reduce the IO load of the backup job. The docs say that the value passed is the number of read/write pairs per second. Is 1000/sec an ...