Pagetext message
- Thread starter Crackle
- Start date
Page may contain affiliate links. Please see terms for details.
Yes ... it was caused by the recent database crash and applies to the earliest posts from the very beginnings of CC.
I've got a backup of the post data but as there are around 13,900 affected posts it's going to take me a while to manually pull the contents from the backup and add them back in to the main database (there's no way to automate the process unfortunately!).
I plan to do this in batches as time allows, so over time they will be slowly drip-fed back into place.
No rest for the wicked eh ...
Cheers,
Shaun
I've got a backup of the post data but as there are around 13,900 affected posts it's going to take me a while to manually pull the contents from the backup and add them back in to the main database (there's no way to automate the process unfortunately!).
I plan to do this in batches as time allows, so over time they will be slowly drip-fed back into place.
No rest for the wicked eh ...
Cheers,
Shaun
andyfromotley
New Member
- Location
- Otley, west yorks
oh shaun no
Don't worry, it'll all in hand; I'm installing Apache, MySQL, PHP, and PHPMyAdmin on my laptop, restoring from the 1GB SQL backup file to recover the post table from the vBulletin database, whittling it down to the 13,900 affected records, writing the ID and Content fields to a new temporary table, dumping the field data to and SQL backup file, importing the contents into Excel, doing a find and replace to set-up the insert statements, exporting them to a CVS file, doing a find and replace to tidy up the statements, then running them through PHPMyAdmin to re-insert them back into the master table.
- Location
- The TerrorVortex
Well, when you put it like that it's all so obvious.
.
.
.
*baffled*
.
.
.
*baffled*
Admin said:Don't worry, it'll all in hand; I'm installing Apache, MySQL, PHP, and PHPMyAdmin on my laptop, restoring from the 1GB SQL backup file to recover the post table from the vBulletin database, whittling it down to the 13,900 affected records, writing the ID and Content fields to a new temporary table, dumping the field data to and SQL backup file, importing the contents into Excel, doing a find and replace to set-up the insert statements, exporting them to a CVS file, doing a find and replace to tidy up the statements, then running them through PHPMyAdmin to re-insert them back into the master table.
Yeah, I thought so......<cough>
wow! Beats 'get your coat, you've pulled'.Admin said:Don't worry, it'll all in hand; I'm installing Apache, MySQL, PHP, and PHPMyAdmin on my laptop, restoring from the 1GB SQL backup file to recover the post table from the vBulletin database, whittling it down to the 13,900 affected records, writing the ID and Content fields to a new temporary table, dumping the field data to and SQL backup file, importing the contents into Excel, doing a find and replace to set-up the insert statements, exporting them to a CVS file, doing a find and replace to tidy up the statements, then running them through PHPMyAdmin to re-insert them back into the master table.
I spoke to soon. Going back from around this date, many threads contain the same text.
https://www.cyclechat.net/
https://www.cyclechat.net/
- Location
- The TerrorVortex
Another affected thread here http://www.cyclechat.co.uk/forums/showthread.php?t=697
- Location
- The TerrorVortex
No great rush - don't feel too guilty if it's lunchtime on Monday before it's finished.