MySQL backup and restore - /var/lib/mysql

[Highway]

Hi everyone,

We are creating backups with bacula for a full and incremental backups for our servers.
A client want's to restore his database, I should say, easy:

Restore the /var/lib/mysql/{database} folder and done...
Bacula sets automatic the good chown and chmod.

Uwhm... no.

The database is'nt restored, only a few tables with some records.

For testing purposes, I have downloaded one other full working and complete database to my localhost, and same problem, so this isn't a bacula issue.

Do I something wrong or forget I something? Can't figure it out...

Database are both magento.

 

[zEitEr]

Hello,

Firstly, you'd better not do incremental backups directly on /var/lib/mysql/. Dump dbs to a file, then backup it.

Secondly, If you're creating backups with bacula, then it mostly has nothing to do with Directadmin and MySQL. You should consult with bacula's documentation.

 

[Highway]

Are there no other data directories from mysql?

 

[scsi]

No everything is in /var/lib/mysql

You should be backing up mysql databases with mysqldump though anyways