Periodically exporting table info from mysql to phpmyadmin -


so i've found plenty of answers perform kind of operation once-off, not periodically. thought interesting share might best technique , gain insight.

picture have windows database a. database keeps important information company, , available on local intranet. however, need make of data available.

for this, we're looking export data mysql phpmyadmin database b.

the issue however, want automatically once per day, rather one-off export. how 1 best go achieving this?

edit: clarify, i'm attempting poll might best way go around syntax issues might arise, , "good form" in situation this, since honest first time of kind. additional information specific situation might find useful:

the mysql database hosted remotely on web server, windows database hosted locally. phpmyadmin version: 3.5.8.2 attached mysql database: 5.5.42 windows database: 2008 r2

the exact goal we're trying achieve: got table "users" in windows database. inside table users have few values want move phpmyadmin. (firstname, name, birthdate...) ideally i'm looking use scheduled tasks perform once each day, work these (such powershell script) appreciated.


Comments