Menu
My MySQL database (local server) is connected to a weather station. The data are updated continuously on my local server. My idea is to develop a web application that allows me to access this data.
My local database (MySQL) has to be replicated on a remote server (phpmyadmin)
The architecture is as follows:
My questions are: 1- How I do the connection ? I know that I can import my cvs file manually but I don't want to do this. 2- Can I update the datas automatically in my remote server ?
NOTE: I only want to queries on my remote server (phpmyadmin), I will not create or modify new datas. Thanks you for your help.
252
Access Remote MySQL database on phpMyAdmin. Step 1: Enable WSL on Window 10 ( Linux user skip this) Step 2: Install MySQL. Step 3: Install phpMyAdmin locally or on a remote server. Step 4: Edit configuration file. Step 5: Run phpMyAdmin to access a remote database.
MySQL is a widely used Database by big organizations to run their business activities. Data replication is one such technique that allows users to access data from numerous sources such as servers, sites, etc. in real-time. Companies Replicate MySQL Database to tackle the challenge of maintaining high data availability.
In most cases, the MySQL server and phpMyAdmin both are installed on the same server so that the management of the database becomes easy. However, do you know? We can even access the remote server in the phpMyAdmin with just a little tweak. If not, then here is the tutorial on that.
Whether you have installed it on the local or some remote cloud/hosting server, after installing the phpMyAdmin; open the browser and type the server’s ip-address/phpmyadmin. Note: replace the IP-address text with real IP of yours. Once the interface of this open-source database management tool appears you will see the login screen.
As i understood, you want to make a copy of your local mysql data on a remote server.
first of all phpmyadmin is a tool or webapp to access mysql , it is not a server itself.
and second
there are two type of replication approach
You can choose the approach as per your requirement
Master-master vs master-slave database architecture?
How to achieve replication
http://dev.mysql.com/doc/refman/5.7/en/replication-howto.html
171
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
