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

You Might Also Like
Integrate in minutes with our email API and trust your emails reach the inbox | SendGrid Icon
Integrate in minutes with our email API and trust your emails reach the inbox | SendGrid

Leverage the email service that customer-first brands trust for reliable inbox delivery at scale.

Email is the backbone of your customer engagement. The Twilio SendGrid Email API is the email service trusted by developers and marketers for time-savings, scalability, and delivery expertise. Our flexible Email API and proprietary Mail Transfer Agent (MTA), intuitive console, powerful features, and email experts make it easy to ensure all your email gets delivered in seconds and without interruption.
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

Linux, OpenBSD, FreeBSD, NetBSD, Mac

Languages

English

Intended Audience

Advanced End Users, System Administrators, Developers

User Interface

Console/Terminal, Command-line

Programming Language

Unix Shell

Database Environment

Project is a database conversion tool, MySQL

Related Categories

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

Registered

2013-03-18