在服务器上远程链接另一台服务器的数据库的方法how to connet the database from the other host
iwangzheng.com
16:57 [root@a02.cmsapi]$ mysql -u<username> -p<password> -h10.103.xx.xx Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 571 Server version: 5.0.77 Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. (username@10.103.xx.xx) [(none)]> show databases; +--------------------------+ | Database | +--------------------------+ | information_schema | | mvf_for_ykew_development | | test | +--------------------------+ 3 rows in set (0.00 sec) (username@10.103.xx.xx) [(none)]> Ctrl-C -- exit! Aborted tty:[0] jobs:[0] cwd:[/tmp] 16:57 [root@a02.cmsapi]$ mysql -u<username> -p<password> -h10.103.28.25 mvf_for_ykew_development < /tmp/db_bak.20140509.sql tty:[0] jobs:[0] cwd:[/tmp] 16:58 [root@a02.cmsapi]$ mysql -u<username> -py<password> -h10.103.XX.XX mvf_for_ykew_development < /tmp/db_bak.20140509.sql so,how to connet the database from the other host,just try this:
mysql -u<username> -p<password> -h10.103.xx.xx how to import the data to the database ,try this:
mysql -u<username> -p<password> -h10.103.xx.xx databasename < /tmp/db_bak.20140509.sql(the local source)