How to upload / run SQL scripts on your database easily

Whether you are moving to netOxide for the first time and need to transfer yur existing MySQL databases or simply restoring a MySQL database to a previous version, the easiest way to load your .sql files into the database is as follows:

  1. Log on to my.netOxide.co.uk
  2. Select the MySQL icon under Web Tools
  3. Under Manage MySQL Databases it says “To restore a database which you’ve previously backed up. click here.” Click where indicated to take you to the Restore Database screen.
  4. Select the database to run the sql script on, select the SQL script from your local machine, then click restore.

The SQL script will be uploaded and run on the database server.

If it is a large script, and you see a Server Error 500, don’t worry, the script has taken longer to execute than the response time out on the web server.  MySQL will happily keep processign the script in the background.  In this case, click the Manage button against the database in the control panel, and this will launch PhpMyAdmin where you will be able to see the progress of tables and data being added.

Comments are closed.

Community
Registered users can login here. Not a member? register for free to order our great value web hosting & domains.
Information
The Business+ hosting account is for businesses or if you are self-employed and planning on selling goods on your site. It only costs £5 per month and includes e-commerce, CRM and project tracking software.