Re: back-up mysql database using PHP
| From: | Sebastian Hopfe | Date: | Wed, 07 Nov 2007 12:20:50 +0000 |
| Subject: | Re: back-up mysql database using PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-264172@lists.php.net to get a copy of this message | ||
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?