Backing up huge MySQL database

[shield]

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 :p)

[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 ;)