System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
1answer
37 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
1answer
30 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
45 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
16 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
66 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 databases;...
0
votes
0answers
8 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 ...
1
vote
1answer
79 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
86 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
21 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
vote
1answer
37 views

Our app lags “randomly” due to Disk I/O issues?

We have made an app that requires hundreds of images downloaded for each user every day. Our basic server setup is as follows: Loadbalancer -> Nginx -> Databaseserver However, our app "randomly" ...
-1
votes
4answers
218 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 ...
0
votes
1answer
523 views

DBD: Can't load driver file apr_dbd_mysql.so

I am using Apache 2 on a virtual machine running a LAMP stack (mysql version 5.6). When I try to restart the server I am getting this error; DBD: Can't load driver file apr_dbd_mysql.so I have made ...
1
vote
1answer
40 views

Postgresql calculate kernel share memory?

We are running PGSQL 9.2 and following are hardware specs OS: CentOS7 64bit CPU: 24 Memory: 32GB Disk: SSD I want to calculate shmmax/shmall values then what would be the good way? I google it and ...
1
vote
0answers
11 views

Sql Partitionning a table time by time [closed]

I try to do a partioning into a SQL table with Microsoft SQL Server Management Studio. I want to do this partition all night at 23h. For example i put all lines with a 0(on the column) on my ...
-3
votes
1answer
104 views

Can't login into phpmyadmin but password is correct

I'm trying to login into my phpmyadmin but it keeps redirecting me back to the login page. My username password should still be correct becuase my website is still functioning and I can even login to ...
1
vote
2answers
58 views

Using NAS Server as a Database Server, a good option?

Introdution: I have six dedicaded servers with localhost dababases, additional I have rented a NAS server (NFS HA Hybrid) mounted in each dedicaded server under /mnt directory, I want to use this as a ...
0
votes
2answers
700 views

Can't load driver file apr_dbd_mysql.so when restarting Apache

I have an Apache 2.2 version running on a Centos 7.1 machine running a LAMP stack (MySql version 5.6). Apache has been configured to enable the DBD modules, and running a DUMP_MODULES using httpd ...
0
votes
1answer
43 views

Lock a specific mysql database in shared mysql database

I am trying to migrate a database from one cluster to another cluster. In order to avoid any data loss during the migration, I am trying to lock my database with the WRITE operations. But the lock ...
0
votes
0answers
26 views

DNS: check client IP in database, reply different if ip exists in a DB

I'm trying to setup a DNS server that looks for the client IP in a DB, and returns a static IP as result if the client is in fact in the DB. There might be thousands or a couple million of records ...
2
votes
1answer
80 views

Thought about using my server hardware effectively

I will receive my new server hardware in some days, and of course I am already planning on how to use it the most effective way. My current thoughts are about scaling the web and database server on a ...
-1
votes
1answer
34 views

Distributed (serverless) Database System [closed]

I've currently a setup where 10 database clients access one (Postgres)-SQL server on the same network. The applications have a very low db footprint. They do load a few tables upon startup and do ...
2
votes
1answer
61 views

Empty space in MySql database

Forgive me if I'm not using the appropriate vocabulary. I'm planning on implementing a MySQL database with a PHP front end so I can enter work order details and files (screengrabs, ZIPs, etc.) into ...
1
vote
0answers
42 views

Sybase heavy Disk I/O issue

I have a Sybase 15 server that is constantly reading from the hard disk. I noticed that the sqlsrvr.exe is the culprit which is the main database engine. This is a pretty utilized server that is ...
-2
votes
1answer
40 views

Share the database with another person in same network [closed]

I am a newbie to the database topic. I need to create a database and share the database to another person in my office so the other person can also create/delete tables in the same database. I created ...
1
vote
1answer
43 views

ZFS Backup vs. ZFS Data Folders for Services [closed]

So I recently set up my own little server here at home. I got my main system set up on an SSD and a ZFS pool of larger HDDs for data storage. Now the question I was asking myself was if for services ...
0
votes
0answers
12 views

Oracle 9i - Data Guard - how to completely resync existing stanby?

Thank's to another SF user, I've managed to recover the control file needed to start a target data guard database in standby mode. So I have an active primary running in ALM keeping only the last 14 ...
0
votes
1answer
19 views

Oracle 9i - Data guard target DB - lost control files, can I recreate from primary database?

I'm dealing with a problem whereby a I have a database that is managed using data guard using Redo Apply, so redo logs are copied to the target database, applied and kept in sync ready for fail over. ...
0
votes
2answers
669 views

Importing database in LDAP creates error

I have exported my database using the following function slapcat > ldif While I am importing database in other LDAP server it creates error. I am using the following function slapadd -l ldif. ...
1
vote
2answers
230 views

Sharing SSH port tunnel with local network

I've successfully created a SSH tunnel to our cloud postgresql server on a local linux server, with this command: ssh -N -f -L 5431:localhost:xxxx mycloudserver.com (where xxxx is remote port) ...
0
votes
0answers
102 views

sql-php-sqlyog: Access denied for user .. unable to connect to database

I browsed around all other answers provided for this same issue. But didnt find a solution. So I thought to ask mine here. I am not very good with sql. But this is the first time I am facing this ...
1
vote
1answer
57 views

MongoDB on RHEL vs. Ubuntu [closed]

I'm looking to install MongoDB on an Amazon EC2 instance, to me AMI doesn't matter much... but maybe it should. While searching online for how-to's, I've only found thorough guides for installing ...
0
votes
1answer
14 views

Remote data service: speed concern

I would like to provide an online service that consists of the following: A proprietary database Queries to the database that not only ask for data, but more importantly sophisticated calculations ...
1
vote
0answers
60 views

Securing communication over LAN in VPS provider

I'm curious about best practice when connecting from app to DB in a cloud provider. A quick rundown of our setup. We have 4 servers all on the same provider, in the same region running as VPS. ...
0
votes
1answer
38 views

PostgreSQL : Strange Sudden Data type AND select schema issue

Here is my problem : Actually I am using postgresql 9.4 and postGIS extension. I am creating a database, and adding new tables with no problems... with geometry data types... until now... Now, I ...
0
votes
1answer
1k views

How to raise max no of file descriptors for daemons running on Debian Jessie?

I'm playing with pgBouncer as a connection pooling system for PostgreSQL. My system is a 12-core with 64GB RAM and 1Gbps network interface running Debian 8.1. Now I want to raise the limit for open ...
0
votes
1answer
105 views

Active directory authentication and authorization for an application

Currently all our applications are web based and our authentication and authorization mechanism is always through the database. eg database logins and access controls defined at database. However now ...
0
votes
1answer
30 views

Removing a mySQL database without password? [duplicate]

So about 6 months ago I set up a wheezy server and at the same time I installed MySQL even though I didn't need it. I've now updated to Jessie and need the database but can not remember the password ...
0
votes
0answers
80 views

Bridge server for connecting two databases?

I'm in a bit of a pickle. I currently have 2 database servers. One is hosted in the US and is online on the internet. The other is local, working only on LAN and external connections are not allowed. ...
0
votes
0answers
14 views

Conservative Azure Windows VM to Run SQL Server 2008 R2 [duplicate]

For testing purposes I need to set up three Azure Windows VMs to each run an instance of SQL Server 2008 R2 each holding one DB of approx 100GB. There will be quite a few complex stored procedures/...
0
votes
1answer
227 views

Slony PostgreSQL replication - Can I create an index on a table on a slave that isn't on the master?

I have just set up a slony replication set up between 2 postgres servers. One master, and one slave host. Data is being copied. We don't want to use this for data backup or anything, but want to do ...
0
votes
3answers
1k 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 /tmp/...
9
votes
3answers
2k views

Best practice for 24 Disk Array

we have just migrated for our old fibre SAN storage to an IBM v3700 storwize with 24 SAS 600GB disks. This storage is connected directly to two IBM ESXi 5.5 servers each with two 6Gbps multipath SAS ...
0
votes
2answers
503 views

Pros and cons of database choice for OwnCloud [closed]

OwnCloud provides 3 choices for its database: SQLite MariaDB PostgreSQL Obviously SQLite is not a practical choice, since it can rarely handle the load. What about the other two? Is MariaDB or ...
1
vote
4answers
112 views

reliably write database dump directly to remote filesystem (Linux)

I need to move a very large database (~320 GB) from server1 to server2 (Linux). Because of different extension versions, the database can only be restored on server2 from a dump file as described here....
0
votes
0answers
373 views

How can I access to a database on OpenShift?

I created an application on OpenShift, everything is working and there are no problems. I now need to attach the database that is on OpenShift with my desktop application developed in C #. The desktop ...
1
vote
1answer
277 views

Connecting to Oracle DB hosted on Windows 8.1 Azure VM

I have a windows 8.1 vm created on azure, it has 14 GB of memory and 200 some GB storage. I have installed Oracle with a templated database onto it. Everything is fine with the installation and I can ...
0
votes
0answers
23 views

SSD vs RAM - Optimal ratio for different data sets / databases [duplicate]

I am looking for an advice or even better some studies / benchmarks to read for different scenarios (data sets) when it comes to the best ratio between actual RAM and SSDs. I know that fitting the ...
0
votes
0answers
127 views

How to Restore from sql Maintenance plan backup

I have a SQl 2005 Instance in my PROD SQL server. I have been given a task to migrate databases inside that instance to different SQL box ( SQl 2008 r2 in Win 2008 r2 box) Database. Current sql ...
1
vote
1answer
3k 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 innodb-force-...
2
votes
2answers
179 views

Database backup encryption

I've been trying to work out an effective database backup encryption scheme lately. I have a Postgres 9.4 server, I have most of the backup scheme fleshed out I think. Backups will be stored in a ...