Archive for March, 2017

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.

Comments