Re: MySQL Database backup

The easiest way would be to call mysqldump from PHP (system, exec, backticks, whatever) and pipe it to a file, all from the command line. This would backup the core data in the form of valid MySQL statements. If you have several indexes, this method will actually produce smaller files as well. /* Chris Lambert, CTO - chris@whitecrown.net WhiteCrown Networks - More Than White Hats Web Application Security - www.whitecrown.net */ ----- Original Message ----- From: Alex Sofronie <maxx@mail.dntis.ro> To: PHP General <php-general@lists.php.net> Sent: Sunday, August 26, 2001 3:28 PM Subject: [PHP] MySQL Database backup | I tried find a solution to backup a mysql database using php but i didn't | find anything but the binary file transfer solution (just open and binary | copy all the files in my database directory). But this is not a desired | solution because it involves some security holes that I cannot afford. | Can anyone tell me where can i learn more about this? Or some simple :) and | security holes free solution? | | Thanks all. | Alex Sofronie | maxx@mail.dntis.ro | | | -- | PHP General Mailing List (http://www.php.net/) | To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net | For additional commands, e-mail: php-general-help@lists.php.net | To contact the list administrators, e-mail: php-list-admin@lists.php.net | | |