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
Gen AI apps are built with MongoDB Atlas Icon
Gen AI apps are built with MongoDB Atlas

The database for AI-powered applications.

MongoDB Atlas is the developer-friendly database used to build, scale, and run gen AI and LLM-powered apps—without needing a separate vector database. Atlas offers built-in vector search, global availability across 115+ regions, and flexible document modeling. Start building AI apps faster, all in one place.
Start Free
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