[SOLVED] Site move with DB Error (MySQL vs MySQLi)
Posted: Tue Jan 29, 2013 12:29 am
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:
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
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 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