RE: Error while using Mysqldump

[Sanjeev Sagar]

This issue is closed. THANKS ! 

>  -----Original Message-----
> From: 	Sagar, Sanjeev  
> Sent:	Wednesday, July 16, 2003 3:28 PM
> To:	mysql@stripped
> Cc:	Sagar, Sanjeev
> Subject:	Error while using Mysqldump
> 
> Hello All,
> 
> I am using Mysql 4.0.13-max-log on Solaris 2.8
> 
> If I run mysqldump like below
> 
> /usr/local/mysql/bin/mysqldump -u root -pabc -d -r
> /usr/local/mysql/testbackup/schemadump.sql --all-databases
> 
> It abort with following error
> 
> /usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table 'address'
> (Can't open file: 'address.InnoDB'. (errno: 1))
> 
> But if I take out -u root -p option then it work fine. Also I don't have
> any table like address, see below
> 
> |      Tables       |
> +-------------------+
> | ACCOMPANIEDTRAVEL |
> | ADVRESTKT         |
> | AGENCYCALCULATE   |
> | BASEFAREINFOTBL   |
> | TABLE02           |
> | bench1            |
> | bench_1           |
> | bench_10          |
> | bench_11          |
> | bench_12          |
> | bench_13          |
> | bench_14          |
> | bench_15          |
> | bench_16          |
> | bench_17          |
> | bench_18          |
> | bench_19          |
> | bench_2           |
> | bench_20          |
> | bench_21          |
> | bench_22          |
> | bench_23          |
> | bench_24          |
> | bench_3           |
> | bench_4           |
> | bench_5           |
> | bench_6           |
> | bench_7           |
> | bench_8           |
> | bench_9           |
> | testac            |
> | testad            |
> +-------------------+
> 
> 
> Am I missing anything here for root privilege. My login id is mysql, which
> owns the MySQL binaries. I have tried with different database and it's
> same behavior.
> 
> Appreciate it.
> 
>  << File: Sagar, Sanjeev.vcf >>