MySQL

There is an occasional requirement to manually move your database from one server to another. Typically this is required as the result of an account migration between data centres. In this example we will look at how to move a … Continue reading →

When transferring MySQL databases between hosts or servers there are various methods available from the web based phpMyAdmin to remote GUI clients such as Toad. One of our favourites is the classic mysqldump and mysql-client due to their simplicity, portability … Continue reading →

If you receive an email from support@pipeten.co.uk or .com with the title “Warning (Approaching resource limit)” it means that you are approaching or exceeding some of the inclusive resources on your hosting package. Explanations of what these resources are and … Continue reading →

When you reach approach or exceed the default size of your hosting packages inclusive database quota/storage you will receive an email from support@pipeten.co.uk or .com to the primary account contact with the subject “Warning (Approaching resource limit)”. This post provides … Continue reading →

Since our last Dublin update we’ve had a few users having issues with their old OSCommerce installs. Below you’ll find the most common problem and fix. The problem: Error Message – 1054 – Unknown column ‘p.products_id’ in ‘on clause’ The … Continue reading →

Yes, you can connect to your database using a client such as MySql Front or Aqua Data Studio. We only enforce standard authentication for remote MySql connections, you just require your database username, password and server address.