Ever had to manually edit SQL tables for your forum?

[Zyenet]

Like the topic title says, ever had to manually edit SQL databases for your forum?
I know you all are thinking what I'm saying is installing Modifications, but I'm not.
I'm talking about editing them because they just don't work, like you get the error message "Fatal error" or something.
I've never had to do it for a forum, but my topsite crashed last night, and I had to go through several tables and manually change the table names. Not fun.
Luckily, my CoffeeCup HTML Editor has a find and replace function, which made it a bit easier.
Anyone else had to do something like that?

 

[CyberFreak]

I haven't had to do anything like this yet and hopefully i never will have to.

 

[Zyenet]

I hope I never need to again. It took about 2 hours of deleting and restoring tables, renaming tables, and file uploads.
I actually thought the topsite would get restarted.

 

[Cierra]

I've had to repair some when they crashed and manually edit a member but that's about it. Luckily there are good guides on MySQL out there.

 

[Thomasss]

Yep, oh so many times. Like doing a mass password reset or mass updating peoples tables, etc.

 

[Ravenfreak]

I've only had to do this once when I was merging an existing forum to another one. I had to manually change all the previous forum software's prefix to the current one. It worked, but I ended up ultimately converting to a different software due to features. :V It was quite time consuming, but it wasn't difficult at all.

 

[Nebulous]

After I switched from MyBB to Xenforo, I ran a few SQL queries to make sure that everyone started out on the same page (in regards to the default settings and whatnot).