Editing Issue of partial data visibility on Slave Server

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