MySQL Replication Setup

On the Master we first flush the tables in the database setting a read lock: USE phpMyWebcam;
FLUSH TABLES WITH READ LOCK;
SHOW MASTER STATUS; The last command will show something like this +——————+———-+————–+——————+ | File | Position | Binlog_do_db | Binlog_ignore_db | +——————+———-+————–+——————+ | mysql-bin.015586 | 364167 | phpMyWebcam | | +——————+———-+————–+——————+ 1 row in set […]

Read More

MySQL Problems

* MYSQL WON’T START OR STOP?: ============================= You may never ever delete the special mysql user “debian-sys-maint”. This user together with the credentials in /etc/mysql/debian.cnf are used by the init scripts to stop the server as they would require knowledge of the mysql root users password else. So in most of the times you can […]

Read More

RSS RSS Feed

  • An error has occurred, which probably means the feed is down. Try again later.

Categories

Tags