UKC

Solution: ERROR 2006 (HY000) at line XXXXX: MySQL server has gone away

Getting MYSQL server has gone away when importing database from .sql file

Problem: You are trying to import a .sql file using the command line mysql command but it is unsuccessful as follows:

# mysql -u douser -pdbpass yourdb < db_file.sql
ERROR 2006 (HY000) at line XXXXX: MySQL server has gone away

The solution is to edit /etc/my.cnf and add the following line to the [mysqld] section:

max_allowed_packet=64M

Then restart mysql:

# service mysqld restart

Re-run your import query (you may need to delete the partly database first and re-create it) and it will now succeed.

Beware Hidden Costs – Choose your Domain Registrar Wisely

With so many registrars to choose from it is difficult to determine which deals are the best.

If you have done your homework you will have already discovered that the initial registration cost is not the only cost you need to consider. The hidden fees make it extremely difficult to choose who to use. We make it very easy – by not having any! 

  • Transfer Out Fees – Our Transfer Out (or Away) fees are £0.00, that’s right, we do not hold you to ransom if you register your domain name with us. You can transfer your domain away at any time.
  • Beware the Small Print – There is NOTHING in our small print that will enable us to charge, penalise or fine you in any way for the use of your domain name.
  • WHOIS Record Charges – It is important to keep your WHOIS details up to date. We do not charge for any changes to your WHOIS record nor do we restrict updates to your WHOIS record, you are free to make these changes.
  • IPSTAG Change Fees – We do not charge any fee to transfer away your UK domain name or for IPSTAG changes. Many registrars make this fee so high it’s easier to stick with them. Check this fee before you register with anyone
  • Registrar Lock Fees – It is important to lock your non-UK domain but we don’t extort you for it. We give you FULL control over your Domain Locking. You can lock and unlock your domain at will and as required at no cost
  • Transfer Auth Code Fees – Registrars often quote free transfer outs and then charge you for the AUTH code! You can get your domain auth code from us at any time for free. The transfer away of any domain is at no cost.
  • Parked Domain Advertising – To make money from domains many registrars place advertisements on your parked domains. We do not place third party advertisements on your parked domain or any other service.
  • Web Forwarding – You can forward your domain name to any location and change this setting whenever your with. For free. Often registrars will make small annual charges for changes to your web forwarding service.
  • Name Server Changes – You are free to change your name servers as you wish, no limited, for free.
  • DNS Management – This is often an additional fee based service to your domain registration. With us, you have FULL control over your domain DNS Management at all times. There are no fees to make any changes. Ever.

How to connect Domain POP Mailbox to iPad/iPhone

If your domain is hosted, this guide is not for you. If your domain name is parked, ie. using name servers ns.microlite1.com and ns2.microlite1.com and you have purchased a POP Mailbox – read on…

Your domain is registered, you’ve got your Webmail login for your Domain POP Mailbox, now you want to get things moving on your iPhone or iPad. Here is an example of a POP Mailbox configured on an iPad3 (Ok, The New iPad). Obviously use your own name, username and password as provided.

First, let’s set up the Incoming Mail Server:

Now let’s setup the SMTP Outgoing Mail Server:

That’s all there is to it. You can use the same setting in other mail clients such Outlook, Entourage etc.

Plesk – Change Email Password from Command Line

How to Change Plesk Mailbox Password from SSH Console

If you are in a hurry to change a Plesk Mailbox Password then the official route of going through the Plesk Control Panel, finding the account, drilling in to mailboxes can take some considerable number of mouse clicks. However, if you are comfortable with the server console then you can do it in an instant as below:

/usr/local/psa/bin/mail -u mailbox@domain.co.uk -passwd NwPsWrd3