Where is the database physically stored (created in Workbench)?

Question

MySQL

Trite question, but I can't find where exactly the database files are stored. MySQL Workbench created a database called paymentservice with table mobilepayment. I need to copy the DB to another PC. In C:\Program Files\MySQL\MySQL Server 5.6\data I didn't find anything related to my database. Maybe I'm misunderstanding something and looking in the wrong place?

Answer 1

The base is usually copied using export-import. On the source machine you create a data dump, on the target machine it imports this dump. You can use PMA, SypexDumper or the regular console utility mysqldump.

Answer 2

Workbench has a handy database export/import tool. Take advantage of it.

Answer 3

If you have a local database, then look for the files of the database itself at least in the directories with the Mysql server or in user files.