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


Updated May 08, 2019 09:06 AM

Updated October 11, 2016 09:02 AM

Updated May 03, 2017 19:06 PM

Updated December 10, 2018 09:06 AM

Updated August 30, 2019 16:06 PM