I am having trouble with a nightly backup of our MySQL database. Using the
mysqldump command, we dump our entire database to a backup directory. But
consistently the backup file contains only 33 of the 88 tables in the
database. The 33 getting backed up are the first 33 of the 88 as sorted
alphabetically by table name.

Here are the relevant lines in the backup script:

mysqldump --opt ACA >/home/sites/home/users/admin/dump/ACA/`date
--date '1 day ago' +%m%d`.all.ACA
mysqldump mysql >/home/sites/home/users/admin/dump/ACA/`date --date '1
day ago' +%m%d`.mysql

I'm a newbie with MySQL, so I don't know what other info to provide.

I appreciate your help.
 
Danny S.

*****************************
Adventure Cycling Association
Inspiring people of all ages to travel by bicycle.
800/755-2453, 406/721-1776
www.adventurecycling.org 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to