RE: [PHP-DB] MYSQL Table Dump
| From: | Jennifer Goodie | Date: | Wed, 10 Sep 2003 20:33:43 +0000 |
| Subject: | RE: [PHP-DB] MYSQL Table Dump | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30453@lists.php.net to get a copy of this message | ||
> Is there any way *from the command line* to get a dump of a mysql
> table and
> have it saved to a local file, instead of standard output
from running mysqldump --help
-r, --result-file=... Direct output to a given file. This option should be
used in MSDOS, because it prevents new line '\n'
from being converted to '\n\r' (newline + carriage
return).
So... mysqldump -ulogin -p -rfile.sql database [tables]
Or on a 'nix box just use > to pipe it to a file.
mysqldump -ulogin -p database [tables] > file.sql
Assuming 'login' is your username and you want to be prompted for a
password.