The Elvidge Family

Web Design

Transfer MySQL database (Easy)

Saturday, 24 October 2009 11:06 | Author: Administrator |

Here's a method of backup-restore MySQL databases without using PHPMyAdmin which i have found a lirttle tricky, especially for large databases.

1. Download and install the free version of SQLYog (Trial) Here or Publisher's Site.

2. Add the access details for both your old and new MySQL databases. (Back-up your existing database - you can use SQLYog by clicking 'Backup Database as SQL Dump').

3. Connect to the two databases at the same time and open the window sith the data you want to transfer.

4. If both databases are successfully open - the 'Copy Database to different Host/Database' icon will be available. Select the correct tables/all and it's as easy as that.

Last Updated (Saturday, 24 October 2009 15:22)

Using ZoneEdit with Fasthosts (more control over A Records and Subdomains)

Saturday, 31 January 2009 00:00 | Author: Paul |

Here's how I added sub domains to our website so we could point to different IP addresses (such as our office server).
1. Register with www.zoneedit.com and create a 'Zone' by specifying the domain you are using. This service is free if you do not exceed their bandwidth limits.

2. Login to your newly created zoneedit account and create the necessary records so your fasthosts hosting will still function after the dns transfer.
Choose 'Edit Zone' and select 'IP addresses (A) to add A records that will point to the right services. Enter A records for all the Fasthosts services as shown in their article here. Here's the list for your convenience (check this is up-to-date):

webmail.yourdomain.co.uk - 213.171.216.231
matrixstats.yourdomain.co.uk - 213.171.192.197
sitebuilder.yourdomain.co.uk - 213.171.195.58
ftp.yourdomain.co.uk - shown in your control panel
mcp.yourdomain.co.uk - 213.171.195.22
cp.yourdomain.co.uk - 213.171.195.47
ssh.yourdomain.co.uk - 213.171.218.5
exchange.yourdomain.co.uk - 213.171.192.50

Add the custom subdomains that you would like to add.

custom.yourdomain.co.uk - your i.p. address

3. Delete Mailforward that was automatically created when you added the zone to zoneedit by going into 'MailForward' and deleting the entry.

4. Now go into 'Mailservers' and add an MX record for all the mail on your domain to be still sent to your fasthosts servers. Fasthosts instructions found here. BUT - make sure you check your fasthosts control panel (Mail) where it will tell you the correct external server. Here's what is says the entry should look like:

domain (domain.com) server ( smtpin1.livemail.co.uk)

NB. You will also need to set up A records for the two mail servers used for accessing pop/smtp mail.

mail.yourdomain.co.uk - ip address shown in Control Panel for mail
smtpyourdomain.co.uk - ip address shown in Control Panel for mail

5. Now when zoneedit is all ready, you need to change the DNS servers on fasthosts. Login to the control panel, Domains & hosting, Your Domain, Registration settings, Nameservers. Your new nameservers should look like this:

ns2.zoneedit.com
ns3.zoneedit.com6.

Changes will take a few days to become active accross the net.

Last Updated (Thursday, 29 October 2009 10:00)