OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12a

From: Gleb Paharenko (gleb.paharenkoensita.net)
Date: Mon Jul 04 2005 - 15:52:34 CDT


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 <jpyeronpdinc.us> wrote:
> No the user is still the same, there are just no innodb files. ?anymore?
>
> On Mon, 4 Jul 2005, Gleb Paharenko wrote:
>
>> Hello.
>>
>> [glebblend gleb]$ perror 1
>> OS error code 1: Operation not permitted
>>
>> Do you run new MySQL service under different user account?
>>
>>
>>
>> Jason Pyeron <jpyeronpdinc.us> wrote:
>>>
>>> I get errors like:
>>> ERROR 1016 (HY000): Can't open file: 'files.ibd' (errno: 1)
>>>
>

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __ ___ ___ ____ __
  / |/ /_ __/ __/ __ \/ / Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql