Re-Publishing

Clearing published site and starting again

[camweh]

As I explained before in the post (Problem Publishing) I have a glitch on my website believed to be on the host server, publishing works sometimes and other times it doesn't - I'm using FP2003. To fix the problem it's been suggested by the host that they could clear the site off the server and I could re-publish again from scratch.

I've no problem doing that but I'm a wee bit nervious about my phpbb forum files. I have them backed up on my hard drive and I'd reckon it would just be a matter of FTPing them back to the 'form' folder after the site has been restored. The database is on a different server so that should reconnect automatically. Is my thinking on this sound? Into my ninth year of retirement and enjoying the challenge, but worried about letting my forum members down.

[bill]

The FP site should not pose any problems if you don't have any special database components setup.

The phpBB forum however uses a MySQL database so you'll need to go to their support site and make sure that you have backed up the database properly. Simply copying the existing files from your phpBB won't be a sufficient backup. You'll probably need to re-install the forum and then import your data in. Take all the steps you would as if you were moving to a new host.

[camweh]

Thanks Bill,
I've always had the good habit of backing up my forum's database through both the Control Panel and phpMyAdmin at the SQL database

If the worst comes to the worst I can install new phpbb files and get things back to what they were. But it sure would be nice just FTPing the backup phpbb files back to the 'forum' folder after I reload the website.

[roldar]

Maken sure you've got all the records in your backup before you delete anything. phpMyAdmin has a file size limit I believe, so it's possible that it could time out and leave you with only a partial backup. I think the size limit is somewhere around 50 MB, but that may be only if you transmit the backup directly via HTTP rather than saving it to the server first.

If you've got a huge database (thousands of forum posts) then you'll probably have to shell in and create a database dump on the server and then download that file.

[camweh]

Well it worked a charm. After re-publishing the 250 pages back onto the server I FTP'd the phpbb files I saved back into the Forum folder. Really pleased with myself - and loving retirement.