Skip to content

datetime format incorrect #3

Description

@yucikala

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions