On 26 December 2017 at 13:24, Renee B <[email protected]> wrote:
> 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</s...' for column 'text' at row 1
------------------------------------------------------------------------------------------------------------------------------------------------------------
How to solve this 1? :-)
Regards,
Amey.
>
>
>
>
> 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
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
