Script to Check or Repair All MySQL Databases
Tags: sfx
, nelli-tuning
, intermediate
Last Updated: Oct 30, 2009 01:52
- Author: Ere Maijala
- Additional author(s):
- Institution: None
- Year: 2008
- License: MPL 1.1 / GPL 2.0
- Short description: Use, modification and distribution of the code are permitted provided the copyright notice, list of conditions and disclaimer appear in all related material.
- Link to terms: MPL 1.1, GPL 2.0
- Skill required for using this code: intermediate
Description
A small script that runs the table_maintenance.pl script provided with SFX for all instances.
The method, modifying environment variables, works for us for now but has to be considered a hack.
State
Stable
Author(s) homepage
http://wiki.helsinki.fi/display/Nelli/Etusivu
Download
Using the following Ex Libris API
None.
Changes
Version 1.0
Initial release.
Release notes
None.
Installation instructions
- Use sfxglb3 user account. The script will read the instance list from the config file instances.config_ in sfxglb/config
- Unpack somewhere on the SFX server
- Make the script executable (chmod +x filename) and run it in a directory with write permissions, because the script will write log to table_maint.log in the current directory
- The script defaults to check mode. Run with parameter --repair to run it in repair mode.
- When the script has finished, check table_maint.log for errors.
Please contact Ere Maijala (ere.maijala (at) helsinki.fi) for more information or if you encounter any trouble with the installation.
TO DO list
-
Known issues
None.
Comments