1

Context, I am trying to explore the sales data of my friend's small restaurant. The system is set up to make copies of the database only locally, that is, not into the cloud. I rooted around the computer and found the backup files of the database, in .sql format. Filesize is approximately 200mb.

Quick googling tells me that a .sql file is a sql script. I opened the file in MySQL Workbench. Screenshot linked below. Workbench keeps on crashing, I suppose the file is too big?

Question #1: aren't data and code supposed to be stored in separate files?

Question #2: How to extract the data (e.g. into a csv file) from the file?

Screenshot: https://i.stack.imgur.com/2TrV3.jpg

jarlh
  • 42,561
  • 8
  • 45
  • 63
Markku P.
  • 133
  • 1
  • 4
  • 1
    no they aren't separated in a sql file, and run the script and extract the data from the database – nbk Sep 28 '22 at 16:56
  • Does this answer your question? [Import SQL file into mysql](https://stackoverflow.com/questions/5152921/import-sql-file-into-mysql) – Schwern Sep 28 '22 at 17:51

0 Answers0