MySQL to MySQL clone with PHP

Question

Anyone know of a PHP script that will clone an entire MySQL database to another on another server? As a sort of backup?

Answer 1

phpMyAdmin does this very well. Of course, if you had shell access, try this instead:

mysqldump -u [username] -p [password] [database] > [filename]

Answer 2

You'd have your PHP script run (with e.g. the exec() or system() call) something like

mysqldump -q -C --databases mydatabase | mysql -C -h othermachine

Add the appropriate flags to these commands for specifying credentials, etc.

Answer 3

You can refer this link. -

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

This page is titled

MYSQL DUMP — A Database Backup Program

It contains all the details.

Hope this helps you.