How to recover MySQL data from Innodb in windows 7
Posted by: mehvish (39.32.66.---)
Date: March 08, 2015 10:08PM

How to recover MySQL data from Innodb in windows 7?
i have C:\wamp\bin\mysql\mysql5.1.36\data
ib_logfile0
ib_logfile1
ibdata1.
please give me solution you can i recover mysqldatabase.urgent please

Options: ReplyQuote
Re: How to recover MySQL data from Innodb in windows 7
Posted by: Otomatic (Moderator)
Date: March 09, 2015 09:43AM

Hi,

Import the SQL file backup of your database.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Options: ReplyQuote
Re: How to recover MySQL data from Innodb in windows 7
Posted by: mehvish (39.32.177.---)
Date: March 09, 2015 10:40AM

i don't have the SQL backup file,i have only wamp file .where data is store .please give me sugestion ,how can i recover without SQL file

Options: ReplyQuote
Re: How to recover MySQL data from Innodb in windows 7
Posted by: RiggsFolly (---.as43234.net)
Date: March 09, 2015 11:00AM

Welcome mehvish,

I think you know the answer to this question, deep down inside!

But on a more productive note, nobody here is clarevoyant, so in order to give you any actual help we would need to know rather more actual facts about the specific issue you have.

1. Answers to these questions [forum.wampserver.com]
2. What do the error logs tell you?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 03/09/2015 11:08AM by RiggsFolly.

Options: ReplyQuote
Re: How to recover MySQL data from Innodb in windows 7
Posted by: mehvish (39.32.233.---)
Date: March 09, 2015 07:31PM

When you ask a question, it is absolutely necessary to specify the following items:

1 - Windows version used is 64 bit
2 - Version WampServer 64 bit
3 - Apache Version is 2.2.11
4 - PHP Version 5.3.0
5 - MySQL Version5.1.36
6 - WampServer icon is white

i have problem that i have no SQL database file...i have all data in C:\wamp2\bin\mysql\mysql5.1.36\data.
but how to recover data base.
all data of my wordpress site is contain in that database.please give me suggestion ,how can i recover it from mysql data file.

Options: ReplyQuote
Re: How to recover MySQL data from Innodb in windows 7
Posted by: RiggsFolly (---.as43234.net)
Date: March 09, 2015 09:45PM

Oh, that version of WAMPServer is so old I forget if the color of the wampmanager icon is relevant!

Does this really mean you have not done a database backup since 2012?

So have you looked at the mysql error log? Like I asked in last post ??

Does it tell you anything?

Paste a few example lines that describe the error!


I am trying to help, but basically if you keep ignoring my requests for some useful information then there is nothing I can do for you.

I realise this is important and urgent to you, but I am not clarevoyant, and there is NO MAGIC BULLET solution I can quote to you.
So if you cannot provide any useful information i.e. useful to someone that is not looking over your shoulder your cries for help are going to get you nowhere fast.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote


Sorry, only registered users may post in this forum.