[PHP] Re: back-up mysql database using PHP

2007-11-07 Thread Sebastian Hopfe 

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 [EMAIL PROTECTED] schrieb im Newsbeitrag 
news:[EMAIL PROTECTED]
hello thereis 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? 


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Re: back-up mysql database using PHP

2007-11-07 Thread Philip Thompson 
On 11/7/07, Sebastian Hopfe [EMAIL PROTECTED] 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 [EMAIL PROTECTED] schrieb im Newsbeitrag
 news:[EMAIL PROTECTED]
  hello thereis 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