Hello, 15.10.2007 04:15,, RYAN vAN GINNEKEN wrote:: > > > 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
You should repair the tables using myisamchk. See the corresponding man page for details. > mysqldump: Couldn't execute 'show create table `File`': Table > './bacula/File' is marked as crashed and should be repaired (145) Indeed so. > mysql> source make_mysql_tables No. make_mysql_tables is a shell script and not supposed to be passed to mysql. Arno -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de ------------------------------------------------------------------------- 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
