Re: MySQL error when trying to run /otrs-schema.mysql.sql script for otrs 6.0.3
Amey Abhyankar <[email protected]>
| Newsgroups | gmane.comp.otrs.user |
|---|---|
| Message-ID | <CAGT4=KK1oPU7QMDsjxWokQB_n-vQj=BXyV3b75wOTPS5zEw93g@mail.gmail.com> |
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