How can i backup my db and write to the server as a .sql file???

[cemlouis]

How can i backup my db and write to the server as a .sql file???

[Grizzly]

What DBMS are you using?

[Halide]

I have this question too...for MySQL :)

i want a copy of the server's db on my comp as well

[Uranium-235]

if it's mySQL you can use phpMyAdmin

http://www.phpmyadmin.org

[iDxMan]

Without repeating the use of phpMyAdmin (which I recommend first), what format do you want the output? (btw, phpmyadmin does nice csv or any kind of delimited output)

traditional dump format so you can reload it? pipe delimited? etc....

-r


(edit: if you have command-line access, check out the `mysqldump` command for quick dump/load - very handy for transferring the db)

[Halide]

well, with phpmyadmin i have to completely drop the database first, i wish it would be simplified; it should just override the entire database with an .sql file... ;)

[iDxMan]

I only have an old 2.2.3 version in front of me, but maybe the newer ones have that option. (I believe the mysqldump output can create that though `see the --opt arg`

eg: mysqldump -ufoo -p -A --opt >all_dbs.out
)

-r