Re: Re: back-up mysql database using PHP

On 11/7/07, Sebastian Hopfe <s.hopfe@gmx.net> wrote: > > Dear Vanessa > > You can use the "SELECT ... INTO OUTFILE 'file_name' " with > mysql_query($vAnf, $dbconn); > For the syntax you can have a look at > http://dev.mysql.com/doc/refman/5.0/en/select.html > > Should you be allowed to send system-queries to the Server, than you > should > have a look to > http://dev.mysql.com/doc/refman/5.0/en/backup.html > > There are many ways to backup the Database. I thought this will help you. > > Regards > Sebastian > > ""Vanessa Vega"" <vanessa@activediscovery.net> schrieb im Newsbeitrag > news:ED.FC.31692.5F071374@pb1.pair.com... > > hello there....is there a way to create a back-up database through > > PHP?...i would like to create a file maybe an sql file that would served > > as back up of my database. Im using mysql database. I know i could use > > phpmyadmin to do this but i just like to have a function that would do > > this without going to phpmyadmin.any help? With a quick google search of "php mysqldump", this was the first result: http://www.php-mysql-tutorial.com/perform-mysql-backup-php.php I personally like mysqldump. It's fast and it saves all the table info.... and you can use PHP to call it. For more info (parameters, etc) on mysqldump: http://dev.mysql.com/mysqldump Good Luck, ~Philip