how to restore my sql

[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

[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.

[rasikabanda]

noo Sharley i do ,but its not working....

[Sharley]

Tell me what you did exactly.

[rasikabanda]

ohh ma godd
i install mysql manualyy..i think data folder is there..its on c drive

[Sharley]

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.

[rasikabanda]

noo i install mysql before using xampp thts y i tld u,

[Sharley]

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.

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.

[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