Error while using Mysqldump

[Sagar, Sanjeev]

------_=_NextPart_000_01C34BD8.C9973A3A
Content-Type: text/plain

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.

<<Sagar, Sanjeev.vcf>>
------_=_NextPart_000_01C34BD8.C9973A3A
Content-Type: text/plain; charset=us-ascii

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw
------_=_NextPart_000_01C34BD8.C9973A3A--