title: Automate MySQL DB to update tables on remote server from localhost continuously
body: <p>I am a newbie and hence need some advice.</p>
  
  <p>My problem is similar to <a href="https://stackoverflow.com/questions/34888875/replicate-my-local-database-mysql-to-remote-database-phpmyadmin">this question</a> but I couldn't resolve the problem yet.</p>
  
  <p><strong>Problem:</strong>
  I am processing data internally and generating 8-10 tables. I want to replicate those tables (in 2 different schema) to remote server <strong>automatically and continuously every 15 minutes.</strong></p>
  
  <p>I went toward AWS solution using EC2 DMS RDS but got stuck there and couldn't resolve the problem after spending two days (<a href="https://stackoverflow.com/questions/45405802/continuous-automatic-mysql-database-replication-from-local-to-remote-using-aws">here is my other question</a> if it helps to understand the background).</p>
  
  <p><strong>Proposed Solution:</strong>
  By doing research and reading <a href="https://stackoverflow.com/questions/8520367/automatic-php-mysql-update-script-using-xml-csv-ftp">this post</a>, <a href="https://dba.stackexchange.com/questions/91686/automate-csv-files-to-mysql-database">this post</a>, <a href="https://stackoverflow.com/questions/14661501/synchronize-mysql-remote-local-database-using-phpmyadmin?rq=1">this post</a> and <a href="https://stackoverflow.com/questions/11843456/cpanel-does-not-allow-using-script-to-create-file">this post</a>, I have come up to a different solution. </p>
  
  <ol>
  <li>Automatically Dump and FTP the csv file(s) to remote web server/cPanel every 15min using PHP and Windows Task Schedular.</li>
  <li>Automatically read those csv file(s) and update records on remote DB using PHP script and with some sort of task schedular on web server? (is it possible?).</li>
  </ol>
  
  <p><strong>Question/Advice:</strong>
  Is my above approach correct or do I need to find another or better solution to do this? If this approach is correct then any kind of related help would be highly appreciated.</p>
  
  <p><strong>Please note:</strong>
  I couldn't find any solution after spending hours on research on and off S.O.
  I'm no natural born coder, I find solutions to what I need to achieve</p>