MySQL backup

[roni]

Backup instructions on manual

[bogdan.sh]

Hello Fernando.

In backup documentation we do dump all databases, however copy only system mysql database. As far as we know privileges are not dumped properly with mysqldump so better to have system database as is.

The error after mysql_upgrade means that most probably someone did a database backup with just copying database name to /var/lib/mysql/t1rue2kea3dv-wwwtrue_true , and most probably there are duplicate keys in it. Please move out that directory from /var/lib/mysql and run mysql_upgrade again.