2010/8/18 Daniel P. Brown <daniel.brown@xxxxxxxxxxxx>: > On Tue, Aug 17, 2010 at 15:19, tedd <tedd@xxxxxxxxxxxx> wrote: >> >> Bingo -- that worked. >> >> It's interesting that a space is optional between -u and user, but required >> to be absent between -p and password. Seems not symmetrical to me. > > The command I sent was because - as I said in the original thread > - passing any password directly to the command line is Very Bad[tm]. > If you're passing it via exec(), though, and don't want to use an > 'expect' shell, passing it directly to -p is at least a bit less > dangerous. Plus, doing so will not leave anything in your > ~/.bash_history on the server. > > That said, sorry for appearing inattentive, despite this being > directed right at me. I have been out of the office more than in for > the last couple of weeks, while working on a ton of new stuff. > Eventually it will go back to "normal." > > -- > </Daniel P. Brown> > UNADVERTISED DEDICATED SERVER SPECIALS > SAME-DAY SETUP > Just ask me what we're offering today! > daniel.brown@xxxxxxxxxxxx || danbrown@xxxxxxx > http://www.parasane.net/ || http://www.pilotpig.net/ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > I recommend gzipping it on the fly and if you're using own MYSQL functions and /or stored procedures, then I'd add --routines as parameter to include these in your sum. Here's my command line: $ mysqldump -u USERNAME -p --opt --single-transaction --routines DATABASENAME | gzip > sqldump.sql.gz Note that you must only replace Databasename and Username in the example.. mysqldump will ask for the passwort. If you specify your password in the command line, then you end up haviung it in your shell history which can make it easy for crackers. --opt means the same as: --add-drop-table, --add-locks, --create-options, --quick, --extended-insert, --lock-tables, --set-charset, and --disable-keys. and is enabled by default. Regards -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
