Backing up huge MySQL database

Python

What is the best way to backup a huge mysql database? I mean a database with about 30,000 tables

Any ideas?

Arestia

If you have root access, this is a solution.

I would use a SSH based ftp client to log in using root access. Available Here:
http://ftp.ssh.com/pub/ssh/SSHSecureShellClient-3.2.9.exe

When logged in you can go to /var/lib/mysql/databasename/ and download all of the files on there to your computer. These files contain all of the tables and their data and can be simply uploaded to the same directory to restore the database to your backup version.

I recently had to transfer a very large MySQL Database from one server to another. I found this to be the best way.

Hope this helps
-Dan

martian2k4

Thats pretty sweet, I may have a look at it aswell (even though my database is tiny )

daboss

are you sure the database contains 30,000 tables? it's very difficult to believe

martian2k4

I think PY is just starting disscoussions and this is a good one coz you know in a few years when i got 30,000 database tables i will know what to do