title: Automating data dump and restore between Postgres and MySQL
body: <p>I've just set up a delta-loading data flow between multiple Mysql DBs and a Porgres DB. It's only copying tens of Mbs every 15mins.</p>
  
  <p>Yet, I'd like to set a process to fully load the data between them in case of emergency...</p>
  
  <p>Python is just crashing and seems not to be fast enough when using SQLachemy etc.</p>
  
  <p>I've read that the best might be to just dump everything from MySQL into CSV and then use file_fdw to load the entire tables into Postgres..</p>
  
  <p>Has anyone faced a similar issue? If yes, how did you proceed?</p>