Less than operator not working on where clause in mysqldump

by Matthew Singer   Last Updated September 11, 2019 18:06 PM

I am trying to backup some tables with the built in mysqldump function from MariaDb version 10.4. My tables all have a column called insertDateTime with a timestamp in the form of 2019-09-11 12:00:00

Querying one of my tables with the simple statement:

select * from account where insertDateTime < '2019-08-13 18:00:00'

will return a set of rows where that condition matches. However when I run the following code in command prompt no rows are returned in my dumped sql file.

C:
cd c:\Backup_Location

"C:\Program Files\MariaDB 10.4\bin\mysqldump.exe" -u root -p password database account > account.sql --where="insertDateTime < '2019-08-13 18:00:00'"

I have been wracking my brain on why these two statements should return different amounts of rows but am unable to figure out why. Does anyone know why this would be.

Tags : mysql mariadb


Related Questions



How to restart MariaDB Galera cluster?

Updated October 11, 2016 09:02 AM



Index on VIRTUAL column in MariaDB and MySQL

Updated August 30, 2019 16:06 PM