The database tag has no wiki summary.
0
votes
2answers
19 views
How to connect to MySQL server in LAN
Ok, Here is the technical description.
My laptop's config:
Ip Adress:192.168.2.5
Mysqlserver 5.0 on port : 3306
Operating system: Ubuntu
the database is in this machine
My friend's laptop ...
0
votes
0answers
7 views
Conversion of GRIB and NetCDF to my database
image: http://i.imgur.com/lgV9A.png (my first question, so I can't atach it yet)
I have downloaded "High Resolution Initial Conditions" climate forecast data for one day, it was in extension .tar.gz ...
0
votes
1answer
47 views
How to get the difference between two dates based on an item (truck) number
I'm trying to set up a database for a co-worker to track information based on truck number, amount disposed, etc. Sometimes trucks are left with garbage at then end of the day. That truck may not be ...
0
votes
0answers
13 views
How can I sum up sub-datarecords in a calculated field?
I'm building a little Music Database with following tables:
I would like to sum up the total count of tracks in the Table 'albums' as calculated field.
I created a Query with SQL that groups to ...
0
votes
2answers
39 views
Easy to use database with views for a medical student doing research?
I'm having trouble finding a tool that does this for my friend (without designing it myself). What is needed is a simple program with a database where input forms and views can be designed and saved.
...
0
votes
1answer
41 views
What command in MySQL is like the command “host” in oracle sqlplus
Oracle sqlplus allows you to drop down to a system command line shell which lets you run operating system command like ls, cd, cp, etc.
Here are examples SQL*Plus_FAQ, docs.oracle.com
Is there some ...
-1
votes
1answer
59 views
How to Extract Web Data for Shopify Bulk Import
I want to import a huge database of products (5000+) to Shopify. My supplier only gave me the website, he refused to give me the database file.
How do I extract the web data to a CSV format so that I ...
1
vote
2answers
40 views
How to transfer results to Excel
I have a massive (and I mean MASSIVE) amount of results from Minitab 16 displayed as plain text organized in columns and rows.
My problem: I need to put all this information into tables to manipulate ...
0
votes
0answers
57 views
Show DB2 Tables in Oracle SQL Developer
(Yes, this is a duplicate question from SO. I made it long ago, and it's still unanswered. I think it may get better results here?)
I'm connecting to a DB2 database with Oracle SQL developer. There's ...
0
votes
0answers
32 views
In Visio 2010, how can I create a mandatory, non-identifying relationship between two database tables
I'm working in MS Visio 2010. This is the relevant part of my ERD:
The relationship between Event and Adventure is correct: there's a foreign key from Event to Adventure, and that FK is part of ...
0
votes
0answers
27 views
Allow user to add value to an MS Access table without handling NotInList?
I have a form in Access that queries a table to supply options to a combo box. When I enter a value into the combo box that isn't in the table, I see the following message:
Microsoft Office Access ...
0
votes
0answers
26 views
What is the easiest way to get started using databases with real data? [migrated]
I have a project that could benefit from using a database, but I have no experience with databases, don't have access to a server, and have relatively little experience working with things living ...
0
votes
1answer
49 views
Database Migration from MyISAM to InnoDB
I am migrating a database with MyISAM tables to InnoDB engine.
some of the tables in MyISAM have full text indexes, if I have to retain the full text indexes in InnoDB engine. What are the things ...
0
votes
0answers
25 views
Best approach to doing automatic analysis of sets of tags in Excel/Access/or similar?
I have a large set of open-ended responses to a survey (~10,000), and each has been assigned a set of tags representing what the person has said in the response. This data is sitting in an Excel ...
0
votes
0answers
73 views
Access 2012 - Can't find object
When opening certain macros, whether in design or run, I get ' Microsoft Access cannot find the object 'whatever the object name is>'. This only is on certain macros, but most of them work properly. ...
0
votes
2answers
29 views
Access, select or utilise names in another worksheet of the same book
I've created a name database on an Excel sheet and I would like to access, select or utilise any of these names in another sheet of same book.
0
votes
0answers
31 views
Sage 1000 data dictionary
I'm just starting doing reporting using MSQL SSRS against a Sage 1000 database. It's working well but I'm trying to find out more about the data model on the database in order to make best use of the ...
0
votes
0answers
27 views
What enterprise tools exist for exporting from a database into a set of files?
I'm looking for software that's designed to select/query data from a database (SQL or NoSQL), and export it into files (CSV, XML).
Ideal characteristics:
Manage very large datasets (petabytes), ...
0
votes
0answers
97 views
Could Jekyll/Octopress and other static blogging engines be a good option for a heavy online magazine? [closed]
I'm exploring several options for setting up a static blogging engine and migrating there some contents for some blogs I've got. I'd like to test the performance of these engines, and I've heard great ...
1
vote
0answers
30 views
Alternative, more efficient scraping method for a noncoder, than Google doc's importxml and xpath?
I've searched throughout the net for a simple solution, but it seems everyone has their own unique method (coding language) of achieving this. I'm only just beginning to learn Linux, and my coding ...
0
votes
1answer
44 views
MS Query unresponsive after launching in Excel 2007
User is launching MS Query from within Excel 2007 querying a database and then MS Query becomes unresponsive staying minimized to the task bar. Any assistance would be appreciated, the user is able to ...
1
vote
1answer
35 views
Change location of storing mysql database
Im running a linux server and I wondering if and how could I change the contents of Mysql server to be saved on an external hardrive instead of the place where it is being stored now.
0
votes
1answer
41 views
Issue changing mysql password on Debian
I installed mysql on my Debian server. I couldn't get into the database because it kept saying I put in the wrong password so I looked on the internet and found that I could log onto mysql using the ...
0
votes
0answers
86 views
Export MS SQL database as *.dbschema
We have a production database and visual studio 2010 database project. We had to make some changes in database schema. Unfortunately we don't have previous database schema file for production ...
1
vote
1answer
160 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.
...
0
votes
3answers
44 views
Can there be permissions/limitations with browsers over a network?
I'm part of a network at my job and the only thing that can be accessed from my/my co-workers computers is the company database and sharepoint. These are accessed through IE. Everything else is denied ...
1
vote
1answer
65 views
Should you set up a separate EC2 instance for your database? [closed]
Is it a good idea to set up separate instances for your app and your database if you're only going to start with one micro instance on EC2 for your app? What are the benefits and disadvantages of ...
1
vote
1answer
119 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
1answer
85 views
Relational database software with user web frontend? [closed]
Does anyone know of a database package like access or openoffice-base with a http frontend rather than a software client?
preferably open source software
0
votes
1answer
22 views
Form no longer updates table; what'd I do?
I've been working on an "Enter Scores" type of form for a database that's used in a competition. What should happen is - I pick a team from a combobox, enter their score in a text box, then upon the ...
0
votes
3answers
81 views
Structured data manipulation software with fully customizable interface
Is there any general xml-like data manipulation software that would allow defining data structures, and defining/drawing your custom interfaces for editing and exploring your data?
Something that ...
3
votes
2answers
84 views
How can I keep every fifth row in Excel
I have a data set in excel with 3084 rows. I need to delete 4 rows, then keep one: deleting Tuesday, Wednesday, Thursday, Friday but keeping Monday to create a weekly rather than daily data set.
...
0
votes
2answers
66 views
extract information from table of values
Hi I have table of values stored in a csv file and the table is organized
the following way:
Method1,,Method2,
T1,T2,T1,T2
a1,b1,c1,d1
a2,b2,c2,d2
a3,b3,c3,d3
a4,b4,c4,d4
One example of something ...
1
vote
1answer
185 views
What's the difference between .db and .sqlite files?
I had a look into a program's folder in Program Files of the Windows directory and I found that it has a lot of files with .db extension. I opened one with notepad and I saw that the first string in ...
0
votes
0answers
44 views
How can I get Access 2007 to update a record from a text box on a key press?
My goal is to pick a team from a drop down box, enter a score in the form's text box, hit the "Enter" key, and have a record called Brief Score updated in a table based on the selected team. For ...
1
vote
0answers
30 views
Why are there limits to scaling relational databases? [closed]
It is often repeated that the Big Data problem is that relational databases can not scale to process the massive volumes of data that are now being created.
But what are these scalability limitations ...
0
votes
1answer
19 views
Is there a way to see preexisting relationships in a database?
I'm using MS Access 2007 and working on cleaning up a functioning database. I want to see the relationships between the tables and queries at will, but the closest I can get is the object dependencies ...
1
vote
1answer
52 views
Fastest way to transfer an mssql database backup from one windows server to another?
Would it be by copying it onto a hard disk or is there a faster way?
-1
votes
1answer
52 views
Is it possible Connect landphones to mysql? [closed]
I have a land phone that displays the caller ID.
I want to use a some interface or cable to connect the phone to a pc and then connect it to mysql, check if the user is available in the database, and ...
0
votes
0answers
115 views
Compile IMDB search programs and database on OS X, possible stack size increase
I am trying to compile the IMDB search programs with the corresponding databases, but somehow I am unable to do so. Here are the infos, here is the direct link to the files (Warning: it links to an ...
1
vote
1answer
289 views
How can I create an ERD for my phpmyadmin database?
Is there a way I can create an ERD for my PHPMyAdmin database?
1
vote
1answer
137 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 ...
2
votes
0answers
119 views
Join multiple consecutive SQLite database dump files into 1 common database? Purpose: Search through ENTIRE Chrome Browsing History
Google Chrome 's default web browsing history search engine only lets you access the records of the recent 100 days.
Nevertheless in your application data, Chrome keeps your entire browsing history in ...
1
vote
0answers
99 views
How to export and import an user profile from one Quassel core to another?
I'm using for quite a long time Quassel as my bouncer for IRC.
We (a group of administrators of a small network) have set up a shared Quassel core with many users on the same core.
But now I would ...
1
vote
1answer
101 views
Why would a DB connection over LAN be slower than a WAN connection?
I'd noticed for ages that a MySQL database connection over my LAN was significantly slower than a database connection over the Internet.
I'm running Windows 7 32bit and I'm connected to a switch ...
0
votes
1answer
43 views
Merging Database Modifications - CVS
I'm working on a project using git for version handling. What is the best approach to include the database in the cvs?
For example, if I checkout the database and install it at home, make some ...
0
votes
2answers
107 views
How to setup anonymous FTP for file upload
I want to have a FTP server setup that allows clients to upload large files (2GB+ database dumps) by SFTP. The important point is that I want clients to log into the server with a single username and ...
1
vote
2answers
206 views
Linux library software for videos and movies [closed]
I'm looking for a (hopefully) open-source movie library/database application to be able to navigate my 2000+ movie collection (all in digital files, ripped from owned DVDs). My platform is Linux (so ...
0
votes
0answers
88 views
Access 2010. Create list of checkboxes (automatically) for seperate values, not multivalue
I'm trying to create a form whereby I can add multiple values to a table, I want to select the values using a list of check boxes, but there are a lot of values- is there anyway to automatically ...
2
votes
1answer
69 views
Possibe data corruption in x-ray room
I built a small fingerprint ID system for a lab. Registration is done at a reception and identification at 2 other points. One point is the x-ray room
The problem: Identification often seems to fail ...
