I tested three following methods for migration but above mentioned method is secure, faster and reliable. The default path of MySQL datadir in Linux is (/var/lib/mysql). Copy database tables from Windows to Linux on a newly created database by OS level using any tool like WinSCP, Filezilla, or by ssh script.Create a database by using any tool like Navicat, MySQL Workbench, or MySQL command line.Save the file and restart the MySQL server by this command to apply the changes (service mysql restart).Add (lower_case_table_names=1) parameter in config file.Open the MySQL config file (vi /etc/mysql//mysqld.cnf).First login on Ubuntu by ssh with sudo rights. Navicat for MySQL comes with an intuitive and well-designed GUI that simplifies your database administration and development on Linux, Windows, and macOS systems.One Ubuntu18 64bit server with MySQL database.Ĭopy databases from Windows to Ubuntu OS.ĭatabases table names in different naming conventions like (PkaistanCitiesList), and when we copy these tables from windows our scripts do not work because table names not recognized due to case-sensitive issues.One windows server 2012 with MySQL database.

Install navicat ubuntu