Page 1 of 1

how to restore my sql

PostPosted: 05. May 2011 07:37
by rasikabanda
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

Re: how to restore my sql

PostPosted: 05. May 2011 07:53
by Sharley
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.

Re: how to restore my sql

PostPosted: 05. May 2011 08:00
by rasikabanda
noo Sharley i do ,but its not working.... :(

Re: how to restore my sql

PostPosted: 05. May 2011 08:24
by Sharley
Tell me what you did exactly.

Re: how to restore my sql

PostPosted: 05. May 2011 08:27
by rasikabanda
ohh ma godd
i install mysql manualyy..i think data folder is there..its on c drive :(

Re: how to restore my sql

PostPosted: 05. May 2011 08:43
by Sharley
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.

Re: how to restore my sql

PostPosted: 05. May 2011 10:54
by rasikabanda
noo i install mysql before using xampp thts y i tld u, :(

Re: how to restore my sql

PostPosted: 05. May 2011 11:09
by Sharley
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.

Re: how to restore my sql

PostPosted: 25. August 2011 15:54
by JonB
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