I know this is an old problem, but is has bitten me again. When I use dalecosp's
mysqldump -u root -p pass mysql
I get a whole lot of answers that are greek to me. The last line says:
Got error: 1146: Table 'mysql.innodb_index_stats' doesn't exist when using LOCK TABLES
I have re-installed MySQL-5.7.1-m11 twice and the table isn't created.
The calls_to_dispatch.sql file simply reads:
Navicat Premium Data Transfer
Source Server : KathyString
Source Server Type : MySQL
Source Server Version : 50701
Source Host : localhost
Source Database : calls_to_dispatch
Target Server Type : MySQL
Target Server Version : 50701
File Encoding : utf-8
Date: 07/19/2013 10:46:47 AM
I've found a whole bunch of varying answers on the web, but they don't agree at all. What are my options? Manually create the table? Where would I put it?
As always, thanks for the help.