Author Topic: Import mysql.initial.sql problem  (Read 130 times)

Offline H1080241008

  • Newbie
  • *
  • Posts: 1
Import mysql.initial.sql problem
« on: January 26, 2020, 07:59:36 AM »
Hi,

When I run this command on Ubuntu 16.04 to import mysql table,

#mysql -u root -p roundcubemail < /tmp/mysql.initial.sql

I received error:
ERROR 1064 (42000) at line 8: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''session' ('sess_id' varchar(128) NOT NULL, 'changed' datetime NOT NULL DEFAU' at line 1

The MySQL version is 5.7

Do we have anyone having trouble import RoundcubeMail table schema?

How do you solve this problem?



Thanks,
H.