Questions tagged [files]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
15 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
1answer
30 views

MariaDB CONNECT engine BIN table - file record layout, storage of a date data type, padding

In mariadb-10.4.5, running on Windows 10, I created this table (in the local database): `CREATE TABLE IF NOT EXISTS `testbalNoFieldFormat` ( `fig` int(4) NOT NULL, `name` char(10) NOT NULL, `...
7
votes
3answers
675 views

Access to the path 'c:\some\path' is denied for MSSQL CLR

I think this is a permissions problem, but I'm having trouble locating it. I have a group of CLRs on one server (SQL Server 2016) and they work as they should. All are marked UNSAFE and they do ...
0
votes
2answers
54 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/...
2
votes
1answer
52 views

How to find out the oldest full backup still existing on disk?

one of the things I like to find out is what is the oldest full backup file still living in my servers. it is the custom to delete or move those files to a different place after a number of days. How ...
1
vote
1answer
261 views

xp_delete_file - error message when no files for deleting

I have a job that deletes transaction log backups older than 3 days. if for some reason there are no files to delete, it comes out with the following error message: Msg 22049, Sev 16, State 1: ...
1
vote
1answer
101 views

Hierarchical / tree data - which type of database to use & design?

For querying (and writing to) a hierarchical structure (like a folder containing files and other folders, up to n levels deep, where n is pretty small, probably around 10, and there would be lots of ...
1
vote
2answers
77 views

Mp3 file directly in a Database Without using BLOB [closed]

I need to store Mp3 files in a Database. Problem is that the files are going to be accesed with a smartphone. As the Smartphone is going to need to decode the Blob it would be very slow. I tried ...
1
vote
1answer
217 views

Storing files with extension in database as BLOB

Recently during development process I've faced file storage issue. I'm not sure which solution is the best one that's why I decided to write this question. I don't have a lot experience of database ...
2
votes
0answers
803 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 ...
1
vote
1answer
35 views

SQLite - What are .acd, .ard and related file types?

I'm using a SQLite database, and the main database file is: Config.acd and there are also files named: Config.acd-shm Config.acd-wal What is the .acd file type, what are those variants (acd-shm, ...
0
votes
1answer
73 views

how can I get mariadb tokudb to put all its files in directories per database

Is there a way to get tokudb to put all the files it creates for a database into subdirectories. When I started using tokudb the most irritating thing I have found is that it puts all its files into ...
1
vote
3answers
1k views

How to check whether old MDF and LDF files are referenced

I inherited a setup, and I'm rather new with DB work. I've got a drive on my production server that was created during a big crisis a few years ago at my company. Crisis was navigated and everything ...
3
votes
1answer
173 views

Deleting files from within SQL Server

I've been using xp_delete_file to delete old backup files but I now an a need to delete files that are part of an application (as part of GDPR). As xp_delete_file only will only let you delete log or ...
2
votes
1answer
1k views

Storing large files (~1GB) in MySQL

We are considering a solution that will store large files in MySQL with InnoDB. The size of the files can range from 250MB - 1GB (might grow up to 50GB in future). Here is what the plan is. Create ...
0
votes
1answer
331 views

mongodb wt file corrupt issue, can not query few documents

I have a mongodb cluster with 3 shards and no replication The problem is one of the shards has a bad disk and because of which some files show input/output error when trying to read [root@mongodb2 ...
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 ...
3
votes
1answer
723 views

Why is Postgres not respecting my log file name convention dictated by “log_filename”?

I’m using Postgres 9.5 on Ubuntu 14.04. I have these settings set in my /etc/postgresql/9.5/main/postgresql.conf file log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern, ...
1
vote
2answers
254 views

Running out of disk space mid-restore

A colleague of mine reported that an hour after starting a restore the operation failed because the server ran out of disk space. He mentioned that since we are using filestream the size isn't ...
1
vote
1answer
1k views

Mysql database .frm and .ibd file read to understand [closed]

I want to read .frm and .ibd files in mysql to understand how mysql database engine store data in files. Which format those file does have, since when I open those files it show non-human readable ...
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
108 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. ...
5
votes
1answer
736 views

Find what data is placed in a datafile

I have a database with 5 .ndf (secondary) datafiles on SQL Server 2008 R2. (Each of these datafiles is assigned to a separate filegroup.) I want to know what data is there in those files. Is it ...
1
vote
0answers
373 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
1answer
751 views

The number of records that is the table shows in .dbf file is not match with the real number of records

I have some .dbf files made in VFP. I have to work with them and occasionally edit it. Recently I noticed that one of .dbf`s is running in a wrong way. The number of records that is the table shows is ...
10
votes
1answer
16k views

Database with multiple .mdf files

I have searched online but not found what I am looking for. The problem/query is to my knowledge a database in SQL Server should have One .mdf file and maybe some .ndf files and One .log file. I ...
1
vote
1answer
325 views

Data Files Outgrowing Hardware - Split the File?

Where I'm currently working, the primary business database is located on a virtual server (SQL Server 2005 standard). The temp DB and logs are on one disk, the database itself on another. The SAN is ...
1
vote
1answer
4k views

Two SQL Server databases setup with same .mdf and .ldf files

In a SQL Server 2008 R2 instance two databases (the second one being a restore/copy of the first one) have been setup against the same .mdf and .ldf files. How would I go about either deleting the ...