MySQL Database and Table Loss I have installed mysql and XAMPP on my system. I wanted to remove the mysql service of XAMPP. After removing it, I tried to install the new service for mysql using "MySQLInstanceConfig.exe". but now I can't see any of my databases or tables. Have I lost all my data? The data folder in mysql directory is full.

This is a picture of my data folder. I have all the data here. but mysql can not read them.



Is there any way to make the mysql read these !?
If the mysql service is up right now, shut it down

C:\&gt; net stop mysql


You need to create my.ini

Go to  C:\Program Files\MySQL\MySQL Server 5.5

You should see a bin folder and the data folder you have in your question

Create my.ini in C:\Program Files\MySQL\MySQL Server 5.5

I noticed you have


ibdata1
3 innodb log files
binary logs that start with mysql-bin


Make sure you have these options in my.ini

[mysqld]
innodb_data_file_path=ibdata1:10M:autoextend
innodb_log_files_in_group=3
innodb_log_file_size=256M
innodb_buffer_pool_size=768M
log-bin=mysql-bin


You need to start the service manually

C:\&gt; cd "C:\Program Files\MySQL\MySQL Server 5.5\bin"
C:\&gt; net start mysqld


By default, when starting up mysqld like this, mysqld.exe expects the my.ini to initially be in its parent directory.

If mysql starts successfully, you should see mysqld.exe in the processlilst of the Task Manager and the file clarinet.err should have today's date. You can shut it down using:

C:\&gt; cd "C:\Program Files\MySQL\MySQL Server 5.5\bin"
C:\&gt; mysqladmin -uroot shutdown


Now configure mysql service so that it uses C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld.exe