I have a large phpbb database I am migrating. I want to do most of the migration while the old site remains active. Then, on migration weekend, rerun the migration script after reloading the database. This will reduce the migration weekend only to import a couple of thousand user posts versus 300,000. is this feasible? Does the migration script maintain the restart points outside the MySQL database? is there an easy way to make the script upload a new database dump without resetting the previous work or duplicating it? Any best practices or suggestions would be welcomed.

Thank you for your reply. Clarification on the reply of “after loading your updated SQL database.” Does this mean the import script will automagically recognize a new dump file and will update the database? Or does this mean, I need to refresh the database with updated data manually?

You need to delete the older database from MySQL, import your latest sql file as a new database, and run the import script which will load the newest database. The script will iterate through all the database content, detect if some content (users, posts, etc.) already exists in Discourse, and will import only the new data.

Thank you for that clarification.

[image] Coconut Flavored Quark: The script will iterate through all the database content, detect if some content (users, posts, etc.) already exists in Discourse, and will import only the new data. @Canapin thanks for your instructions to migration, just an query incase if records gets delete(ex: product or product option deleted) from the table. Does the script update those rows of table?

[image] Deep Vyas: just an query incase if records gets delete(ex: product or product option deleted) from the table. Does the script update those rows of table? No, and it will also not detect updates (edits) to posts and users.

To provide an update. I performed my phpBB migration in a two step method. First Migration While my current phpBB system was still in productions state I did the following: Followed the standard phpBB migration guideline Took a sql dump of my current phpBB database Copied over all files and avatars. This allowed me to migrate the majority of data and test everything out with real data. After validating the data and setting up the new Discourse system. I moved on to a second migration activity. Second Migration This time I shut down my phpBB forum. I ran the import script a second time: Updated the files and avatars with any new files since first migration. Replaced the mysql dump with a new dump file. I ran the import script. Since the process only had to import a couple of weeks worth of data, the script took less than 15 minutes. Everything ran smoothly. If you have a large phpBB forum to migrate, I highly recommend the two phase approach for migration.

Database reload

Product Support Migration

Canapin (Coin-coin le Canapin) December 16, 2024, 3:07pm 2

Yes, the phpbb import script supports that. Simply rerun the script after loading your updated sql database. It will skip existing content and add what’s missing to Discourse.

Topic		Replies	Views
Reset after running migration script? Migration vanilla	4	706	October 9, 2023
My phpBB Migration Journey (postgresql) Migration phpbb	23	2373	March 30, 2023
Appending an import > it didn't import any posts (solved) Development	4	748	December 27, 2019
Migration via snapshot upload Migration	3	1013	January 15, 2022
Importing old database to latest version Self-hosting	16	1608	June 7, 2022

Database reload

Related topics