Questions tagged [files]

The tag has no usage guidance.

12 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
1k views

MongoDB GridFS triples the file sizes

I really like using mongodb to store my data and recently I tried out GridFS and it really fits my use case. My problem with it is the space requirement, which seems quite odd. I have ~107GB of ...
2
votes
0answers
1k views

Restoring a database with just .idb and .frm files

I've never attempted something like this before. We had a WAMP installation with WordPress running on my wife's PC, and the Aestan tray menu failed. I figured we need to uninstall and re-install WAMP, ...
1
vote
0answers
335 views

Export and split QUERY results in multiple files

I would like to know if it's possible to export and split query results in multiple files. Let's assume I have a query returning 100 results and I want to save the results in 5 different csv files (20 ...
1
vote
0answers
98 views

How to scale MongoDB/GridFS for fast ingestion on limited timescale

I'm working on a cloud-agnostic service which must allow the ingestion of a lot of media files in a very limited timeframe. Some numbers: 3-4 hours total of workload: the service will be active ...
1
vote
0answers
35 views

Factors affecting the migration of MS SQL into MySQL vice versa

What are the factors affecting the migration of database from MS SQL Server to MySQL causing corrupted files? I transferred my database from MS SQL Server 2012 into MySQL on the same Windows PC. I ...
1
vote
0answers
112 views

How to restore InnoDB from files

here is the situation I fu*d up my mysql setup, before I did that I copied entire /var/lib/mysql directory to another location. Now fresh installation of mysql is back and I cannot restore my files. ...
1
vote
0answers
403 views

Moving Large Tables and All Indexes to a new File Group

I'm looking at implementing File Groups on an existing database that's roughly 600GB. The largest hurdle I have is actually setting this up in production. I need the database to still be available but ...
0
votes
0answers
14 views

mySQL InnoDB tablespace move to network drive

In Windows 10 with mySQL 8.0.26, I am seeking to move a set of rarely used but occasionally necessary tables from my working SSD to another physical device with more space. I have attempted to move ...
0
votes
0answers
49 views

How to open .bin SQL database?

I'm stuck and not sure if somebody had a similar issue. I have an old database stored as .bin files. It dates back to 2012. I can see an xml catalogue file which indicates to me that it is some kind ...
0
votes
0answers
36 views

Restore FULL Oracle DB from ORADATA after DISK fail

my system DISK crashed and know I have to restore my oracle from ORADATA only. CTL, DBF, REDO is okay because system was shutdown normally. I installed new harddisks and new OS. After that I installed ...
0
votes
2answers
148 views

Error 5123 when creating a database with my SQL Server on Linux

I followed the steps of this MS Guide and I managed to run a localdb and create a Testdb with this script: CREATE DATABASE Test ON (NAME='Test_DAT', FILENAME='/home/dlag/Documentos/Proyectos/...
-3
votes
1answer
53 views

Is file system in DBMS same as file handling in C programming language?

We know that file system in not good for storing data , thus relations(tables) are used in DBMS. When we talk about files in database management system (DBMS), are these same/similar to that in C ...