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 - 13:15:22 CDT


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 just lost a bunch of personal and work development projects whilst
> upgrading to MySQL 4.1.12a (msi script).
>
> I get errors like:
> ERROR 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.
>
> [jpyeronMrLaptop 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. DOH!!!
>
> TIA
>

--
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