aburbello,
Wednesday, June 12, 2002, 4:08:23 PM, you wrote:
a> When I try to make a backup executing the sql:
a> backup tb_name1, tb_name2 to 'c:\temp'
a> and I have a error like
a> "Failed copying .frm file: errno =3D 2"
a> What I have to do in this case.
Use slash '/' or double slash '\\'
* [EMAIL PROTECTED]
> 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
Either shut your mysql server down before making the backup or exclude your
mysql directory from the backup and use mysqldump to dump the contents.
(Which is what I do every night.) Then backup the dump.
Even if nobody is using the server, mysql still holds the files open. There
are ways to back
but it this a problem from the mysql??
I need to use this sql. I can't use mysqldump.
What is the solution for this problem??
Alexander
-- Mensagem Original --
>use mysqldump
>
>Agris
>
>agc> When I try to make a backup executing the sql:
>agc> backup tb_name1, tb_name2 to 'c:\temp'
>
>agc>
