I am having trouble running the bacula drop_mysql_tables and make_mysql_tables
i always get the error below. The reason i need to run these commands is i
think there is a problem with my bacula database i keep getting this error when
i restart bacula however a stop and start gives no error.
bacula-dir restart
Stopping bacula_dir.
Orphaned buffer: backup1-dir 26 bytes buf=80f4318 allocated at
parse_conf.c:438
Waiting for PIDS: 18987.
Starting bacula_dir.
Whn i try to dump the database as described in the manual i get this error
mysqldump -u bacula -f --
opt bacula > bacula.sql
mysqldump: Got error: 145: Table './bacula/File' is marked as crashed and
should be repaired when using LOCK TABLES
mysqldump: Couldn't execute 'show create table `File`': Table './bacula/File'
is marked as crashed and should be repaired (145)
mysql> source make_mysql_tables
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'bindir=/usr/local/bin
db_name=bacula
if $bindir/mysql $* -f <<END-OF-DATA
USE ${' at line 1
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'END-OF-DATA
then
echo "Creation of Bacula MySQL tables succeeded."
else
ec' at line 1
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
