0
I used Sqlite for a project, with it it is possible to create a database with format '.db' and see inside and everything else.
Would it be possible to export in Mysql a database file created in the same way as in Sqlite? I use Mysql Workbench.
1 answer
1
Yes, you have the option to export:
Server -> Data export
You can create a file dump or script, with the structure of the tables, with the data or not, etc:
-
my bank is already all over town, I wanted to export it with everything already created, how would I do? and that would change something in my bank already created?
-
and it is not q I wanted to import pro Slite, I just wanted to know if it has how to create a file like Slite, which is '.db'
-
No. Mysql does not work with 1 file only, they are different technologies. In addition the sqlite is limited to 2Tb size (which is a monster). You can only export a "backup", so I showed you.
-
Ahh, I get it, is that my teacher had asked to create the bank and such, I thought he wanted equal Slite, but I think just want the commands all, thank you very much
-
No... Mysql works different anyway. Usually the files are in
C:\ProgramData\MySQL\MySQL Server 5.7\Data(Programdata is hidden). Files are of various formats (.frm, .ibd, etc). Legal also know the type of technology, for example the Innodb.
Browser other questions tagged mysql mysql-workbench
You are not signed in. Login or sign up in order to post.
If you are exporting from Mysql directly to sqlite, then I misunderstood the question. I will leave the answer until a return.
– rbz