Re: backing up database with mysqldump
| From: | dpgirago at mdanderson dot org | Date: | Mon, 25 Oct 2004 16:23:51 +0000 |
| Subject: | Re: backing up database with mysqldump | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37005@lists.php.net to get a copy of this message | ||
MySQLdump is an executable program.
From the command line:
C:\>mysqldump databasename > ./path/to/backup/file.sql (or file.txt )
C:\>mysqldump --help
gives all the options
dave
"Perry, Matthew (Fire Marshal's Office)" <Matthew.Perry@fmo.hctx.net>
10/25/2004 11:14 AM
To:
php-db@lists.php.net
cc:
Subject:
[PHP-DB] backing up database with mysqldump
I have attempted to follow the documentation for mysqldump both on
mysql.com
and previous emails to this list server. Unfortunately none of the advice
has helped me successfully backup my database. I have been spoiled by
phpmyadmin backup procedures and have never had to manually set up a
backup
system for a local server.
From shell> what should I enter tot to backup my database called "sampdb"
to
a location "c:/backups"?
Everything I have tried spits out an error message.
-Matt