manpage

NAME:

• mysqltr

SYNOPSIS:

• mysqltr --from=user@host[port]/database --to=user@host[port]/database [OPTIONS]

DESCRIPTION:

mysqltr provides for the following functionality:

• Change the encoding of a database.
• Change a database or table collocation
• Rename a database
• Delete/strip/change database data through regular expressions.
• Change a table database engine type
• Whitelist or black list tables from the conversion process

MYSQLTR OPTIONS:

• --blacklist=blacklist
  ** A comma seperated list of table names to exclude from the database conversion.
• --collation=collation
  ** The desired target collation for the database conversion. The Default is utf8_general_ci
• --encoding=encoding
  ** The desired target encoding. The default is utf8
• --engine=engine
  ** The database engine to be applied the the converted tables. The default is InnoDB
• --from=user@host[:port]/database
  ** The source database from where the original data will be streamed. The user is the mysql username. host is the host where the mysql server resides. The port is optional. If it is not specified, the default mysql port 3306 will be used. The database refers to the database name.
• --help
• --silent
• --to=user@host[:port]/database
  ** The destination database to where the original data will be streamed. The user is the mysql username. host is the host where the mysql server resides. The port is optional. If it is not specified, the default mysql port 3306 will be used. The database refers to the database name.
• --whitelist=whitelist
  ** A comma seperated list of table names to include from the source database