Mysql Error 1219
an malware detection (FilesManBackdoor) [Solved] ISP-CP can't send mail viaoutlook Installing NginX as Frontend to Apache for ISPCP [Part1] Installing NginX as Frontend to Apache for ISPCP [Part2] สวัสดีชาวโลก - -‘ How to install Tomcat6 +Mod_JK Enable wildcard domain inIspCP Setup NTP Linuxdatetime หมวดหมู่ คอมพิวเตอร์และอินเทอร์เน็ต (4) สุขภาพและความสุขสมบูรณ์ (1) ไม่มีหมวดหมู่ (19) Computers and Internet (12) Education (1) How to MySQLReplication Posted: สิงหาคม 26, 2009 in คอมพิวเตอร์และอินเทอร์เน็ต 0 1 Configure The Master First we have to edit /etc/mysql/my.cnf. We have to enable networking for MySQL, and MySQL should listen on all IP addresses, therefore we comment out these lines (if existant): #skip-networking#bind-address = 127.0.0.1Furthermorewe have to tell MySQL for which database it should write logs (theselogs are used by the slave to see what has changed on the master),which log file it should use, and we have to specify that this MySQLserver is the master. We want to replicate the database exampledb, so we put the following lines into /etc/mysql/my.cnf:log-bin = /var/log/mysql/mysql-bin.log# what database you want to replicationbinlog-do-db=exampledbserver-id=1 Then we restart MySQL: /etc/init.d/mysql restart Then we log into the MySQL database as root and create a user with replication privileges: mysql -u root -p Enter password: Now we are on the MySQL shell. GRANT REPLICATION SLAVE ON *.* TO ‘slave_user'@'%' IDENTIFIED BY ‘
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Replication :: Replication - sync slave table with master New Topic Advanced Search Replication - sync slave table with master Posted by: Milo () Date: April 26, 2005 11:20AM Hi, I am using MySQL 4.1.8a on Debian Linux. I wonder what's the best practice to sync a replicated slave table with the master table. I have a table with 8000 rows in the master table but only 7000 rows in the slave table. How can I sync the https://mirindafanta.wordpress.com/2009/08/26/how-to-mysql-replication/ slave table? I realize the situation should not occur, but if it does... ;-) I thought this should do it: use
at work, and replicating is really simple and easy check the steps bellow a) You must have 2 servers http://adrianavarro.com/blog/2007/07/25/how-to-mysql-replication/ running MySQL ( I like MySQL-Max ) b) There will be 2 configurations one p/ server ( Master ) and one per client ( Client 😛 ). --- >Server / Master Side: 1) Edit /etc/hosts.allow and add this line ( you MUST change this IP's for yours !! ) mysql: 192.168.10.70 192.168.10.13 2) Edit my.cnf …. In my case mysql error located at: /etc/my.cnf * I'm going to show just a what you need the my.cnf file contains much more info.
####### Comment this lines:
bind-address = xxx.xxx.xxx.xxx
skip-networking
####### Make sure this lines exists in the [mysqld] Section:
log-bin=mysql-bin
server-id = 1
3) Now lets move to mysql using a power user mysql error 1219 like root xD
mysql> GRANT ALL ON databasename.* TO repl@'%' IDENTIFIED BY 'put_some_pass_here';
mysql> FLUSH PRIVILEGES;
mysql> GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO repl@'%' IDENTIFIED BY 'put_some_pass_here';
4) restart MySQL service --- >Client Side: 5) Edit my.cnf …. In my case located at: /etc/my.cnf * I'm going to show just a what you need the my.cnf file contains much more info.
#### Add this lines or modify them
log-bin=SOME_NAME-relay-bin
server-id = 2
#### This number increases when you add more than one SLAVE os CLIENT to the MASTER server
master-host = 192.168.50.8
#### Put the Hostname or IP from your MASTER server
master-user = repl
master-password = put_some_pass_here
replicate-do-db=databasename
6) restart the service 7) done !! all data will be Replicated. 8) Troubleshooting Master:
mysql> SHOW GRANTS FOR repl;
mysql> SHOW MASTER LOGS \G
mysql> SHOW BINARY LOGS;
mysql> SHOW MASTER STATUS;
mysql> RESET MASTER ---> ( CAUTON !!! )
-------- SLAVE:
mysql