Questions tagged [database]
A collection of data that is usually organized into tables for different data objects. Tables usually consists of records on instances of the data objects.
867 questions
2
votes
2
answers
4k
views
Where to retrieve a MySQL database backup in CentOS 6?
Had taken a look at:
Where Are Databases Located - MySQL File Location
Didn't seem to help much.
I used this for a single MySQLDatabase backup:
http://www.tecmint.com/mysql-backup-and-restore-...
- 59.3k
0
votes
1
answer
10k
views
Problems connecting using MongoDB Compass
I'm trying to see the contents of a collection using MongoDB Compass. I have username/password authentication set up. I can log in successfully but can't see any documents in the collection. Instead, ...
CommunityBot
- 1
1
vote
1
answer
280
views
Where can I find database backup files?
Is it possible to find a database backup within phpMyAdmin or are backup files always stored locally on a PC?
- 59.3k
0
votes
0
answers
88
views
Installing Perl DBD-Mysql on Windows 11
I can't get DBD-mysql to install on my Windows 11 machine.
Activestate Perl 5.40.2
DBD-mysql version 5.013 (Auto)
Mysql server 8.4
Mysql server is running.
Database 'test' has been created.
...
- 1,147
2
votes
1
answer
62
views
Searching the database objects
How can I search SQL server database to find string in any of objects name? I have a problem when testers says this and that is not working and I can not find it by its name.
4
votes
1
answer
800
views
Index files and folders in Windows
I want to create a database of all files and folders within a specific location (say, E:\movies).
How can I do this? Is there any software which can do this for me? Otherwise do I need to write code ...
4
votes
4
answers
19k
views
What's the equivalent of Microsoft Access on the Mac?
I want to use a Microsoft Access 2007 database on my Mac. However, it appears that Office 2008 for Mac does not have an equivalent to Microsoft Access. I'm new the Mac so can anybody suggest a easy to ...
1
vote
1
answer
5k
views
Why can't I connect to PostgreSQL (localhost server) when my VPN is active?
I just wasted an hour of my life trying to figure out why pgAdminIII couldn't connect to the server on localhost. After trying config edits, starting/stopping the postgresql service, etc., I finally ...
CommunityBot
- 1
0
votes
0
answers
45
views
How can I sort our library's text report about books so that pulling them is more efficient?
TL;DR: I work at a library and we run a daily report (see below) to know which books to pull off shelves; how can I sort this report better, which is a long text file?
I work at a library. The ...
- 87.7k
-3
votes
1
answer
121
views
Matching and confirming combination of data from different columns, where data could be exact or an approximate match
I have a case, I am not sure if its possible to solve, but I will appreciate any help or some sort of workaround. I need to compare combination of data from columns A+B with combination of data from ...
- 71
0
votes
1
answer
5k
views
How to create draw.io database diagram in Confluence from Excel?
I have a a list of fields in Excel which are the fields/columns of a table in my database.
I want to convert this into a database diagram (ERD) in Confluence using draw.io. But I can't seem to be able ...
CommunityBot
- 1
1
vote
1
answer
5k
views
PostgreSQL 9.2.4 (Windows 7) - Service won't start, “could not load pg_hba.conf”
I am trying to get Postgres 9.2.4 to run as a service on Windows 7. After installing postgres, the service was running fine. However, after setting postgres up as a server for another program, the ...
CommunityBot
- 1
0
votes
1
answer
8k
views
How to fix UDI-31623 error in Oracle?
Yesterday I've tried to import another dump as a new Oracle schema and failed to to limited space. So the impdp (Data Pump Import) exited with an error. I've successfully deleted outdated schemas ...
CommunityBot
- 1
0
votes
1
answer
29k
views
Mongodb, mongoimport, uncaught exception: SyntaxError: unexpected token: identifier : @(shell):1:15
Getting the below error while importing a csv file in MongoDB database.
command:
mongoimport -d test -c FAQ --drop --type csv --file C:\Users\KUMA\Desktop\FAQ.csv --headerline --host localhost:27017 --...
CommunityBot
- 1
6
votes
1
answer
8k
views
What's the database format for WhatsApp Desktop for Windows?
I'm trying to extract all of my WhatsApp messages with metadata for analysis, searching, graphing, e.t.c. Extraction of the Android database requires rooted access, so I'm trying to use the database ...
CommunityBot
- 1