backup your mysql db ?

[mmccue]

Quirky question on my mind...

can I backup a remote hosted mysql db? I can't access the .db (or whatever mysql extensions are) file itself... is there a way that I can dump all the data into a delimited file, download it... and if there's a problem later, upload it and read it back in?

Thanks,

Mike

[RAGE]

mysql has a "dump" function which u can utilize,. the easiest way is that mysql has a shell program called "mysqldump" .. which will do the query stuff for you, u just need your mysql password + database... telnet to the server, find out where mysqldump is (the same place where the mysql binary is) and run it with --help to see its options, you can dump specifi tables or whole databases..

------------------
Vinay Sahni (vinay@kryogen.com), Coder .. specializing in php/mysql
( Realmz ) ( ReviewDepot ) ( . . : : k r y o g e n : : . . )

[Karl]

If you have PHP installed on your web server you could use phpMyAdmin from http://www.phpwizard.net to do the job for you. This way is much easier if you don't like messing about with telnet. It also has many other functions that you will probably find useful.

------------------
Karl Austin
KTech Design Associates - No URL Because It's Not Finished