Re: [otrs] MySQL error when trying to run /otrs-schema.mysql.sql script for otrs 6.0.3

[Renee B]

Replace &lt; with <

mysql -u root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql




Am 26.12.2017 um 08:38 schrieb Amey Abhyankar:
> Hello,
>
> I have installed MySQL 5.7.20 for Cent OS 7 using RPM method. [64bit]
> I have installed OTRS 6.0.3 using RPM.
> OTRS & MySQL are on same Cent OS 7 machine.
>
> Now trying to run mysql script using following command = mysql -u root
> -p otrs &lt; /opt/otrs/scripts/database/otrs-schema.mysql.sql  [Same
> error if I execute this command by root user or by otrs user.]
>
> But it's throwing error as follows =
>
> ------------------------------------------------------------------------------------------------------------------------------------------
> [root@localhost ~]# mysql -u root -p otrs &lt;
> /opt/otrs/scripts/database/otrs-schema.mysql.sql
> [1] 29397
> bash: lt: command not found...
>
> [1]+  Stopped                 mysql -u root -p otrs
> /opt/otrs/scripts/database/otrs-schema.mysql.sql: line 7: syntax error
> near unexpected token `('
> /opt/otrs/scripts/database/otrs-schema.mysql.sql: line 7: `CREATE TABLE acl ('
> ------------------------------------------------------------------------------------------------------------------------------------------
>
> How to solve this issue?
>
> Thanks & Regards,
> Amey.
> ---------------------------------------------------------------------
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs


-- 
Perl / OTRS development: http://perl-services.de
OTRS AddOn repository: http://opar.perl-services.de

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs