I already tried that,
[root@ovirt1 bacula]# ./create_mysql_database
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
Creation of bacula database failed.
[root@ovirt1 bacula]#
On 3 November 2016 at 11:03, Mike Ruskai <than...@earthlink.net> wrote:
> 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> 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
> listBacula-users@lists.sourceforge.nethttps://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
>
>
------------------------------------------------------------------------------
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
