Gentoo Archives: gentoo-user

From: Michael Orlitzky <michael@××××××××.com>
To: gentoo-user@l.g.o
Subject: Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW()
Date: Fri, 28 Dec 2012 18:02:38
Message-Id: 50DDDE3B.6070103@orlitzky.com
In Reply to: Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW() by Joseph
1 On 12/28/12 12:51, Joseph wrote:
2 >
3 > Yes, I run osCommerce on my server.
4 > Is the manuall command:
5 >
6 > mysqldump --opt -ppassword catalog > catalog_backup.sql
7 >
8
9 I think --opt is on by default, but yes, that should do it. If you would
10 like to automate the backup (say, nightly), you can add the following to
11 ~/.my.cnf [1]:
12
13 [mysqldump]
14 user = <your mysql username>
15 password = <your mysql password>
16
17 Then, when you run the `mysqldump` command, it will use that username
18 and password automatically (and not prompt you). That way you can make
19 the backups in a cron job.
20
21
22 [1] Warning: chmod 600 the ~/.my.cnf file if you create one.

Replies

Subject Author
Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW() Joseph <syscon780@×××××.com>