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
537
June 03, 2019 07:04PM
Re: Where data are stored
401
June 03, 2019 07:49PM
331
June 03, 2019 08:24PM
348
June 04, 2019 11:54AM
278
June 05, 2019 05:40PM


Sorry, you can't reply to this topic. It has been closed.

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.