HostMonster ssh 导入sql
HostMonster HostIt offers free SSH,By SSHImport / Export MySQL databaseIt is quite easy,Specific steps are as follows:
1. HostMonster host to export MySQL database
The following example shows how to export a MySQL database,Export data to be backed up often still necessary,Procedure In the following command line:
(1). mysqldump -u username -p database_name > FILE.sql
(2). Enter
(3). Prompt for password
(4). enter password,Enter.
Where username, database_name is the user name and password MySQL database、Password and database name。FILE.sql file is backed up on HostMonster host MySQL database,Now you can be downloaded to a local to save。
2. HostMonster host import MySQL database
MySQL database backup files to upload(For example, to export the above file FILE.sql)HostMonster to the server,Then execute the following command:
(1). mysql -u username -p database_name < FILE.sql
(2). Enter
(3). Prompt for password
(4). Enter the user name corresponding password,Enter.