All,
Working on a single machine (win2k) needing to do backups. Trying Backup
Table with the following syntax:
BACKUP TABLE tbldealers TO 'c:\mysql\backu ps'
BACKUP TABLE tbldealers TO /mysql/backups
I've tried with/without quotes, ticks, nothing except the path. I either
get error in syntax, or I do get 1 row in set, but there are no files in
that directory.
Any help would be appreciated.
I've read the manual as extensively as I know to and can't find anything on
backup table syntax.
I'd prefer to stay away from mysqldump and mysqlhotcopy and control the
backups myself.
Thanks in advance,
Kirk
Working on a single machine (win2k) needing to do backups. Trying Backup
Table with the following syntax:
BACKUP TABLE tbldealers TO 'c:\mysql\backu ps'
BACKUP TABLE tbldealers TO /mysql/backups
I've tried with/without quotes, ticks, nothing except the path. I either
get error in syntax, or I do get 1 row in set, but there are no files in
that directory.
Any help would be appreciated.
I've read the manual as extensively as I know to and can't find anything on
backup table syntax.
I'd prefer to stay away from mysqldump and mysqlhotcopy and control the
backups myself.
Thanks in advance,
Kirk