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
Turn Your Content into Interactive Magic - For Free Icon
Turn Your Content into Interactive Magic - For Free

From Canva to Slides, Desmos to YouTube, Lumio works with the tech tools you are already using.

Transform anything you share into an engaging digital experience - for free. Instantly convert your PDFs, slides, and files into dynamic, interactive sessions with built-in collaboration tools, activities, and real-time assessment. From teaching to training to team building, make every presentation unforgettable. Used by millions for education, business, and professional development.
Start Free Forever
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