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 unique solution thanks to Namecheap hosting support

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 using another web hosting service. I chose Namecheap.

I have contacted Namecheap about the problem I was having on godaddy. I have to say that Namecheap has the best amazing support team.

They provided me with this soultion:

In the constants.php file of the “All in one wp migration” plugin we have changed the the line number 284 in that file from: “define( ‘AI1WM_MAX_FILE_SIZE’, 2 << 28 );” to “define( ‘AI1WM_MAX_FILE_SIZE’, 32 << 28 );” (sometimes that string can be on the 303 line )

After trying this, I managed to upload the file successfully via all in one wp migration plugin.

Please I appreciate if you support me and Namecheap for this fix they provided. Support us by using Namecheap hosting services.

Why Namecheap over Godaddy?
    • Free domain + SSL with a hosting purchase
    • 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) 

Click here to check Namecheap hostingservices.