Greetings Community. This isn't really a programming question, but I figured someone in here probably knows how to answer this.

I want to replicate the exact same database on a friends webserver onto my own server here at my house. So I figure what I need to do is create those sql scripts to rebuild everything. And to do that I use mysqldump right?

I've read the syntax's for mysqldump at mysql.com but I'm a lil confused because I connect to my database with multiple options:

is what I type in to connect to my database. And then it prompts me to enter in my lengthy password and then im in. So could anyone please tell me what I would type in to dump out every table from my database into a file that I could then use to source into my own server at home? Ps. I use SSH to establish this connection.

Thanks for reading and for the replies.

mysqldump -A -a -u root -p >dump.sql

-A all data bases
-a all create options (indexes etc...)
you don't have to be root to run this just a user with enough permission to select on all tables on all db's.

to re-insert

mysql -u root -p <dump.sql

-Matt