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)

1
vote
1answer
961 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: ...
0
votes
0answers
8 views

TortoiseSVN database locking errors after disabling Samsung RAPID mode

One of my users is getting database lock errors from TortoiseSVN after disabling Samsung RAPID mode. What's a good way to find out what programs had a file locked recently? Since it requires a ...
20
votes
5answers
26k views

“FATAL: lock file ”postmaster.pid“ already exists”

I just reinstalled postgres via brew install postgres I ran initdb /usr/local/var/postgres -E utf8 but got this: The files belonging to this database system will be owned by user "atal421". This ...
0
votes
0answers
7 views

SQL Server 2014 Express has reached database size limit. What is the quickest solution?

My SQL Server 2014 Express database has reached database size limit. What is the quickest solution to get back up and running? Is Express software the same as the full version, with just some ...
-2
votes
0answers
9 views

windows virtual private server database access [closed]

I got the access credentials to a windows virtual private server that has a sql server. Also the password for the sa account on sql server. I need to access some databases in that server which has got ...
0
votes
1answer
12 views

Hardwareinventory - Copy Record with values in Access 2016 Web App

I want to make a WebApp in Access which help me inventory all our Hardware. Below is a VERY wip ERM for the Database behind it. Every CPU-Object is its owm physical thing (if we have 2x i5-3450 there ...
0
votes
1answer
26 views

Excel Pivot Table with Microsoft Access Connection

I have a pivot table which sources its data from a query within an Access database file. Whenever I make an update, I make a copy of both the Excel and Access files first - and carry out the update on ...
-1
votes
0answers
12 views

VPN connect to Postgres DB error

I have a big trouble: I need connect to my db in another city with Navicat (or other SQL clients). I made vpn - tunnel, but when I connect (with Navicat or other SQL clients) I get the following error ...
1
vote
1answer
203 views

How do I find out what my SQL Server database audit records contain?

I need to find out if my SQL Server 2005 database audit records contain the required information that I need. Where or how can I find this out?
0
votes
0answers
6 views

What embedded database format is used by this Chrome extension?

Chrome extension F.B. Purity writes its data at ~/.config/chromium/Default/Local Extension Settings/ncdlagniojmheiklojdcpdaeepochckl/000003.log (not a log file despite its name). This file is a kind ...
0
votes
0answers
7 views

Query optimization in Data stream

I am confused about the idea of query optimization in stream of data. As a background, i know that optimization for any query is happen inside the DBMS with using of System catalogs which contain ...
1
vote
2answers
6k views

How can I remove Postgres completely from my Mac?

I have been experiencing spooky behavior with Postgres after using the Mac installer for Postgres. There seems to be an existing half-baked Postgres installation that was already there and remains ...
0
votes
3answers
3k views

How may I retrieve data from an Excel table based on a variable number of criteria?

I have the following salary data for example: Country State 2012 2013 -> 2027 ======= ===== ==== ==== China Other 1000 1100 China Shanghai 1310 1400 China Tianjin ...
2
votes
2answers
21 views

Which wildcards can I use for a Microsoft Access form asking for month and year?

I made an Access Database that includes dates. I have a Report connected to a query that, when opened, prompts the user for a month in numbers (1-12) in order to produce the report for that months. ...
0
votes
3answers
4k views

Linux Mint (Ubuntu) Microsoft Access Replacement? [closed]

I've just switched over from Window to Linux Mint, and the only thing I'm missing is a replacement for Microsoft Access. I'm aware of LibreOffice (which comes installed), are there any others I ...
0
votes
2answers
18 views

Excel 2016 list of options for connection to DB has suddenly reduced, (MySQL, PostgreSQL)

I work with open source dbs such as MySQL or PostgreSQL as a back-end data storage with my excel 2016. I had the full list of connections to all different kinds of dbs but they are suddenly reduced ...
1
vote
1answer
80 views

Back end already in use

We are using an Access Database divided in front end and back end (in a shared folder). I distributed copies of the front end to every user. All users have the shared folder and subfolders added to ...
3
votes
2answers
4k views

Incremental Backup for PostgreSQL 8.3

I'm looking for a way to make good incremental backups for a large (more than 100 GB) PostgreSQL 8.3 DB. I'm currently using pg_dump which isn't incremental and very slow in backup and restore, ...
0
votes
0answers
52 views

MySQL Install DB Error 13 / 1005

I am trying to programmatically install multiple mysql databases on a Ubuntu distribution server via a bash script, and I keep hitting the ERROR: 1005 Can't create table 'db' (errno: 13) each time I ...
1
vote
0answers
13 views

Miscrosoft Access - Multi-Table Data Entry

I'm using Microsoft Access 2016, and am designing a tool to track our engineer drawings at work. As you can see from the image of my relationships, the project info cascades down on the left and the ...
0
votes
1answer
59 views

XAMPP and MySQL workbench [duplicate]

Ok so I have this message error in XAMPP: 20:25:37 [mysql] Error: MySQL shutdown unexpectedly. 20:25:37 [mysql] This may be due to a blocked port, missing dependencies, 20:25:37 [mysql] ...
0
votes
0answers
42 views

XAMPP and MySQL

Ok so I have this message error in XAMPP: 20:25:37 [mysql] Error: MySQL shutdown unexpectedly. 20:25:37 [mysql] This may be due to a blocked port, missing dependencies, 20:25:37 [mysql] ...
0
votes
2answers
311 views

How to determine sql server name

I'm trying to install sap business one on my computer. But I can't seem to connect to the database server which is ms sql. ![enter image description here][1] I get the notice: unable to connect to ...
2
votes
1answer
802 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!) ...
19
votes
4answers
32k views

How to export mysql schema from phpmyadmin?

I have a huge db that hangs the server if I try to export it, is there a way I can export it without all the data? Only the tables structure.
3
votes
2answers
6k views

How can I create a mandatory, non-identifying relationship between two entities?

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 ...
-2
votes
3answers
6k views

mysql access denied for 'root'@'name of the computer'

I am getting this error everytime im trying to connect to my database Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'root'@'name of the computer' ...
5
votes
2answers
672 views

SQL Server Management Studio ignores default DB

When I use SQL Server Management Studio to log in to databases, it ignores my default DB and always puts me in master. I checked that my Windows user has a login with the correct DB set, and I tried ...
0
votes
0answers
27 views

“Navicat for PostgreSQL” gives error “80070003: PrectServer2 not connected” when attempting to autocomplete with materialized views

For some reason I get the error "gives error "80070003: PrectServer2 not connected" when Navicat tries to autocomplete. Take the following example select co.| from visualize.co_mention co When the ...
0
votes
0answers
11 views

How to allow a database user to do anything inside the databases she/he creates?

I have a problem with yabs, a free business software. This piece of software can use a mysql server for storing its data. As usual a user in mysql-server is created to limit the authorities of the ...
4
votes
4answers
15k 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 ...
0
votes
0answers
61 views

Read out Lotus Notes Calendar entries from NSF-Database?

I don't know how to display my calendar entries on another machine. I already created the view, which reads out the needed information (calandarView.xml) in my Inbox.nsf . My main problem is, that ...
0
votes
0answers
9 views

Curious search behavior in Sql Server 2014, searching for dot also returns comma results

Background I'm getting some unexpected search results, consider the following pseudo-query: SELECT SomeField1WithSearchCriteria, SomeField2WithSearchCriteria, ...
1
vote
2answers
396 views

How can I convert MS Access 2003 (2000 file format) to Sql Server Express 2014?

I've been searching for the past two days on how to get this conversion done, but every suggestion I've seen yields no effective results. I've installed Sql Server Express 2014 and have verified that ...
-1
votes
1answer
30 views

drop database via bash with dash in database-name

I have a variable in a script with the list of folder names with dash in their names DBDIR="some directory" dbdash=`ls -l $DBDIR | egrep '^d' | grep '.-.' | awk '{print $9}'` And I want to drop ...
0
votes
0answers
52 views

How to Create Drop Down Tables In Microsoft Access 2013

My question is: how do I make multiple drop-down tables in Access? I'm trying to make a table with multiple entries and drop-down tables underneath. For example: Main file: Car Types, Sub File 1: ...
0
votes
0answers
849 views

MySQL server will not start after upgrading to Windows 10

I had a MySQL server on my machine, and then I got the helpful free Windows 10 upgrade. I updated to Windows 10 and then I tried to start the server again after a reboot and I cannot get it to work. ...
1
vote
2answers
47 views

Why am I getting this MySQL database creation error?

I have a redhat linux in AWS EC2. I created a few dbs yesterday for an application. Today, I am getting an error in creating a new database. mysql -u root -p pw: xxx CREATE testdb; I get an ...
1
vote
1answer
39 views

Is there a way to automate the conversion of old Access databases (.MDB files) to the newer .ACCDB format?

I have a couple hundred old Access databases, in the old .MDB file format. I'm not sure which version of Access they were created in. My ultimate goal is to make them usable to someone who has Access ...
-1
votes
1answer
89 views

C# console Application with DB

i have c# program connected to SQL server and it is working very good but when i am trying to install this program in other PC it doesn't work unless SQL installed the data base is very simple .. i ...
0
votes
0answers
15 views

Merging multiple folders with different names, but similar content

I have a database of images, within the images folder are different folders of the alphabet: C:\Images\A C:\Images\B etc... Within the alphabetical folders, there are folders with the naming ...
0
votes
0answers
4 views

SonarQube Server end of an update process

during a CI process,after a SonarQube Scanner analisys, we must produce some reports using fresh analisys result data. SonarQube stores analisys results data asynchronously but we have to know if a ...
1
vote
1answer
29 views

MS SQL query which split to other table columns

I have two table: table1: |Manager | USER | +--------+------+ |John | Tom | |John | David| |John | Marry| |James | Henry| table2: Now is empty, but must be like: ...
0
votes
0answers
44 views

Cleaning up data fetched from Google Spreadsheet to Excel

I've been trying to synchronize and build a local database with Excel data. I need to build the database and program to create user accounts, manage the packages, track and log the status of the ...
1
vote
1answer
22 views

Database Query and Excel

I have a report on Excel that built using database query. I need to write comments on each row. When I refresh the file the comments don't stay on the same row and don't match the record. What should ...
0
votes
0answers
85 views

Microsoft ODBC for Oracle not working with Oracle 11.2.0.2

I have Oracle client installed and i am able to connect using sqlplus, i am also able to use My requirement is to try to use Microsoft ODBC for Oracle using the following VBSript code my .vbs file ...
0
votes
1answer
61 views

Remove all references to removed Sql Server database

One of my programs that I have written, creates on installation a SQL Server database. The database name is hardcoded in the sources. Now I have the problem, that on a clients machine the program was ...
0
votes
0answers
15 views

Is column imprints applicable to string columns

I came across this secondary index 'column imprints' which is very interesting and effective. My usecase is, I want to know whether these imprints can be applied on string columns. I found monetdb ...
0
votes
3answers
86 views

How to access SQL Configuration Manager

Upon checking the programs installed on my machine, it says that I have SQL Server 2014 installed. However I can't access the Configuration Manager in the "All apps" of the start menu to make a ...
0
votes
1answer
29 views

How do I convert sql to excel syntax?

I have two sheets in an excel file, "sheet1" and "sheet2". The first sheet has a table called Oranges, it shows where the oranges were produced and where they were exported to: On the second sheet ...