Re: Can't restore databases, Error 1214

[Rick James]

You appear to be running entirely (or mostly) MyISAM.

( Uptime ) = 269 -- How long (in seconds) the server has been running.
-- Comment: The system has not been up long enough to get reliable suggestions for many of the issues. Fix what you can, then come back with fresh values after a few hours.

( open_files_limit ) = 1,024 -- ulimit -n
-- Comment: To allow more files, change ulimit or /etc/security/limits.conf or in sysctl.conf (kern.maxfiles & kern.maxfilesperproc) or something else (OS dependent)
-- Recommendation: change open_files_limit to 16000

( table_open_cache ) = 64 -- Number of table descriptors to cache
-- Comment: Several hundred is usually good.

You have the Query Cache half-off.
You should set both query_cache_type = OFF and query_cache_size = 0 .
There is (according to a rumor) a 'bug' in the QC code that
leaves some code on unless you turn off both of those settings.

( long_query_time ) = 10.000000 = 10 -- Cutoff (Seconds) for defining a "slow" query.
-- Comment: Suggest 2

( thread_cache_size ) = 0 -- How many extra processes to keep around
( Threads_created / Connections ) = 7 / 8 = 87.5% -- Rapidity of process creation
-- Comment: INcrease thread_cache_size:
0 good for Windows
0 is inefficient for non-Windows
-- Recommendation: change thread_cache_size to 5.