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>>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]