Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [files]

The tag has no usage guidance.

0
votes
2answers
44 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
37 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
109 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
77 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
48 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
103 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
616 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 ...
0
votes
1answer
25 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
60 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
831 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
159 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 ...
1
vote
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
279 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
578 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
210 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
961 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
970 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
107 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
656 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
364 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
712 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
15k 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
321 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 ...