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

Renee B <[email protected]>
Newsgroups gmane.comp.otrs.user
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.