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
10 views

Transposing data from single column list to multi-columns

I have an Excel spreadsheet which is tens of thousands of entries long but it's not organized. All the data is in a single column with each entry taking up 3 rows followed by a space. For example: ...
0
votes
0answers
12 views

How to retrieve all the result records? [on hold]

How do I get in a single Word, Excel, PDF, or Notepad file all the results available on the following URL? http://nts.org.pk/Test&Products/Results/CW_12Oct2014_Result/Search.php Of course I can ...
0
votes
0answers
4 views

mysql 2 databases synchronization

I've got 2 databases, one in local server and one in internet: local) server1 : DB1 { table1(40lines) } Net) server2 : DB2 { table2(30lines) } So how can I get those 10 lines from table1 in ...
0
votes
2answers
16 views

Update a sqlite database while select into a while loop

There is a bash script that will do "some magic"™ to files which will be referenced to a sqlite database and after doing "some magic"™ the database should be updated. Here are the simplified code ...
1
vote
0answers
22 views

Can you recommend an alternative to iTunes on Mac computers? [on hold]

I have a large iTunes database (over 750 GB) and iTunes can't manage large databases without screwing up. I am looking for an alternative solution to manage the metadata of my collection (including ...
0
votes
2answers
32 views

Shortening an Excel formula if possible

I am unable to shorten an Excel formula I am using in an Excel database. I have googled it, but this appears to be the shortest way already from the first page on Google. ...
3
votes
1answer
19 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 ...
0
votes
0answers
4 views

Access freezes before I can change data source

I have an .adp file that connects to MSSQL Data Source A, on Intranet #1. I copy the .adp to Intranet #2, including moving the .mdb to MSSQL Data Source B. I try to open the .adp to change the Data ...
1
vote
1answer
23 views

Excel - auto-fill blank cells or 0 in B:B to a dummy e-mail address which changes sequentially

I am creating a database in Excel that requires an e-mail address to be assigned to each row or user. While some users have an e-mail address in the original CSV file the majority do not. Each e-mail ...
1
vote
0answers
11 views

USe of Optimal Flexible architecture in oracle 11g?

I would like to to know about Optimal Flexible Architecture(OFA). I went through some articles in internet. But how exactly should we do to separate Oracle binary files and oradata(data files ) in ...
0
votes
0answers
6 views

Eclipse plugin for viewing database scheme

I tryed to install following plugin: dbschemaviewer but it doesn't work for me. I see following message: I think that it is related with version incompatibility. Can you advice alternative plugin ...
-2
votes
0answers
22 views

SQL in Database Management Systems [closed]

How to start working on SQL for the for the first time, I am trying to work on the problems from my Database management systems text book.I have opened the window called "New Query".After that I dont ...
0
votes
0answers
14 views

Duplicate data in first column, while retaining data for other columns

I have data that is organised in this fashion: Airport Forecourt 0610 0640 0705 however I require the data to be in this format: Airport Forecourt 0610 Airport Forecourt 0640 Airport Forecourt ...
1
vote
0answers
19 views

How to fix botched Outlook CSV data export 2013

When I exported contacts from outlook into a CSV file (to later upload it to Insightly database), it placed company names as part of the email address, it looks like this: Column named "E-mail" ...
0
votes
0answers
12 views

Why do webhosts make you explicitly add which IP addresses can remotely connect to their MySQL databases? [migrated]

In order to connect to a MySQL database, you typically use the following command: mysql -h host_address database_name -u db_user -p where db_user is associated with the database in question. ...
0
votes
0answers
7 views

IDEA bad encoding inside database veiw

I have connected my database and IDEA. Now I see list of tables from my database. but when I want to see table content I see following: Actually this content on my native language(not English). ...
2
votes
0answers
41 views

How to use ShemaSpyGui for view database diagram

I installed Postgre today and I want to watch database shema. I resolvse to use schemaSpy and download it and also schemaSpyGui and then I see: This is the command (password not displayed!) ...
-1
votes
1answer
32 views

Is it possible to connect to router through ssh?

I have a WiFi-router (cisco linksys) at my job and I have to access the database of our website frequently, but the access to the database is restricted and is only possible from my workplace. I read ...
-1
votes
0answers
59 views

Can't access MySQL command line after yum update Centos

I need help I just run yum update on my centos 6.5 still not Reboot system and i can't login by command mysql [root@localhost]# mysql mysql: relocation error: mysql: symbol strmov, version ...
0
votes
0answers
39 views

OpenFire connect to SQL Server Database: Network error IOException: Connection refused

I am trying to get OpenFire to run with my SQL Server. I am following the instructions at Instructions. I have created a new database, named it OpenFireDB, and have created a new login and user, both ...
0
votes
0answers
24 views

Select last four from credit card field and place in new field

I am new here. I hope this is the correct place to post this? I have a table ("accounts") in Advantage DB with two fields (CCNo & LastFour). CCNo is Credit Card Number. Last Four is the last four ...
-2
votes
1answer
32 views

How does social media sites store posts [closed]

Do social media sites such as Facebook and twitter, store posts in a database? Like mysql? Wouldn't the database be extremely large? Does Facebook or social media sites remove old post?
0
votes
0answers
18 views

Extending an formula over multiple cells

I want to set up an excel table where: A:A is my 1st data table B:B is my result table C:C is my "Column" table D:D is my "Row" table E:E is my 2nd data table I want the result of the function to ...
0
votes
0answers
16 views

Plotting two data sets with measurements at different scales

I'm doing research on a rock core with tools that measure different things over different lengths. One will give me a reading every foot , the other will give me a reading every 2in. I am trying to ...
0
votes
0answers
17 views

How can I connect to apex oracle database using ssh?

I have obtained a workspace in apex.oracle.com , where I can use database provided for me. Now I can run the sql command in browser to do operations, but thats kinda slow. So what I need to do is , ...
0
votes
0answers
34 views

Network shared access database: your network access was interrupted access to continue close the database

I have a network with several Windows XP and Windows 7 users accessing MS Access databases over shared files in a NAS Synology. One of the XP users get several times in a day the following message: ...
0
votes
1answer
68 views

Photo Organizer that works from many computers to one file server

I have a file server in the closet. It runs Ubuntu, and exports my photo library as NFS4 and SMB. I have children and a wife who all also want access to these photos. Right now, the archive has the ...
0
votes
0answers
32 views

generate entity relationship diagram from h2 database

is there an easy way to generate entity relationship diagram from h2 database? I coudn't find any useful thing from google.
0
votes
1answer
29 views

MS-Access many to many relationship with subform having multiple criteria

In my database design there are 5 tables and i want my database to be able to save the course fee given by student. according to the design one student can enroll in many courses. i want to ...
-1
votes
1answer
52 views

Missing MySQL Database after Windows Upgrade

First of all, please bear with me as I am quite new to HeidiSQL, MySQL, and the concept of relational databases as a whole. I recently started using HeidiSQL in order to create tables for import into ...
0
votes
1answer
45 views

Are Intel i7 core mobile processors decent enough for software development? [closed]

I'm reaching out because I'm in the market for a new laptop, and I would like something light that I can take with me for a job interview or meet clients, so I can demonstrate my source code and ...
0
votes
0answers
21 views

Recover back end database password from front end connection string

I built an MS Access database about a year ago and set separate passwords for the "front end" and "back end" components of the database. It's been a long time since I've had to access the back end ...
3
votes
1answer
41 views

SFTP transfer a file from server to desktop

I am trying to compete an assignment for school and I have one final step. I have use the "put" command to load the file. Then ran a spool and the file followed by ending the spool. Now I am back at ...
1
vote
0answers
17 views

Database-based word document

I will take an example, it'll be easier: So I have a database about classrooms. There is student db which contains all the students like so: id name surname slug class 0 John ...
0
votes
0answers
21 views

Barnyard - Database Warning

I installed snort and barnyard. When I start snort and barnyard services, barnyard could read snort.log file but it doesn't write to mysql database. So I run tail -100 /var/log/messages and I ...
0
votes
0answers
19 views

SSDT compare dacpac and db solution

I have a question related to the compare of the db solution and a dacpac, I'm using SqlPackage.exe for the comparison but when I have the result I saw that in the comparison was included all the ...
0
votes
0answers
55 views

Barnyard Service - MySQL Error

I installed barnyard2 and saved as a service. When I run service barnyard2 start, Barnyard2 is failed. After I run tail -100 /var/log/messages and I encounter a fault like this. ERROR database: ...
0
votes
0answers
30 views

Is there a tool for syncing changes to individual nodes within HDF5 files?

I'm looking for a tool for efficiently syncing large scientific datasets in HDF5 format: Each file is ~20-30GB in size and contains many large floating point arrays, which are usually chunked and ...
1
vote
0answers
64 views

Getting Excel to “update” or “follow” a linked Access table?

I'm using Excel and Access 2007. I'm having an issue at work and my current knowledge of Access and Excel isn't enough. I have an Access database that has certain data in it. I have an Excel ...
0
votes
0answers
9 views

Oracle RAC 11G Requirements VS Single Node 11G

I have an Oracle 11G Database running on Solaris SPARC. I'm already using NFS for the node. I'm looking at moving to RAC. Would there be any additional requirements for RAC besides an additional ...
0
votes
0answers
16 views

2010 Microsoft Access Relational Table Insert

I am working with a Microsoft Access 2010 database with 3 tables. What I want to do is edit the 3rd table (Street) and be able to call information via combo boxes from City and State. When I add a row ...
0
votes
1answer
149 views

How do I create & restore a mysql database dump with Chef?

Environment Ubuntu 12.04 Precise64 Enterprise Chef opscode-cookbooks/mysql opscode-cookbooks/database Wordpress 3.9 Objective I am trying to replicate/clone my production Wordpress server. I'd ...
0
votes
0answers
5 views

Unable to restore testcase database of quality center 9.2

We are using quality center 9.2 for storing test cases. Recently the Quality center server had some issues, so we took back up of entire C drive and formatted the PC and installed OS newly. Now we ...
0
votes
0answers
46 views

MS Access .mdb & .ldb database corrupted

I am using a A.mdb database. You know when connecting the databae Microsoft automatically create a .ldb file. Unfortunately my pc shutdown when connecting the database. As a resutl after restart the ...
3
votes
3answers
111 views

How to split one row in Excel into multiple rows for database management

I have a set of data that is currently 39,000 rows and 27 columns. The first column is the ID number. The subsequent columns correspond to elections, with the date of the election in row 1 (cells ...
0
votes
0answers
9 views

Are there any NULL bytes in an MS Access database?

Mercurial diffs files only if it is "not binary", where "binary" is defined as "contains a NULL byte". Do databases in MS Access (.mdb) contain null bytes?
0
votes
0answers
15 views

Personal queryable address book with document management

Please suggest me any freeware software or cloud solutions that allows: Create and manage a person date (like in address book) Attach any documents to the persons Query the system, e.g. to select ...
0
votes
0answers
46 views

Auto-Fill Textfields in PDF from external sites?

So I've got an editable PDF with 2 text fields. Name and EMail. The PDF is locally as in on my current PC. The database is remote, and has 2 fields called "Name" and "EMail". However it is not a ...
0
votes
2answers
52 views

Pulling out data from a spreadsheet

I need to add information of clients who have visited the office, which department, who they were referred by, who they were referred to etc. I have linked a screenshot of what I have currently made ...
0
votes
1answer
45 views

SQL database recovery from corrupt database file. What to do next?

Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental ...