0
votes
1answer
41 views

Different technologies for syncing with server

Well, I'm currently teaching DB in a course in University. Students had already gone through advanced programming (this includes torturing them through a whole semester with massive projects, they ...
1
vote
0answers
58 views

Unexplained excessive database response times - very powerful hardware, tiny database

I've a strange problem that's repeatedly troubled me across 3 different servers now. The problem Please see the graph from NewRelic showing the huge amount of time spent in the database. The ...
0
votes
2answers
68 views

Alternative to FTP

I'm now teaching data bases and all my students get access to a virtual machine running ubuntu. They use FTP as the main way of connecting to the server and uploading their PHP files. Last time I was ...
0
votes
1answer
56 views

Cannot open './/ib_buffer_pool' for reading: No such file or directory

I've realised that my Percona DB which has several InnoDB tables doesn't actually have InnoDB buffer pool running as it wasn't specified in the my.cnf. I had a buffer pool size specified of 256MB, ...
0
votes
1answer
64 views

How can I change the Postgres data_directory folder location?

I use Ubuntu 12.04, postgresql 9,1 postgis 1.5. I want to change database location. I use instruction http://www.whiteboardcoder.com/2012/04/change-postgres-datadirectory-folder.html The only ...
0
votes
1answer
93 views

Securing database server with IPTables

I have my app (WordPress) and database (MySQL) on separate servers; they are connected on a private network provided by the hosting service provider, and I've taken all the preliminary steps (that I ...
-1
votes
1answer
50 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
1answer
232 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 ...
0
votes
1answer
1k 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
2answers
764 views

How do I get my ubuntu server to listen for database connections?

I am having a problems connecting to my database outside of phpmyadmin. Im pretty sure this is because my server isn't listening on port 3306. When I type: sudo netstat -ntlp on my OTHER working ...
0
votes
0answers
104 views

Mysql database on ubuntu server not accepting connections

I am having problems with my database. The only way I can connect to it is via phpmyadmin. I try to use the same username and password to connect to the database in 'SQL PRO' and I get the following ...
0
votes
2answers
2k 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 ...
1
vote
1answer
354 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
106 views

ft_stopword_file not picked up

I have a VPS server with a company called Webfusion. I want to remove some or all of the FULLTEXT stopwords because some specific words needs to be searchable with my DB content. I opened ...
3
votes
1answer
790 views

Is it possible to recover MongoDB databases from .ns and .0, .1, . … files?

I have a MongoDB 2.0.4 installation on Ubuntu 12.10. Recently I had some problems connecting to the database from the outside, and figured out there was something which prevented MongoDB from starting ...
1
vote
1answer
117 views

Postgresql init.d script not working

I installed Postgresql 8.4 on my VPS with Ubuntu 10.04. Default setup, nothing unusual. After the installation the dbserver is automatically started and is running great. The installer also sets a ...
1
vote
1answer
70 views

Backup websites with database in ubuntu server

I am having one ubuntu local server in which we used to have all our development websites. They all are php based sites. I would like to know whether we can have script or something to cron backup the ...
1
vote
0answers
483 views

mysql fails to start

My Django web app was working fine, writing data to a mysql database. However, sometime in the past 36 hours or so, it stopped working. I typed "mysql" into the command line (i'm using ubuntu on ...
1
vote
2answers
336 views

What is the standard system architecture for MongoDB

I know this question is too vague, so I would like to add some key numbers to give insights about what the scenario is Each Document size - 360KB Total Documents - 1.5 million Document created/day ...
0
votes
2answers
714 views

Error while connecting to sql database

I am trying to access a sql database remotely. The database and the server are on two different ips. i have tried commenting out bind-address line and all the other things people have suggested in ...
1
vote
1answer
110 views

my.cnf in server directory, why

On my Ubuntu machine, I have installed MySQL . I notice that there are /etc/my.cnf file which contain the content (only two lines): innodb_buffer_pool_size = 1G max_allowed_packet = 512M While ...
-1
votes
1answer
67 views

/data/tmp on database server? [closed]

I am on a Linux ubuntu machine with MySQL installed. My teacher gave out an assignment which mentioned "copy cars.dat to /data/tmp on the MySQL database server" without any explanations, I do not ...
0
votes
3answers
1k views

“chown mysql:mysql /data/tmp” command

I am on a Linux ubuntu machine with MySQL installed. If there is a MySQL installation on a Ubuntu machine, I saw some people doing the following thing: sudo chown mysql:mysql /data/tmp I get ...
1
vote
1answer
324 views

Allow Remote Connections to MySql Database

I have looked at this Post and it details how you can allow a connection from a remote host to the database. But the line that took me off guard was this: mysql> GRANT ALL PRIVILEGES ON *.* TO ...
3
votes
2answers
1k views

Transfer database data from xampp on Windows to Ubuntu [closed]

Which is the fastest way to transfer mysql databases from xampp on Windows to a MySql server on Ubuntu?
3
votes
1answer
2k views

Postgresql table drop taking very long time

I am kind of new to Postgresql and server administration so I am not quite sure if this is normal behavior or not. Right now I am trying to drop a table with the cascade option. The command I used ...
1
vote
4answers
647 views

2 instances of LDAP on same server

I need to run 2 LDAP instances on the same ubuntu server which have the same structure (both writing to ou=People,dc=example,dc=org for instance) but have data which should remain separate. The 2 LDAP ...
2
votes
1answer
187 views

Restoring MySQL user accounts, databases and configuration from backed up /var/lib/mysql directory

Last night, I backed up my Ubuntu 10.10 box using the sbackup utility. The process ran with the default options, which backed up the /etc /home /usr /var directories to a separate partition on my ...
0
votes
2answers
1k views

Confusing MySQL error/warning/info message

I am having trouble administering my MySQL. I tried to stop it like this: /etc/init.d/mysql stop and I got this message: Rather than invoking init scripts through /etc/init.d, use the service(8) ...
0
votes
2answers
306 views

What Could Be Causing MySQL To Crash On A Read Query?

So I have a pretty large MySQL DB... 7 Gigs in Total size, 35 million URLs. I was querying it (using SELECT queries only) quite fast the other day. My ubuntu froze/shutdown (that's a first!) and said ...
0
votes
2answers
599 views

How to do MySQL Maintenance especially after disk is full

I have a quite large mysql database (InnoDB) running on ubuntu server virtual machine. Recently due to my fault the hard drive became full (on the physical machine) and the server got stuck and users ...
0
votes
1answer
514 views

Set up Glassfish connection pool to talk to a database on a Ubuntu VPS

On my Ubuntu VPS, i have a mysql server running and a Glassfish 3.0.1 Application Server running. And I am having a hard to have my GF successfully ping the database. Here is my GF set up Assume: ...
0
votes
1answer
1k views

How to install Percona Server on Ubuntu 9.10 Karmic?

I followed the instructions on this page: ~$ gpg --keyserver hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A gpg: requesting key CD2EFD2A from hkp server keys.gnupg.net gpg: key CD2EFD2A: public ...
0
votes
1answer
446 views

MySQL problem: “Incorrect key file for table …”

I'm trying to migrate a mysql server to new hardware. The old server runs mysql 4.1.12 on RHEL 4; the new server is mysql 5.1.41 on Ubuntu 10.04. I've been having some strange issues trying to ...
3
votes
2answers
238 views

10 Million records = wiped MySQL DB?

So I was trying to load some test data and it appears to have killed my entire database. This is one case where it's great to have backups! They were all plain insert queries, probably about a 900 MB ...
2
votes
3answers
5k views

Postgres 8.3 and 8.4 in Ubuntu 9.10

After upgrading to Ubuntu 9.10 I've got 2 istances of Postgres DB on my system: a running 8.4 on port 5433 and the original 8.3 from old distribution stopped on port 5432. I tryed to change ...