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:
mysql -u <myusername> -p -h <hostname> <dababasename>
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.