how to restore my sql

Problems with the Windows version of XAMPP, questions, comments, and anything related.

how to restore my sql

Postby rasikabanda » 05. May 2011 07:37

im using xampp windows version,,my computer is not bootable now.i install windows 7 again..but i fogot to take mysql data base backups
i have xampp folder because im not install in c drive... pleeease help me how can i restore ma old data bases...

please help me
rasikabanda
 
Posts: 4
Joined: 05. May 2011 07:27

Re: how to restore my sql

Postby Sharley » 05. May 2011 07:53

Make sure that Apache and MySQL are Stopped on your new installation on the C:\ drive.

Look in the \xampp\mysql\data\ folder of your XAMPP that is not in the C:\ drive for a folder that has the same name as your lost database.

Copy that folder, with the same name as your lost database, to you newly installed C:\xampp\mysql\data\ folder.

Next start Apache and MySQL and go to phpMyAdmin and make sure your database is visible.

Let me know if you have problems.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: how to restore my sql

Postby rasikabanda » 05. May 2011 08:00

noo Sharley i do ,but its not working.... :(
rasikabanda
 
Posts: 4
Joined: 05. May 2011 07:27

Re: how to restore my sql

Postby Sharley » 05. May 2011 08:24

Tell me what you did exactly.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: how to restore my sql

Postby rasikabanda » 05. May 2011 08:27

ohh ma godd
i install mysql manualyy..i think data folder is there..its on c drive :(
rasikabanda
 
Posts: 4
Joined: 05. May 2011 07:27

Re: how to restore my sql

Postby Sharley » 05. May 2011 08:43

rasikabanda wrote:ohh ma godd
i install mysql manualyy..i think data folder is there..its on c drive :(
Not possible for any ma godd if you installed mysql manualyy. :) All is lost!

This is an XAMPP forum and so the database you created using MySQL in XAMPP may not work if you are trying to copy it to the data folder of a manually installed MySQL (no XAMPP).

See the MySQL web site (in your language) for help with a manually installation.

See also the phpMyAdmin web site or some other GUI for MySQL.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: how to restore my sql

Postby rasikabanda » 05. May 2011 10:54

noo i install mysql before using xampp thts y i tld u, :(
rasikabanda
 
Posts: 4
Joined: 05. May 2011 07:27

Re: how to restore my sql

Postby Sharley » 05. May 2011 11:09

rasikabanda wrote:noo i install mysql before using xampp thts y i tld u, :(
Sorry, I don't understand what you are trying to say, never have but I took a guess - your last post is all mobile phone gibberish text abbreviations and not required on a forum. :roll:

I told you how to do it in my first post and if as you say it does not work then it doesn't work and there is nothing I can do about it.

Perhaps now you have learned your lesson about always backup files and folders before attempting destructive processes.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: how to restore my sql

Postby JonB » 25. August 2011 15:54

And a great idea, other than its for MS SQL, not MySQL

but you knew that, didn't you???

I hope you got your 5 rupees
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Windows

Who is online

Users browsing this forum: dogmatic and 37 guests