MySQL Forums
Forum List  »  MySQL Workbench

Re: Where data are stored
Posted by: Peter Brawley
Date: June 03, 2019 07:49PM

Database files (not data files) are in the folder described by the result of ...

select @@datadir;

each database is stored in a set of files in a subfolder there, the subfolder name corresponding to the database name.

Note that unlike "data files" you may have become accustomed to manipulating in other software contexts, relational database files ought not to be messed with. Your interface to them is SQL, in this case the MySQL version of that language.

Options: ReplyQuote


Subject
Views
Written By
Posted
182
June 03, 2019 07:04PM
Re: Where data are stored
76
June 03, 2019 07:49PM
71
June 03, 2019 08:24PM
80
June 04, 2019 11:54AM
62
June 05, 2019 05:40PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.