CODEWITHSUNDEEP
mysql-workbenchheidisql
Josephine
Josephine

Reputation: 77

can i transfer my database from HeidiSQL to Mysql Workbench?

I have a database with few table in HeidiSQL, I would like to transfer it to MySQL Workbench. I used the SQL Export to export the selected database as Single.sql file. Then i used the import option in MySQL. Used import from self-contained file in MySQL workbench. The import was done, but I don't see any data.

Upvotes: 0

Views: 1156

Answers (1)

Mike Lischke
Mike Lischke

Reputation: 53357

You need to understand how RDBMSes like MySQL are working. There is a server which holds the data and answers to requests by clients, and there are clients like HeidiSQL or MySQL Workbench. Clients never hold data by design. Their entire purpose is to communicate with a database server (running queries, manage it etc.).

Considering this you will see that your question is entirely wrong. There is no data you can move from one client to another. Simply use either client to connect to your server and it will have the data ready for you to work with.

Upvotes: 2

Related Questions