>> > [root@e drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt
>> > drupal
>> > mysqldump: Got error: 1: Can't create/write to file
>> > '/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when
>> > executing 'SELECT INTO OUTFILE'
>> Change the owner of that directory so the mysql server can write into it.
> Thanks it did worked but i want it to dump on a single file for
> example backup.sql, as i could see lot of file
Please write to the list next time.
If you want a single file use
mysqldump [your options] [your database] > backup.sql