PHP Quick Hacks

emanuel.feruzi · 2009-10-05T12:54:12+00:00

I had write a small script to allow someone to do a dump of the MySQL database that was later sent to them by email. It worked very well until we tried it on the productions server that was running on Windows and it broke. I have rewritten it so that it works on Windows:- <?php /* variable declaration */ $db_user = "yourUsername"; $db_password = "yourPassword"; $db_database = "yourDatabaseName"; $db_server = "yourHostName"; //default: localhost $backup_path = "C:\\path\\to\\backup\\folder\\"; //e.g $backup_path = "C:\\backups\\sqldumps\\"; $path_to_mysqldump = "C:\\path\\to\\mysql\\bin\\"; //e.g $path_to_mysqldump = "C:\\xampp\\mysql\\bin\\"; $filename = "backup".date("YmdHis").".sql"; //filename with a timestamp /*construction the command to be run */ $command= "$path_to_mysqldump\\mysqldump.exe --add-drop-table --add-drop-database -h $db_server -u $db_user --password=$db_password $db_database > $filename "; /* excution of the command */ exec($command, $dump, $status); /*checking the status of the command after runing */ if($status!=0){ echo "The execution was not successfull. An empty file has been created"; }else{ echo "The execution was successfull. Backup files is " . $backup_path.$filename ; } ?> I hope some finds this useful. Comments are welcome.

Thread starter emanuel.feruzi
Start date Oct 5, 2009

emanuel.feruzi

Senior Member

Oct 5, 2009

emanuel.feruzi

Senior Member

Oct 5, 2009

Thread starter
#2

You must log in or register to reply here.

Facebook X Bluesky LinkedIn Reddit WhatsApp Email Link

Educational, Tech & Prof
Tech, Gadgets & Science Forum

Our Community

JamiiCheck
JamiiVoices
JamiiStories
JamiiData
JamiiCourses
JamiiShop
JamiiSocial
Premium Content
Start Discussion

Regional Communities

Tanzania
Uganda
Kenya

JamiiForums uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Accept Learn more…

Back

Top Bottom

Forums

New posts