Hello.
What do you think about switching to mysqldump with --hex-blob
option?
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Restoring a backup of a very large database, I've received an error
> message by the server (4.13) about an sql syntax error. I've done the
> backup with my
Restoring a backup of a very large database, I've received an error
message by the server (4.13) about an sql syntax error. I've done the
backup with mysql administrator and I've used the same procedure for
months without problems.
I've discovered that problem is into a blob
field that store lo
I am using the MySql Administrator tool to schedule weekly backups on my
databases. I have defined the databases I want backed up and how often,
plus where to store the data. I ran a sample, but it appears that just
the structure is being backed up, not the data in the tables as well.
How do
Evgeny,
Tuesday, May 28, 2002, 12:23:58 PM, you wrote:
>>> When try to use BACKUP TABLE, i get an error
>>> 'Failed copying .frm file: errno = 2' in the result table.
>>> What's the problem?
RC>> BACKUP TABLE write files with the user MySQLd is running...
RC>> So if your deamon run as mysql, you
RC> On mardi, mai 28, 2002, at 09:35 , Evgeny Chuykov wrote:
>> When try to use BACKUP TABLE, i get an error
>> 'Failed copying .frm file: errno = 2' in the result table.
>> What's the problem?
Sorry, my stupid mistake. As you said there was problems whith rights
and dir 'test' didn't exists in
>> When try to use BACKUP TABLE, i get an error
>> 'Failed copying .frm file: errno = 2' in the result table.
>> What's the problem?
RC> BACKUP TABLE write files with the user MySQLd is running...
RC> So if your deamon run as mysql, you had to autorize user
RC> mysql to write into your backup des
On mardi, mai 28, 2002, at 09:35 , Evgeny Chuykov wrote:
> When try to use BACKUP TABLE, i get an error
> 'Failed copying .frm file: errno = 2' in the result table.
> What's the problem?
BACKUP TABLE write files with the user MySQLd is running...
So if your deamon run as mysql, you had to autori
When try to use BACKUP TABLE, i get an error
'Failed copying .frm file: errno = 2' in the result table.
What's the problem?
P.S. Unix FreeBSD, MySQL 3.23.40 and type of the table is MyISAM
(CHECK works fine).
-
Before posting,