Skip to main content
Share Your Experience: Take the 2024 Developer Survey

New answers tagged

2 votes
Accepted

how to verify mysql backup file using BlackHole

I finally found the way: in the [mysqld] section of my.ini or my.cnf: exclude NO_ENGINE_SUBSITUTION from line sql_mode=... ex.: sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,...
fpierrat's user avatar
  • 121
0 votes

How to take mysqldump with Generated column?

Same problem here, and since my provider uses mysqldump for creating backups I have no say in solving the problem at the root: illegal SQL-commands in backup-file. My WORKAROUND has been to replace ...
Nibbik's user avatar
  • 1
0 votes

Can mysqldump dump triggers and procedures?

It is possible for the triggers to be copied successfully in a dump and restore but not be visible from a database tool run from a client computer. But visible from a database tool installed on the ...
user2367418's user avatar

Top 50 recent answers are included