View Issue Details

IDProjectCategoryView StatusLast Update
0001927Database Workbench v5MySQL Modulepublic2021-10-26 11:37
ReporterSvein Erling Tysvær Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityalways
Status feedbackResolutionopen 
Summary0001927: Importing what was just exported fails
DescriptionTo transfer between two MariaDB databases I tried to use DBW to export as tab-separated file from one database, then import the file to the other and whilst the export worked flawlessly, two issues came up during import:

1) My computer uses the date format dd.mm.yyyy and dates where reported to be incorrectly formatted (the export stores as dd.mm.yyyy, I think the import expects yyyy-mm-dd)
2) Fields defined as Bit gave an error message about field to long when importing
Additional InformationI am on DBW 5.7.6 and don't know whether newer versions work better. The first of these issues I avoided by writing a tiny program that reformats the dates, whereas the second can be avoided by not using Bit as field type. Just thought you might want to know about these issues so that you can choose whether or not to fix them.
TagsNo tags attached.

Activities

Martijn Tonies

2021-10-26 11:37

administrator   ~0000558

What export format are you using?

Issue History

Date Modified Username Field Change
2021-10-22 14:37 Svein Erling Tysvær New Issue
2021-10-26 11:37 Martijn Tonies Assigned To => Martijn Tonies
2021-10-26 11:37 Martijn Tonies Status new => feedback
2021-10-26 11:37 Martijn Tonies Note Added: 0000558