how to download mysql databases

[Fandelem]

does anyone know how to do this? :D

i mainly want to just backup my databases periodically incase the server crashes or something.. but can you save/import the database to something like excel? (just curious)

any help would be great

~kyle

[Sweede]

mysqldump -u username -p database > output.sql

[Strike]

I was about to say the same - just make a dumpfile and download that.

[Fandelem]

wow. that was awesome.. worked like a charm. hehe dang it's 2megs, that's insane.. gonna take forever to download ;o)

is there anyway to specify a certain table within the database or no? i think i'll readup on mysqldump :D

~kyle

[Mikey123]

You may want to check out phpMyAdmin which is an excellent web based front end for a mysql db written in php.
http://www.phpwizard.net/