Re: can not backup table

2002-03-13 Thread Abi
you're absolutely right ds :) I have solved this problem yesterday, i miss one thing that my mysql runs by user mysql.. thanks alot --- ds <[EMAIL PROTECTED]> wrote: > On Wed, 2002-03-13 at 01:48, Abi wrote: > > Hi, > > I have this following error when back up table : > > > > mysql> lock table

Re: can not backup table

2002-03-13 Thread ds
On Wed, 2002-03-13 at 01:48, Abi wrote: > Hi, > I have this following error when back up table : > > mysql> lock tables mytable read; > Query OK, 0 rows affected (0.02 sec) > > mysql> select * into outfile > '/home/myhome/dump/mytable.txt' from mytable; > > ERROR 1: Can't create/write to file >

can not backup table

2002-03-12 Thread Abi
Hi, I have this following error when back up table : mysql> lock tables mytable read; Query OK, 0 rows affected (0.02 sec) mysql> select * into outfile '/home/myhome/dump/mytable.txt' from mytable; ERROR 1: Can't create/write to file '/home/myhome/dump/mytable.txt' (Errcode: 13) what does errc