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
– TechplexEngineer, Commented Sep 19, 2010 at 1:42
You could adjust this: electrictoolbox.com/php-script-backup-copy-mysql-table — miku
– miku, Commented Sep 19, 2010 at 1:42

nos · Accepted Answer · 2010-09-19 02:10:45Z

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, 2010 at 2:10

answered Sep 19, 2010 at 2:05

nos

231k60 gold badges436 silver badges516 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Delan Azabani · Accepted Answer · 2010-09-19 01:40:47Z

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, 2010 at 1:40

Delan Azabani

81.8k30 gold badges174 silver badges215 bronze badges

2 Comments

TechplexEngineer Over a year ago

I am not quite sure what to do with that.

Sumith Harshan Over a year ago

It created file.But there are no any data. 0 bytes. Can you help me.

Alpesh · Accepted Answer · 2010-09-19 05:22:18Z

1

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.

answered Sep 19, 2010 at 5:22

Alpesh

5,4152 gold badges23 silver badges19 bronze badges

Collectives™ on Stack Overflow

MySQL to MySQL clone with PHP

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related