MySQL

MySQL

MySQL is one of the most popular databases on the planet. It holds the top spot, along with Oracle and Microsoft SQL Server. It is especially popular as a web server database, being very easy to use. MariaDB and Percona Server are compatible with MySQL, so all our solutions for MySQL work well with MariaDB and Percona.

MySQL was made by MySQL AB, an open-source company founded in 1995. The database is named after co-founder Michael 'Monty' Widenius's daughter, My.

MySQL AB was one of the largest open-source companies in the world with around 400 employees in 25 countries. It was acquired by Sun Microsystems in 2008. Sun itself was acquired by Oracle Corporation in 2010, thus MySQL today is owned by Oracle. Monty tried stopping Oracle’s ownership of MySQL (citing worries of Oracle deliberately keeping MySQL weak in order not to cannibalize Oracle database licenses), but failed. Monty then left Sun, forked MySQL into MariaDB (named after his other daughter, Maria) and continued working on MariaDB till the present day.

Worldwide success of MySQL can be attributed to its simplicity and speed when used in simple usage scenarios. As most websites need just very simple features, MySQL excels for their use case. For a long time, MySQL didn’t even support transactions, which changed with introduction of InnoDB table storage engine, a default engine starting with MySQL 5.5. Ability to use different engines per table in a single database is one of the most innovative features of MySQL. For example, you can use very fast MyISAM engine for log files, where you don’t can about transactions, and InnoDB engine for tables holding user data, purchases, documents and like.

Programmability of MySQL is pretty modest. Compared to big players like Oracle and SQL Server, MySQL can’t compete due to many of the advanced features missing. That’s why shops who start with MySQL tend to move to one of the more powerful databases as their demands grow. However, for large scale, there are good solutions based on MySQL, so companies who have great load find that MySQL can fill their needs well.

Full Convert supports MySQL database directly. MySQL is also known as MyISAM, InnoDB (related files: frm, myd, myi).

MySQL data types we support

Integral

bigint, bigint unsigned, int (integer), int unsigned (integer), mediumint, mediumint unsigned, smallint, smallint unsigned, tinyint (bool, boolean), tinyint unsigned, year

Decimal

decimal (dec, numeric, fixed, decimal unsigned), double (double precision, double unsigned, real), float (float unsigned)

Text

char, longtext, mediumtext, nchar, nvarchar, text, tinytext, varchar

Binary

binary, bit, varbinary

Date/Time

date, datetime, time, timestamp

Large objects

blob, geography, geometry, longblob, longtext, mediumblob, mediumtext, text, tinyblob

Other

enum, json, set

Export MySQL database

It may make sense to migrate your data away from MySQL. You may want to do it permanently or just need to share your tables with a collague in a different format.

We will copy all your tables with their data and apply indexing and relationships exactly as they are in your current MySQL database. In a nutshell, you get exactly the same database in another database engine. Each time you run the migration, we will copy all the tables again. Of course, we have a built-in scheduler, so you can run this overnight and have a fresh database copy in the morning.

Take a look at the quick tutorials below to see how it's done.

Import data into MySQL database

Additionally, if you want to import data on a regular basis and do not want to recreate the whole target database from scratch every time, but rather do tiny targeted sync of only changes since the last run, please use Full Convert Pro or Ultimate.

Take a look at the quick tutorials below to see how it's done.