This is an incompatibility (assuming the database model is correct) between MySQL workbench and MySQL Server. For example, this could occur occasionally by installing XAMPP 3.2.2 and latest MySQL Workbench 8.
For example: XAMPP 3.2.2 installs Maria DB 10.1.37 which is compatible with MySQL 5.7 but MySql workbench 8 is compatible with MySQL 8.0.
The solution would be to either upgrade MySQL to 8.0 so that it is compatible with MySQL workbench or downgrade the MySQL workbench model:
- Open MySQL workbench and desired model
- Go to Edit, Preferences, then Modeling section, MySQL
- set MySQL version to 5.7.
- forward engineer
You should not use phpmyadmin to export big tables from mysql. You may get partial exports because of php server timeouts.
Best way is to connect via SSH to the server and use mysqldump to export the dataset. Then you can download it and transfer it to the new server. There you could use the mysql command to import the dataset.
Continue reading Import and export SQL tables
If you have installed MySQL and you cannot connect to it after installation, you may try the following:
sudo mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
Replace the password with the one you want.
Display a list of running processes:
show full processlist;
Then kill any process you want with kill command:
if, while you are trying to load data, you receive the following error:
Error Code: 1148. The used command is not allowed with this MySQL version
you should perform the following steps:
Continue reading MySQL Load Data error 1148