Change the encoding and collation of mysql databases on the fly. Clean html characters from your database, change the database storage engine, select collation type or convert text to UTF-8 or any other encoding. Completely configurable filter options.

This script primarily useful in database migration and changing your database to finally support UTF-8 and other encoding types.

Features

  • convert mysql database to utf8
  • convert mysql database engine to InnoDB
  • configure mysqltr to remove/change specific entities in your database

Project Activity

See All Activity >

License

GNU General Public License version 3.0 (GPLv3)

Follow mysqltr

mysqltr Web Site

Other Useful Business Software
Paessler: Easy to Use With Enterprise Power. Free Trial Icon
Paessler: Easy to Use With Enterprise Power. Free Trial

A low-code dashboard makes monitoring intuitive for any admin, while scripting and custom sensors give experts full control.

You shouldn't have to choose between a monitoring tool that's easy to use and one that's powerful enough for a complex environment. PRTG's low-code interface lets any admin build dashboards, set alerts and monitor devices without scripting, while custom sensors and full API access are there when your team needs deeper control. One platform, no compromise. Download a free 30-day trial now.
Get Free Download
Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
★
0
1
0
0
0
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5

User Reviews

  • Hello, in my situation this is a very valuable tool! Unfortunately it isn't functional in my environment. My database includes defined functions and views that use those functions. When running mysqltr on this db, it returns the error message ERROR 1305 (42000) at line 6360: FUNCTION db.pName does not exist db is the database that should result after the conversion. It seems to me that the functions should be "transferred" before the tables, views and other stuff. Regards - and thanks for any comments H. Stoellinger, Salzburg
Read more reviews >

Additional Project Details

Operating Systems

FreeBSD, Linux, Mac, NetBSD, OpenBSD

Languages

English

Intended Audience

Advanced End Users, Developers, System Administrators

User Interface

Command-line, Console/Terminal

Programming Language

Unix Shell

Database Environment

MySQL, Project is a database conversion tool

Related Categories

Unix Shell Database Software, Unix Shell Database Engines Servers, Unix Shell Internationalization (I18N) Software

Registered

2013-03-18