greglo.blogg.se - Navicat on ubuntu

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.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.