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?

I guess what I'm really looking for is something that will automatically detect teh number of tables, rows in each table, and then loop through them all, and do the appropriate create operation on a remote database.(Automatically) If so where do I get it, or ahow do I make phpMyAdmin do it? — TechplexEngineer, Sep 19 '10 at 01:42
You could adjust this: http://www.electrictoolbox.com/php-script-backup-copy-mysql-table/ — miku, Sep 19 '10 at 01:42

score 6 · Answer 1 · answered Sep 19 '10 at 01:40

6

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

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

answered Sep 19 '10 at 01:40

Delan Azabani

I am not quite sure what to do with that. – TechplexEngineer Sep 19 '10 at 02:05
It created file.But there are no any data. 0 bytes. Can you help me. – Sumith Harshan Jan 12 '13 at 13:58

nos · Accepted Answer · 2010-09-19T02:10:45.480

6

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.

edited Sep 19 '10 at 02:10

answered Sep 19 '10 at 02:05

nos

score 1 · Answer 3 · answered Sep 19 '10 at 05:22

1

You can refer this link. -

This page is titled

MYSQL DUMP — A Database Backup Program

It contains all the details.

Hope this helps you.

answered Sep 19 '10 at 05:22

Alpesh

3 Answers3