I'm running the bacula-mysql-2.0.1-1 rpm on Fedora Core 6. About a week
ago, my /var partition filled causing general system problems.
It gets better.
Now I'm having problems with the /usr partion (SCSI drive is dying) and
when I try to restore to a new disk, I get the following MySql error:
*restore
First you select one or more JobIds that contain files
to be restored. You will be presented several methods
of specifying the JobIds. Then you will be allowed to
select which files from those JobIds are to be restored.
To select the JobIds, you have the following choices:
1: List last 20 Jobs run
2: List Jobs where a given File is saved
3: Enter list of comma separated JobIds to select
4: Enter SQL list command
5: Select the most recent backup for a client
6: Select backup for a client before a specified time
7: Enter a list of files to restore
8: Enter a list of files to restore before a specified time
9: Find the JobIds of the most recent backup for a client
10: Find the JobIds for a backup for a client before a specified time
11: Enter a list of directories to restore for found JobIds
12: Cancel
Select item: (1-12): 9
Defined Clients:
1: alpha-fd
2: beta-fd
Select the Client (1-2): 1
The defined FileSet resources are:
1: Catalog
2: Full Set
Select FileSet resource (1-2): 2
Query failed: INSERT INTO temp1 SELECT Job.JobId,JobTdate FROM
Client,Job,JobMedia,Media,FileSet WHERE Client.ClientId=1 AND
Job.ClientId=1 AND Job.StartTime<'2007-03-26 21:59:38' AND Level='F' AND
JobStatus='T' AND Type='B' AND JobMedia.JobId=Job.JobId AND
Media.Enabled=1 AND JobMedia.MediaId=Media.MediaId AND
Job.FileSetId=FileSet.FileSetId AND FileSet.FileSet='Full Set' ORDER BY
Job.JobTDate DESC LIMIT 1: ERR=Table './bacula/JobMedia' is marked as
crashed and should be repaired
<end of output>
I know that working on the bacula database by hand is just asking for
it. I tried mysqldump but that gives me the same error. Is there
anything I can do to repair this or is this a case where all I can do is
wipe the database and reload the catalogs off tape.
TIA.
AltGrendel
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
