Home > MySQL > Importing a MySQL database from the command line.

Importing a MySQL database from the command line.

Command line access to MySQL is available but access is restricted to the Pulsant shell server. Shell access is available on all Pulsant webspace accounts but is disabled by default, if you would like this enabled simply email [email protected] and we will do this for you.

To import a MySQL database you must first have a file containing the required SQL (import.sql in our example), upload this to your web space account and then use the following command to save this into the database.

This will ask for your database password, will import the SQL file and return you to a command prompt.

Note that <server name>, <user name> and <database name> should be substituted by the details specific to your database, see the MySQL server details.