logo

Channel List
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies
Safety
We take forum safety very seriously here at BellaOnline. Please be sure to read through our Forum Guidelines. Let us know if you have any questions or comments!
Newest Members
Angela Josef, chavonne, HallieWVoegele, everythingbegins, pallavi04gaur
58297 Registered Users
Forum Stats
58,297 Registered Members
417 Forums
118,898 Topics
844,084 Posts

Most users ever online: 615 @ 04/22/15 10:11 AM
Top Posters (30 Days)
Nancy Roussy 284
Mona - Astronomy 111
Angie 25
Connie - ADD/Sandwiches/Reading 22
Susan Helene Kramer 21
Dianne W - Editor 17
Lisa LowCarb / VideoGames 16
Angela - Drama Movies 16
Celestine - Baptist Editor 16
Korie - California/Yoga/Knitting Editor 13
Ad Income Supports Charity
Topic Options
#837744 - 09/12/13 07:26 AM MySQL Install Issues
Lisa LowCarb / VideoGames Offline
BellaOnline Editor
Highest Posting Power Known to Humanity

Registered: 01/04/04
Posts: 22486
ok now I'm confused. I did a fresh install of #MySQL 5.5.15 on my other WIndows 2003 machine, default empty starting config, and the default db won't run. I haven't even gotten to the part where I work with my old database file. I can't even get the initial install to work smile. So clearly I'm doing something wrong here. I have MySQL, the ODBC connector, and Workbench installed, and Visual C++ 2010 so the Workbench would run. Will start checking permissions.
_________________________
Lisa Shea, Low Carb / Video Games Editor
Low Carb Forum

Top
#837761 - 09/12/13 08:00 AM Re: MySQL Install Issues [Re: Lisa LowCarb / VideoGames]
Lisa LowCarb / VideoGames Offline
BellaOnline Editor
Highest Posting Power Known to Humanity

Registered: 01/04/04
Posts: 22486
It had come up running, but when I shut it down I couldn't get it to start again. So I rebooted, again it came up running, and I'm just letting it run for now.

I'm exploring where MySQL is making files and such in its default state. For example I'm seeing by default it puts the detailed frm data files (which I'm currently missing from my needs-to-be-recovered system) into Documents-and-Settings rather than Program-Files. I must have changed that default when I moved from 5.1 up to 5.5, because on my damaged C drive I see those files in place in a 5.1 directory, but they're not there in the 5.5 directory. Now to figure out where they might be.

I had thought the frm data files simply didn't exist for INNODB tables, but it seems they do. So I'm trying to find them, on that damaged server.
_________________________
Lisa Shea, Low Carb / Video Games Editor
Low Carb Forum

Top
#837791 - 09/12/13 09:48 AM Re: MySQL Install Issues [Re: Lisa LowCarb / VideoGames]
Lisa LowCarb / VideoGames Offline
BellaOnline Editor
Highest Posting Power Known to Humanity

Registered: 01/04/04
Posts: 22486
Hmmm it looks like my old version my.ini didn't have the datadir defined - maybe that's why I have the three main innodb files but not the others. They must be somewhere! I can't figure out what the default would be for datadir if it's not defined explicitly. Still looking ...
_________________________
Lisa Shea, Low Carb / Video Games Editor
Low Carb Forum

Top
#837803 - 09/12/13 11:45 AM Re: MySQL Install Issues [Re: Lisa LowCarb / VideoGames]
Lisa LowCarb / VideoGames Offline
BellaOnline Editor
Highest Posting Power Known to Humanity

Registered: 01/04/04
Posts: 22486
IT WORKS! IT WORKS! IT WORKS! I HAVE ACCESS TO ALL MY #MYSQL DATA!!!! WOOOO HOOOOOOO smile
_________________________
Lisa Shea, Low Carb / Video Games Editor
Low Carb Forum

Top
#837866 - 09/12/13 08:53 PM Re: MySQL Install Issues [Re: Lisa LowCarb / VideoGames]
Lisa LowCarb / VideoGames Offline
BellaOnline Editor
Highest Posting Power Known to Humanity

Registered: 01/04/04
Posts: 22486
It turns out my system had gotten fairly confused during my upgrade last fall from 5.1 to 5.5. Even though the ini file clearly said to put the data into one spot, there must have been a registry entry or something else still pointing to 5.1. So while the three main files – IBDATA1 and such – were in the 5.5 directory, all the matching .frm files were down in the 5.1 directory.

When I assembled all the pieces together on my 2003 server, with the matching 5.5 MySQL software, POOF, the WordPress five databases exported completely smoothly, with all data up through the crash. Those five databases are up and running on the new server. Everything is fine with them. These five had only .frm files in their directories and were listed in there as INNODB. So the data was indeed in the IBDATA1 file I had.

That leaves the three remaining UBB forum databases. They have .frm as well as .myi and .myd files in the directories. The .frm files indicate that the tables are MYISAM. I had converted them all to INNODB just after the upgrade. So it seems that these .frm files are not the ones that go with the IBDATA1 file. But I can’t find any other .frm files on the old C drive. I was able to successfully export the data that was there in those .myi / .myd files – which was the data state just before I converted them to INNODB, last December. This at least gets the forums live and working with 8 or so years of data – but of course the last 9 months are still missing. Everything after the INNODB conversion is “trapped” in the IBDATA1 file.

I know I converted the tables to INNODB. I know this INNODB file I have (the IBDATA1) was the active one being used, as I just got all the wordpress content out of it. Apparently I now have to find the “correct” .frm files to go with that – or find some way to extract the data from the IBDATA1 file without having the .frm files. Alternately, could I edit the .frm files I do have and change them from saying these tables are MyISAM (their current state) to saying they are INNODB (which in reality they are)?
_________________________
Lisa Shea, Low Carb / Video Games Editor
Low Carb Forum

Top
#838037 - 09/13/13 01:46 PM Re: MySQL Install Issues [Re: Lisa LowCarb / VideoGames]
Lisa LowCarb / VideoGames Offline
BellaOnline Editor
Highest Posting Power Known to Humanity

Registered: 01/04/04
Posts: 22486
OK this is getting silly. I couldn't find the EnjoyMA blog .frm files ANYWHERE. I only had my IBDATA1 core file So I copied those .frm files from another wordpress blog, completely different data. Same table layout. VOILA. It connected fine and let me export all my data from that IBDATA1 file. So really, all you need if you have an IBDATA1 file and "trapped" INNODB data in it is to make up a dummy database with the same table definitions. Then copy those .frm files into a directory with the correct name of the data you do want. Good to know!
_________________________
Lisa Shea, Low Carb / Video Games Editor
Low Carb Forum

Top

Moderator:  Allison_PCAdvice 

Want to reply? Register as a Forum Member - it's quick, free and fun!
Brand New Posts
Continually learning about prayer
by Lynne - ChristianLiving
Christian Living
12:10 PM
What did you SPEND money on today?
by Nancy Roussy
Frugal Living
09:53 AM
What is your biggest interview challenge?
by Nancy Roussy
Job Search
09:47 AM
Spiritual Food
by Celestine - Baptist Editor
Baptist
09:45 AM
How do YOU look for a job?
by Nancy Roussy
Job Search
09:45 AM
Drug screening for new jobs
by Nancy Roussy
Job Search
09:43 AM
What is your favorite Gospel Song?
by Celestine - Baptist Editor
Baptist
09:43 AM
Happy 55th birthday, ESO
by Mona - Astronomy
Astronomy
09:38 AM
What is your stress level today?
by Nancy Roussy
Stress Management
09:31 AM
Supersmart Astro Women
by Mona - Astronomy
Astronomy
09:25 AM
Register to Post!
Want to post? For security reasons you need to Register as a Forum Member. It's quick, easy and free!
Forum Activities
Book Clubs
Trivia Contests
Who's Online
0 registered (), 85 Guests and 2 Spiders online.
Key: Admin, Global Mod, Mod
Ad Income Supports Charity



| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2016 Minerva WebWorks LLC. All rights reserved.