I have backed up the osTicket DB by running the following command in a Windows batch file.

mysqldump -v -u <user name> -p<password> Mysql --log-error=%JOB_LOG_FILE% > %WORK_DIR%\Mysql_db_export.sql

Then I import the dump file, Mysql_db_export.sql, using the following command.

mysql -v -u <user name> -p -hlocalhost Mysql < Mysql_db_export.sql > Mysql_import.log

I got the following error messages.

ERROR at line 866: Unknown command '\''.

When I open the dump file Mysql_db_export.sql in an editor and go to line 866, I found the line is

=================================

INSERT INTO `ost_file_chunk` VALUES (1,0,'NG\r\n\Z\n\0\0\0\rIHDR\0\0\0駹0\0\0$\0\ ...

=================================

I can see that the record content of this table is stored in binary format. I have checked that records of all other osTicket tables consist of printable characters only. So I guess that the error may have something to do with the binary format of the records of the table ost_file_chunk.

 

Any Help is appreciated! Thank you!

 

 

    Is this really an osTicket question?Check HERE.Jack

      5 years later

      JRogers
      Check where, Jack?

      Of course it's a osTicket question, Jack.

      Eric_So Have you managed to solve the issue? Did you import it?

          This is clearly NOT an osTicket question. It's a MySQL question.
          This thread is also 5 years old.
          Please don't be a necromancer.
          Killing zombie thread with a head shot.

          Write a Reply...