Undoing Queries
 

Hi there everyone...Alright I am going to be doing some changed on my site and would like to remove some hacks. Some of the hacks have altered the tables in the db (see below for example)

How do I go about reversing what was changed?

Thanks everyone for the help!

in this case it would be:
[sql]ALTER TABLE user DROP INDEX (lastactivity);[/sql]
But the reverse will vary with each statement.

Thank you very much...so 'ADD' would be 'DROP' what are some of the others?

Alright I am confused...I get an SQL error when I try to run that.

What is the error you get?

I am getting a syntax error....I cannot duplicate it right now, but it basically says I have something wrong with my SQL syntax??

Well it is difficult to help without the full error.

I understand...I am sure I will get it as soon as I attempt another one...I will report back. Hey, with that said, do you know the answer to this:

Currently I am running VB 3.0.3 and my server is running 4.1.13 for SQL.

Previously I had a server that was running SQL 4.1.9 it it jacked up my attachments and avatars.

My question is, have they fixed the collation bug in 4.1.13? Can I backup that database without issues or do I have to run those queries first?

Thanks!

Define 'Those queries', are you talking about the changes posted at vb.com?

And to answer: yes on 3.5 and 3.0.8 the workaround for the MySQL bug is done.

I understand what you are saying. What I wanted to do is make a backup of my curent forums which are 3.0.3 do I need to run those queries from vb.com or will I be ok since I am using sql 4.1.13?

Since you are running MySQL 4.1, you should run them before making a backup if your board is not on 3.0.8 or 3.5.

PS This assuming that we talk about the same queries from vb.com.