Hi there! I’m trying to figure out how to automatically sync a database from phpMyAdmin to my local MySQL setup. I need to create a copy of a database that my service provider manages, but I can’t access their MySQL server directly. My plan is to do a complete initial import to my local database, then set up regular updates to keep everything current. This is for building a Power BI dashboard that needs this data. Here are my system specs:
MySQL Setup:
- Host: Local via UNIX socket
- Type: MySQL
- Version: 5.7.42-0ubuntu0.18.04.1
- Protocol: v10
- Charset: cp1252 West European
Server Environment:
- Apache 2.4.29 on Ubuntu
- PHP 7.2.34 with mysqli and curl support
- MySQL client: libmysql mysqlnd 5.0.12-dev
What would be the best approach for this kind of automated backup process?