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


Problem :

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?



Solution :

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.


Mysql Tutorials

Mysql Howto..

How to remove large data from MySQL?

MAMP Pro 2.0.2 - Mysql db's synced on dropbox have somehow become out of sync?

If not found in first MySQL TABLE, how do I make it do a search in a second TABLE?

How to import a csv file into MySQL workbench?

MYSQL - How to UPDATE after SELECT from a table

How to store a data whose type can be numeric, date or string in mysql

How to remote connect mysql on raspberry PI?

how to display the database records with MySQL Query

how to check null or not if mysql datatype is timestamp with a default value of “0000-00-00 00:00”?

MySql & PHP: How to find which row has an item in the leading spot in a CSV list?

mysql - How to determine the length of a field which stores a mutable string?

How to optimize mysql query.?

how to show an image from link taken by database

How to update an Entity Framework model from a MySQL database?

how to solve a hyphen issue in a mySQL insert query

How to link up the tables in MySQL

How to merge empty field with the following value in MySQL? [duplicate]

How to store currency values with commas in them?

How to show data from a csv file on web page in tabular form

How to search a field with a JSON value in MySQL?

MySQL - How to simplify this query?

How to save a hash of a password in MySQL

How to select more than one row per group in MySQL?

PHP/MySQL, How to update just some records in database, not all at once?

how to reset all mysql stats?

PHP/MySQL: how to access an array value from a mysql field

MySql-How to parse date which is attached with another string

How do I set a schema level default engine? [MySQL]

MySQL: using timestamp, how to convert to my user's timezone?

Brain boiling from MySQL - How to do a complicated select from multiple tables?