Build a Celestial Bodies Database - Saving universe.sql file from CodeAlly VM

I agree that the instructions were very unclear, especially for users (such as myself) with no prior knowledge of Github, repositories, etc.

So for those users who find their way here with the same questions I had, you need to do the following steps:

  1. Use the provided instructions to create the SQL dump
  2. You should then see the file in the left pane of the Code Ally screen. Under Project you should now have a new file named “Universe.sql”
  3. Open that then Ctrl + A and Ctrl + C to copy all of it
  4. In your GitHub account select to create a new public repository
  5. Below the “Quick setup” option you’ll see smaller text " Get started by [creating a new file] or [uploading an existing file]." Click the “creating a new file” hyperlink.
  6. Give it the name “Universe.sql” and then paste all you copied from Step 3 into the editor
  7. Scroll down and click “Commit New File” button
  8. Below “yourName Create Universe.sql” you will see a row with the text “Universe.sql”. Right click that hyperlink and copy the link address (It should be something like this: “https://github.com/yourName/yourPublicRepositoryName/blob/main/Universe.sql”). This is what you need to paste into the Solution Link field in freecodecamp to submit that you have completed the challenge.
8 Likes