List:General Discussion« Previous MessageNext Message »
From:Roger Baklund Date:June 12 2002 2:56pm
Subject:Re: make backup
View as plain text  
* aburbello@stripped
> When I try to make a backup executing the sql:
>  backup tb_name1, tb_name2 to 'c:\temp'
>
> and I have a error like
>
> "Failed copying .frm file: errno =3D 2"

Strange... I get:

mysql> backup tb_name1, tb_name2 to 'c:\temp';
ERROR 1064: You have an error in your SQL syntax near 'tb_name1, tb_name2 to
'c:\temp'' at line 1

This is because the correct syntax is "BACKUP TABLE..."

> What I have to do in this case.

You should find out what error 2 means... use the perror utility:

C:\mysql\bin>perror 2
Error code   2:  No such file or directory

Are you sure you have a directory called "c:\temp"?

Also, in mysql you have to escape backslashes, because backslash _is_ the
escape character... use double backslashes: "C:\\temp"

I don't have a "c:\temp" folder, when I try this on my w2k, mysql version
3.23.30-gamma, I get this:

mysql> backup table testme to 'c:\\temp';
+--------------+--------+----------+------------------+
| Table        | Op     | Msg_type | Msg_text         |
+--------------+--------+----------+------------------+
| test2.testme | backup | status   | Operation failed |
+--------------+--------+----------+------------------+
1 row in set (0.01 sec)

...and when I use an existing directory:

mysql> backup table testme to 'c:\\trash';
+--------------+--------+----------+----------+
| Table        | Op     | Msg_type | Msg_text |
+--------------+--------+----------+----------+
| test2.testme | backup | status   | OK       |
+--------------+--------+----------+----------+
1 row in set (0.02 sec)

I tried to change permissions on the .frm file, so that mysql can not read
it, then I got Msg_text: "Can't find file: '.\test2\testme.frm' (errno: 13)"

C:\mysql\bin>perror 13
Error code  13:  Permission denied

This does probably not answer your question, but hopefully I helped you to
get a little bit further with the problem... :)

--
Roger

Thread
make backupaburbello12 Jun
  • Re: make backupcal12 Jun
  • Re: make backupRoger Baklund12 Jun
  • Re: make backupVictoria Reznichenko12 Jun
Re: make backupaburbello12 Jun