Re: Error importing databases in mysql: ERROR 1005 (HY000) (errno:-1)

[Imanol Bernabeu]

Rick James Wrote:
-------------------------------------------------------
> Out of disk space?

Definitely no, the HD is 300Gb and currently is almost empty.

> Is tmpdir pointing to a small db?

I don't know right now. I will look for it when I have access to the server.

> Was it dumped via mysqldump and reloaded via
> mysql?

Yes.

> How many tables?

108 tables per DB.

> MyISAM or InnoDB?

InnoDB.

It could be some InnoDB related variable? While I was looking for a solution, I found some of them that could be guilty (cache sizes and stuff), but as I said, they were the same as in another server where it works.

Thank you for the help.