• Welcome to Simple Machines Community Forum. Please login or sign up.
December 03, 2021, 01:35:39 AM

News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord


Moving servers

Started by barpc, March 08, 2017, 06:42:19 AM

Previous topic - Next topic

barpc

This may have been covered in other posts, but I cannot find a decent answer
I am using SMF2.0
I had to move severs from one using MYSQL/php5.6 to MYSQLi/php5.6
I did a backup of the old database in myphpAdmin in zip format.
I then created a new database on the new server MYSQLi/php5.6.
I reinstalled from scratch SMF2.0 into the new server database, then did an import of the old database zip file into the new database.

I then popened the forum and all the settings for the new database are there in Maintenance section, But there are no members or posts or anything else.

What have I done wrong??


barpc

Hi
Thanks for the quick answer, I uploaded the repair.settings.php, then ran it
It confirmes that all the settings for the database are correct, but I noticed that it would not let me set MYSQLi
So I changed this in settings.php.
I get the message Table 'db672766193.smf_settings' doesn't exist
????

Trevor

Kindred

I don't think that 2.0 defines mysqli.....
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.<br /><br />"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Illori

Quote from: Kindred on March 08, 2017, 07:20:15 AM
I don't think that 2.0 defines mysqli.....

at this time SMF 2.0 does not support mysqli, it only supports mysql. once SMF 2.0.14 is released it should support mysqli.

Shambles

Or if you cannnot wait, install the following modification which works quite well.

http://custom.simplemachines.org/mods/index.php?mod=3469

barpc

Hi

Again thanks for the advice.
I had already changed mysql to mysqli in settings.php
so the result from the forum is still Table 'db672766193.smf_settings' doesn't exist

Trevor

Illori

then either your database name is incorrect or the prefix is incorrect.

Steve

Did you install the mod Shambles mentioned?
Please do not PM me for support.

Kindred

you changed it in settings.php -- but, as stated, SMF 2.0.x does not currently support mysqli as an option...   so, that is your problem right there.

Change it back to mysql.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.<br /><br />"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Advertisement: