Re: missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12a
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 [EMAIL PROTECTED] wrote: No the user is still the same, there are just no innodb files. ?anymore? On Mon, 4 Jul 2005, Gleb Paharenko wrote: Hello. [EMAIL PROTECTED] gleb]$ perror 1 OS error code 1: Operation not permitted Do you run new MySQL service under different user account? Jason Pyeron [EMAIL PROTECTED] 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12a
That is what I attempted, but to no success. I will try again, I think the installer blew away my old my.ini. On 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. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12a
On 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? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12a
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. [EMAIL PROTECTED] 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 -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12a
Hello. [EMAIL PROTECTED] gleb]$ perror 1 OS error code 1: Operation not permitted Do you run new MySQL service under different user account? Jason Pyeron [EMAIL PROTECTED] 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. [EMAIL PROTECTED] 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: missing ibd files on upgrade of mysql from 4.1.9 to 4.1.12a
No the user is still the same, there are just no innodb files. ?anymore? On Mon, 4 Jul 2005, Gleb Paharenko wrote: Hello. [EMAIL PROTECTED] gleb]$ perror 1 OS error code 1: Operation not permitted Do you run new MySQL service under different user account? Jason Pyeron [EMAIL PROTECTED] wrote: I get errors like: ERROR 1016 (HY000): Can't open file: 'files.ibd' (errno: 1) -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]