MySQL really needs an undo button...
Jul. 15th, 2006 11:22 amIn an attempt to be clever and update all future LondonFur meets on my Furmeets UK site with the new venue, I accidentally made an error with my SQL and managed to update all meets, past and future with the new LF meet venue... (I know, it really shouldn't have happened but my SQL is rusty and I did it fairly early in the morning).
I didn't make a backup before making the change so I've emailed my domain host in the vein hope that they have a backup they can restore. If not, I will need to manually modify all of the meets historically and future meets to show the correct data. As such, please can anyone reading this who has any info for meets which show as "lost data" or meets which show incorrect info let me know the correct details, it would be much appreciated.
Update: Looks like my domain host was able to restore it after all. It's back the way it was now. Now I've just gotta update all the LondonFur meets to the new venue again :P
I didn't make a backup before making the change so I've emailed my domain host in the vein hope that they have a backup they can restore. If not, I will need to manually modify all of the meets historically and future meets to show the correct data. As such, please can anyone reading this who has any info for meets which show as "lost data" or meets which show incorrect info let me know the correct details, it would be much appreciated.
Update: Looks like my domain host was able to restore it after all. It's back the way it was now. Now I've just gotta update all the LondonFur meets to the new venue again :P