• Mysql

Error restoring a particular database

By PrasadNaik

August 29, 2020

[root@OK1053 mysql]# mysql uulimain_testagain < /home/uulimain/public_html/uulimain_testagain.sql
ERROR 1067 (42000) at line 242: Invalid default value for ‘up_to_date_as_of’

For this error need to cross check the mysql version of database backup from where is imported and also the mysql version on the current server, if both are same database will restore.