rdamashek / Community-Through-Caring

Strengthening Small Group and Community Relationships through Caring for Each Other's Needs
MIT License
1 stars 0 forks source link

How to facilitate the use of the repository with a generic SQL database dump? #5

Open dancesWithCycles opened 1 year ago

dancesWithCycles commented 1 year ago

Hi folks, Thank you so much for providing and maintaining this repository!

Here you can see that the origin of this database dump is a MariaDB DBMS. The dump was created in a way that it inherits characteristics from the origin. As a consequence, you can not straight use this dump and import it into any DBMS. The dump is DMBS-specific; MariaDB or MySQL-specific if you will.

Anyhow, would the dump be DMBS agnostic/independent, you could import it straight into any DBMS.

To get to an DBMS independent dump, I can imagine two ways.

Please feel free to use, study, share or improve these thoughts. Cheers!

dancesWithCycles commented 1 year ago

I can confirm, that you can import this database dump into a MySQL DBMS using the following instruction.

mysql -h <host> -u <user> -D <database> -p < ../Database/community_caring.sql