MySQL dump all databases?

[Wanch]

Is it possible to dump all MySQL databases into a SQL file so I can move the databases to a new MySQL server? I've been doing it 1x1 but realized there are some databases that I may miss (like the horde database).

[Jordan]

This is possible, I had to look in the manual and found it here:

MySQL :: MySQL 5.0 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program

You can dump all databases by doing:

# mysqldump [options] --all-databases

An example would be:

# mysqldump -u root -p --all-databases > all_dbs.sql

If you just want to dump several databases into one file:

# mysqldump [options] --databases db_name1 [db_name2 db_name3...]

An example would be:

# mysqldump -u SomeUser -p --databases mydb1 mydb2 mydb3 > myDbs.sql

[Prog]

There is also a way to iterate through all tables but I cannot remember it.

[Wanch]

Jordan's suggestion works. Thanks for your help!

[tecktalk]

yeah!.. he is the god of this forum and is very talented person.. i love him just anyways.. Hey Jordon.. I would too like to know something but about the installation of programs in linux as I am just new in linux as I was using Windows previously and just confused about everywhere.. I am using ubuntu..
Can you please tell me where I can get main programs like media players. for linux the basic things??

____________________
corporate awards thermaclear

[WingedPanther]

I would use Synaptic for that. Ubuntu has it labeled something like an Add/Remove programs. It will download the necessary files from the internet.