View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001927 | Database Workbench v5 | MySQL Module | public | 2021-10-22 14:37 | 2021-10-26 11:37 |
| Reporter | Svein Erling Tysvær | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | feedback | Resolution | open | ||
| Summary | 0001927: Importing what was just exported fails | ||||
| Description | To 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 Information | I 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. | ||||
| Tags | No tags attached. | ||||
| 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 |
