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.
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.
See more progress on: Learn MySQL
No comments:
Post a Comment