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 ...
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. ...
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.
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 ...
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 ...