All in one wordpress migration plugin, import stuck. How I fixed it.

All in one wordpress migration plugin is something I have been using for the past three years to export a wordpress website and import it on another website. When I am working on a new wordpress website, I work locally on my computer and then I upload it on a server once I am ready.

This time, I had serious trouble. After I had spent one whole week trying to import the website online using the plugin, I failed miserably. I looked all over the internet to find a solution. I did whatever I could from increasing the max_upload_size, to importing the website manually using phpmyadmin.

At first I thought that it was an issue related to the plugin but I was so wrong.

Unable to import error and what I tried
When I tried to import the website using all in one wordpress migration plugin I was having the following error: unable to import.

It was a generic error and after looking for help, I have updated max_execution_time, max_file_size and more settings with no luck..

After that I tried to import the database and upload the wordpress files manually. Whenever i tried to import the database manually I was facing the following error:  Missing expression. (near “ON” at position 25) SQL query: Edit Edit SET FOREIGN_KEY_CHECKS = ON; MySQL said: Documentation #2006 – MySQL server has gone away

This error I had never seen before. I tried to search online for help and again, no luck.

My website was hosted with Godaddy and their support kept saying that my database was corrupted. True, a database can get corrupted although it is very difficult. I set a fresh wordpress installation on my laptop locally and the database was imported successfully using all in one wordpress migration plugin.

So basically, the database was fine.

The only ‘solution’ I found

To cut the story short, after one whole week trying to figure out a fix with Godaddy support and also searched all over the internet for a fix, the last thing I could try was to import my website on another hosting service. I chose Namecheap.

On just the first attempt and using all in one wordpress plugin on Namecheap, my website was live in just few minutes!

If you are experiencing the same issue like I did, most probably it is a problem with your hosting service settings.

I suggest to try Namecheap if you are experiencing the same problem I had and stop wasting your time.

This “solution” might sound strange, yes, but please bare in mind that I had spent a whole week trying to find a solution alone and also making various attempts with Godaddy support to provide me with a fix.

Namecheap vs Godaddy

    • Namecheap Fixed my problem instantly by just moving my website to their server (Tried and tested)
    • Free domain + SSL with a hosting purchase
    • Cheaper and better
      • Hosting- namecheap: €3.45, Godaddy: €6.99 (Per month)
      • Domains- namecheap: €7.89, Godaddy: €18.99 (Per Year)
      • SSL Certificates- namecheap: €7.88, Godaddy: €55.99 (Per Year)
  • Efficient support compared to Godaddy
Update 22nd March 2019: It seems that godaddy also swtiched off the import function for all in one wordpress migration plugin.