apparently I don't have mysqli

[Thunderchild]

I am trying to move a wordpress website. To do this I easily do it with a plugin. But on attempt to reinstall on my new server i am told that I don't have mysqli I have no idea what to do, apparently this should be in version 5.2 and above and i am using 5.6....

 

[web-project]

you will be able to enable it through the easy Apache

 

[Thunderchild]

err, that requires a "rebuild" ? should I move to easyapache 4?

 

[PenguinInternet]

Ideally long term you want to move to EasyApache v4, however if you have v3 in place currently you can just rebuild that now to include any new modules needed and then address the move to v4 separately

 

[Thunderchild]

Well I have nothing setup on my server yet so now is probably the best time to upgrade as if I do it later and break stuff that would be a nightmare. Do i need to specifically enable mysqli in apache4 or is that standard?

 

[Thunderchild]

I do get these warning in the pre check for apache 4:

Cpanel evaluates known issues such as network connectivity

• Warning: “Cpanel::Easy::PHP5::MailHeaders” ignored since it does not have an RPM.
• Warning: “Cpanel::Easy::Apache::Fileprotect” ignored since it does not have an RPM.
• Warning: “Cpanel::Easy::Apache::Access” ignored since it does not have an RPM.
• Warning: Current profile has the following MPMs: ea-apache24-mod_mpm_prefork
• Warning: Adding the missing package, ea-apache24-mod_suexec, to the EasyApache 4 profile.

 

[Thunderchild]

right so now my wordpress importer want to play but as I've updated to MariaDB as it was recommended and I thought it would fix thix it's now not compatible with that. Apparently I can't downgrade. What should i be doing regarding mysql ? The previous version was beyond it's support date and the MariaDB was recommended but now apparently not compatible with stuff.

 

[PenguinInternet]

MySQL functionality is enabled by including the mysqlnd package when choosing your modules within EasyApache v4. Wordpress certainly should work with MariaDB (and you are correct in that you can't downgrade). It's a drop in replacement for MySQL - what errors are you getting from this? It may be that they are not directly related to the fact that it is MariaDB, but an SQL issue overall.

 

[Thunderchild]

No wordpress is fine, I just did a blank install but I was hoping to migrate my site using a duplicator plug in, this simply spits out an installer.php file and a compressed copy of the website and database and sets it up again on another server/host. This is quite handy where the database name etc changes. This particular plug in does not know what do do with the MariaDB and tells me to naff off, so now I'm a bit stuck.

I believe i can manually move wordpress by backing up and importing the database to a new database (not really sure what I'm doing there, did it years ago and it worked not so much lately), move the files and probably update the database detail in the config file of WP.

 

[cPanelMichael]

Hello,

I also recommend updating to EasyApache 4. As far as those warning messages, you can read more about them at:

EA3 to EA4 warnings, should I worry?

As far as backing up and restoring WordPress, they document how to do that at:

WordPress Backups « WordPress Codex

Thank you.

 

[Thunderchild]

Yes I did the update to apache 4, I am also on mariaDB now which seems to include mysqli functionality but the plug in is not compatible with that but I can move the sites manually though.