SMF Support > Install and Upgrade Help

Moving forum to new host/domain

(1/2) > >>

cdds:
Before I begin, I just wanted to note that I have done all the research I could on this topic and have done everything correctly to my knowledge, but seem to be having a separate issue than most.

• Downloaded /forums/ (my smf folder) from old host and uploaded it to my new host (same directory name, /forums/)
• Did a backup of the old forum through Forum Maintenance and saved table structure and data
• Created a database on new host, importing the backup with character set ISO-8859-1 (after trying UTF-8) with this error:


--- Quote ---Error

SQL query:

# # Dumping data in `phpbb_posts` # INSERT INTO `phpbb_posts` (`post_id`, `topic_id`, `forum_id`, `poster_id`, `post_time`, `poster_ip`, `post_username`, `enable_bbcode`, `enable_html`, `enable_smilies`, `enable_sig`, `post_edit_time`, `post_edit_count`) VALUES (302, 83, 1, 4, 1208661517, '186fd30a', '', 1, 1, 1, 1, NULL, 0), (5, 5, 2, 4, 1204323248, '186ff0c1', '', 1, 1, 1, 1, NULL, 0), (1711, 367, 3, 4, 1235920273, 'ad14613f', '', 1, 1, 1, 1, NULL, 0), (7, 7, 1, 4, 1204328318, '186ff0c1', '', 1, 1, 1, 1, NULL, 0), (8, 7, 1, -1, 1204331333, '4b8c15fc', 'Cherrios', 1, 1, 1, 0, NULL, 0), (9, 8, 1, -1, 1204337177, '4b8c15fc', '=22= Cherrios', 1, 1, 1, 1, NULL, 0), (715, 179, 2, 4, 1216577696, '186fce89', '', 1, 1, 1, 1, NULL, 0), (13, 11, 1, 4, 1204439503, '186ff0c1', '', 1, 1, 1, 1, 1204493745, 3), (16, 11, 1, -1, 1204440486, 43093e68, 'KiJJ3RKaD3', 1, 1, 1, 1, NULL, 0), (17, 11, 1, 15, 1204469338, '44cf5c91', '', 1, 1, 1, 1, NULL, 0), (18, 7, 1, 16, 1204[...]

MySQL said: Documentation
#1367 - Illegal double '4669e961' value found during parsing 
--- End quote ---

• Ran repair_settings.php to all recommended values (which are correct)
• Continue to get the follow error on the new host


--- Quote --- Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.
--- End quote ---


Just to mess around, I did the following with no success:
• Installed another SMF board in a new directory successfully with the prefix TEST_. I then used repair_settings.php on the old board to point to TEST_, nothing. I also removed the prefix on the new board (as the old board has no prefix) and the new board stopped working. After all this, I deleted the new board and database before doing the following:
• Changed the name of the directory and database name and updated the repair_settings.php. I continue to get a connection issue even before I was able to re-upload the backup to the new database. Not sure if this means that the issue lies with the transfer of contents from one host to the next or with my backup and import using Phpmyadmin.

K@:
Please tell me that you can get a copy of the database from your old CPanel...

The Forum Maintenance one's CRAP and I've been pushing to get it removed.

cdds:
As in exporting the database through Phpmyadmin and importing it as I was with the Forum Maintenance one?

K@:
Yeah. Either that or CPanel>Files>backups.

The one in the SMF admin panel often results in errors, I'm afraid.

cdds:
Good news: it worked and showed that it successfully imported all files, no errors were given.

However, I had a few issues with my theme acting a little funny and after messing with it for almost an hour and then re-doing this entire process, I ended up fixing it through what I believe to be "Reset Options" and re-updating the paths to each of the themes. (However, they were correct at one point while still giving me problems). All is fixed!

Thank you very much.

PS - I just hope at some point in time they can fix some of the bugs in the Forum Maintenance backup for those who may not be able to access the SQL Database. :)

Navigation

[0] Message Index

[#] Next page