Dumping database information into a .sql

[zhchua]

I would like to know, lets say I have a few tables with username\password info in it and I would like to carry that info around with me in a form of .sql, can it be done?

How?

[FatPiper]

Sure ..
PHPMyAdmin has a dump table function you can use. It'll even send it as a download (which is probably the best). Or you can just have it dump the whole database.
Otherwise, you can write a simple PHP script that'll output everything in a comma delimited format or something like that .. email/post for an example

[Overgrow]

man mysqldump

mysqldump -p databasename optionaltablenames > file.sql

Lots of options on the dump command.. OPT is usually a good idea, also lock the tables, and a few other things. to read it back in:

mysql -p < file.sql

[Son Nguyen]

.sql is not a specific extension in this case if the file only contains SQL query
I can name it: "backup.sql", "backup.txt" or just "backup"
All contains the same thing: TEXT

However, if there is .sql which aren't contain SQL query or it's a binary file then that's a different story.

[lirux]

I'm also really interested in this one. I have a db called liruxdb; After reading this post, I supose all I'd need to do is:

1: Login using telnet

3: type :
mysqldump -p liruxdb > file.sql
Type no table names becouse I want them all backed up

4: be prompted for my password ant type it in

6: close telnet

7: Login to FTP and download my file

is this right? Don't I need to start mysql (mysql -u username -p)?

Thanks 4 Ur help ppl!

[Son Nguyen]

You need your user name and to obtain the fastest dump, use --opt

mysqldump --opt -u usr -p DBNAME > file.sql

[lirux]

Thanks son