Gentoo Archives: gentoo-user

From: Joseph <syscon780@×××××.com>
To: gentoo-user@l.g.o
Subject: Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW()
Date: Fri, 28 Dec 2012 18:23:40
Message-Id: 20121228182322.GD25197@syscon7.inet
In Reply to: Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW() by Michael Orlitzky
1 On 12/28/12 13:00, Michael Orlitzky wrote:
2 >On 12/28/12 12:51, Joseph wrote:
3 >>
4 >> Yes, I run osCommerce on my server.
5 >> Is the manuall command:
6 >>
7 >> mysqldump --opt -ppassword catalog > catalog_backup.sql
8 >>
9 >
10 >I think --opt is on by default, but yes, that should do it. If you would
11 >like to automate the backup (say, nightly), you can add the following to
12 >~/.my.cnf [1]:
13 >
14 > [mysqldump]
15 > user = <your mysql username>
16 > password = <your mysql password>
17 >
18 >Then, when you run the `mysqldump` command, it will use that username
19 >and password automatically (and not prompt you). That way you can make
20 >the backups in a cron job.
21 >
22 >
23 >[1] Warning: chmod 600 the ~/.my.cnf file if you create one.
24
25 Thank you, that will help.
26 I'm stuck with oSCommerce 2.2rc2 as they don't want to put visa module in the new oSC ver. 3
27
28 ....{@} * {@} * {@} Happy New Year!
29 {@} * {@} * {@} * {@}
30 {@} * {@} * {@}
31 \ \ \ 2013 / / /
32
33 --
34 Joseph