Category Archives: MySQL - Page 2

Fix Workbench Error Code: 1175

just run this query:

SET SQL_SAFE_UPDATES = 0;

MySQL dump only one table without structure or only data

mysqldump -u USER -p -h SERVER DATABASE TABLE --skip-triggers --compact --no-create-info --complete_insert > path/to/save/your/dump.sql

mysql foreign key check

turn off

SET FOREIGN_KEY_CHECKS=0;

turn on

SET FOREIGN_KEY_CHECKS=1;

ex.:

SET FOREIGN_KEY_CHECKS=0;
YOUR QUERY;
SET FOREIGN_KEY_CHECKS=1;
Page 2 of 212