1

Can’t start MySQL on Ubuntu 12.04 after restored from innobackupex

view story
linux-howto

http://serverfault.com – I can’t start MySQL on Ubuntu 12.04 after restored backup from innobackupex. Before I tried to restore the db from backup I moved the datadir and got the same problem. With help from google I fixed the problem and got MySQL started. Ready to set up my new slave, I restored the backup via innobackupex –-copy-path /db/mysql, and now I can’t start MySQL. I am sure of the following: In my.cnf the datadir = /db/mysql The new datadir is chown mysql:mysql. The /etc/apparmor.d/usr.sbin.mysqld contains: #/var/lib/mysql/ r, #/var/lib/mysql/** rwk, /db/mysql r, /db/mysql** rwk, AND (HowTos)

grtyyu's picture
Submitted by grtyyu on 10/17/2012

Stories similar to Can’t start MySQL on Ubuntu 12.04 after restored from innobackupex

I tried to change the database dirrectory, datadir, I did the following steps. My machine: Laptop Ubuntu 11.10 64-bit

Install: sudo apt-get install mysql-server mysql-client All Ok, I can create databases, tables, all ok. Change the datadir:

1) $ /etc/init.d/mysql stop 2) $ cp -R -p /var/lib/mysql /new_path 3) $ rm /new_path (this only remove files unnecessary) 4) $ gedit /e

/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.example.com.err --open-files-limit=20000 --pid-file=/var/lib/mysql/server1.example.com.pid

Memory is at %10 always and Cpu at %1 Also /usr/local/apache/bin/httpd -k start -DSSL I have like 10 of them running

Hi,

I Installed mysql on my CentOS 6.2 Server. But when I tried to change the location of /var/lib/mysql to another directory. I can't start the 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.

Hi everyone,

I tried to change the database dirrectory, datadir, I did the following steps. My machine: Laptop Ubuntu 11.10 64-bit

Install: sudo apt-get install mysql-server mysql-client All Ok, I can create databases, tables, all ok. Change the datadir:

Quote:

1) $ /etc/init.d/mysql stop 2) $ cp -R -p /var/lib/mysql /new_path 3) $ rm /new_path (t

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.

Cannot connect to mysql 38 weeks 5 days ago

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

I've changed data directory in /etc/my.cnf.

I've been seeing this in Process Manager for some time, for months actually, but I don't know what it is and would like to know.

It has my hostname in it.

Quote:

/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xxx.xxxxx.xxx.err --pid-file=/var/lib/mysql/xxx.xxxxx.xxx.pid