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.

learn more… | top users | synonyms (2)

0
votes
0answers
39 views

Disable Excel Data Connections Properties

We have spreadsheets hooked up to our database through the network. The only thing is the data connection requires a login to the database by an administrator. We have other people that need to view ...
1
vote
0answers
13 views

Exporting data from Unicode DB to Non-Unicode DB

So, I have 2 databases A & B. A is Unicode database and B is non-unicode. I am going to send some data from Unicode database A to non-unicode database B. I do not have any multi-byte data in ...
0
votes
0answers
43 views

How to combine multiple databases in excel into one strong and efficient database

I'm working in a highly reputed government company as a data entry clerk and my responsibility is to keep the contact information database updated by adding new contacts and making sure that all the ...
22
votes
4answers
64k views

Sync Two MySQL Databases

What is a good way to sync two MySQL databases? I would like to sync the data in my production website's database to my local development database. Right now, I am just using the PHPMyAdmin ...
1
vote
0answers
381 views

Hibernate Entities generated using IntelliJ have no Foreign Keys generated

I have a normalized SQL Server database with 20+ tables on it that created using SQL Server Management Studio 2014. I am able to connect to this database in IntelliJ and follow along with the steps ...
0
votes
1answer
464 views

#126 - Incorrect key file for table '.\mysql\db.MYI'; try to repair it

I posted my question on serverfault but they hold my question by advising to post it in SuperUser I installed Xampp and can see localhost page as well as both apache and mySQL is starting fine but ...
0
votes
0answers
18 views

Having MS Access send me emails or updates

I would like to store information on my company's activities in a database, and design it so when a deadline approaches, the database could send an email or an alert notifying us that action is needed....
1
vote
0answers
100 views

Specific request on SQLMAP using “where” clause

In order to clean a database and delete inactive users, I would like to know users that haven't loged onto their account since at last 2 years. These are the data i have : database name : db01 table : ...
0
votes
0answers
18 views

MySQL Query to Find Distinct Instance of Status

My question is regarding a MySQL query that I am trying to write. I have written some psuedo-code to help illustrate what query I am trying to write: SELECT * FROM persons AS p INNER JOIN ...
0
votes
0answers
115 views

Mysql won't start on CentOS 6.7 running Plesk

I have a Plesk server, and yesterday I tried to update it to the newest version. After a couple of tries, I couldn’t reach my Plesk panel anymore. Getting this error: ERROR: ...
0
votes
3answers
2k views

I'd like to create a database of pictures. Where to begin? [closed]

I'd like to create a searchable database of images. I'd like something a little expandable, meaning I'd like to define my own fields and be able to search on them, but I'd also like to be able to ...
1
vote
0answers
79 views

Can MS Access make a column-of-rows type of form like the one pictured?

I am trying to make a form consisting of multiple forms stacked side-by-side in Access, like the one pictured below but have run into many, many issues. I will settle for a report if I can't get a ...
2
votes
5answers
13k views

Where to store\update tnsnames.ora file when installed oracle client only?

I installed the oracle client only but was told to update my tnsnames.ora file with the info my dba sent me. But I don't have a tnsnames.ora file. On another machine with a full oracle admin install ...
1
vote
0answers
161 views

How do I combine data in two tables in LibreOffice?

I have a spreadsheet with two sheets. SheetA has Customer number and location, and SheetB has Order number, Customer number. How do I combine the data so that one sheet has Order number and location? ...
1
vote
1answer
127 views

Saving password for Excel Analysis Services Connection

I created an xlsx file with a connection to an Analysis Service (Tabular). On top of that I build several Pivot Tables and Slicers. Unfortunately, when I share my file to someone else, he or she is ...
1
vote
2answers
3k 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 ...
5
votes
3answers
5k views

How does geolocation based on IP address work?

As all Internet users, I've visited web sites which appear to know in which country and city I'm located. I understand that these web sites typically look up my IP address in a database which maps IP ...
0
votes
0answers
41 views

Suggestions for Staging table for XML ETL?

Suggestions for Staging table for XML ETL? Thanks for responding to my threads and looking into this issue. We have a large XML message file. We want to extract the data from this XML file and load ...
0
votes
0answers
37 views

How to automate the process of importing an excel sheet in Toad using Toad?

Is there a way to automate the process of importing an excel sheet into a table using Toad? It should be like import process should start only when triggered, and shouldn't be a scheduled job. Any ...
0
votes
0answers
23 views

Data Scraping - Item prices / download links

I am new to import.io and would require advice on 2 different scenarios. Scenario 1a Login is required to view the index of all mp3s and videos. After logging in, I am presented with over 1,000 ...
0
votes
0answers
80 views

Mysql crashed and can't be restarted after trying to access database from phpMyadmin

I was trying to edit an entry in one of my mysql databases on my pc from phpMyadmin but when I clicked on the database MySQL crashed and since than it can't be restarted. (MySQL ver. 5.6.26 x64 on ...
0
votes
1answer
284 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 ...
0
votes
1answer
63 views

Am I 'root' user on my shared hosting database?

I have a shared hosting in which I can create databases, and users. Is any of the users created by me root user?
0
votes
1answer
68 views

Find riak node's listening HTTP and Protobuf port

I recently followed and scripted the Riak 5 minute install, successfully getting 4 nodes running on a Ubuntu 14.04 VM. Currently the nodes are running and are joined / clustered successfully. ...
0
votes
1answer
26 views

Repeating Randomness in Microsoft Access Reports?

I have created a report in Microsoft Access which contains a text box. The text box has a simple expression in the control source to generate a random string of digits in a specific format. I need to ...
1
vote
0answers
15 views

What database uses “H??X!$L<” (“ndcy”? ) as a Magic Header String?

I'm trying to determine what database Cydia uses for metadata on jailbroken iOS devices. There is no file program available to offer a possible answer. Here's the head of the cat: iPad:~/root# cat /...
0
votes
0answers
21 views

Where do in-memory databases load their data into?

When talking about in-memory databases do terms like in-memory main memory random access memory (RAM) etc. describe the same component? Wikipedia describes it as in-memory, but I also found ...
2
votes
1answer
3k views

ODBC Data Source Driver 'Does Not Exist' After Updating to Windows 10

I received the following errors in the Microsoft ODBC Data Source manager (64-bit), for my data source an MS Access DB (.accdb), after updating to Windows 10 from 7 and uninstalling MS 2010 and ...
0
votes
1answer
372 views

How do I split a single row into multiple rows based on quantity in Excel?

I have a spreadsheet that lists medical equipment (identified by JSN) within a room. A single piece of equipment (JSN) may have multiple quantities within a room. I'd like to separate all rows that ...
1
vote
2answers
151 views

How to remove or fix the date stamps of specific messages in Skype?

In order to exerience Terraria events without waiting until Christmas I changed my system time from the current time (September) to December. Skype messages that I received during this time were ...
-2
votes
1answer
36 views

How to find a specific data file being used by a specific program

I have a program ( I don't want to have its name here) which I enter data from time to time. So I believe it stores these data in a file somewhere on my PC. How can I find this data file and change it ...
-1
votes
1answer
29 views

Can someone help me understand sequential files? [closed]

Can someone help me understand: What sequential files are? How to create, access and add sequential files? Which software can be used for these purposes? I am a beginner in this area. I need your ...
0
votes
0answers
84 views

How can I export MySQL large database from remote server using only phpMyAdmin access? [closed]

My client give me phpMyAdmin access to do database related task. I am stuck to export the database because database size is very large. Client give me credential like followings: {ip-address}/...
0
votes
1answer
90 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: ...
0
votes
1answer
12 views

Using Open Office to list time elapsed in months

I'm new to open office and using the spread sheet for a database of cattle on my farm. I need it (amongst other things!) to be able to calculate the age of the cattle in months. So, in column B I ...
-1
votes
2answers
62 views

how to use the &command in SQL insert into statement?

what is the syntax of the insert into statement wherein SQL prompts for input? like for example, if I have attributes "name" and "age" in a student table and I write an insert query , SQL will prompt "...
2
votes
1answer
26k views

Importing CSV files into Excel using a macro

I want to develop a macro where in my Excel worksheet I type a date in a specific cell, and the macro will go into a folder containing text files. A database you could say. I want it to find the ...
0
votes
0answers
32 views

Should I go for Hadoop?

I hope discussing scenarios and solutions isn't out of context, if it is then please suggest. Details: Windows server 2012 R2 with IIS and MS SQL standard edition, using C# in the front end with Ajax ...
0
votes
0answers
65 views

why am I getting an error with postgres and kerberos?

I am trying to install a web app that requires a postgres database, with a user and a password. Whenever I try to connect to the database, I get the following error: Cannot connect to database mydb: ...
9
votes
3answers
17k views

Where can I find H2 JDBC driver?

http://www.h2database.com/html/download.html I don't see it on this website. Is there anything I missed?
0
votes
0answers
219 views

Merging two sqlite3 databases into one database file

I would like to combine two sqlite3 database files (*.db) into a single database. Both databases have the same tables. Is there any easy way to do this?
0
votes
1answer
83 views

What data storage solution to choose HDD vs SSD vs Pendrive for an event storage? [closed]

I intend to buy a PogoPlug for a small server. I want to install Debian or Arch on it and I will use it for sharing and backing up photos between computers and as a HTTP server or/and event storages ...
0
votes
0answers
7 views

Is there a way to get links on URLs in a column in phpmyadmin?

In my personal database, I have one column which contains only URLs with scheme (e.g. http://...). For something else which cannot be automated, I need to quickly have a look at all these pages. I'm ...
2
votes
1answer
304 views

To edit commandline Anki flashcards in MySQL

I need to make a small change in 77777 Anki flashcards, preferentially programmatically, not by using their replace tool which is not sufficient. I imported data originally there as CSV files where ...
0
votes
0answers
20 views

How do I modify the definition of a view in Sequel Pro?

I just switched to Sequel Pro (OSX) from HeidiSQL (Windows), and can't seem to find an easy way to modify the base query of a view. Is there something I'm missing? Or do I have to drop the view and ...
1
vote
1answer
2k views

Is it possible to add a data connection to an existing table in Excel?

I have a table in Excel which has a data connection to an Access database. When the data changes, I can click "Refresh" to re-query the data and update the table. However, Excel 2008 for Mac doesn't ...
2
votes
1answer
132 views

CentOS - Trying to backup/restore a MySQL database?

My CentOS 6 server got a server issue, so customer support took a backup of my server and reinstalled it. The backup is in a folder called /home/42406. I'm trying to find my MySQL database called '...
0
votes
1answer
1k views

Merging two *.db files with same tables into one *.db file

I would like to combine two mysql database files (*.db) into a single database. Both databases have the same tables. Is there an easy way to do this?
0
votes
2answers
549 views

Shortening an Excel formula if possible

I am unable to shorten an Excel formula I am using in an Excel database. I've googled it, but this appears to be already the shortest way from the first page on Google. =COUNTIF(K:K,"Busy")+...
1
vote
0answers
106 views

PostgreSQL and database cluster ownership on shared storage

For my research, I am using an always on virtual machine for the primary analysis of my data. In doing this I need (or, I suppose, would like to) create and store the data in a PostgreSQL database. ...