Ryan Gustason’s Blog

Well, made a toolbar for the site. Download it here: http://gustason.ourtoolbar.com/

Well, just converted an SMF database from 1.0.8 to 1.1.5. Basically had to create a new instance of SMF from scratch. Used phpMyAdmin to do the merges. Here is what I learned for those of you trying to do something similar.

1) upload the old database files from the previous forum. Be sure the file is named something different than the new SMF.

2) use the following code sample in phpMyAdmin in the SQL tab:

INSERT IGNORE INTO `sample_new_smf1`.`smf_permissions`

SELECT *

FROM `sample_old_smf1`.`smf_permissions`

replace sample_old_smf1 with the name of the database you are copying from.

replace sample_new_smf1 with the name of the database you are copying to.

smf_permissions is the name of one of the tables in smf. You’ll have to repeat this for every table in smf. Also note that some of the table structures might have changed between versions. If you get errors merging the databases, this is most likely the reason why you are getting errors. To do the comparison, print out the table structure of the new table you are copying into. Then go into the old table and insert or modify the old table’s structure to make it match the new table’s format. Using phpMyAdmin, this is fairly simple. Just click on the pencil icon to modify a record entry, or scroll to the bottom to find an easy way to add new record fields into the table.

Once the two table’s structures match, re-try the merge again, and you should have no problems.

After all of this is completed, all you’ll need to do is relog into your forum and go through the fix any errors and optimize the tables.

Hope this helps.