I am trying to change the data directory for mysql in a LAMP setup. The partition that LAMP is installed in cannot support the size of a .sql dump I am trying to import. I have another hardrive with plenty of room on it that I want all the data to live on.
I have changed the datadir to my new directory and moved the /var/lib/mysql folder and content to it.
Hi,
I have install MySQL serve in Fedora 16 32 bi distro that I have on my pc, but I can't start MySQL from command line. Can you please help?
Recently I have moved the data folder of MySql to the other folder as describe in the my.ini following:
[mysqld]
port= 3306
socket= "D:/xampp/mysql/mysql.sock"
basedir="D:/xampp/mysql"
tmpdir="D:/xampp/tmp"
datadir="I:/Dropbox/mysql/data"
pid_file="mysql.pid"
skip-external-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buff
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 was setting up a soft link in linux. Here were the steps I followed:
> groupadd mysql
> useradd -g mysql mysql
> cd /usr/local
> gunzip /home/Tim/Download/mysql.....gz | tar xvf -
> ln -s /usr/local/mysql.... mysql
Seems that you might be missing a file--at least, that's what the error is telling you.Confirm that mysql-bin.index exists in your ~/.mysql directory and try starting it again. Also, all files (and the directory containing them) should be set to mysql:mysql and the parent directory's permissions should probably be set to 0750 or 0770.
Today I have changed mysql config file and restarted mysql with:
service mysql restart
And saw the following:
Stopping mysql database server: mysqld.
Starting mysql database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
After that the mysql service started working, but later I saw errors on my website and realized that InnoDB engine was not star
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.
Hey guys, so I've been running F17 for quite some time now, and earlier I attempted to install mysql for computer science class, and so far I have been the recipient of two not so unfamiliar errors I've gotten in the past while trying to install apache and other server software, number1 is it didn't prompt me to configure my mysql root password and secondly, every time I try to start it up I get t
Email this page
