mohSalah66/MySQLBackupNetCore

datetime format incorrect

yucikala opened this issue · 0 comments

I have an issue with datetime format. I have the same databases (develop and production). Develop is local and prod is on hosting. I dont know why, but i can not dump production db.

Reason is, that i have

2023-02-01 17:04:22.1617|ERROR|MysqlBackup.Program|System.FormatException: Input string was not in a correct format.
at System.DateTimeFormat.FormatCustomized(DateTime dateTime, ReadOnlySpan1 format, DateTimeFormatInfo dtfi, TimeSpan offset, StringBuilder result) at System.DateTimeFormat.FormatStringBuilder(DateTime dateTime, ReadOnlySpan1 format, DateTimeFormatInfo dtfi, TimeSpan offset)
at System.DateTimeFormat.Format(DateTime dateTime, String format, IFormatProvider provider, TimeSpan offset)
at MySQLBackupNetCore.Methods.QueryExpress.ConvertToSqlFormat(Object ob, Boolean wrapStringWithSingleQuote, Boolean escapeStringSequence, MySqlColumn col, BlobDataExportMode blobExportMode)
at MySQLBackupNetCore.MySqlBackup.Export_GetValueString(MySqlDataReader rdr, MySqlTable table)
at MySQLBackupNetCore.MySqlBackup.Export_RowsData_Insert_Ignore_Replace(String tableName, String selectSQL)
at MySQLBackupNetCore.MySqlBackup.Export_RowsData(String tableName, String selectSQL)
at MySQLBackupNetCore.MySqlBackup.Export_Rows(String tableName, String selectSQL)
at MySQLBackupNetCore.MySqlBackup.Export_TableRows()
at MySQLBackupNetCore.MySqlBackup.ExportStart()
at MySQLBackupNetCore.MySqlBackup.ExportToFile(String filePath)
at MysqlBackup.Program.Test() in D:\Projekty\smallprograms\MysqlBackup\Program.cs:line 396

I think, that there is default format (at mysql) like 1.12.2023 00:15:26. I dont know hot to change it or fix.... I can not find differences between develop and prod.

I find, that datetime column is ok. Problem is with timestamp