MySQL backup not backing up all tables

2004-06-23 Thread Danny Smitherman
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

MySQL backup not backing up all tables

2004-06-21 Thread Danny Smitherman
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

Restoring database doesn't restore all tables

2004-01-23 Thread Danny Smitherman
I could use some help with restoring a backup. I have a backup file, generated using the mysqldump command. This file is approximately one gigabyte in size. I use the following command to restore this backup file: mysql -u root DevDBs New.all.aca When the command is finished executing, I