System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

0
votes
1answer
77 views

How to securely store sensitive data on a shared-hosting provider while accessible to server-side scripts?

I want to store some sensitive data on my hosting provider which is a shared-hosting, lets say for example on MySQL, and i want it to be accessible to the website(server-side languages like PHP) ...
2
votes
4answers
636 views

How can i create in incremental backups of mysql databases

I have linux centos 6.4 server with mysql5.6 I have the cron job for making hourly mysql database backups like this Its in python os.popen("mysqldump -u %s --password=%s -h %s -e --opt ...
0
votes
0answers
48 views

Dismounted Exchange Database - It's disappeared

I dismounted a database to try and fix the backup. It's not in the list of databases anymore, and I can't figure out how to mount it again. Googling does not help. Does anyone have any suggestions? ...
21
votes
1answer
257 views

Is it possible that just one bit switches so my file shows me a letter “Q” instead of a “S”

In our application we use Hibernate and PostgreSQL to store data. In one of our database tables we have a discriminator column which says for example "TIPPSPIEL". It is a fixed string and can not be ...
-1
votes
1answer
53 views

Server A cant connect to Severs B's mysql database [closed]

I have two servers both running mysql on Ubuntu 12.04. I have an application on Server A which has to connect to Server B's database. I have opened the my.conf file on server B and make the ...
0
votes
3answers
63 views

Connecting mySQL to MSSQL

I need a little advise, I need to sync a DB that is currently on a Server 2008(SQL Server 2005) machine and I use Studio Express to connect to it. I need a way of syncing this DB to mysql that lives ...
0
votes
0answers
323 views

Postgresql running slow

We recently migrated our postgresql server from a heroku 400mb ram add-on to a SSD VPS with 1GB of ram and we have seen a huge performance drop. I am using ubuntu 12.06 and have increased the ...
0
votes
2answers
46 views

Should my database server offer SSL?

I was installing a renewed SSL cert on my web servers and noticed that my DB server doesn't have one set up, which got me wondering: Should my database server only accept connections via SSL? The ...
-1
votes
2answers
517 views

Debating our network structure (DMZ, database, service)

We're trying to decide where we should locate different servers. Should we put them in the DMZ? In our trusted network zone? And so on... Lots have been written on this topic, but there seems to be ...
0
votes
2answers
148 views

MySQL server on openstack

I want to set up a MySQL database that is easy to scale. Traditional, off-cloud scaling means (1) upgrading the hardware, (2) sharding, or (3) replicating. Option 1 is easy but is limited. Option 2 ...
-1
votes
1answer
135 views

Setup Postfix and Dovecot with mysql but can't receive mail for users defined in database

I setup Postfix and Dovecot with mysql but can't receive mail for users defined in database. Actually I can login to webmail and even send mail. Remote host said: 550 5.1.1 ...
-1
votes
2answers
1k views

How to regain access to myql server and dump database?

We retake the management of our server and now we need to make some reverse engineering. We gave to an external company the development of our new Website and they need a dump of database from old ...
0
votes
1answer
468 views

Understanding postgreSQL's indent, md5, password in pg_hba.conf

If I have the following in my pg_hba.conf # TYPE DATABASE USER CIDR-ADDRESS METHOD local all all trust local all all ...
2
votes
3answers
212 views

Is it a bad idea to give our COO a copy of the production db?

We're a small company with only a handful of employees. Our non-technical COO has asked that we setup a copy of the production database for him to use with a service like Chartio, because our ...
2
votes
1answer
104 views

What does -fixcolnames do in log parser 2.2?

I'm using Logparser 2.2 to try to bring a .csv filled with Performance Counter information into a SQL database, and I'm using the following command line command: logparser "Select * into IISCounters ...
1
vote
2answers
554 views

Using Puppet to install, initdb and start Postgres database

We are trying to write a Puppet to provision the Virtual Machine. One of the tasks is to install and populate Postgres database with data. We can decompose this task into a few smaller tasks: ...
0
votes
1answer
71 views

How to arrange a replication in mysql?

Here is my problem. I have a busy Drupal site struggling under high load. After applying all caches I see that, no surprisingly, database is the bottleneck. I have two servers to handle the site: A ...
0
votes
1answer
25 views

How do you deny a user access to a certain collection in mongo?

I have several collections that I would not like certain users to see. How would I go about "hiding" them or blocking a user from viewing?
-1
votes
2answers
754 views

Postgresql pgdump script on RHEL5: “failed: fe_sendauth: no password supplieddatabase ”

What I'm trying to accomplish is having a pg_dump script run as a cron job. Right now I'm just trying to get the script to run by invoking it myself at the command line. I've searched the postgresql ...
1
vote
1answer
107 views

Oracle SQLConnect: 1033 via UnixODBC

Here is the full error: PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[08004] SQLConnect: 1033 [unixODBC][Oracle][ODBC][Ora]ORA-01033: ORACLE initialization or shutdown in ...
1
vote
0answers
22 views

My transactional overnight batch has spiked in duration

I have an overnight batch run which is transactional...picking up data doing some small calculations and putting it somewhere else and it was finishing around 3am every day for the last 2 months. Now ...
-1
votes
1answer
38 views

InnoDB Failure of some kind [closed]

I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked. InnoDB is listed under SHOW ENGINES; Any idea ...
-1
votes
1answer
2k views

mysqld 5.6 service error 1067

Upon running this service "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56 I get this error windows could not start ...
0
votes
1answer
2k 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
2k 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 ...
0
votes
3answers
771 views

Can't start MYSQL after changing directories

So I started running out of space on my linux hard disk. I added another hard drive and now I want to change the MySQL directories. So instead of saving the data into the old hard drive, it saves it ...
0
votes
1answer
47 views

Database replication with old data

I am using MySQL to accomplish Database replication. The replication process is works very well. What my problem is, the old record is not copied from the master database. Is there is any way to keep ...
0
votes
2answers
231 views

OpenLDAP: How to hide config directory from tools like JXplorer, etc

I'm trying to set up an OpenLDAP server for test and demonstration purposes - my team need to be add LDAP connectivity to our product, so we want to have an LDAP server we can authenticate against. ...
0
votes
1answer
52 views

Setting up a transparent proxy for a database

Currently my setup is as follows :- Database client/library <---------------------> Database I'd like to have the following :- Database client/library <---> Proxy <-------------> Database ...
1
vote
1answer
45 views

IBM Tivoli Reclaim vs Update

What is the difference between TSM reclaim vs update? I have accidentally run the reclaim command on my offsite pool? Is it fine to run the reclaim command on offsite pool or is there a bad impact by ...
-1
votes
1answer
47 views

Improving Database Performance [closed]

I've heard that you can do something like the following in my.cnf to get better performance: tmpdir = /dev/shm I'm running MariaDB and wondering is this a good idea? All it does it create the ...
4
votes
1answer
4k views

Maintenance of tables: do I need to REINDEX a table after truncating and repopulating?

I have a table with about 2 million rows in it of transactional data that we use for analytics. Every week we reload this with new data, so we've been using TRUNCATE to clear it out and then inserting ...
0
votes
1answer
113 views

Solutions for a growing Postgresql database on Amazon EC2?

I've been doing a lot of research into scaling issues on Amazon EC2, especially growing databases. I looked into how I can make the database more solid and sound (I use PostgreSQL). Many sources say ...
0
votes
1answer
52 views

Stable version of Mysql [closed]

I am plan to do some real application, here i finalized to use mysql as a backend. And my question is Currently which MySQL version is stable. Also want the major pitfalls for MySQL 5.5 if MySQL 5.6 ...
1
vote
0answers
263 views

Neo4j Web Server Hangs: Logging Issue?

I have a small database that was working fine just a day ago, but now, when I try to start it, the console claims that it succeeds in opening, but the web server hangs. lsof -i | grep 7474 states ...
2
votes
2answers
141 views

Serve large number of small images in ext4

I read through some similar question, but still have some confuse about my situation. My website allow user upload huge number of large images (scan pages of book). My server will auto tiling and ...
-1
votes
2answers
313 views

How can I synchronous two databases

I have two databases. First one is local and the other is at Internet, in my domain. I want to synchronous two databases. Is it possible to do so ? How can I synchronous two databases ? Some detailed ...
0
votes
1answer
35 views

Install mysql 5.5 without remove old version

I am using CentOS 5.7 (64-bit). By default mysql 5.0.88 version is installed in my machine. Now i wants to install mysql 5.5, without remove mysql 5.0.88. I didn't get any clear document to install a ...
0
votes
1answer
1k views

cpanel account transfers failing: ERROR: Failed to dump one or more databases [closed]

Getting this error when transferring multiple accounts via whm transfer utility: ERROR: Failed to dump one or more databases I was told this by a cpanel tech Here is the specific error I'm seeing ...
0
votes
1answer
2k 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
3k views

Why can't I connect to my PostgreSQL database?

I'm trying to install tentd-admin. The install fails during this step: $ DATABASE_URL=postgres://localhost/tent_server bundle exec rake db:migrate I also tried this: $ ...
0
votes
0answers
43 views

Need some information about using SQL-Express 2012 with an OLD databse software

I have a friend who has managed to go for many years running their company on an old piece of software that is no longer supported. The original software vendor is no longer in business and the one ...
0
votes
2answers
179 views

Postgresql performance enhancement

I have my setup like this: Two separate instances of the database on a clustered environment. Both instances are on dedicated servers each carries up to the standard configurations. Instance one ...
3
votes
2answers
4k 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 ...
-4
votes
1answer
37 views

how to connect my server to internet [closed]

We have a project which very resource consuming in databse part and we found that database hosting which is satisfied our needs is lot money consuming. We want to built own server and connect our ...
0
votes
1answer
2k views

Reducing memory usage of MySQL

Conclusion: if you really want to use little memory out-of-the-box drop MySQL and use PostgreSQL: it has a ~30Mo memory footprint, i.e. more than 10x less than MySQL; the migration was quite easy be ...
0
votes
2answers
556 views

MariaDB set maximum database size to 1 GB

I'm using MariaDB on my hosting. I would like to limit database size to 1 GB. How to do this properly in /etc/my.cnf ?
1
vote
2answers
2k views

How to install Sphinx on CentOS 6 where the DB and App server are separate servers

First what is the best way to install Sphinx on a centOs server rpm -ivh http://sphinxsearch.com/downloads/accept.php?file=sphinx-2.0.6-1.rhel6.x86_64.rpm yum install sphinx didn't seem to work. ...
3
votes
2answers
5k views

1286 - Unknown storage engine 'InnoDB'

I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a ...
0
votes
0answers
25 views

Storing and accessing common non-sql database live from the cloud?

Let's say the database is non-sql, something completely archaic like paradox or whatever. I have no power over it as I'm not the developer. However, I would really like to have the database live on a ...