List:General Discussion« Previous MessageNext Message »
From:Gerald R. Jensen Date:March 2 2003 12:13am
Subject:Re: Best way to dump for daily archiving
View as plain text  
Try ...

/usr/local/bin/mysqldump -uUserName --opt $db > $location$db.sql



----- Original Message -----
From: "Scott Haneda" <lists@stripped>
To: "Cal Evans" <cal@stripped>; "MySql" <mysql@stripped>
Sent: Saturday, March 01, 2003 5:18 PM
Subject: Re: Best way to dump for daily archiving


on 03/01/2003 3:03 PM, Cal Evans at cal@stripped wrote:

> use the -opt flag.

Can you tell me how to add in the username as well, I get a
./bin/mysqldump: invalid option -- o error

Here is the pertinent line
 /usr/local/bin/mysqldump -uUserName $db > $location$db.sql

-------------------------------------------------------------
Scott Haneda                                Tel: 415.898.2602
http://www.newgeo.com                       Fax: 313.557.5052
scott@stripped                            Novato, CA U.S.A.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread133755@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-autodata=execpc.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Thread
Restoring from a mysqldump fileJeff Mao1 Mar
  • Re: Restoring from a mysqldump fileZak Greant1 Mar
  • Best way to dump for daily archivingScott Haneda1 Mar
    • RE: Best way to dump for daily archivingCal Evans2 Mar
      • Re: Best way to dump for daily archivingScott Haneda2 Mar
        • Re: Best way to dump for daily archivingGerald R. Jensen2 Mar
    • RE: Best way to dump for daily archivingDon Read2 Mar