Databases

How to shrink the MSSQL transaction log

In this guide I’m going to go through the process of shrinking an MSSQL database transaction log. Shrinking your transaction log will allow you to make more space within your database without removing any of the data stored within the … Continue reading

MySQL 5.5 now available

We are pleased to announce that we are now running MySQL 5.5 across our shared hosting platform.

Tagged ,

Huge wp_options table? Here’s what you can do

Recently I’ve noticed a number of customers contact support with very large WordPress databases. The main reason for this appears to be a very large wp_options table caused by transient database entries. WordPress uses these transient entries to cache certain … Continue reading

Tagged ,

Exporting and Importing MySQL via phpmyadmin

In this guide I’m going to explain how you can use phpmyadmin to export and import MySQL backups to your MySQL server.

Tagged , ,

Importing and Exporting MySQL via SSH

In this guide I’m going to explain how you can use SSH or terminal to import and export MySQL backups to your MySQL server. This is perfect for the larger size databases but can be used for any size. If … Continue reading

Tagged , ,

Kentico 8 – Installation

Kentico 8 has been redesigned from the ground up,  whether it’s a CMS, e-commerce shop or an online community Kentico 8 is a out of the box powerful solution for all your website requirements. In this guide we are going … Continue reading

Tagged ,

Debugging MySQL connection problems

If you’re running a website which uses a MySQL database, you may be often presented with a generic error message, such as “Error establishing database connection” – I’m going to tell you how you can obtain a more detailed error, … Continue reading

Tagged ,

Run larger websites with Pipe Ten

You can now run even larger websites on Pipe Ten’s standard shared hosting plans as inclusive database allocations have now been increased at no extra cost.

Tagged

MySQL Database house keeping

In this article I’m going to explain what you can do on a regular basis to help keep your MySQL database in ship shape.

Tagged ,

Exporting and Importing stored procedures MSSQL

In this guide we are going to walk you through exporting and importing your MSSQL stored procedures within SQL management studio. Note: If you are using our littlebackup tools to import/export your database, then this will include a back up … Continue reading

Tagged ,

Shared SQL Server 2008

All shared web hosting customers now have the option to use either MS SQL Server 2008 rather than MS SQL Server 2005.

Updating your MySQL User Password hash lengths

In this article I’m going to explain how you can update your MySQL user password hash lengths for use with PHP 5.4 and beyond. This change is required as the later version of PHP have become more strict on what … Continue reading

Tagged ,

Connecting to MS SQL Server using MS SQL Server Management Studio

In this tutorial we will show you how to connect to a MS SQL server using MS SQL Server Management Studio. In here you can do database queries in a few clicks.

Tagged

How to make MySQL work with ASP using the ODBC connection

When enabling classic mode under any .NET version (whether you are using .NET or not) if you enable classic mode your application runs in a worker application pool that is in a 32 bit environment. To fix this we need … Continue reading

Tagged ,

How to use MyLittleBackup

In this tutorial we are going to walk you through backing up your MSSQL databases using MyLittleBackup. This back up process will create a .bak file. myLittleBackup for SQL Server 2000, 2005 and 2008 is the first Backup/Restore solution specially … Continue reading

Tagged ,

How to back up your hosting account

This page has been designed to be a one stop guide to help you back up all of your Pipe Ten website’s data, we will show you how to create a full back up of your hosting account including databases, … Continue reading

Tagged ,

Connecting to MySQL using Dreamweaver

In this tutorial we are going to show you how to connect to your Pipe Ten MySQL databases using Dreamweaver CS5.5 (this will also work with earlier versions of Dreamweaver).

Tagged

Switching MS SQL database servers

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.

Tagged , , ,

Switching MySQL database servers

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.

Tagged ,

Dumping & Restoring MySQL

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.

Tagged ,