List:General Discussion« Previous MessageNext Message »
From:Sanjeev Sagar Date:July 16 2003 8:28pm
Subject:Error while using Mysqldump
View as plain text  
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>> 

Thread
Error while using MysqldumpSanjeev Sagar16 Jul
RE: Error while using MysqldumpSanjeev Sagar16 Jul