Banish --compact option to mysqldump command line, especially with dotclear2 backups. You will save some hours when you will try to restore[1] a backup :-)
This option suppresses comments and enables the --skip-add-drop-table, --no-set-names,
--skip-disable-keys, and --skip-add-locks options. There was some huge problems that I'm not able to explain because of my very low level in databases knowledge. But I saw some problems with keys between tables.
A database-killer could perhaps explain the problems with logical explanations.
One day, I will perhaps looking for some helps about that. I will let you know if I find something.
Comments
Can you detail what happened with this option and your backup?
A database-killer could perhaps explain the problems with logical explanations.
One day, I will perhaps looking for some helps about that. I will let you know if I find something.