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
Enterprise-grade ITSM, for every business Icon
Enterprise-grade ITSM, for every business

Give your IT, operations, and business teams the ability to deliver exceptional services—without the complexity.

Freshservice is an intuitive, AI-powered platform that helps IT, operations, and business teams deliver exceptional service without the usual complexity. Automate repetitive tasks, resolve issues faster, and provide seamless support across the organization. From managing incidents and assets to driving smarter decisions, Freshservice makes it easy to stay efficient and scale with confidence.
Try it 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