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.
- Upload your SQL file to your Linux webspace.
- Connect to shell.lumison.net, using SSH, and log in using your webspace username and password (Note that if using windows web hosting you will have 2 passwords and you will need to use the one associated with your email).
- Change directory to the location of the uploaded SQL file.
- Type ‘mysql -h mysql.lumison.net -u <user name> -p <database name> < import.sql’ and press enter.
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.