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.
cancer10
47
Posting Whiz in Training
Recommended Answers
Jump to PostIf you are allowed to use exec() then that will make it a one line script. Otherwise you can't access mysqldump directly through PHP.
Jump to PostIf 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:
All 8 Replies
stymiee
111
He's No Good To Me Dead
Team Colleague
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
47
Posting Whiz in Training
and how about restoring the db?
MitkOK
61
Junior Poster
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
111
He's No Good To Me Dead
Team Colleague
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
61
Junior Poster
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
0
Junior Poster in Training
this is nice one a really learn from it
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Mitko,
the restore command should be using mysql, not mysqldump.
MitkOK
61
Junior Poster
Pritaeas, you are rigth. My bad.
- Mitko Kostov
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.