CODEWITHSUNDEEP
mysqlapachephpmyadminxampp
RubenGeert
RubenGeert

Reputation: 2952

How to to fix XAMPP after deleting too many MySQL databases?

I've been stupid enough to delete too many databases in XAMPP with PHPMyAdmin and now my sites on localhost don't run properly anymore. Please see this screenshot of the main errors enter image description here

I guess entirely reinstalling XAMPP will fix the problem but that might take much more time than necessary. Preferably, I'd like to just reinstall the MySQL component or perhaps recreate/repair some databases required for XAMPP to function properly. However, it looks as if I can only reinstall XAMPP entirely instead of separate components (and if that's correct, it's probably for a reason...).

Do I have a better option here than a complete reinstall of XAMPP?

Upvotes: 6

Views: 20464

Answers (2)

RubenGeert
RubenGeert

Reputation: 2952

OK, fixed it with the kind help of scones.

1) By default (XAMPP 1.8.1 on Windows XP), there seems to be a folder C:\xampp\mysql\backup\phpmyadmin. Just copy-paste this entire folder into C:\xampp\mysql\data.

2) Stop and restart MySQL

3) If you're using WordPress, your pages may be blank since it may think there are no themes available. Go to [frontpage url]/wp-admin/. Now just reactivate the theme you'd like to use and all seems up and running again!

Upvotes: 12

scones
scones

Reputation: 3345

You dropped the database for PHPMyAdmin. If you can just restore that (with a command line mysql tool or any tool that does not rely on a web-interface), you can use phpmyadmin again.

Upvotes: 0

Related Questions