On 26 December 2017 at 13:24, Renee B
Replace < with <
mysql -u root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql
Thanks Renee it worked for above command but getting error for following command = ------------------------------------------------------------------------------------------------------------------------------------------------------------ [otrs@localhost ~]$ mysql -u root -p otrsdb < /opt/otrs/scripts/database/otrs-initial_insert.mysql.sql Enter password: ERROR 1366 (HY000) at line 1838: Incorrect string value: '\xE2\x96\xA0
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 < /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 < /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