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.
864
questions
1
vote
3
answers
4k
views
What is the equivalent of MSSQL to Open Source
I want the equivalent of MSSQL to opensource DB?
1
vote
1
answer
5k
views
PHP 5.6 OCI8 Install Issue:
I am trying to install the OCI8 extension on Red Hat 7 (PHP 5.6.x.) I have spent at least two days trying to figure this out including combing SuperUser and StackOverflow. So far none of the answers ...
1
vote
1
answer
195
views
Is there a term for software that allows users who don't understand DBs to create reports from a DB? [closed]
Is there a term for software that allows users who don't understand DBs to create reports from a DB?
A customer might just say I wanna see people and addresses that are related to this incident, for ...
1
vote
3
answers
8k
views
Installing MySQL database on Windows
I need to install MySQL on Windows XP. But looks like both .msi and and .zip versions require Windows admin rights to get database working. Is there any way possible to install MySQL without windows ...
1
vote
1
answer
72
views
tool for documenting database and software changes
I'm currently working on a php project with 3 other people. I need a free software which can help me document the changes/revisions on the database and on the application that were developing.
1
vote
2
answers
341
views
Email correspondence history viewer: Solution for a local politician
A local (Good!) politician in my city handles nearly 200 citizens' emails each day. She has two paid assistants, but they can't handle the pressure altogether, so they've recruited volunteers to sort ...
1
vote
4
answers
324
views
Which is the best solution for shared database meeting these requirements? [closed]
Which solution would you recommend which has:
a relational database with a user interface
access for 20-50 users potentially working in parallel
user authentication
log of changes
customizable forms, ...
1
vote
1
answer
2k
views
Downloading wikipedia database for offline use
Here there are many ZIM files: https://dumps.wikimedia.org/other/kiwix/zim/wikipedia/
I want complete English Wikipedia with images... which one should I download?
What is the difference for example ...
1
vote
1
answer
1k
views
Microsoft Access how to get a field name to only show with certain entries
My database in Access is listed by classification (e.g. cinema, press (local), publication (local) etc).
For the cinema classification I want to have a column titled 'the number of screens in the ...
1
vote
2
answers
6k
views
Excel: How to create multiple records from a single record
I have a database of several companies. There is one record per company. Within each company record, there are multiple contacts.
How can I create a record for each CONTACT (preserving all the same ...
1
vote
1
answer
1k
views
Remote copy of LMDB
I want to migrate an LMDB from my local machine to another remote machine, but there is some weirdness about the file size. According to the filesystem, an LMDB is a directory containing two files: ...
1
vote
1
answer
11k
views
Why is my mysql database table not allowing me to edit data manually?
For some odd reason out of the blue my database in MySql will not allow me to manually edit any records. My guess is it never has. I am logged in with the Workbench under the root account. I have ...
1
vote
1
answer
1k
views
What does the output of this "source" command mean?
Unix newbie here, installing MYSQL.
Per the directions from the server admin, I just added two lines to the end of my .cshrc file to create 2 new environment variables:
setenv MYSQL_UNIX_PORT /home/...
1
vote
2
answers
4k
views
SQL Server Management Studio: Database Attachment Failed
I have publish my website in IIS7. It is running in DefaultAppPool. The Identity of this app-pool is set to LocalSystem. The IIS is running and I can run the application from IIS without any problem.
...
1
vote
2
answers
123
views
how to search file at server
i'm newbie at linux...
1. i want to make backup database(use mysqldump)
2. copy from server(use linux-server) to client PC (use linux- ubuntu 9.0)..
3. before that i want to search that DB file using ...
1
vote
1
answer
791
views
Virus cleanup + dying drive = XP Automatic Updates crashing in esent.dll
Background
I'm doing system recovery on an old WinXP SP1 system brought to me on suspicion of virus infection. After taking preliminary backups, I used MalwareBytes to detect and clean the infection. ...
1
vote
4
answers
4k
views
Copy a SQL Server 2008 database verbatim
I need to copy my entire SQL Server 2008 database including the schema and all data verbatim from one computer to another.
How do I do that?
1
vote
3
answers
2k
views
Connection problem to MySQL on another machine on LAN
I'm having trouble connecting to a MySQL database on the other machine on the same network.
Could not connect to the specified instance.
MySQL error number 1130
Host 'abc' is not allowed to connect ...
1
vote
2
answers
906
views
How do I recover my database?
I exported my database to test whether it works. I then deleted the database and then it went to the "Trash" (I'm using Ubuntu). I then deleted it from "Trash" accidently.
Is there a way to recover ...
1
vote
2
answers
476
views
Home movie database software
I am looking for (preferably open-source) software for Windows XP that will allow me to keep track of all our self-made videos. My parents should be able to operate it, so we would like it to have a ...
1
vote
2
answers
123
views
Power Query Editor: Strip Leading Zeroes from Numeric Values Stored as Text
I am using Power Query Editor in Excel for Microsoft 365.
Table A has a column ID that holds a unique identifier. This identifier is usually numeric, but it sometimes contains text. Given this, I've ...
1
vote
1
answer
26
views
Reformatting table in Excel - Can PivotTables cut it?
Suppose I have a table in an Excel worksheet which looks like this:
Day
TimeOfDay
Color
Foo
1
Morning
Green
450
1
Morning
Blue
682
1
Evening
Green
253
1
Evening
Blue
413
2
Morning
Green
150
2
...
1
vote
1
answer
1k
views
Connecting to a Postgres database, hosted within a Windows Subsystem for Linux, from a separate device
I have two devices:
HOST: a Windows device, on which I have installed a Windows Subsystem for Linux.
CLIENT: a Linux device.
I have then taken the following steps.
I have installed Postgres within ...
1
vote
2
answers
458
views
Auto Fill Forms For All Major Browsers
I am building a form hosted on my server. I want to save the user as many keystrokes as possible since this is form with many fields.
Is there an autofill forms for other major browsers like Safari, ...
1
vote
1
answer
220
views
disable (or trim) logging of bytea requests in postgres
Our application store some big blob (bytea) in a separate database every 30 minutes. It's fine and we want to keep it like, this, but it's causing crazy logging:
2021-01-25 11:11:00 UTC postgres109432 ...
1
vote
2
answers
127
views
How are databases stored for I website that I create and host [closed]
I am learning web development and I am using python (flask) along with HTML and CSS with bits of JavaScript. I want to know how I can connect a database (MySQL) to my website and where and how it will ...
1
vote
1
answer
2k
views
Microsoft Access: Query to delete duplicate data but keep most recent
To my surprise, I've been having trouble finding an answer to this question for my specific case.
I have a table with ID and date and I would like to keep only one ID, and that is the most recent one.
...
1
vote
1
answer
1k
views
MySQL Crashed, Logs Have Many Errors, DB Possibly Corrupted
I run a LAMP server on Digital Ocean with a WordPress installation on it for a friend's website. I recently transferred it over from AWS. It crashed and I received the Error establishing database ...
1
vote
1
answer
3k
views
Remove Empty Second Line From Very Large CSV File in Windows 10
I have an very large CSV file (data for all the taxi trips in NYC during March). The second line is empty which angers PostgreSQL's import. I can run
(gc file.csv) | ? {$_.trim() -ne "" } | set-...
1
vote
1
answer
139
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?
1
vote
2
answers
2k
views
Where can I find an RRD file specification?
I'm trying to write a Python program to directly pull information from RRD performance files stored on our servers at work, but the files aren't stored in plaintext format, and I cant find any ...
1
vote
2
answers
2k
views
How to move postgresql database from one computer to another?
I've been created an Internet service on Debian server. I want to move all data from one server to a new one.
So, how can I move the postresql database? What is the best pipeline?
1
vote
1
answer
1k
views
Oracle SQL Developer Data Modeler: How to Search for a Table and Show in the Diagram
In the Oracle SQL Developer Data Modeler 4.0, there is find functionality. It's icon is the binoculars in the top right corner.
When we use that find operation, we receive a list view of results that ...
1
vote
2
answers
5k
views
Is there a tool to put a phone number into E.164 format?
I'm looking for both a quick and dirty, as well as easily repeatable, solution to strip non-numeric data from a column in a spreadsheet for import to a MySQL database. Example:
(123)456-7890 fred ...
1
vote
1
answer
2k
views
Oracle SQL Select: If not exist, leave blank
I have two tables:
Table1
[ID] [Number]
1 40
2 100
3 7
and
Table2
[ID] [Number] [Name]
1 40 A
3 7 C
Data originates in Table1, then gets copied to ...
1
vote
1
answer
3k
views
how do I alter the structure of a table in SugarCRM CE?
How do I add fields to the opportunities table so that they propagate?
From within Studio > Opportunities > Fields I added fields. Pardon, I don't understand the next step to effect a change ...
1
vote
1
answer
1k
views
In Mysql Workbench, where is Synchronize Model with Database
As displayed in Mysql Database Synchronization documentation.
I cannot find this particular Synchronize Model with Database window / wizard under Database ->
I have Mysql Workbench 6.0.9.11421 ...
1
vote
1
answer
3k
views
mysqldump not on wamp server
I am trying to use mysqldump on my wamp server mysql console however, it doesn't seem to have mysqldump included. I found the mysqldump.exe file in this location:
/cygdrive/c/wamp/bin/mysql/mysql5.6....
1
vote
3
answers
781
views
Does Google Chrome have some primary key in its cookies database?
I am writing some scanner for Google Chrome cookies, as stored in a SQLite database. It also has an option to delete cookies, however I didn't find any ID field. The most similar is creation_utc, I ...
1
vote
1
answer
3k
views
How do I open a Rails Mysql database in Mysql Workbench?
I having trouble finding my mysql database files in Ruby on Rails project and opening it in MysqlWorkbench
This is my folder structure for a app
This is my database.yml
development:
...
1
vote
4
answers
2k
views
this database is not compatible with this application - Application compatibility toolkit
I installed the Windows Application Compatibility Toolkit and installed SQL server 2012 express to use as the database server. When I run ACT and try to create or select a database, it puts a little ...
1
vote
1
answer
888
views
Copy data from mail server to database
Is it possible to backup emails into MySQL database?
Say, I have an account [email protected] and I want to keep record of all the emails inside the mail.domain.com locally, in my computer.
From what I'...
1
vote
2
answers
66
views
Best option for db installed in home dir? [closed]
My research group shares a server for which I do not have root access. I would like to install a database in my home directory to manage my results. What would the best option in terms of ease of ...
1
vote
1
answer
5k
views
Difficulty connecting to a database with Primavera P6
I'm having trouble connecting to Primavera P6 (project). When I enter my username and password, I receive an error:
This user is already logged in...
The password was never changed.
1
vote
1
answer
3k
views
Database structure for handling multiple accounts (Multi-Tenant Data Architecture)?
It's always easy to write software that handles a single entity. However, designing software to handle multiple accounts/companies requires due diligence.
I'm currently doing initial research into ...
1
vote
1
answer
8k
views
How to run a SQL select query in Oracle database through a shell script?
I need to run a SQL select query in an Oracle database and have to capture the list of retrieved records in a shell script. Also I would like to modify the query for certain conditions and need to ...
1
vote
1
answer
432
views
Can't login in with `su` on Fedora
I'm new to Fedora 15 and Linux. I've stumbled upon a problem while installing Oracle XE; I can't set environment variables or do anything else - any change I make won't stick.
I'm using the terminal:
...
1
vote
2
answers
13k
views
Mysql won't show my databases
After I restart my computer, my databases doesn't show when I run the command show databases;
It only shows the following:
information_schema
test
If i go to /usr/local/var/mysql, my databases files ...
1
vote
2
answers
699
views
MySQL storage: how to manage a grow to infinite?
I'm just thinking about how famous internet services like facebook or twitter manage fast growing databases.
Which could be a solution for this kind of problem?
What about ids ? I read there is a ...
1
vote
1
answer
474
views
Advise on VMWare hardware requirements and host OS
I'm a newbie developer wanting to learn a bit about Virtualization (from the IT point of view, not theoretical/academic).
What I'd like to do:
Prepare a machine
Install VMWare or VirtualBox
Prepare ...