0
votes
1answer
200 views

Ubuntu 10.04 server delay when POST to mySQL

I have a Ubuntu 10.04 Server and for some reason it always seems to exhibit an intermittent delay whenever performing CRUD operations on the mySQL database. Most Post commands are executed within a ...
1
vote
1answer
106 views

Recent Ubuntu update prevents MySQL root access

I recently updated my Ubuntu (10.04 LTS) server (apt-get update, apt-get upgrade), and everything works fine, apart from the root access to my MySQL database. phpMyAdmin, CakePHP, and essentially all ...
0
votes
1answer
1k views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

My mysql installation was screwed up. I uninstalled and installed it multiple times. But I kept getting a hang or a error "cant connect". I now finally have it running with sudo -u mysql mysqld. How ...
0
votes
2answers
3k views

MySQL version to be used on Ubuntu 10.04

I've a production server and a test server both having Ubuntu 10.04.4 LTS When I installed MySQL on test server, I just run apt-get install mysql-server and 5.1.62-0ubuntu0.10.04.1 got installed ...
1
vote
1answer
451 views

Upgrade MySQL to 5.5 on Lucid, upgrade server to Precise or switch to Percona?

Looking into upgrading mysql on our development server to which is running 10.04 so is stuck at MySQL 5.1, as it appears there is no apt-get support for upgrading to 5.5 except by certain 3rd party ...
3
votes
1answer
585 views

Run mysql queries in ubuntu 10.04 shell (cmd) stored in a files (desc order by filename)

I have a folder with about 40 SQL scripts with varying names, All using the pattern number description.sql. The file number consist of 2 digits and goes from 01 to 40, not all numbers in this range ...
2
votes
4answers
2k views

After upgrading to 12.04 from 10.04, can't login to PHPMYADMIN

I just can't login to PhpMyAdmin anymore, it says bad logins. PHP works perfectly. Please help. Thank you. 2002 Cannot log in to the MySQL server Language Log in Username: Password: Connection for ...
2
votes
3answers
298 views

How to disable mysqld in 10.04?

I have a few (Linode) Ubuntu 10.04 (64bit) VPSes, and mysqld keeps starting on every reboot on all of them -- $ uptime 16:32:26 up 1 min, 1 user, load average: 0.09, 0.08, 0.07 $ ps -ef | grep -i ...
1
vote
1answer
104 views

How to upgrade MySQL to >=5.1.51 on Lucid via aptitude

The mysql-server package in Lucid is listed as 5.1.41-3ubuntu12.7. Is there a safe way to upgrade to the latest 5.1 release via aptitude?
6
votes
1answer
13k views

How do I enable the mod_rewrite Apache module for Ubuntu 11.04?

In other linux like CentOS, it works but i am not getting it running in Ubuntu 11.04. /var/www/html/folder/public/.htaccess: Invalid command 'RewriteEngine', perhaps misspelled or defined by a module ...
2
votes
1answer
183 views

Is there a solid howto for replacing MySQL with Maria in the LAMP stack?

I've heard great feedback on a few folks migrating production machines (including from this question), and I'd like to test the transition in our dev environment. Maria is apparently in the 11.10 ...
4
votes
1answer
6k views

How do I enable my innodb

I need to enable innodb on my ubuntu server 10.04 and having tons of problems, I have tried posting questions everywhere and I have no answers....i tried this show variables like "%innodb%"; ...
1
vote
1answer
4k views

How restore /var/lib/mysql after i delete it?

How restore /var/lib/mysql (UBUNTU 10.04) after i delete it? History: delete /var/lib/mysql folder paste new /var/lib/mysql folder with wrong files delete again /var/lib/mysql folder clean + ...
1
vote
1answer
293 views

Remote connection problem

Hello I have ubuntu 10.04 installed with mysql on it and I have a problem with remote connection. When I connect through putty it works but sometimes it looks like it hangs for example when I ...
4
votes
1answer
2k views

Install old version of mysql in 10.10

I'm using Ubuntu 10.10, but I find that this project is having issues with the version of mysql server that 10.10 installs. I have another machine running the same build of this project but it's ...
3
votes
4answers
569 views

MySQL Data Modeling on netbook

Possible Duplicate: ER diagram software Looking for a MySQL data modeling toll, that will actually fit on my netbook screen. The official Workbench needs a higher resolution, so the bottom ...