Click to See Complete Forum and Search --> : how to download mysql databases


Fandelem
04-22-2001, 10:40 PM
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
04-23-2001, 04:45 AM
mysqldump -u username -p database > output.sql

Strike
04-23-2001, 09:22 AM
I was about to say the same - just make a dumpfile and download that.

Fandelem
04-23-2001, 01:10 PM
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
04-23-2001, 01:42 PM
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/