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 |