Namesco customers get a new database server

This week we are pleased to announce that we have released a new MySQL server called mysql7.namesco.net to improve our shared hosting service.

This new server has been designed from the ground up to provide superior performance, resilience and reliability and should provide a more than adequate new platform for our customers’ databases.

If you wish to migrate your databases to our new server, you can do so by following our simple steps below. If you have any trouble you can raise a ticket with the Customer Support Department via your Online Control Panel by clicking HERE. Please include “MySQL Migration” as the brief description.

– Start off by logging into your Online Control Panel at https://admin.names.co.uk

– Once you have logged in select Domain Names on the left menu.

– In the middle of the screen there will be a list of your domains, please click on your domain name.

– Going back to the left menu, select the option MySQL Databases

– In the middle of the screen you can click on Add Database to create a new database. Our new server mysql7.namesco.net will be selected as can be seen below.

Now that you’ve created your new database you can now migrate your old database via PhpMyAdmin.  Login to your database through the MySQL Databases section of your Online Control Panel or directly by visiting http://www.mydbadmin.co.uk/

To log in, you will need to enter your old database username, the password and also select from the drop down menu, the server your database is on (e.g. mysql4.namesco.net).

IMPORTANT! Once you have logged in select the database you would like to export from the list on the left hand side.

Then click on the Export tab at the top of the screen, as shown below:

 

It is safe to use the default options on the export options page, but you will need to ensure Save as file is selected as this will allow you to download the database files to your computer. Select Go once you are happy.

Once your database has successfully saved to your local computer we now need to import it into your new database.  Again this is done via the current system, PhpMyAdmin. Firstly you will need to log out of your current database by clicking the green exit button on the left menu.

Back on the login screen, enter your new database details, being sure to select mysql7.namesco.net from the drop down menu.

Once you have logged in you will need to import the database backup by selecting Import as shown below.

From the Import screen click the Browse button and select your database file from your local computer. Once you have selected your database file on your local computer select Go.

PhpMyAdmin will now import your database for you. Please note there may be a slight delay while the import process runs.

Now that your database file has successfully imported to your new database you can delete your old database.

As before, login to your Online Control Panel at http://admin.names.co.uk

– Once you have logged in select Domain Names  from the left menu.

– In the middle of the screen there will be a list of your domains, please click on your domain name.

– Going back on the left menu, select the option MySQL Databases.

You will then have a list of your databases, select the database you wish to remove, then select Delete as shown below.

Don’t forget that if you have any questions you can submit an enquiry to our support team via your Online Control Panel – http://admin.names.co.uk

– Login to your Online Control Panel and click on Technical Support then Support Tracking.

– Fill out the form on-screen, detailing your request, selecting Customer Support Department and including “MySQL Migration” as the brief description.

– Select the right team to deal with your enquiry from the drop-down menu- Finally, click on Submit.

You can also update the configuration of any applications you may be using that connect to your database. For example, if you are using the WordPress blogging application then you will need to locate the file called wp-config.php and update the database details to your new ones.

 

 

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks

10 thoughts on “Namesco customers get a new database server

  1. Once you have created your export file, you will need to remopve the “Create Database” instruction in it, as the database will already exist on the new server.

    It is Line 21, and starts:

    CREATE DATABASE ` YOUR_DATABASENAME_HERE ` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

    Remove the entire line and the import will then work corerctly.

    HTH

    Any problems, happy to help, at very resonable rates.
    info@lancefrench.com

  2. Please advise which files need updating for my Joomla websites so the new database is recognised. I use Joomla 1.5X and Joomla 2.5

    Thanks,

    Michael Jansen

  3. These instructions need some revision to be user friendly. Also, is the first comment accurate?

    I’m getting “#1044 – Access denied for user” when trying to import. Any suggestions?

    1. Hi James,

      We revised and simplified some of the paragraphs in this article yesterday in response to customer feedback – hopefully it is more straighforward now.

      If you’re still having problems, if you could reply to the migration email you received then we’ll take a look for you.

  4. This is such a pain, I have a lot of sites affected, does anyone know how to change cubecart so this will work?

    Cheers, John

    1. Hi John,

      Cubecart stores it’s database connection details in a file called global.inc.php which is located in your includes directory. You will either need to manually alter that file or use the configuration section of your Cubecart administration area.

      If you’re still having problems, if you could reply to the migration email we sent you then we will see if we can do it for you.

  5. Thanks for this, it seems to work as instructed.

    As a layman who doesn’t understand the intricacys of web hosting it would be great if there was some kind of explanation of why we keep having to do this. I have sites with several other hosts, and have for years, yet namesco is the only one I keep having to migrate my database on. Are the other hosts simply not doing this or are they doing it automatically?

    Also when I had updated I got the message;
    “Your PHP MySQL library version 4.1.22 differs from your MySQL server version 5.5.25. This may cause unpredictable behavior.” which is a worry – I had something similar the last time I had to do this with a namesco account as well, what does this mean to/for me as a customer? Thank you.

    1. Hi Chris,

      As we add new, more powerful, database servers into our network, we like to retire the older database servers and move the databases on there to the newer servers. Although we do this ourselves (as many other hosts would) we like to keep our customers informed and give them the opportunity to do it themselves – hence the email you have received.

      With regards to your comment about the PHPMyAdmin message, this is just informing you that the version of PHPMyAdmin installed is older than the version of MySQL installed on the server. I wouldn’t worry about this too much as it won’t really cause you any issues, although it is something we may look at addressing during a future maintenance cycle.

Leave a Reply

Your email address will not be published. Required fields are marked *