Foggy's Progress - a record of improvements to the forum
- Foggy
- Dick Tater
- Posts: 11327
- Joined: Mon Feb 22, 2021 8:45 am
- Location: Fogbow HQ
- Occupation: Dick Tater/Space Cadet
- Verified: grumpy ol' geezer
Re: Foggy's Progress - a record of improvements to the forum
I looked and I looked, and I have a good copy of the database from four days before the disaster. Or to be more specific:
2/17/2021 - most recent backup of the DB
2/20/2021 - 1&1 Hosting set my server on fire
2/21/2021 - I found out about it and spent the whole day scrambling with no luck, so,
2/22/2021 - Fogbow Reborn
Anyway, I have the files. I have the DB. I am going to try to restore it, which will take a few days, so be patient.
Of course, if I do this thing there will still be 5 days of posts missing. I understand those were the most brilliant posts ever and you can never replace them.
2/17/2021 - most recent backup of the DB
2/20/2021 - 1&1 Hosting set my server on fire
2/21/2021 - I found out about it and spent the whole day scrambling with no luck, so,
2/22/2021 - Fogbow Reborn
Anyway, I have the files. I have the DB. I am going to try to restore it, which will take a few days, so be patient.
Of course, if I do this thing there will still be 5 days of posts missing. I understand those were the most brilliant posts ever and you can never replace them.
- Foggy
- Dick Tater
- Posts: 11327
- Joined: Mon Feb 22, 2021 8:45 am
- Location: Fogbow HQ
- Occupation: Dick Tater/Space Cadet
- Verified: grumpy ol' geezer
Re: Foggy's Progress - a record of improvements to the forum
OK, this is a project, so bear with me.
And when we're done, am I really maintaining two websites? Because I can't merge the databases, that's unpossible AFAIK.
First, the name of the site will be formerly.thefogbow.com, in other words a subdomain.
Second, the DB I have is too big, I need help uploading it from the hosting company.
Third, there are configuration issues, because each hosting company has its own naming schema, and the old DB came from the previous horrible evil nightmare hosting company.
So anyway, I don't know what to do about having duplicate forums. Can you imagine? You won't even be able to remember which forum you posted what brilliant comment. I hope to give you access to all the posts in the first forum, but somehow prevent you from posting in it, because that database is unwieldy as it is, I'd hate to make it any bigger. If I can give you access to it, and everybody can see it, and you can give links to it, then that's the goal.
I'm online with the hosting company about uploading that DB.
And when we're done, am I really maintaining two websites? Because I can't merge the databases, that's unpossible AFAIK.
First, the name of the site will be formerly.thefogbow.com, in other words a subdomain.
Second, the DB I have is too big, I need help uploading it from the hosting company.
Third, there are configuration issues, because each hosting company has its own naming schema, and the old DB came from the previous horrible evil nightmare hosting company.
So anyway, I don't know what to do about having duplicate forums. Can you imagine? You won't even be able to remember which forum you posted what brilliant comment. I hope to give you access to all the posts in the first forum, but somehow prevent you from posting in it, because that database is unwieldy as it is, I'd hate to make it any bigger. If I can give you access to it, and everybody can see it, and you can give links to it, then that's the goal.
I'm online with the hosting company about uploading that DB.
Re: Foggy's Progress - a record of improvements to the forum
Whatever happens, Foggy, thank you for your work on this.
- Volkonski
- Posts: 12456
- Joined: Mon Feb 22, 2021 11:06 am
- Location: Texoma and North Fork of Long Island
- Occupation: Retired mechanical engineer
- Verified: ✅
Re: Foggy's Progress - a record of improvements to the forum
“If everyone fought for their own convictions there would be no war.” ― Leo Tolstoy, War and Peace
- keith
- Posts: 4406
- Joined: Mon Feb 22, 2021 10:23 pm
- Location: The Swamp in Victorian Oz
- Occupation: Retired Computer Systems Analyst Project Manager Super Coder
- Verified: ✅lunatic
Re: Foggy's Progress - a record of improvements to the forum
How big is it? Can they download/copy it to a USB message stick?
The are terabit message sticks these days
The are terabit message sticks these days
Be assured that a walk through the ocean of most souls Would scarcely get your feet wet
- Reality Check
- Posts: 2499
- Joined: Mon Feb 22, 2021 3:46 pm
- Verified: ✅ Curmudgeon
- Contact:
Re: Foggy's Progress - a record of improvements to the forum
You have to be careful with these terabyte and larger USB sticks and external drives. Many of the cheap ones are fake. Even though Windows will show the capacity they will not hold anywhere near that much data.
I assume if you restore the old Fogbow forum it would be closed to new posts? That would be terrific even if it is available for reference only. There are so many hours worth of research and history represented there.Foggy wrote: ↑Sun Aug 07, 2022 2:00 pm OK, this is a project, so bear with me.
And when we're done, am I really maintaining two websites? Because I can't merge the databases, that's unpossible AFAIK.
First, the name of the site will be formerly.thefogbow.com, in other words a subdomain.
Second, the DB I have is too big, I need help uploading it from the hosting company.
- Kriselda Gray
- Posts: 3125
- Joined: Sun Nov 28, 2021 10:48 pm
- Location: Asgard
- Occupation: Aspiring Novelist
- Verified: ✅
- Contact:
Re: Foggy's Progress - a record of improvements to the forum
That sounds like a great idea. Keeping it as a reference tool and this one as the "living" board. Good luck getting it all worked out, and thanks for the effort, O Great Rooster!Foggy wrote: ↑Sun Aug 07, 2022 2:00 pm I hope to give you access to all the posts in the first forum, but somehow prevent you from posting in it, because that database is unwieldy as it is, I'd hate to make it any bigger. If I can give you access to it, and everybody can see it, and you can give links to it, then that's the goal.
- keith
- Posts: 4406
- Joined: Mon Feb 22, 2021 10:23 pm
- Location: The Swamp in Victorian Oz
- Occupation: Retired Computer Systems Analyst Project Manager Super Coder
- Verified: ✅lunatic
Re: Foggy's Progress - a record of improvements to the forum
Quite so, but I tend to trust 'correctly priced' SanDisk. Kingston and Corsair are pretty good too, in general. Never had a counterfeit, from these guys, which means of course that the scammers are busy building them now. I also trust my local distributors with bricks and mortar retail outlets. There are several in Melbourne close to me, and I've never got a counterfeit from them, either.Reality Check wrote: ↑Sun Aug 07, 2022 11:13 pm
You have to be careful with these terabyte and larger USB sticks and external drives. Many of the cheap ones are fake. Even though Windows will show the capacity they will not hold anywhere near that much data.
Here's the SanDisk 1T message stick at one of my favourite stores: https://www.scorptec.com.au/product/fla ... 0-1t00-g46
The description above is kinda weird though. It claims its a USB 3.2 device, but doesn't say which generation 1, 2, or 2x2. It claims its read/write performace is in the hundreds of MB/second, but USB 3.2 gen 1 is already 5 GB/second (USB 3.2 gen 1 is the new name for USB 3.1 gen 1 which was the new name for USB 3.0 - I wish they would stop that).
I've got a 512gig 128gig version of the one above, purchased at my local big box office supply shop. It is not counterfeit.
Be assured that a walk through the ocean of most souls Would scarcely get your feet wet
- bill_g
- Posts: 7057
- Joined: Mon Feb 22, 2021 5:52 pm
- Location: Portland OR
- Occupation: Retired (kind of)
- Verified: ✅ Checked Republic ✓ ᵛᵉʳᶦᶠᶦᵉᵈ
Re: Foggy's Progress - a record of improvements to the forum
Thank you for trying Foggy. Herculean effort for sure. May I suggest rewatching Jurassic Park for an idea of the unintended consequences of resurrecting long dead things.
- pipistrelle
- Posts: 7965
- Joined: Mon Feb 22, 2021 11:27 am
- Reality Check
- Posts: 2499
- Joined: Mon Feb 22, 2021 3:46 pm
- Verified: ✅ Curmudgeon
- Contact:
Re: Foggy's Progress - a record of improvements to the forum
You are absolutely correct that if you stay with a well known manufacturer like Kingston, Sandisk and others you should be OK. This is an example of what I am talking about:keith wrote: ↑Mon Aug 08, 2022 2:15 am
Quite so, but I tend to trust 'correctly priced' SanDisk. Kingston and Corsair are pretty good too, in general. Never had a counterfeit, from these guys, which means of course that the scammers are busy building them now. I also trust my local distributors with bricks and mortar retail outlets. There are several in Melbourne close to me, and I've never got a counterfeit from them, either.
Here's the SanDisk 1T message stick at one of my favourite stores: https://www.scorptec.com.au/product/fla ... 0-1t00-g46
The description above is kinda weird though. It claims its a USB 3.2 device, but doesn't say which generation 1, 2, or 2x2. It claims its read/write performace is in the hundreds of MB/second, but USB 3.2 gen 1 is already 5 GB/second (USB 3.2 gen 1 is the new name for USB 3.1 gen 1 which was the new name for USB 3.0 - I wish they would stop that).
I've got a 512gig 128gig version of the one above, purchased at my local big box office supply shop. It is not counterfeit.
https://a.co/d/6Ll3jYK
1 TB for $20 is a huge red flag. A 1 TB thumb drive from SanDisk is $169 USD.
- Foggy
- Dick Tater
- Posts: 11327
- Joined: Mon Feb 22, 2021 8:45 am
- Location: Fogbow HQ
- Occupation: Dick Tater/Space Cadet
- Verified: grumpy ol' geezer
Re: Foggy's Progress - a record of improvements to the forum
It's not a question of disk size. My hard drive is 1 TB, and the hosting company can hold unlimited data. There's no function for a thumb drive/USB stick at all. We're talking only about uploading and downloading from my hard drive to the hosting company servers.
No, the problem is, the file is so goddamnned big -- remember, it has 12 years of posts, more than 1.2 million of them -- that the server "times out" before the file is fully uploaded. And I learned how to tweak the server to enable uploading very large files, and I still had a glitch because of an "invalid character" somewhere in the database (Narrator: After 12 years, there are tons of "invalid characters" in the database, it's just how the world works).
So now I'm trying a third option, which is using phpMyAdmin to import the DB into a blank database. If that works, we'll move forward from there. I think I have the server tweaked correctly to upload the file, but phpMyAdmin is saying the max filesize is 2,047 MB and I think our DB is a little bigger than that. Like I said upthread, I'm probably going to have to submit a ticket to get it done correctly, and that means a few days delay, written tickets are assigned out in order etc.
Baby steps ...
No, the problem is, the file is so goddamnned big -- remember, it has 12 years of posts, more than 1.2 million of them -- that the server "times out" before the file is fully uploaded. And I learned how to tweak the server to enable uploading very large files, and I still had a glitch because of an "invalid character" somewhere in the database (Narrator: After 12 years, there are tons of "invalid characters" in the database, it's just how the world works).
So now I'm trying a third option, which is using phpMyAdmin to import the DB into a blank database. If that works, we'll move forward from there. I think I have the server tweaked correctly to upload the file, but phpMyAdmin is saying the max filesize is 2,047 MB and I think our DB is a little bigger than that. Like I said upthread, I'm probably going to have to submit a ticket to get it done correctly, and that means a few days delay, written tickets are assigned out in order etc.
Baby steps ...
Edit: If I can't do it alone, I can upload the file using FileZilla (SFTP) and then submit a ticket. The techs there will have better and faster computers, and they'll be able to install the DB. But that's only Step One Hundred And Whatever, because then the DB is totally configured for a different hosting company and will need to be re-configged.
Re: Foggy's Progress - a record of improvements to the forum
Not sure if this applies, but once at work we had to upload a big file and we had to turn off the virus scanning program because it was slowing the process down so much (and we didn't need it anyway for that file).
- RTH10260
- Posts: 17166
- Joined: Mon Feb 22, 2021 10:16 am
- Location: Switzerland, near the Alps
- Verified: ✔️ Eurobot
Re: Foggy's Progress - a record of improvements to the forum
Did not read all of the discussion, but this hint: Some FTP clients offer the choice to transfer in chunks. Cunks are just a byte range of the file but behave like file for error recovery etc. The ftp program will make sure that all parts get completed and makes restarts if necessary. Cunks will be transferred parallel, be sure tp specify the number of concurrent tasks. Limit the total transfer to like 80% or you will not get a chance to do other work online.Foggy wrote: ↑Mon Aug 08, 2022 1:12 pm It's not a question of disk size. My hard drive is 1 TB, and the hosting company can hold unlimited data. There's no function for a thumb drive/USB stick at all. We're talking only about uploading and downloading from my hard drive to the hosting company servers.
No, the problem is, the file is so goddamnned big -- remember, it has 12 years of posts, more than 1.2 million of them -- that the server "times out" before the file is fully uploaded. And I learned how to tweak the server to enable uploading very large files, and I still had a glitch because of an "invalid character" somewhere in the database (Narrator: After 12 years, there are tons of "invalid characters" in the database, it's just how the world works).
So now I'm trying a third option, which is using phpMyAdmin to import the DB into a blank database. If that works, we'll move forward from there. I think I have the server tweaked correctly to upload the file, but phpMyAdmin is saying the max filesize is 2,047 MB and I think our DB is a little bigger than that. Like I said upthread, I'm probably going to have to submit a ticket to get it done correctly, and that means a few days delay, written tickets are assigned out in order etc.
Baby steps ...
Edit: If I can't do it alone, I can upload the file using FileZilla (SFTP) and then submit a ticket. The techs there will have better and faster computers, and they'll be able to install the DB. But that's only Step One Hundred And Whatever, because then the DB is totally configured for a different hosting company and will need to be re-configged.
- Foggy
- Dick Tater
- Posts: 11327
- Joined: Mon Feb 22, 2021 8:45 am
- Location: Fogbow HQ
- Occupation: Dick Tater/Space Cadet
- Verified: grumpy ol' geezer
Re: Foggy's Progress - a record of improvements to the forum
Thanks, but I will have to do it the easy (but time-consuming) way. I used FTP to upload the gzipped file and put in a support ticket.
More will be revealed ...
More will be revealed ...
- Reality Check
- Posts: 2499
- Joined: Mon Feb 22, 2021 3:46 pm
- Verified: ✅ Curmudgeon
- Contact:
Re: Foggy's Progress - a record of improvements to the forum
Good luck on recovering the old forum. That would be super if you could. I am glad Doc C. decided to keep OCT alive and searchable even though he is not posting anything new there.
- Tiredretiredlawyer
- Posts: 8129
- Joined: Tue Feb 23, 2021 10:07 pm
- Location: Rescue Pets Land
- Occupation: 21st Century Suffragist
- Verified: ✅🐴🐎🦄🌻5000 posts and counting
Re: Foggy's Progress - a record of improvements to the forum
I consider this thread my Foreign Language credit thread on the Bow.
"Mickey Mouse and I grew up together." - Ruthie Tompson, Disney animation checker and scene planner and one of the first women to become a member of the International Photographers Union in 1952.
- Foggy
- Dick Tater
- Posts: 11327
- Joined: Mon Feb 22, 2021 8:45 am
- Location: Fogbow HQ
- Occupation: Dick Tater/Space Cadet
- Verified: grumpy ol' geezer
Re: Foggy's Progress - a record of improvements to the forum
No maintenance tomorrow, I'm in Bathysphere or wherever it is, I don't trust the bandwidth of my dad's wifi. I'll do maintenance Monday morning bright and early, how's them potatoes.
- Foggy
- Dick Tater
- Posts: 11327
- Joined: Mon Feb 22, 2021 8:45 am
- Location: Fogbow HQ
- Occupation: Dick Tater/Space Cadet
- Verified: grumpy ol' geezer
Foggy's Progress - a record of improvements to the forum
Have to add this here ...
1. Link to the old forum added to the Board Index page, in the Welcome section.
2. Also re-created the usergroups Gadflies, Grumpy People, Badass Ladies, and Ladies in Pink. These are just for fun, there are no changes except your name color. Join and be colorful!
If you join one of these groups, say so here, and I'll make that group primary for you, which will change your name color. Example: MN-Skeptic is a Badass Lady (honestly!) so her name color is a dark red. But other groups have colors as shown above.
1. Link to the old forum added to the Board Index page, in the Welcome section.
2. Also re-created the usergroups Gadflies, Grumpy People, Badass Ladies, and Ladies in Pink. These are just for fun, there are no changes except your name color. Join and be colorful!
If you join one of these groups, say so here, and I'll make that group primary for you, which will change your name color. Example: MN-Skeptic is a Badass Lady (honestly!) so her name color is a dark red. But other groups have colors as shown above.
- Tiredretiredlawyer
- Posts: 8129
- Joined: Tue Feb 23, 2021 10:07 pm
- Location: Rescue Pets Land
- Occupation: 21st Century Suffragist
- Verified: ✅🐴🐎🦄🌻5000 posts and counting
Foggy's Progress - a record of improvements to the forum
I'm a Badass Lady too, also.
"Mickey Mouse and I grew up together." - Ruthie Tompson, Disney animation checker and scene planner and one of the first women to become a member of the International Photographers Union in 1952.
- Foggy
- Dick Tater
- Posts: 11327
- Joined: Mon Feb 22, 2021 8:45 am
- Location: Fogbow HQ
- Occupation: Dick Tater/Space Cadet
- Verified: grumpy ol' geezer
Foggy's Progress - a record of improvements to the forum
And you are now red, like a Badass Lady should be!
- Tiredretiredlawyer
- Posts: 8129
- Joined: Tue Feb 23, 2021 10:07 pm
- Location: Rescue Pets Land
- Occupation: 21st Century Suffragist
- Verified: ✅🐴🐎🦄🌻5000 posts and counting
Foggy's Progress - a record of improvements to the forum
"Mickey Mouse and I grew up together." - Ruthie Tompson, Disney animation checker and scene planner and one of the first women to become a member of the International Photographers Union in 1952.
- Foggy
- Dick Tater
- Posts: 11327
- Joined: Mon Feb 22, 2021 8:45 am
- Location: Fogbow HQ
- Occupation: Dick Tater/Space Cadet
- Verified: grumpy ol' geezer
Foggy's Progress - a record of improvements to the forum
Yeah, y'know what I haven't re-created yet, after Fogbow Reborn has been around one year, seven months, and one week already?
I haven't re-created FEMA Camp 7 1/2 yet, or Under the Bridge, or whatever other variations there were in the distant past, where I put trolls and others who were trying to pester us. But I think you may remember, realist never did cotton to the idea, no matter how much I opened it up to the rest of the world, and I simply haven't seen the need for it yet, or anything like it.
Maybe I never will put that in again.
I haven't re-created FEMA Camp 7 1/2 yet, or Under the Bridge, or whatever other variations there were in the distant past, where I put trolls and others who were trying to pester us. But I think you may remember, realist never did cotton to the idea, no matter how much I opened it up to the rest of the world, and I simply haven't seen the need for it yet, or anything like it.
Maybe I never will put that in again.
- Foggy
- Dick Tater
- Posts: 11327
- Joined: Mon Feb 22, 2021 8:45 am
- Location: Fogbow HQ
- Occupation: Dick Tater/Space Cadet
- Verified: grumpy ol' geezer
Foggy's Progress - a record of improvements to the forum
Too bad, too. The FEMA camp could be lots of fun, like remember when we had a guy join who called himself U.S. Army MSGT Ret., and he told us he was a black guy who was just trying to figure out if Obama was legit, but we found out he was really a white birther asshole who never served a day in the US Army? So I tried to set him up with a fake black lady so they could be a fake black couple and be fun at parties and stuff.
https://formerly.thefogbow.com/forum/vi ... 77#p192577
https://formerly.thefogbow.com/forum/vi ... 77#p192577
- Kriselda Gray
- Posts: 3125
- Joined: Sun Nov 28, 2021 10:48 pm
- Location: Asgard
- Occupation: Aspiring Novelist
- Verified: ✅
- Contact:
Foggy's Progress - a record of improvements to the forum
I just don't know if I'm more badass or grumpy - or if I actually fit either one. Must ponder for a bit...