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

0
votes
4answers
795 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 ...
1
vote
2answers
657 views

Install MariaDB without password prompt in Ubuntu

I need to install MariaDB server in Ubuntu without password prompt. For this purpose, I execute the following commands, but it doesn't gave me any progress. It again shows password prompt. I used the ...
3
votes
1answer
52 views

MySQL runs out of memory when importing innodb database

I have a small VPS with 512MB RAM and no swap (can't have any). I am importing a 1.5GB innodb database with mysql -u -p < database.sql Before the operation can finish it says : Lost connection ...
1
vote
1answer
127 views

pgpool replication not allowing md5 authentication

I have installed both pgpool and postgresql via apt. In pgpool.conf, I have made the changes necessary to use replication mode, as well as my two postgresql databases (currently all running on the ...
1
vote
1answer
103 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
1answer
39 views

Large RAM use after import database - ubuntu server

My new vps has 4 GB of RAM. Before importing database system use about 1,2 GB of RAM. When I import database, about 250 MB sql file, 25000 tables use of RAM goes to 97%. Htop showing 3302 mb in cache. ...
0
votes
1answer
26 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 ...
0
votes
1answer
1k views

Installing and configuring postgresql 9.3 on ubuntu 13.10 using puppet

I'm having some trouble getting postgresql[1] to install with puppet[2] on a blank ubuntu box. I need to install postgresql 9.3 on Ubuntu 13.10. Since postgresql 9.3 is apparently not in the official ...
1
vote
0answers
26 views

how do I debug postgresql 9.1 server terminating

my /var/log/postgresql/postgresql-9.1-main.log shows 2014-03-25 10:39:30 CET HINT: In a moment you should be able to reconnect to the database and repeat your command. 2014-03-25 10:39:30 CET LOG: ...
1
vote
0answers
22 views

Pg_restore table size differences

What would account for the difference in table sizes between one PostgreSQL database and another restored from its dump file? On an Ubuntu 12.04 host, I'm running PostgreSQL 9.1, and I dumped my ...
1
vote
0answers
81 views

MySQL replication backup

How to take MySQL Master-Master and Master-Slave replication backup?. I have setup Master-Master replication with a separate slave for each master on Ubuntu. What happens if, I issue or schedule ...
1
vote
0answers
779 views

Why can I not start mysql server on ubuntu after change the innodb_flush_log_at_trx_commit value to be 2?

Why can I not start mysql server on ubuntu after change the innodb_flush_log_at_trx_commit value to be 2 ? updated to answer the 3 questions: mysql> show variables like 'version%'; ...
0
votes
0answers
29 views

Sync MySQL database to central server

What I am trying to accomplish, is to configure my laptop and server so that my laptop synchronizes an existing database with my server, so that the data can be used as an ODBC data source for other ...
0
votes
0answers
25 views

MySQL Server constantly crashes

my apologies for having already posted on this issue, but it has moved on so far I feel a new question is the only way to go. First a little history - I have a MySQL server which runs a few small ...
0
votes
0answers
21 views

Connecting mysql on server A/ to webapp on server B/

I am connecting mysql on server A/ to a webapp located on server B/. Both servers are Ubuntu servers. For security purposes, is there any way on server B to avoid showing the full path / IP address ...
0
votes
0answers
53 views

PostgreSQL problems on Ubuntu 12.04

I'm having terrible problems with PostgreSQL initialization on my VPS. I followed several tutorials on this topic and nothing made my database server work. I followed these steps: sudo apt-get ...
0
votes
0answers
54 views

MySQL overtaking system memory and forced to restart

I'm facing a frustrating issue. I have a MySQL Server 5.5 running on top of Ubuntu Server 12.04.3 LTS (VMWare guest w/ 16GB RAM - 8 Cores) mysqltuner.pl says [OK] Maximum possible memory usage: ...
0
votes
0answers
431 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 ...