AIOWPS tables interfer with mySQL DB import

Hi, the backups created by your host should also work in the same server if you ever need to restore your site from one of the backups created.

Now in regards to exporting your site from a live server into a local site “Your computer” it can be tricky sometimes. There are a few variables you need to consider. Do both servers have the same applications/ specifications? Do both server use the same PHP version? etc etc. I think you understand what I mean.

What you might like to do is use one of the backup plugins found here in the repository. Then create a backup of your live site, then use that backup to restore/install your site locally. The process is very similar to using phpMyAdmin. However for me it works better to use a backup plugin than phpMyAdmin.

In some cases with some plugins like cache and security plugins, I tend to disable these plugins when creating a backup that will be installed locally. Then once I import the backup locally then I enable these plugins again.

You might like to read the following documentation.

Remember the above information is just some basic steps that I take to perform a backup from a live server into my computer/laptop. Others might do this differently to me. There are many ways to skin a cat ?? As long as the end result is what you want.

Kind regards

Hi,

I am quite relieved to learn that my host’s backups should be OK. This was really my concern. I will ask my host anyway to make absolutely sure. I had a preliminary look at the documentation you suggested and will read it more carefully later. Although the procedures you describe are much more complete than what I do, they look similar to what I do except that I use phpmyadmin instead of a plugin. This method has been working fine for more than one year (until I started using a security plugin that is) and now I could make it work by omitting the aiowps tables from the export and reactivating the plugin after the import like you suggest. Just a little more cumbersome but it is OK. Anyway I will try to backup/restore with aiowps instead of phpmyadmin and see what happens and if I get interesting results I might post it here. Thank you very much indeed for your rapid answer and help.

Best regards

You are most welcome ??

You can mark this support thread as resolved. If you need to share more information you are quite welcome or even open up another ticket.

Oh one more action you could try. Every now and then restore one of your host backups. This will let you know if the backups actually work. This is something I have learned over the years from working in IT supporting systems and backups, that testing backups is very important. And before you go ahead with this, you might like to create a backup of your site with a plugin just in case your host backup crashes or corrupts your site.

Regards

• This reply was modified 7 years, 11 months ago by mbrsolution.

Thanks again, I will follow your suggestions (although I tend to be extremely anxious when playing with the “real” site).

Best regards

Hi mbrsolution,

Thanks for your reassuring reply above (#8557866). However I still wanted to see if I could import my DB locally without prior removal of the “faulty” AIOWPS_global_meta table. In fact it is very simple although it took me quite a long time to find the answer. I just exported the whole DB, edited it and removed all data (which I do not need) from the table and it went on smoothly. Additionnaly I had increased “post_max_size”, “upload_max_filesize” etc. according to the mbrsolution tutorial so import proceeded without interruption and for the first time in nearly one year I got the “green OK” from mysql instead of the innocuous but ennoying “ERROR 1231 (42000):Variable ‘character_set_client’ can’t be set to the value of ‘NULL'”. So I can now check locally the quality of my host backups.

Thanks a lot again for your help and “feliz a?o nuevo”

You are most welcome ?? I am glad you got it working after such a long time.

Feliz A?o Nuevo