Biswajit: Created page with "Category:Radico-Khaitan == Mysql on Linux is Cases sensitive and Mysql on Windows is case insensitive == '''Problem''' The error shows st_tnt_up_excise.'''C'''ompany ..."

2019-07-30T09:26:47Z

Created page with "Category:Radico-Khaitan == Mysql on Linux is Cases sensitive and Mysql on Windows is case insensitive == '''Problem''' The error shows st_tnt_up_excise.'''C'''ompany ..."

New page

[[Category:Radico-Khaitan]]

== Mysql on Linux is Cases sensitive and Mysql on Windows is case insensitive ==

'''Problem'''
The error shows st_tnt_up_excise.'''C'''ompany doesn't exists

[[File:Screenshot from 2019-07-30 11-36-10.png ]]

== [[Solution]] ==

In my.cnf
edit /etc/my.cnf and add the following line after [mysqld]

lower_case_table_names=1

move or remove /var/lib/mysql directory. This will delete all databases!!!!

mv /var/lib/mysql /tmp/mysql

Create a new /var/lib/mysql directory and make mysql user as owner

mkdir /var/lib/mysql
chown -R mysql:mysql /var/lib/mysql
chmod 750 /var/lib/mysql
service mysqld stop
service mysqld start

Database will get initialized and then you can dump the database and start replication .

== Problem 2 ==
Due to change in SQL Mode the data is not exported from the Slave Server

[[File:Screenshot from 2019-07-30 11-33-48.png]]

== Solution ==

In my.cnf
edit /etc/my.cnf and add the following line after [mysqld]

sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION

'''Reference''' - https://tableplus.io/blog/2018/08/mysql-how-to-turn-off-only-full-group-by.html

and restart Mysqld

Issue of partial data visibility on Slave Server - Revision history

Biswajit: Created page with "Category:Radico-Khaitan == Mysql on Linux is Cases sensitive and Mysql on Windows is case insensitive == '''Problem''' The error shows st_tnt_up_excise.'''C'''ompany ..."