Ubuntu is a desktop and server operating system based on Debian GNU/Linux. Note that http://askubuntu.com is specifically dedicated to Ubuntu questions.

learn more… | top users | synonyms

1
vote
3answers
684 views

How i can export just structure of mysql database

I use ubuntu 14.10 Phpmyadmin I have ''big'' mysql database, 900mb, I need just structure of this database, how i can export just database structure/empty database without remove data or download ...
0
votes
1answer
979 views

Error: /var/lib/postgresql/9.3/main is not accessible or does not exist

I have a PostgreSQL db that was running on my server. I tried to do a db_dump and got a weird error message. I eventually thought I would just restart PostgreSQL. However its now stopped and won't ...
0
votes
1answer
194 views

After upgrade from 9.1 to 9.3, commands still point to 9.1

Upgraded from 9.1 to 9.3 on my Ubuntu 12.04 server. Everything worked great but running commands like 'createdb' still runs them from the 9.1 path. /usr/lib/postgresql/9.1/bin/createdb: unrecognized ...
6
votes
2answers
7k views

Preventing PostgreSQL from starting on boot in Ubuntu

I am using PostgreSQL 9.2 and it runs automatically when I start the system (Kubuntu). How can I avoid this? I need to start it manually, and I don't want it to start unattended because I need to ...
4
votes
2answers
4k views

Redis takes up all the Memory and Crashes

A redis server v2.8.4 is running on a Ubuntu 14.04 VPS with 8 GB RAM and 16 GB swap space (on SSDs). However htop shows that redis alone is taking up 22.4 G of memory! redis-server eventually crashed ...
0
votes
0answers
70 views

MySQL performance_schema not working properly?

I have MySQL 5.6.19 community server running on my Ubuntu 14.04. Lately I have been trying to monitor MySQL server using performance_schema. Previously I used to do this by running SHOW FULL ...
1
vote
1answer
3k views

Authentification failure for PostgreSQL server (9.3)

I can currently not connect to my Postgresql server (9.3) from pgadmin (Running on Ubuntu 14.04). The server according to pg_lsclusters is on port 5433. Ver Cluster Port Status Owner Data ...
2
votes
1answer
613 views

Warnings while running AutoMysqlBackup

I am using Automysqlbackup.sh file to take MySql backups on Ubuntu.I have only 1 database. But when i run this script then it generates several Warnings (plus a error mail) like below Errors reported ...
0
votes
1answer
448 views

Upgrading MariaDB Galera cluster from 5.5 to 10.0 - rolling upgrade possible?

I've had a good search around and cannot find much on the topic. We want to upgrade our live MariaDB 5.5 Galera cluster to the MariaDB 10.0 branch, ideally without any downtime. We installed ...
5
votes
2answers
3k views

How to run specific version (8.4, 9.1) of postgresql pg_* command (e.g., pg_dump)

I have Postgresql versions 8.4 and 9.1 installed. For any given Postgresql command, how do I specify a specific version of the command to run? (e.g., psql, pg_dump, pg_ctlcluster, pg_restore, ...) ...
4
votes
1answer
9k views

Connection to an oracle db from another computer

I have installed Oracle 11g to an ubuntu, I can connect to DB using sqlplus from the localhost, But I cannot connect from another computer, I have configured my tnsnames.ora as followed; ELIF = ...
2
votes
5answers
7k views

MySQL gives me:“Can't open and lock privilege tables: Table 'host' is read only”

I am facing problem restoring a MySQL database. My primary database was MySQL 5.1 and now I am trying to copy it to MySQL 5.5. The database was backed up by using Xtrabackup. I am using Ubuntu ...
0
votes
0answers
660 views

TokuDB fails to load in MariaDB, even when transparent hugepages are disabled

Earlier, I upgraded my website server to Ubuntu 14.04 LTS. I had a very nice setup with MariaDB and the TokuDB engine. However, the setup was kind of messed up when TokuDB refused to load properly, ...
1
vote
1answer
315 views

Postgresql connection refused

I'm trying to remotely connect to my postgresql database. I have two virtual machines set up both running ubuntu 14.04. I am trying to connect to the second vm using the first vm using psql -h ...
0
votes
0answers
93 views

Pre requirements missing when installing oracle database 11g Ubuntu

I'm trying to install Oracle Database 11g on Ubuntu 14.04. At the middle of executing ./runInstaller I'm getting following message saying about missing prerequisites. This says make is missing but, ...
6
votes
2answers
6k views

How to Install/Configure Oracle Instant Client on Ubuntu

Installing the Oracle Instant Client on Ubuntu/Debian based systems is awkward since Oracle is RPM centric regarding its Linux support. What's the best way to easily install and configure the Instant ...
0
votes
1answer
4k views

oracle 11gR2 installation on ubuntu 14.04 LTS

I have installed oracle 11gR2 on ubuntu 14.04 LTS. On terminal I wrote following to start oracle: sudo service oracle-xe start on pressing enter, got following output : " Starting Oracle Net ...
0
votes
3answers
224 views

Large RAM use after import database - ubuntu server

My new VPS has 4GB of RAM. Before importing database system use about 1.2 GB of RAM. When I import into the database, using 250 MB SQL file, 25000 tables use of RAM goes to 97%, htop showing 3302 mb ...
0
votes
0answers
47 views

mysqldump replace option - ubuntu / mediawiki

I know this is probably a silly question, but I'd like to be sure, rather than make assumptions. There's the option to use 'replace' in a mysqldump, which uses the 'REPLACE' rather than the 'INSERT' ...
2
votes
3answers
3k views

Installing Oracle 11g on Ubuntu 11.10

Does anyone know to how to install Oracle 11g on Ubuntu 11.10?
2
votes
1answer
622 views

Problems installing Postgis extension on Ubuntu 14.04

I have Ubuntu 14.04 with Postgres 9.3 and I'm trying to install Postgis extension. One of the most recommended and straightforward ways I found is very simple: sudo apt-get install postgresql-contrib ...
1
vote
2answers
133 views

Trying to create PostGIS database

I am trying to create a spatially enabled PostGIS database by following the PostGIS documentation. In the short version, i executed, createdb yourdatabase createlang plpgsql yourdatabase But I did ...
0
votes
2answers
664 views

starting pgbouncer on startup

I installed pgbouncer and configured it and it starts only via using this command pgbouncer /etc/pgbouncer/pgbouncer.ini however using service pgbouncer start it dose not start. I then set up ...
1
vote
2answers
3k views

PostgreSQL cannot start after replacing contents inside its Data folder

When recovering the Postgresql database from a hacked Ubuntu 12.04 server, I copied the data directory to another location, reinstalled the OS and PostgreSQL, stopped PostgreSQL service, removed the ...
0
votes
2answers
8k views

How do I allow remote mysql access to all users?

I have setup a mysql server on unbuntu. The server hosts websites for my various clients. Hence, I want all of them(and any new clients) to have remote access to the mysql server. How do I configure ...
3
votes
1answer
171 views

Very large btree index with few rows (openstreetmap gis data)

I tried to import a subset of open street map data to a Postgres database using the standard tool (osm2pgsql). I then tried to rebuild the indices on the table using plain sql (dropping them, then ...
1
vote
1answer
3k views

How to completely remove EnterpriseDB Installation of Postgresql on Ubuntu?

All, I'm trying to install/run PostgreSQL 9.3, but am receiving a multitude of errors which seem to point to a failed installation of postgresql from the enterpriseDB package. For example, trying to ...
0
votes
2answers
2k views

Freeware GUI tool for DB2 , usable in Ubuntu Linux [closed]

Are there any freeware user interface tools for DB2 to be used in Linux (Ubuntu 11.04)? RazorSQL is pretty good, but it's not freeware.
0
votes
0answers
143 views

MySQL 5.5, Xubuntu 14.04 - INSERT and UPDATE bottleneck

DBAs: I have been developing and maintaining plugins for Moodle for the last ~2 years, and have recently decided to try using my local desktop again, rather than my institutions ESX VMs, as a ...
0
votes
1answer
3k views

Good configuration for 2gb (my.cnf) [duplicate]

I'm little newbie in configuring mysql and i seek a good configuration for mysql i have one site in ajax with many query and very slowly with VPS Iam in kimsufi 2gb i run only mysql in vps not apache ...
0
votes
0answers
35 views

Optimization mysql very slowly [duplicate]

Hello I have a server in kimsufi 2gb RAM and 500gb storage but the query with php mysql is very slowly I have change innodb buffer pool size to 500M but i have error too many connections, i add max ...
0
votes
0answers
63 views

Starting up postgres on Ubuntu for the first time

I've installed postgres on ubuntu, created a node and now I'm trying to start up that node as per the instructions: postgres --coordinator -D /usr/local/pgsql/data -p 1281 But I get the following ...
1
vote
1answer
294 views

Safely changing innodb_buffer_pool_size on MySQL replication master?

We have a MySQL server which is a replication master. We need to change the innodb_buffer_pool_size and innodb_flush_method to (hopefully) improve performance as the database has grown. What is the ...
0
votes
0answers
647 views

huge size of /var/lib/postgresql/9.3/main/base/1 directory (postgresql)

i'm using postgresql 9.3.4 and real size of database is about 5.5 GB but POSTGRESQL fill disk about 256 GB !! is this POSTGRESQL Cache and what is method to clean thing issue ?
0
votes
1answer
1k views

changed password for postgres login in pgAdmin, now can't connect to server

I was trying to use pg_dump to script out a database and in the process I used pgAdmin to change the password for the postgres user. I realize (now) that changing that password was a bad idea. But now ...
1
vote
2answers
1k views

Can't restore mysqldump database backup in Ubuntu 12.04

I'm trying to restore a database backup created using mysqldump. If I do: $ mysqldump -u ROOT -p DATABASE_NAME < DATABASE.SQL the database remains empty, even though I get some screen output ...
0
votes
0answers
125 views

listen_addresses set to '*' in postgresql.conf disappears every reboot of Ubuntu

I have set listen_addresses to '*' in /etc/postgresql/9.1/main/postgresql.conf and stopped/started Postgres 9.1 with /etc/init.d/postgresql to "reload" configs. This works fine and I can access my ...
2
votes
1answer
185 views

Easiest way of shutting down a PostgreSQL server on Ubuntu

According to pg_lsclusters I have 2 servers running on Ubuntu 14.04: Ver Cluster Port Status Owner Data directory Log file 9.1 main 5432 online postgres ...
2
votes
0answers
2k views

Setting password for 9.3 PostgreSQL server

I currently have a 9.3 server running (on Ubuntu 14.04) with "trust" set as the authentification method in pg_hba.conf. How can I set the password again. In pgadmin the server currently doesn't allow ...
1
vote
1answer
121 views

Which version of linux OS has support for MongoDB installation?

I would like to learn how to install MongoDB in my Windows machine. Currently I have a Windows 8 64 bit OS laptop and I installed MongoDB 64 version for Windows. My question is: which version of ...
1
vote
1answer
146 views

Authenticating to Oracle REST data services as admin

i'm working on an android app connected to a database, the database has more data than any tablet can handle, so after some research i found many solutions, most of them consisted of implementing a ...
3
votes
1answer
523 views

MySQL queries are 10 to 100 times slower after OS reboot

I have a MySQL server running on Ubuntu. If I restart the MySQL, everything is fine. If I however restart the OS, my queries take anywhere from 10 times to 100 times as long. The only "solution" to ...
0
votes
2answers
2k views

Difficulty with Postgis extension on Ubuntu 14.04

I have a updated Ubuntu 14.04 running postgresql 9.3 (installed using the tutorial from https://wiki.postgresql.org/wiki/Apt). When I access my database through pgadmin and go to the console and ...
0
votes
1answer
1k views

How to resolve “Error log file size is increasing in mysql 5.5” issue w/o restarting mysql

I have an Ubuntu server with MySQL 5.5 installed. In /var/lib/mysql a .err file is kept on updating with these warnings only: [Warning] IP address '234.22.11.221' could not be resolved: Temporary ...
0
votes
3answers
4k views

How do I install postgresql in Ubuntu?

I'm following these instructions, however I can only get to step 17.2. Despite installing postgresql successfully via the sudo apt-get install postgresql command, upon running initdb -D ...
1
vote
4answers
2k views

PostgreSQL 9.3 on Ubuntu Server 12.04 v.s. MS SQL Server 2008 R2 on Windows 7 Ultima

I have searched many articles in Google about the performance of PostgreSQL vs MS SQL 2008 R2 and found that many of those articles say the performance of PostgreSQL is better than that of MSSQL 2008 ...
-2
votes
1answer
136 views

MySQL ran out of space, now won't start

So the partition MySQL was mounted on ran out of space. As a quick fix, I decided to move mysql's data directory to /home/minecraft/mysql/. I then changed the datadir in the config to the correcy ...
1
vote
2answers
332 views

Install MySQL on Ubuntu 12.0.4

This is my first time using Linux. I am trying to install MySQL 5.6.15 on an Ubuntu box. I download MySQL from their website and put it on a USB stick then plugged the stick into the box. How can I ...
9
votes
3answers
5k views

Upstart script in ubuntu for mongodb

I am new to linux and mongodb. I've already installed mongodb on ubuntu but I want to run one more instance on different port. As I understood from other questions and forums , there must be upstart ...
1
vote
1answer
1k views

Do I need to set tcpip_socket = true to allow remote connections to a postgresql database?

I am trying to enable remote connections to my postgresql 9.1 db running on ubuntu 12.04. This tutorial says to "set tcpip_socket to true" -- but it is for a centos server. I am on ubuntu. I ...