How to Set Up MySQL Replication
Why Stack Overflow recommends it
Stack Overflow users link it as a short, visual walkthrough of basic MySQL replication setup in phpMyAdmin/XAMPP, usually for people working with local or small setups.
Recommended by 1 people across 1 different months, 2015 to 2017.
What it is
A roughly three-minute HowTech tutorial showing how to set up MySQL master replication through phpMyAdmin on a XAMPP server. It walks through the Replication tab, picking which databases to replicate, and adding the generated lines to the my.ini file.
What people said
Recommends sdittmar · 2017-11 · Stack Overflow · on “replication tab missing on php my admin”
You are probably using an older version of phpmyadmin. I had the some problem yesterday. You will find the replication information under the "Status" tab and than the [replication] link, which will take you to the bottom of the same page. I found the following short video helpful to understand the basics: [this video] I edited the my.ini file of the MySQL (master) server by hand to include the following lines in the Master section: log-bin=mysql-bin log_error=mysql-bin.err binlog_do_db=<your_database_to_replicate> If you want to replicate the entire server, than you can omit the last line. Or alternatively, if you want to replicate all but certain databases than for each of those db you add: binl
Cites acupofjose · 2015-05 · Stack Overflow · on “CodeIgniter: How to synchronize local and remote databases”
Option 1: The Codeigniter Way You can set up a remote access MySQL server: Tutorial for cpanel here: [LINK] connections-in-cpanel/ Then just set up a new connection in your database.php changing the to $db['remote']['hostname'] = 'xxx.xxx.xxx.xxx'; Do note that you'll have to make a method to pull in this new data and replace it in your local database, so a script that can be run via cronjob. Option 2: The Master/Slave Way You can set up a Master database, being the hotel, and a slave being your local database. I don't know of a method to do this straight cpanel, but you can do it in phpmyadmin, there's a video on how to do it here: [this video] This method would be the most comprehensive/automat
Cites Kenziiee Flavius · 2017-12 · Stack Overflow · on “Xampp Database Replication Setup Error”
Scenario I've been trying to set up mysql database replication on my xampp server but its not been working. I get the following error [LINK] and the error logs display the following message. 2017-12-28 10:14:37 10384 [ERROR] Slave I/O: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it). Internal MariaDB error code: 1593 2017-12-28 10:14:37 10384 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 I understand what the error is saying but im no