I have done a test run on another host and it takes forever!!!!
Not only do I have to download and upload a large database, I will likely have to do this in at least a couple of pieces. Populating a new database so it can later be converted is also a lengthy process. The final part is running the conversion itself, into a new database. To give you some idea of the time and effort involved with the phpbb converter alone, I will have to click a "continue" page after every couple thousand posts are converted. Since there are a couple million posts or so, this will take FOREVER. Once it is successfully converted, I need to run a script to rebuild the search database. This will take several hours.
None of this takes into account that there may be failures in the conversion so I may need to start over.
So I am warning you, the board may be down for some time. I can move the guide over and set up the records forum without too much trouble but the main forum will be down for some time (at least a day).
WHAT YOU NEED TO KNOW:
The forums will unexpectedly be down for at least a day. The rest of the site will likely have much shorter period of downtime.
As the conversion time gets near, I will download all the files on the site. If you change your avatar or I upload a picture and forget I did, those new files may not be there.
The new phpbb3 will have new features. I don't know which ones I will activate. Primarily, I hope that it will be functional after the conversion.
p.s. I have a way around this but if anyone has the syntax for creating a database backup that does not have extended inserts, let me know. I found this:
Code: Select all
mysqldump -h localhost -u [MySQL user, e.g. root] -p[database password] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql
Code: Select all
mysqldump -u username -p dbname > dbexport.sql
--opt
then
--skip-extended-insert
is part of what I need. Adding them might mean I remove the --quick (?) I will have to look at the pages below.
--opt is shorthand for
--add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
https://www.howtoforge.com/faq/how-to-u ... l-database
There is a lot of stuff to learn, relearn and have in order before I do this.