Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Hey I'm getting a weird issue with mysql dumps on a Linux box

Reproducing:

  1. Dump from mysql on box 1, the database has a mix of InnoDB and ISAM tables
  2. Copy the dump to box 2 Create a new database on box 2
  3. Run: source dumpfrombox1.sql

The Result:

  1. MySQL creates all the InnoDB tables and populates with data
  2. MySQL fails to create the ISAM tables with the error: ERROR 1 (HY000): Can't create/write to file '/navtech/DB/mysql/mydb/myisamtable.MYI' (Errcode: 13)

Everything I've read about that error talks about file permissions, but all the InnoDB files are being written to the same directory?

I checked /var/log/audit/audit.log and no entries get created when I run the import.

Any ideas?

EDIT

Manually editing the dump so that all tables are InnoDB tables, the restore works.

share|improve this question

closed as off topic by Sathya May 25 '12 at 15:23

Questions on Super User are expected to relate to computer software or computer hardware within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

Browse other questions tagged or ask your own question.