Import From Sql Statements – Error

[rwinnick]

Hi –

Trying to use import from sql statements to import table data from backup file created by powertools scheduled backups –

Get the following error message –

Query:

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'

Error occured at:2006-07-31 09:52:21

Line no.:14

Error Code: 1193 – Unknown system variable 'SQL_MODE'

What does this mean and how do I “fix” it 🙂

thanks –

Richard

[peterlaursen]

Hello!

Please read the post just below yours:

http://www.webyog.com/forums//index.php?showtopic=2265

I guess that the backup was made from MySQL 5 and you want to restore to an older version¨?

Read about sql_modes:

http://webyog.com/faq/28_72_en.html

You will need to edit the file a little!

[Author]

Posts