| Diary Entries |
See also Site Info & Diary. |
| 08 Nov 2002 |
A PHP4 script to assist maintenance and crash recovery with MySQL tables... |
| |
Whilst off-work, attempting to recover my stability (personal problems in the family have led to insomnia, something which doesn’t help within a steady, commercial life), I've got to do something, so have produced a little utility script which, of course, has proved instantly useful. |
| |
I use windows 98 - first reason for the script’s usefulness - but have also found out that making changes to existing MySQL records, and specifically to text fields in those records, causes a degradation in speed on my system. My computer has 64 MB of RAM - low by modern standards - and I have lots of IE windows open when working on the database. The combination of these two seems also to make my system liable to crash. So far, constant optimisation after Text changes seems to have been successful in warding off the crashes. |
| |
The script uses 3 include files: see 4 Oct for the connection-include file, 18 Dec for the forms-include file & today for the HTML include file. Most all files use Style declarations specific to my own sites - see the Style script for the database site - and will need to be replaced by your own. The only bug is that after successful repair the first Table is still highlighted. I just cannot be bothered to fix this. |
| |
11 Apr 04 update: a very much better include file to use is at html.include.txt, although you may wish to investigate the PEAR html.php file provided with PHP. |
