I'm trying to install MySQL 5.5 on Ubuntu 12.04, but I'm stuck with this error:
Setting up mysql-server-5.5 (5.5.24-0ubuntu0.12.04.1) ...
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.5 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent co
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.5 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.5; however:
Package mysql-server-5.5 is not configured yet.
dpkg: error processin
I have a huge mysql database , say about 15G size .
Now I want to move the database to another mysql server , the normal way to do this is to export mysql file then import this file to the target server . But I find it is so slow and error occured in this process .
Any better way to do this ? Please let me know . Thanks .
I'm on Windows 7 with MySQL Workbench 5.2.44 CE trying to connect to MySQL database at a remote Ubuntu 12.04.1 server using "Standard TCP/IP over SSH" feature of MySQL Workbench with a passphrased SSH key.
I have been having trouble with my MySql setup. This morning it was a working mysql server I added a database and some data with phpMyAdmin then things started to go wrong.
I became unable to connect getting ERROR 2002 unable to connect to socket.
I have completley unistalled mysql server (as best I can) and deleted database files. And now I cannot reinstall it.
I want to recover my mysql root password so I have followed this tutorial and stopped the mysql server . when I am trying to start it its show a error message and won't start.
I've tried it all (removing all the packages associated with MySQL) but keep getting stuff like this:
Preconfiguring packages ...
(Reading database ...
The problem is that my MySQL server keeps crashing every few seconds. Even if I repeat a simple SQL command several times, the MySQL server goes down:
mysql> show databases;
ERROR 2006 (HY000): MySQL server has gone away
No connection.
I can start mysql fine,
/usr/local/mysql/support-files/mysql.server start
Starting MySQL
SUCCESS!
But any mysql action after that I get the error: MySQL server PID file could not be found
/usr/local/mysql/support-files/mysql.server stop
ERROR! MySQL server PID file could not be found!
Where do I find the server PID file on Mac with OSX 10.8? I am wondering if it is a permission problem.