Apache Friends Support Forum

Hey,
I have xampp installed, and I had a large mysql database.
Due to a mistake, I deleted the entire database
I didn't have a .sql backup (like the ones from phpmyadmin).
But I do have a back up on a tape with the entire xampp folder.
Will restoring this folder bring my database back?
Thx,
Seba

You can try this:

You only need to locate your databases on your tape backup in the xampp\mysql\data directory and copy either this directory to your currently installed XAMPP or just copy over the individual database file to your currently installed XAMPP xampp\mysql\data directory.
The databases are in individual directories named after the database itself.

example:
If you had a database name wordpress then that database would be contained in a directory called wordpress in your mysql data directory
xampp\mysql\data\wordpress
If this was the deleted database you mentioned then all you need do is locate and copy this directory over from your backup to your current mysql data directory.
HTH

=================================================
Take a look at the new DeskTopXampp launch control posted by ridgewood:
http://community.apachefriends.org/f/viewtopi ... 967#103967

The DeskTopXampp launch control for XAMPP and XAMPPlite (DTX.exe)
is available here:
http://zedfiles.com/DTX/

I highly recommend DTX.
=================================================

izzy's post can only work if the mysql engine used is myisam.

otherwise, if innodb is used, everything is stored in a single file. and restoring from that...

well i was unable to help a coworker recover his.

try these:

http://www.webservertalk.com/archive145 ... 39692.html


if it were me, and i have backup tape of the entire xampp directory? i would just restore the entire thing and try to recover the data.

then do a SQL dump.

then reinstall xampp and then restore the data.

then think about a proper backup procedure... lol....