Celestial Bodies Database - Build a Celestial Bodies Database

Backend Development
1

Hi there,

I have completed the " Build a Celestial Bodies Database" challenge.

I have made a Github account also. What I am struggling with is how to upload my finished database to Github so I can submit my work.

This is probably a very basic question but any help would be appreciated.

Your browser information:

User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36

Challenge: Celestial Bodies Database - Build a Celestial Bodies Database

Link to the challenge:

2

Firstly, in a bash terminal within the course, you need to create a dump of your database:

pg_dump -cC --inserts -U freecodecamp universe > universe.sql

This will create a universe.sql file in the project folder.

Next, open up a notepad (or similar app) on your PC and paste the entire contents of the above file and then save it to your desktop with the same filename.

Finally, create a new GitHub repo and upload the file to it.

You can then submit the repo link to FCC to pass the project.

1 Like
5

Hi,

Thank you for that!

I have followed those steps and have a notepad document uploaded to my Github account with the solution. Unfortunately the URL isn’t being accepted, I get an error message saying “the project must be completed first”.

Any idea why this is? URL as below:

https://github.com/SBBanger/Build-Celestial-Bodies/blob/main/universe.sql/

Thanks

6

You might need to go back into the project. If you’ve completed the project successfully on CodeAlly you should see a 100% completion message. Make sure you click ‘Continue’ on this message and then go back to the FCC curriculum and click back through to the project page where you submit your git repo link.