make_mysql_tables is a shell script, not just a set of SQL statements.
Run it by itself, providing whatever options you need to connect to and
authenticate with the correct MySQL instance.
In your case, it looks like you just need to get rid of "mysql <" on
your command line.
On 11/2/2016 17:52, Thing wrote:
I went into the mysql and dropped the bacula database.
However I am having problems trying to re-create the database/tables,
============
[root@ovirt1 bacula]# mysql < make_mysql_tables -p
Enter password:
ERROR 1064 (42000) at line 9: You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version for
the right syntax to use near 'bindir=/usr/bin
PATH="$bindir:$PATH"
db_name=${db_name:-bacula}
if mysql -D ${d' at line 1
[root@ovirt1 bacula]# mysql < create_mysql_database -p
Enter password:
ERROR 1064 (42000) at line 6: You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version for
the right syntax to use near 'bindir=/usr/bin
db_name=bacula
if $bindir/mysql $* -f <<END-OF-DATA
CREATE DATA' at line 1
[root@ovirt1 bacula]#
=========
?
On 3 November 2016 at 10:35, Thing <thing.th...@gmail.com
<mailto:thing.th...@gmail.com>> wrote:
Hi,
I have bacula running on centos7.2 using mysql.
What do I do to delete the test backups and start fresh?
This must rate being a FAQ? however I find little via google on
how to do this (that worked).
thanks
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
