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
Orchid, bonding99, davidearly, SusieGG, OSTSEE
58341 Registered Users
Forum Statistics
Forums417
Topics119,287
Posts846,567
Members58,341
Most Online410
Feb 3rd, 2018
Top Posters(30 Days)
Sponsor
Previous Thread
Next Thread
Print Thread
#837744 - 09/12/13 02:26 PM MySQL Install Issues  
Joined: Jan 2004
Posts: 22,602
Lisa LowCarb / VideoGames Offline
BellaOnline Editor
Lisa LowCarb / VideoGames  Offline
BellaOnline Editor
Highest Posting Power Known to Humanity

Joined: Jan 2004
Posts: 22,602
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
#837761 - 09/12/13 03:00 PM Re: MySQL Install Issues [Re: Lisa LowCarb / VideoGames]  
Joined: Jan 2004
Posts: 22,602
Lisa LowCarb / VideoGames Offline
BellaOnline Editor
Lisa LowCarb / VideoGames  Offline
BellaOnline Editor
Highest Posting Power Known to Humanity

Joined: Jan 2004
Posts: 22,602
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
#837791 - 09/12/13 04:48 PM Re: MySQL Install Issues [Re: Lisa LowCarb / VideoGames]  
Joined: Jan 2004
Posts: 22,602
Lisa LowCarb / VideoGames Offline
BellaOnline Editor
Lisa LowCarb / VideoGames  Offline
BellaOnline Editor
Highest Posting Power Known to Humanity

Joined: Jan 2004
Posts: 22,602
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
#837803 - 09/12/13 06:45 PM Re: MySQL Install Issues [Re: Lisa LowCarb / VideoGames]  
Joined: Jan 2004
Posts: 22,602
Lisa LowCarb / VideoGames Offline
BellaOnline Editor
Lisa LowCarb / VideoGames  Offline
BellaOnline Editor
Highest Posting Power Known to Humanity

Joined: Jan 2004
Posts: 22,602
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
#837866 - 09/13/13 03:53 AM Re: MySQL Install Issues [Re: Lisa LowCarb / VideoGames]  
Joined: Jan 2004
Posts: 22,602
Lisa LowCarb / VideoGames Offline
BellaOnline Editor
Lisa LowCarb / VideoGames  Offline
BellaOnline Editor
Highest Posting Power Known to Humanity

Joined: Jan 2004
Posts: 22,602
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
#838037 - 09/13/13 08:46 PM Re: MySQL Install Issues [Re: Lisa LowCarb / VideoGames]  
Joined: Jan 2004
Posts: 22,602
Lisa LowCarb / VideoGames Offline
BellaOnline Editor
Lisa LowCarb / VideoGames  Offline
BellaOnline Editor
Highest Posting Power Known to Humanity

Joined: Jan 2004
Posts: 22,602
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

Moderated by  Allison_PCAdvice 

Brand New Posts
What did you SPEND money on today?
by Nancy Roussy. Frugal Living
02/24/18 03:37 AM
What is your stress level today?
by Nancy Roussy. Stress Management
02/23/18 10:28 PM
2018: On this day . . .
by Mona - Astronomy. Astronomy
02/23/18 09:57 PM
#FemaleFilmmakerFrid
ay Twitter Campaign

by Angela - Drama Movies. Drama Movies
02/23/18 09:24 PM
What are you looking forward to today?
by Nancy Roussy. Self Development
02/23/18 08:36 PM
Where are you and how is the weather?
by Nancy Roussy. Inspiration
02/23/18 08:34 PM
What will you do today?
by Nancy Roussy. Inspiration
02/23/18 08:31 PM
What's your Typical Daily Menu?
by Nancy Roussy. Low Carb
02/23/18 08:21 PM
Did you dream last night?
by Nancy Roussy. Dreams
02/23/18 08:16 PM
What Is a Galaxy?
by Mona - Astronomy. Astronomy
02/23/18 12:02 PM
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 Now
0 registered members (), 168 guests, and 4 spiders.
Key: Admin, Global Mod, Mod
Sponsor


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


Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 1.060s Queries: 14 (0.008s) Memory: 2.0329 MB (Peak: 2.1355 MB) Zlib disabled. Server Time: 2018-02-24 12:11:30 UTC