Unable to create incremental backup

Help
1

Hi Team,

We are using memSQL Ops installed on AWS EC2, when we tried to run backup command with “init” we get error check syntax near with.

Is incremental backup not supported memSQL v7.0.

Thanks in Advance

Prashant

2

Incremental backup was introduced in and is supported in memSQL v7.0

“check syntax near” sounds like a syntax error.
Maybe double check that all nodes are running memsql v7.0 and double check your command against

and

You can also share the command you sent (hiding sensitive info obviously), and we can try to figure out the issue.

3

Can we please know the resolution for this issue. I have been encountering the same error.

memsql> BACKUP abc WITH INIT TO “/nfs/”;
ERROR 1064 (42000): 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 ‘WITH INIT TO “/nfs/”’ at line 1

4

From the link Amy posted above, the syntax is:

BACKUP [DATABASE] db_name TO "backup_path" [WITH { INIT | DIFFERENTIAL }]

The WITH INIT goes after the path.