NAME

upgrade_mysql.pl - upgrades the sites mysql database to the description in mysql.str


SYNOPSIS

  perl upgrade_mysql.pl [-bn] [-v [verbosity]]


DESCRIPTION

Upgrades your BSE database, as described in your Constants.pm to the schema described in mysql.str.

BACKUP YOUR DATABASE BEFORE USING THIS TOOL.


OPTIONS

-b

Asserts that the user has done a backup. Avoids the interactive query about having done a backup.

-n

Only check for the changes needed, rather than actually performing the upgrade. Since it's possible that tables might not exist when checking for indices, this may give you some errors.

-v [verbosity]

Controls verbosity of output. The default level (1), will produce basic descriptions of what is happening, including which table is being checked, and any changes being made.

Level 2 will print debug messages containing any SQL that's being executed.

Level 3 prints information useful only to developers.

-i filename

Specify and input filename that isn't mysql.str.

-h

Display help.


AUTHOR

Tony Cook <tony@develop-help.com>


REVISION

$Revision$


SEE ALSO

bse