"Stop on errors in batch mode" - where is it?

Katy's profile image Katy posted 3 years ago in General Permalink

Hi,

I'm executing a large SQL file (creating a DB from a DB export) and I get the message in the attached screenshot. Where exactly do I find the highlighted option?

Description

Thanks, Mircea.

ansgar's profile image ansgar posted 3 years ago Permalink

It's the button with the warning sign, on the main toolbar:

image description

Katy's profile image Katy posted 3 years ago Permalink

Ouch, didn't think of that, I kept digging for it in preferences. Thanks :)

UweKeim's profile image UweKeim posted 2 years ago Permalink

Was searching in the settings, too.

BTW: In Dark Mode (and via RDP), the checked and unchecked icons literally look the same. Tooltip doesn't change, too. This is literally a try-and-error approach.

kdreally's profile image kdreally posted 2 years ago Permalink

in my case the underlying cause of this was that one of the tables had a BLOB column and it had huge content. you can either filter out that column (or table) from the dump, or you can increase the value of max_allowed_packet (default 4M) to something large like 500M.

phamduchuy552's profile image phamduchuy552 posted 2 years ago Permalink

It's the button with the warning sign, on the main toolbar:

image description

Thank you so much

eflames's profile image eflames posted 2 years ago Permalink

@UweKeim dude u saved me!! hahahaha I pressed the button in dark mode like 100 times xDDD

maravento's profile image maravento posted 7 months ago Permalink

great thanks

giuliam00n's profile image giuliam00n posted 1 month ago Permalink

BTW: In Dark Mode (and via RDP), the checked and unchecked icons literally look the same. Tooltip doesn't change, too. This is literally a try-and-error approach.

This has got to be literally the most idiotic design choice I've encountered in a long while. There is absolutely no indication about the button's status if you're running in dark mode. Neither text nor color or shape. Not even a slight hue variation, or maybe a small message when the error pops up and it says I can try pushing that button. Zero indication whatsoever, just "press the button lol". Loved spending the last 20-30 mins trying to figure out why the freaking button didn't seem to be usable, deleting and recreating the database and choosing various combinations of settings, in case I was missing something. I was almost about to give up and import my SQL with another software.

TTSneko's profile image TTSneko posted 1 month ago Permalink

@giuliam00n:

I do not see any BUG REPORT filed in the matter. Finding something report-worthy and then deciding to ignore it in favor of just moaning around - now that is what I would call a most idiotic choice.

Please login to leave a reply, or register at first.