System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
0answers
7 views

Name [ ] is not bound in this Context. Unable to find [jdbc] Tomcat Issues

I just created a fresh Oracle Linux 7 VM with Tomcat 7 and Java 8_40. I've created several servers with Apache and Tomcat before, but never connecting to databases before. SELinux and firewalld are ...
-3
votes
0answers
20 views

How to write access command with credentials?

We had a third party company setup servers and built services for us years ago. But the relationship is strained now and basically they won't reply any email to us. We could find some legal help but ...
0
votes
0answers
23 views

Database Server froze - High IO - how do I find out whats the reason? (Pics)

got a db server(KVM) running mariadb 10.1, runs fine since months, only servers 2 databases (drupal). Last night it went tits up. Here 2 screenshots from zabbix I checked the logs, they show ...
2
votes
1answer
8k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
-1
votes
0answers
16 views

need to assign mysql root user to database with full permission [closed]

I have a Centos 6 box with MySQL 5.6 There's a database control panel script I bought that requires full root access to MySQL. I can't figure out via CLI how to greant the mysql root user the full ...
-2
votes
0answers
22 views

How can Facebook store the data of billion users? [closed]

My question is: how can Facebook store the data of billion users and show them up in few milliseconds?
1
vote
1answer
3k views

Cannot start Oracle XE 11gR2 Net Listener and Database on Ubuntu 13.04

I have been following the setup step on this article for installing Oracle XE 11g R2 on Ubuntu 13.04. The environment variables PATH, ORACLE_HOME, ORACLE_SID, NLS_LANG ORACLE_BASE have all been set up ...
0
votes
1answer
3k views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
1
vote
1answer
14 views

Do I need to restart SUSE when upgrade glibc?

I plan to upgrade glibc version (HAVE to install by rpm command) on 30 SUSE machines, all the machine are using for running test on Jenkins. Could someone tell me the reboot is needed in this case?
1
vote
1answer
2k views

Recover mysql database innodb 'table doesn't exist'

Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd. I've tried the ...
0
votes
1answer
3k views

Command to list event monitors in DB2

I see the following commands: drop event monitor set event monitor create event monitor But nothing like list event monitor or get event monitor. Is there a DB2 command to list all current event ...
13
votes
6answers
22k views

How can I diff two Oracle 10g Schemas?

I have the feeling that there are some difference between two large complicated Oracle schemas which should be identical, so decided to dump and diff them to investigate. I found an article ...
0
votes
1answer
28 views

Exchange 2013 - 0kb EDB File after ISCSI Drop

I am unsure if anyone will be able to help me out. I have a 0kb EDB file after an ISCSI failure. I cannot run "eseutil" on the file as I get the error: Extensible Storage Engine Utilities ...
5
votes
7answers
24k views

How to undo DROP Table?

I accidentally dropped all tables. Can I restore back? I don't have the backup copy.
1
vote
0answers
19 views

Correct Azure VM firewall settings for Azure SQL Database v12

One of the recommendations when a client runs on an Azure VM and needs to connect with your Azure SQL Database v12 is to: Ensure that the port ranges of 11000-11999 and 14000-14999 on your Azure ...
15
votes
6answers
21k views

From a shell script, how can I check whether a MySQL database exists?

mysqladmin -uroot create foo returns an exit status of 1 if foo exists, and 0 otherwise, but of course it will also create the database if it doesn't already exist. Is there some easy way to simply ...
1
vote
1answer
34 views

Unable to restore postgresql data dump for Django app hosted on Azure VM

I am trying to restore a postgres data dump for a Django app of mine. The data dump was extracted from Heroku, and pg_restore is being run on an Azure VM with Linux on it. There are around 40 tables ...
1
vote
1answer
2k views

ASP.NET Website Administration Tool: Unable to connect to SQL Server database

I am trying to get authentication and authorization working with my ASP MVC project. I've run the aspnet_regsql.exe tool without any problem and see the aspnetdb database on my server (using the ...
1
vote
1answer
20 views

MySQL Error Code: 1017 permission denied

I have downloaded the German version of the Northwind sample database. I moved the folder to /var/lib/mysql and set the rights to drwxr-x---. Here is an output of /var/lib/mysql drwxr-x--- 2 mysql ...
1
vote
1answer
13 views

Back up a database nightly

Question: Is it possible to automate the process of coping a full database every night into the development database on the same server? Software: Windows Server, SQL, SQL Server Management Studio, ...
-1
votes
1answer
34 views

Use Google Drive for live DB backup? [closed]

I am currently trying to define my backup strategy for my AWS EC2 server. I already use Google Drive to backup my apache root folder. This also automatically doubles as a deployment strategy since the ...
0
votes
0answers
23 views

MariaDB query cache not being used with prepared statements

We are seeing a problem with our MariaDB setup where our queries executed as prepared statements are not being cached, however, queries executed locally through mysql command (i.e. text protocol) do ...
2
votes
1answer
1k views

Large lag on mysql replication (Relay_Log_Pos and Exec_Master_Log_Pos does not increase)

Today my two slave's (one mysql 5.1 and second MariaDB 5.5, master is mysql 5.1) started lagging. Similar situation are quite often with lags rises to even 10000 seconds, because slaves have worse ...
1
vote
2answers
704 views

postgreSQL replication and failover with repmgr on Ubuntu

I'm new to Linux and have been tasked with setting up a redundant Linux DB server with PostgreSQL. preferably the fail-over needs to be automatic, but a manual process will be fine for now. What I ...
0
votes
1answer
1k views

Need DB2 OLEDB Driver / ODBC Driver

I am trying to establish a connection between excel and db2. I am able to successfully query and retrieve data from my DB. I am using the below connection string ...
1
vote
1answer
2k views

DB2 Integrity Checks and Exception Tables

I am working on planning a migration of a DB2 8.1 database from a horrible IBM encoding to UTF-8 to support further languages etc. I am encountering an issue that I am stuck on. A few notes on this ...
0
votes
0answers
9 views

Telling how big an oracle DB dump will be when imported

I have an oracle DB dump file that is 30GB and i would like to build a filesystem to support its size once imported - is there a tool/method i can use to tell how big it will be post import ? Thanks ...
0
votes
0answers
16 views

Linking fail2ban with a RDBMS

I would like to maintain a highly dynamic RDBMS table that will be insert/update/deleted from from multiple hosts (a kind of global blacklist for all my servers). The table would have a couple basic ...
-2
votes
1answer
35 views

best configuration for database server [duplicate]

Okay I have a VPS (DO 512 MB) and AWS RDS free tier . I wanna get the maximum performance , please help me cause I'm a little confused . I run a nginx server on the VPS and it can handle 1K ...
2
votes
3answers
622 views

Can I convert my database/script to UTF-8?

How can I convert a database to support UTF-8 and convert it's old data from what ever encoding they're in to UTF-8 ? Extra Info: I'm running a server which has many websites on it, and one of them ...
0
votes
1answer
2k views

SQL Error (1064) when importing data from SQL file

I have a MySQL database, which was originally set up with the default latin1 character set and latin1_swedish_ci collation. I was using the database like this for sometime, until I noticed strange ...
0
votes
1answer
43 views

How can I securely access a Rackspace Cloud Database in AWS?

Rackspace limits access for Cloud Databases to their ServiceNet. How can I securely and efficiently connect to a database instance there from AWS (over the public internet)?
0
votes
0answers
20 views

Get the most out of VPS and AWS [duplicate]

I have a static website running on shared hosting and doing good (not slow) And having a bandwidth of about 3Gb / month and I'm adding 2 other dynamic website with database and php scripting(I assume ...
0
votes
1answer
26 views

How to change MySQL user permission temporarily (Per Connection)

I do not know if it is possible at all or not. What I want is that, when a certain connection is established, the user not be able to modify data with that connection. This is the scenario: ...
3
votes
2answers
6k views

pgAdmin cannot connect to PostgreSQL 9.1

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM. The host's port 5432 forwards to VM's port 5432. pgAdmin Error: Error connecting to the ...
3
votes
1answer
29 views

Connect server A to database on server B and forward remote database port on server A

Edited: I'm quite new to all this admin stuff though! So: Whats the best way to connect a port on server A to the database on server B. The reason i want to do this: I want to connect server A to a ...
0
votes
0answers
29 views

Wordpress showing article title, but content is showing blank

I recovered from a disaster situation on the server, database is not affected. My wordpress files were old, from previous version (maybe 4.3). When I recovered those file and setup nginx with it, I ...
1
vote
0answers
14 views

CouchDB Authentication and Security

i used this link to install CouchDB on virtual machine http://depth-first.com/articles/2010/01/28/pubcouch-install-couchdb-on-ubuntu-karmic-from-source/ everything goes fine, after that i tried to ...
-1
votes
1answer
49 views

All MySQL databases appear to have disappeared

I'm running CentOS 6.7 with MySQL 5.1.73 and it appears as if all of the MySQL databases have disappeared within the past hour. MySQL starts up without any issues, however when running show ...
14
votes
2answers
22k views

Third-party SSD solutions in ProLiant Gen8 servers

I was wondering if anyone had any specific experience using Intel DC3700 SSDs (or similar) in the HP (DL380p) Gen8 servers? I'm upgrading a set of database servers that use direct-attached storage. ...
0
votes
0answers
4 views

How do I resynchronize a Bacula catalog?

I tried performing a Bacula upgrade, but found there were issues with our architecture. Our team tried powering through the upgrade testing backups, but eventually decided to do a downgrade and ...
19
votes
3answers
28k views

Export and import a PostgreSQL database with a different name?

Is there a way to export a PostgreSQL database and later import it with another name? I'm using PostgreSQL with Rails and I often export the data from production, where the database is called ...
4
votes
5answers
1k views

mysqldump for sql server [closed]

I have used mysqldump on a mysql database lots of times and am familiar with how it works. Does anyone know if there is a similar tool that could be used on a sql server database. I know sql server ...
0
votes
3answers
623 views

Postgresql: restoring database from dump fails

I am using psql (9.3.9) on Ubuntu 14.04. I created dump of a database using command: pg_dump db1 > db1.backup I deleted the db and recreated it. Trying to restore it with psql -d db1 -f ...
9
votes
5answers
7k views

Modifying columns of very large mysql tables with little or no downtime

I periodically need to make changes to tables in mysql 5.1, mostly adding columns. Very simple with the alter table command. But my tables have up to 40 million rows now and they are growing fast... ...
7
votes
4answers
40k views

How to duplicate MSSQL database on the same or another server?

It is perhaps a bit stupid question, but I must admit I have very limited experience with MSSQL and yet has to accomplish this: Take a snapshot of the database and create and exact duplicate on ...
1
vote
1answer
52 views

What is the best practice for deploying dev database to live system?

My developers in a project want to have the dev db on dev server synced with live db on live servers, which I think is a bad idea. Despite that, what is the best way to deploy a codebase+db to live? ...
0
votes
1answer
35 views

VSFTPD setup on Centos new virtual user cant connect

I have a vsftpd server configured on centos. Old users that are listed in logins.txt can login via wb browser. Problem is that when I create a new user I can't login 530 bad login error. Steps taken ...
0
votes
0answers
12 views

Merge and transactional SQL replication…database empty (SQL 2005)

Firstly, let me just say that I'm a novice at SQL in general and this might be an easy fix for someone reading, but I've been unable to find anything that would explain or help my issue online. If ...
-1
votes
4answers
123 views

How to mysqldump last 10 rows for EVERY TABLE in a database?

I have seen a lot of articles about "how to mysqldump last 'n' rows from a table in a database". For example: mysqldump --user=superman --password=batman --host=gothamcity.rds.com --where="1=1 ...