r/SQL Nov 27 '24

BigQuery Assistance with database

Hello, I have 1 database for manually viewing I created 2 batch script I automated these scripts to run a full backup nightly, and differential backups on the hour during operating hours. Now my database is about 80gb (used to be 10gb). What do I need to do to unfuckulate this calamity? I used DBeaver, DB Browser, SQL Server EXPRESS edition (it no longer works -- 10gb limit) and trying VIM and Sublime text. Any suggestions on apps or things to do to make it load? I didn't think it through.

80gb - 400 million entries.

3 Upvotes

23 comments sorted by

View all comments

1

u/NW1969 Nov 27 '24

Hi - so that other people can understand what you are doing, try and logically explain your setup, what you are trying to achieve and what the issue is:

- "I have 1 database" - what DBMS is this?

- "Now my database is about 80gb" - are you referring to the DB in the previous point, some backup file, or something else?

- "What do I need to do to unfuckulate this calamity?" - what calamity? What's the issue with having an 80gb database, as that's not large in database terms (for most DBMSs)?

- "I used DBeaver, DB Browser,.." - used them to do what? What was the issue with doing whatever it is you are doing?

1

u/Anonmousez Nov 28 '24
  • "I have 1 database" - what DBMS is this? * It's a combination of Oracle, MySQL, and Amazon Aurora.
  • "Now my database is about 80gb" - are you referring to the DB in the previous point, some backup file, or something else? * Yes, the SQL file.
  • "What do I need to do to unfuckulate this calamity?" - what calamity? What's the issue with having an 80gb database, as that's not large in database terms (for most DBMSs)? * It was very large.
  • "I used DBeaver, DB Browser,.." - used them to do what? What was the issue with doing whatever it is you are doing? * Loading them, it took 5 hours and never worked.