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.
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.
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.
@CocoQuark thanks for your instructions to migration, just an query incase if records gets delete(ex: product or product option deleted) from the table.