Ways to remotely link databases from another server on a server how to connet the database from the other host

Iwangzheng.com

16:57 [[email protected]]$ mysql-u<username>-p<password>-h10.103.xx.xxwelcome to the MySQL monitor. Commands End With;  or \g.your MySQL connection ID is 571Server version:5.0.77 Source distributioncopyright (c) #, Oracle and/or its Affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their respectiveowners. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current inputstatement. ([email protected]x) [(None)]> show databases;+--------------------------+| Database |+--------------------------+| Information_schema | | mvf_for_ykew_development | | Test |+--------------------------+3 rows in Set (0.00 sec) ([email protected]x) [(None)]> ctrl-c--exit! Abortedtty:[0] jobs:[0] cwd:[/tmp]16:57 [[email protected]]$ mysql-u<username>-p<password>-h10.103.28.25 mvf_for_ykew_development </tmp/db_ Bak.20140509.sqltty:[0] jobs:[0] cwd:[/tmp]16:58 [[email protected]]$ mysql-u<username>-py<password>-h10.103.xx.xx mvf_for_ykew_development </tmp/db_ Bak.20140509.sqlso,how to connet the database from the other host,just try this:

Mysql-u<username>  -p<password>-h10.103.xx.xxhow 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