D
D
Dmitry Petrik2013-11-19 08:07:02
MySQL
Dmitry Petrik, 2013-11-19 08:07:02

Is there a MySQL database dump script?

I am writing a small utility to make my life easier. Need a php script to dump databases and restore them (MySql). It would be ideal if the script could archive the dump and put the archives where necessary. Well, restore the database from their own archives. Googled a little. It seems that there are some solutions, but with the naked eye you can see that the dumps are created crookedly, you need to finish it. Or there are overly cumbersome solutions (mysqldumper, Sypex Dumper). And you need something like: entered a login / password, a database name, a host, and everything is dumped into the desired folder automatically.
Maybe someone met similar scripts? Or did he write it himself and can share?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
S
SidexQX, 2013-11-19
@Flexo

http://sypex.net/ru/products/dumper/features/
there is a free version, a very simple and convenient thing))) if you find the old version, then everything works with one file...

M
Masterme, 2013-11-19
@Masterme

exec('mysqldump -u $username -p$password $database --single-transaction --quick > dump.sql');
exec('pigz -k dump.sql')

D
Dmitry, 2013-11-19
@webmix

Maybe Adminer will do?
Slightly add and cut out the excess.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question