Page 1 of 1

[SOLVED] Site move with DB Error (MySQL vs MySQLi)

Posted: Tue Jan 29, 2013 12:29 am
by fearmydesign
Hello everyone, I actually solved this problem (at least I think), but I wanted to get your expert opinion on it.

I moved a site from a VPS server located in the US, to a VPS located in Chile. I did everything the same way I have done in the past: backup Home Directory + Sql Database + Emails. Then uploaded them to the new VPS via cPanel (easy).

Anyways, at first I could not get the site to connect to the database, so I started troubleshooting by erasing everything, start the backup process from scratch twice and same issues! (Data base Fatal error could not connect).

At last I realized that on the config file on this line:

Code: Select all

$config['dbms'] = 'mysqli';
I had to remove the " i " from 'mysqli'

I know that this is an updated version of mysql and I am guessing the VPS in Chile does not have it, and the one here did. So my concern is whether removing this " i " on the config file could cause future problems with my site; giving that I moved it from a server that had this mysqli capability and the original installation was done there.

Hope this makes sense! Thanks

Re: Site move with DB Error (MySQL vs MySQLi)

Posted: Tue Jan 29, 2013 12:36 am
by calguy1000
http://stackoverflow.com/questions/1171 ... over-mysql

Note: That mysql support has been dropped from the official PHP release, and mysqli has been deprecated.

So, within the next few years CMSMS will have to support pdo, and likewise drop support for mysql and mysqli. However since hosting companies are notoriously slow to adapt things (I'm still occasionally getting emails from people wanting to use CMSMS on php4 hosts)... we have some time yet.

Re: Site move with DB Error (MySQL vs MySQLi)

Posted: Tue Jan 29, 2013 12:46 am
by fearmydesign
calguy1000 wrote:http://stackoverflow.com/questions/1171 ... over-mysql

Note: That mysql support has been dropped from the official PHP release, and mysqli has been deprecated.

So, within the next few years CMSMS will have to support pdo, and likewise drop support for mysql and mysqli. However since hosting companies are notoriously slow to adapt things (I'm still occasionally getting emails from people wanting to use CMSMS on php4 hosts)... we have some time yet.
Thank you Calguy, this clears everything up.

Cheers