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. |