Sunday, August 14, 2005

Remembered

I used PHPMyAdmn to explore the MySQL Database and this reminded me of the syntax for creating queries.
So now I have saved query scripts which will delete all rows from the ‘old’ table where ip-text = whatever, and clean up the recentchanges as well as emptying the archive for deleted pages.
Luckily I remembered eventually that nothing actually gets done until after you issue a “commit” command, and that the tables need to be optimised again in order to release the saved file space.

Low priority task remaining:




I still haven’t worked out which tables the individual page histories are stored in, or why the recent changes won’t go back very far.

No comments: