s_ramesh
  • Member for 7 years, 7 months
  • Last seen more than a month ago
  • India
Replicate_Do_DB and Replicate_Wild_Do_Table - Replication does not work
0 votes

Why can’t you use ignoring the particular table from binary logging. [mysqld] log-bin = /var/logs/mysql/bin.log binlog-do-db = db1 binlog-do-db = db2

View answer
Keep mysql.socks
0 votes

You can't change Data directory dynamically. Only option is you have to change in configuration file and bounce the database.

View answer
Remote MySQL connection fails (10060) - "Can't connect to MySQL server on domainname.com(10060)"
0 votes

Provide the output of the telnet (ip): port I had the same issue last time and the iptables is the culprit at that time. When the server got rebooted the iptables rule turns to default and it didn'...

View answer
Slowing down in MySQL insertion with 3 indexes and 1 foreign key
-1 votes

Do the following before you loading the table SET UNIQUE_CHECKS=1; SET autocommit=0; SET unique_checks=0; SET foreign_key_checks=0; Once the import has been completed, enable all. Use multiple-row ...

View answer