'I'm on windows os, I'm trying to export the data from mysql workbench to my local file system. But showing an error message like (no disk space)
I've searched many threads online but none of them worked for me. I found solutions for linux but there is no solution related to windows operating system
ERROR: Export data to file: ("Error writing file 'C:\WINDOWS\SERVIC~1\NETWOR~1\AppData\Local\Temp\MYacdbk0zgsz0sy8wg' (OS errno 28 - No space left on device)", 3)
Solution 1:[1]
If you need only the ddl-dml of some schema, maybe you can do it:
1 - On Workbench. Select the Schema.
2 - Database -> Reverse Engineer(Ctrl + r)
3 - Next ... Select the Schema -> execute ... -> the result is a EER diagram.
4 - On EER diagram you do: Database -> Forwading Engineer
5 - Select:
- Generate INSERT statmentes for tables
- Disable FK checks for INSERTs
- Generate DROP SCHEMA
- Omit schema qualifer in object names
- include model attached scripts
6 - Next ...
7 - Copy the script or download it.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Renan Rodolfo da Silva |