RE: [PHP] mysql backup
| From: | Peter Houchin | Date: | Wed, 21 Mar 2001 23:43:50 +0000 |
| Subject: | RE: [PHP] mysql backup | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-45029@lists.php.net to get a copy of this message | ||
-----Original Message-----
From: McShen [mailto:webmaster@celebritieszones.com]
Sent: Thursday, March 22, 2001 1:42 PM
To: php-general@lists.php.net
Subject: [PHP] mysql backup
hi
how do i back up a mysql DB table? Can you please write me the code?
Thanks.
---------________________________---------------------______________________
______---------
if u want to just back up one table why not just copy the files directly
from the folder your data resides in?? in MySQL you can just copy the whole
directory or the just files you want to back up .. so you don't really need
a script.. but since you asked for a script
go to your mysql/bin directory (command line or prompt)
type
mysqldump dbname table > <path to file eg /usr/local/backup or c:\backup>
Peter
--
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