PHP - PDO mysql backup to remote host?

Question

Welcome,

How can i create a full backup of my database (all tables inside) to remote mysql server using PHP PDO ?

Is there any easy way ?

Answer 1

I would start with the MySQL documentation on replication. I would not recommend doing this with PHP and PDO. You'll have better results when you use the right tool for the job. IMHO.

Answer 2

If it's about having a backup, you should really stick to established admin tools. Use SQLBuddy or PHPMySQLAdmin.

You could write a duplication system using a RPC method or data transfer with JSON or something. But that needs securing, would be slow and only helpful for content transfer, not SQL schema replication.