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]