This issue is closed. THANKS !
-Original Message-
From: Sagar, Sanjeev
Sent: Wednesday, July 16, 2003 3:28 PM
To: [EMAIL PROTECTED]
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
