https://community.qlik.com/t5/Data-Movement-Streaming/How-is-data-stored-inside-MySQL/m-p/2053095#M844 <P>I'm learning SQL, and I'm having trouble understanding file storage when it comes to relational databases. The mistake I'm making is reasoning in terms of Windows applications and their file formats. For example, I can open .xlsx in Excel, and also in LibreOffice.</P> <P>But, how are sheets or databases created inside MySQL stored? Are they stored in a single file or across multiple files? Can I open a database in PostgreSQL, that was created with MySQL?</P> Wed, 19 Mar 2025 23:04:08 GMT bryn41 2025-03-19T23:04:08Z https://community.qlik.com/t5/Data-Movement-Streaming/How-is-data-stored-inside-MySQL/m-p/2053095#M844 <P>I'm learning SQL, and I'm having trouble understanding file storage when it comes to relational databases. The mistake I'm making is reasoning in terms of Windows applications and their file formats. For example, I can open .xlsx in Excel, and also in LibreOffice.</P> <P>But, how are sheets or databases created inside MySQL stored? Are they stored in a single file or across multiple files? Can I open a database in PostgreSQL, that was created with MySQL?</P> Wed, 19 Mar 2025 23:04:08 GMT https://community.qlik.com/t5/Data-Movement-Streaming/How-is-data-stored-inside-MySQL/m-p/2053095#M844 bryn41 2025-03-19T23:04:08Z