Menu
mysqldump -h xxx.xxx.xxx.xxx -u username -ppassword databasename > C:\path\to\store\file It seemed to work as it paused while the file was downloading, however no file appears once it completes.
Do I have something wrong in the command line?
648
Open a new terminal window. Direct your local MySQL client to 127.0. 0.1:3306 with the MySQL server username and password. Your connection to the remote MySQL server will be encrypted through SSH, allowing you to access your databases without running MySQL on a public IP.
Use like this:
mysqldump -P3306 -h192.168.20.151 -u root -p database > c:/my.sql Hope to help you:)
Edition for linux
mysqldump -u root -p databasename > ~/Downlaods/filename.sql If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
