Nigel Hamilton wrote: > HI Lyle, > > Your last idea sounds like a good one. Add the new tables with a > suffix .new and then rename them when you're happy. Once all the > tables are in the same database you can run UPDATE commands to > increase the total columns - or whatever cronjob is computing the > totals in the first place might magically recalculate them for you? ;-)
I think your right. Once the backup data is in the new database I'll be able to sort it all out. > > I use webmin's MySQL module for doing this sort of thing as it > helps you with RENAME and other less common SQL you otherwise have to > get the manual for. I've always found Webmins MySQL module a bit of a pain and usually end up installing phpMyAdmin. Lyle _______________________________________________ BristolBathPM mailing list [email protected] http://mailman.bristolbath.org/mailman/listinfo/bristolbathpm
