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,908 Topics
844,133 Posts

Most users ever online: 615 @ 04/22/15 10:11 AM
Top Posters (30 Days)
Nancy Roussy 280
Mona - Astronomy 112
Angie 27
Connie - ADD/Sandwiches/Reading 24
Susan Helene Kramer 19
Celestine - Baptist Editor 18
Dianne W - Editor 17
Lisa LowCarb / VideoGames 17
Korie - California/Yoga/Knitting Editor 16
Angela - Drama Movies 16
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: 22488
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: 22488
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: 22488
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: 22488
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: 22488
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: 22488
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
Do Not Complain for 1 Month
by Lisa LowCarb / VideoGames
Buddhism
46 minutes 35 seconds ago
Plant a Tree in a Pot
by Angie
Container Gardening
Today at 03:20 PM
DNA and Genealogy
by Angie
Genealogy
Today at 03:17 PM
Distance Learning, a new thing?
by Angie
Distance Learning
Today at 03:15 PM
What are you looking forward to today?
by Angie
Self Development
Today at 03:05 PM
Another Hollywood Player Accused of Harassment
by Angela - Drama Movies
Drama Movies
Today at 11:45 AM
Spiritual Food
by Celestine - Baptist Editor
Baptist
Today at 11:24 AM
New Drama Phantom Thread Trailer
by Angela - Drama Movies
Drama Movies
Today at 10:20 AM
body language
by Nancy Roussy
Job Search
Today at 09:41 AM
Job Searching While Employed
by Nancy Roussy
Job Search
Today at 09:37 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 (), 96 Guests and 3 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.