Database Backup

[ye_aung]

I am trying to automate Database Backup using CRON and I would like to know the mysql command equivanent to 'Database Backup' functionality in OSCommerce.

 

'Database Backup' works well but it is a manual process. I want to automate that process.

 

Thank you,

 

- Ye

[email protected] :blink:

[osSea]

A little digging in the MySQL manual at http://dev.mysql.com/doc/refman/4.1/en/dis...prevention.html should help you with this one.

 

Cheers.

[ye_aung]

Thank you so much Dave.

 

Actually I have checked out the exact URL that you sent me before I posted initially.

 

I used the following command to backup:

 

mysqldump -u<username> -p <database name> > filename.sql

 

And out of 46 standard tables that come with OSCommerce, that above command backs up only 4 of them. 42 tables missing in the backup file.

 

 

(1) Maybe I am not using the right command to back up all tables

(2) Maybe OSComerce is using a different method and I would like to know exactly what comand they use.

 

I would like to know the exact mysql backup command they use in their admin tool.

 

That way I can use their admin tool to restore using the database backup that I create automatically using CRON.

 

Thank you.

 

- Ye