I just lost a bunch of personal and work development projects whilst
upgrading to MySQL 4.1.12a (msi script).
I get errors like:
ERRR 1016 (HY000): Can't open file: 'files.ibd' (errno: 1)
there are no .ibd files in any of the data directories.
I do have 3 very large files at the top.
[jpyeron@MrLaptop data]$ du -h i*
18M ib_logfile0
18M ib_logfile1
10M ibdata1
I guess I am just not thinking straight enough to solve this one.
All MyISAM tables are fine.
oh, yes my backup was taking backups on the 'old' data location. DH!!!
TIA

Hello.

[gleb@blend gleb]$ perror 1
S error code 1: not permitted

Do you run new MySQL service under different user account?

Jason Pyeron <jpyeron (AT) pdinc (DOT) uswrote:

I just lost a bunch of personal and work development projects whilst
upgrading to MySQL 4.1.12a (msi script).

I get errors like:
ERRR 1016 (HY000): Can't open file: 'files.ibd' (errno: 1)

there are no .ibd files in any of the data directories.

I do have 3 very large files at the top.

[jpyeron@MrLaptop data]$ du -h i*
18M ib_logfile0
18M ib_logfile1
10M ibdata1

I guess I am just not thinking straight enough to solve this one.

All MyISAM tables are fine.

oh, yes my backup was taking backups on the 'old' data location. DH!!!

TIA

No the user is still the same, there are just no innodb files. ?anymore?

Mon, 4 Jul 2005, Gleb Paharenko wrote:

Hello.

[gleb@blend gleb]$ perror 1
S error code 1: not permitted

Do you run new MySQL service under different user account?
>
>
>
Jason Pyeron <jpyeron (AT) pdinc (DOT) uswrote:
>>
>I get errors like:
>ERRR 1016 (HY000): Can't open file: 'files.ibd' (errno: 1)
>>

Hello.

I think that deleting .ibd files is a weird behavior for installer. Did
you use innodb_file_per_table? If not, then a new version couldn't
understand an old format of InnoDB data files. Probably, you could
install a binary copy of MySQL 4.1.9, specify your data directory as
it's datadir and make a dump with mysqldump. Then just import it to the
new instance of MySQL.

Jason Pyeron <jpyeron (AT) pdinc (DOT) uswrote:
No the user is still the same, there are just no innodb files. ?anymore?

Mon, 4 Jul 2005, Gleb Paharenko wrote:

>Hello.
>>
>[gleb@blend gleb]$ perror 1
>S error code 1: not permitted
>>
>Do you run new MySQL service under different user account?
>>
>>
>>
>Jason Pyeron <jpyeron (AT) pdinc (DOT) uswrote:

I get errors like:
ERRR 1016 (HY000): Can't open file: 'files.ibd' (errno: 1)

That is what I attempted, but to no success.

I will try again, I think the installer blew away my old my.ini.

Mon, 4 Jul 2005, Gleb Paharenko wrote:

Hello.

I think that deleting .ibd files is a weird behavior for installer. Did
you use innodb_file_per_table? If not, then a new version couldn't
understand an old format of InnoDB data files. Probably, you could
install a binary copy of MySQL 4.1.9, specify your data directory as
it's datadir and make a dump with mysqldump. Then just import it to the
new instance of MySQL.

Mon, 4 Jul 2005, Gleb Paharenko wrote:

Hello.

I think that deleting .ibd files is a weird behavior for installer. Did
you use innodb_file_per_table? If not, then a new version couldn't

it is doing something with the files, but still it looks for the .ibd?

07/05/2005 07:04 10,485,760 ibdata1
07/05/2005 07:04 18,874,368 ib_logfile0
07/05/2005 06:54 18,874,368 ib_logfile1

any ideas?