[SOLVED] backup mysql with emc networker

backup mysql with emc networker

On a CentOS machine we have mediaWiki + bugZilla installed for internal uses. I'd like to use the EMC Networker that there is in our network to backup the databases.

Is it enough to backup the /var/lib/mysql/ directory ? And if yes, do i need to backup the whole directory (ibdata1, mysql, mysql.sock...) or only the mediawiki DB and bugzilla DB. I saw in this post Backup Mysql Databases that

Blockquote For innodb, you'll need to backup using mysqldump Blockquote

Thanks Sam

Solution

If you want to use a file based backup solution for backup MySQL databases it is best to create a dump of the database and backup the dump. You can create a backup by mysqldump -u root -p --all-databases > dump.sql you might also backup you /etc/my.cnf. Having the configuration makes restoring easier.