Have you restored the data
of mysql folder? So you probably lost the data (hope you have a backup). On the mysql does not start (which was what triggered the problem) rather than leaving deleting things look in the log but you need to enable the log first ( How can I start and check my MySQL log? ), access your ./bin
folder (assuming it's windows) by cmd
, something like:
cd C:\wwamp\mysql\bin
If you have a backup of the ./data
folder, restore it at this time
Then type mysql
into the cmd input and press Enter. Then run this:
mysql> SET GLOBAL general_log = 'ON';
If it fails, try to edit the file my.conf
where something like:
# The MySQL server
[mysqld]
port = 3306
socket = /.tmp/mysql.sock
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
sync_binlog = 0
And add this:
general_log = 1
Check the task manager if it has any mysql process, finalize all of them (or restart Windows).
After this will be generated a log file in the folder ./data
called mysql.log
, check the cause of the problem that had affected mysql initialization.