How to backup mysql folder

3 posts / 0 new
Last post
#1 Sat, 10/31/2009 - 05:34
secret

How to backup mysql folder

Hello, I have need to configure autobackup for backup mysql folder located on /var/lib/mysql. I see only this option on backup page : "Contents of server's MySQL databases". This option create a dump of all databases, but I have need a simply backup of mysql forlder and not the dumps. How to create this option?

Sat, 10/31/2009 - 10:00
andreychek

Howdy,

Performing dumps are a common way that MySQL databases are backed up, and can later be used to easily restore the data.

That's also Virtualmin's primary way of backing them up.

If that's not what you want, you can explore other MySQL backup options, such as using the "mysqlhotcopy" tool from the command line. But you'd have to configure them all manually.

Also of note -- it's not possibly to just copy the files in the MySQL data folder while MySQL is running. Doing so would make the data in the files inconsistent.

Personally, I use Virtualmin's built-in database backup, as it does exactly what one needs in a backup... it provides a full database backup so that it can be later restored if something goes wrong.

-Eric

Mon, 11/02/2009 - 00:42
secret

I have need backup of mysql directory with the virtualmin backup system and not the dumps. Someone have one solution?

Topic locked