mysqldump

[cancer10]

Hi

Does anyone know what is the simplest way to backup a database using the mysqldump function in php?

I have googled a lot and the codes i have found are very hard to understand and most of them does not work.

Thanx in advance for your help.

[stymiee]

If you are allowed to use exec() then that will make it a one line script. Otherwise you can't access mysqldump directly through PHP.

[cancer10]

and how about restoring the db?

[MitkOK]

If you are allowed to use exec() then that will make it a one line script. Otherwise you can't access mysqldump directly through PHP.

... or system() :cool:

[stymiee]

and how about restoring the db?

http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/2/

... or system() :cool:

:)

[MitkOK]

Backup :

$command = "mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]";

Restore :

$command = "mysqldump -u [username] -p [password] [databasename] < [backupfile.sql]";

system($commmand);

- Mitko Kostov

[atplerry]

this is nice one a really learn from it

[pritaeas]

Mitko,

the restore command should be using mysql, not mysqldump.

[MitkOK]

Pritaeas, you are rigth. My bad.

- Mitko Kostov