I have a shell script that looks something like that:
#!/bin/bash mysql -udb_user -pdb_password -e "LOAD DATA LOCAL INFILE '/srv/some_file.csv' INTO TABLE db_name.db_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (\`col1\`,\`col2\`,\`col3\`);"
the problem is that when I run this script on my master server the call doesnt get replicated to the slave server (even though
/srv/some_file.csv exists on both servers).
any ideas how to make shell command replicate over servers?