Refresh (replicate) MySQL database from server to server I'm new to MySQL but I have experience with other major RDBMS like Oracle and MSSQL.
I'm trying to find out what are some of the widely used methods (or best practices) when it
comes to refreshing one or more MySQL databases between two servers on a nightly basis.
For example:    refresh the "QA" server from "PROD". I would like to develop an automatated 
process to handle this refresh/reload and put it on a scheduled job and have it run nightly.
The current setup is running under Linux.

I would like to get some feedbacks or suggestions from those who have done this before
or provide me with a few pointers.

Thank you
I would imagine that a nightly "refresh" between two databases like you say would involve dumping one database and importing the dump into the other database. That would lead to major performance drags every time you do that process.

Personally, I don't think that is a great idea when there are tools that allow you to replicate data between database servers. I am afraid I don't entirely understand what your use case entails, but I would recommend reading up on MySQL Replication