From: Michael Orlitzky <michael@orlitzky.com>
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW()
Date: Fri, 28 Dec 2012 13:00:27 -0500 [thread overview]
Message-ID: <50DDDE3B.6070103@orlitzky.com> (raw)
In-Reply-To: <20121228175114.GC25197@syscon7.inet>
On 12/28/12 12:51, Joseph wrote:
>
> Yes, I run osCommerce on my server.
> Is the manuall command:
>
> mysqldump --opt -ppassword catalog > catalog_backup.sql
>
I think --opt is on by default, but yes, that should do it. If you would
like to automate the backup (say, nightly), you can add the following to
~/.my.cnf [1]:
[mysqldump]
user = <your mysql username>
password = <your mysql password>
Then, when you run the `mysqldump` command, it will use that username
and password automatically (and not prompt you). That way you can make
the backups in a cron job.
[1] Warning: chmod 600 the ~/.my.cnf file if you create one.
next prev parent reply other threads:[~2012-12-28 18:02 UTC|newest]
Thread overview: 7+ messages / expand[flat|nested] mbox.gz Atom feed top
2012-12-28 6:44 [gentoo-user] php CURRENT_TIMESTAMP vs NOW() Joseph
2012-12-28 7:00 ` Michael Orlitzky
2012-12-28 15:56 ` Joseph
2012-12-28 16:06 ` Michael Orlitzky
2012-12-28 17:51 ` Joseph
2012-12-28 18:00 ` Michael Orlitzky [this message]
2012-12-28 18:23 ` Joseph
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=50DDDE3B.6070103@orlitzky.com \
--to=michael@orlitzky.com \
--cc=gentoo-user@lists.gentoo.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox