MySQL log-in and backup

Mysql-h Xxx.xxx.xxx.xxx-u Root-p  

  -H indicates that the server name, localhost, refers to the native-u indicating that the user name root is the default maximum privilege user name-p indicates that the password is not filled means the password is empty


Database script Export to file:
Under Terminal: Mysqldump-u User name-p database name > exported file name
For example   mysqldump-h 10.86.2.122 (IP I doodle ~)-  u yourusername-p yourpassword yourdatabase > ~/datadump

If an error is access denied for the user ' yourusername ' @ '% ' to the database ' yourdatabase ' when using LOCK TABLES
You need to use mysqldump-h 10.86.2.122-u yourusername-p yourpassword yourdatabase--skip-lock-tables > ~/datadump

File Import Database script:
MySQL under: Use   database name             

MySQL log-in and backup