Problem with moving from host to another host

Started by SEABOY, January 10, 2010, 05:43:15 PM

Previous topic - Next topic



i have moved from host to another host the new one is HostGator and now i face problem as my site wont show up you can check here

i was using SMF 1.1.10 updated to 1.1.11 then updated to SMF2 RC2 everything were working fine and now after i moved to the new host and done uploaded the public_html and from cpanel tried to restore the sql file and seem everything ok but went to the forums and found there's an error saying Table 'seaboy_online.smf_settings' doesn't exist

i contact HostGator support and after long time of talk with them they said about the sql it self is the problem and asked me to contact SMF Team to see what's the problem coz some string wont be imported so can anyone help me with that...

and here's the database backup from my old host


Okay i figured now this problem might coz the database name coz in the old host my user name were diff than the new host name and that give my database a new name so now how i can rename the database if that possible?

Matthew K.

This issue has been addressed many times. I'd suggest using the Search feature before posting for a faster solution.

What is repair_settings.php?


sure 1st thing i have done search for rename database and the result were so much and i was looking at all but nothing found.

thanks btw gonna try that

Matthew K.

That'll fix your problem if you follow the steps properly.


my database named name_othername so am i able to change this to my old database name by editing the MySQL database name:  and MySQL username: ?

Matthew K.

Unless you really want the database to have the old databases name, just follow repair_settings.php and update it accordingly.

If you want it to have the same name, simply rename the database through "MySQL Databases" (if you have cPanel)


in repair_setting.php it say
Some settings are not being shown because the MySQL connection information is incorrect.

and in my site now it say
Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

that's when i changed the user name and database name to the old one



I got that error a while back... ...sorry, I wish I could remember how to fix it (besides What is repair_settings.php?)

If I remember, I will post here...


Thanks for the response...

and here's what happened exactly with me

i was changing the host so before i change i got a full site backup from cpanel Files - Backups
Download a Home Directory Backup then Download a MySQL Database Backup
also i went to my forums administrator and got the backup for my database from there

so when i moved to the new host i uploaded the public_html and then from my cpanel Files - Backups - Restore a MySQL Database
that's how i restored my online.sql.gz
then i got the msg about ( 'seaboy_online.smf_settings' doesn't exist ) as seaboy is the login for cpanel and this name is diff than my old host login
so as mentioned here by Labradoodle-360 i have uplloaded the repair_setting.php and the file show me as there's error ( Some settings are not being shown because the MySQL connection information is incorrect.  )

so any help with that?

Matthew K.

Please provide a screenshot of the error on repair_settings.php.


i went to your website and i got a screen that asks to login to the Cpanel and other hosting options suggests that the domain has not been properly set up yet.
also the easiest way is to name the new database the same as the old database that way u have no problems that's what i did when i moved my site.

Matthew K.

adbrad - Renaming the database isn't "the best way" it doesn't really matter...or the easiest. Repair_settings.php just fixes the paths.
But it is a very possible solution.


Quote from: Labradoodle-360 on January 11, 2010, 10:40:04 AM
adbrad - Renaming the database isn't "the best way" it doesn't really matter...or the easiest. Repair_settings.php just fixes the paths.
But it is a very possible solution.

i found it easier to doit that way when i moved meant i didn't have to change any settings


Yes the website have been reset to do everything again

now what i have done is i uploaded the public_html folder and from cpanel i created new database name the same name as my old database then from phpMyAdmin i went to import the database after it finished came with this error
SQL query:

/*!40000 ALTER TABLE `smf_ajaxchat_messages` DISABLE KEYS */;

MySQL said: 

#2006 - MySQL server has gone away

any help?


no ideas on that but still not able to acceess your site


I removed the link to your database backup for your own security! :)
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)


Thanks sir for removing :)

now i have found some error while importing the database from phpmyadmin this error about ajax i removed the query about ajax from the old host then exported the db again...and now i imported in my current host and the site came up with this error now
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.


I think the problem is from the database itself now so please let me know if u interesting to help :(