MySQL Server Problem

Question

0.00/5 (No votes)

See more:

Hi to all ..

I have a problem which regards to MySQL Server program which is installed in my PC. I am using Windows 7 Ultimate 64 bit which has been corrupted and I cannot recover it because I have no disk. What I did is that I installed it with an OS which is the same with the old one. Then I got a "Windows.old" and "Windows" folder. And I know that my MySQL Server is in the Windows.old folder.

Here's the problem..

How can I run the MySQL Server from the Windows.old folder in order for me to get a database backup? Is there any way to solve this problem?

Please help me through this.. Thank you all!!

Posted 10-Aug-15 21:52pm

Romeland C. dela Peña

Updated 11-Aug-15 21:28pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Accepted Answer · 2015-08-10T22:22:00

Solution 1

Install a new copy of MySQL (the same version as the old) and copy the data directory from the old folder to the new location...
The folder should be at ProgramData\MySQL\MySQL Server [version]\data...
If you can not find than look for my.ini (or my.cnf) to see where the data stored...

Posted 10-Aug-15 22:22pm

Kornfeld Eliyahu Peter

Comments

Romeland C. dela Peña 11-Aug-15 4:26am

thank you .. i'll try it! :)

Romeland C. dela Peña 12-Aug-15 3:19am

hi Kornfeld Eliyahu Peter ...

I have already copied the data directory from the old folder to the new location the tables shown in the datbase using the MySQL Query Browser and when I try to query a table, it returns a message telling the Table doesn't exist.

Im so sorry for this .. I am only a novice in this development.

Kornfeld Eliyahu Peter 12-Aug-15 3:21am

So you see the database, but not the table?

Romeland C. dela Peña 12-Aug-15 3:29am

i see the database and also its tables. What i did is in this link http://dba.stackexchange.com/questions/24403/change-existing-datadir-path

Kornfeld Eliyahu Peter 12-Aug-15 3:41am

You wrote: "when I try to query a table, it returns a message telling the Table doesn't exist"
So where you DO see that table?

Romeland C. dela Peña 12-Aug-15 4:42am

I am using MySQL Query Browser which shows the Database and its respective tables ...