mount onto existing mysql datadir...

_error_cp

root@GITSRV:/home/gitadmin# cp -Rp /tmp/mysql_data/ /var/lib/mysql/
cp: cannot create directory `/var/lib/mysql/mysql_data': Protocol error

_error_touch

root@GITSRV:/home/gitadmin# touch /var/lib/mysql/touch_test
touch: cannot touch `/var/lib/mysql/touch_test': Protocol error

_error_vim

"/var/lib/mysql/test"
"/var/lib/mysql/test" E212: Can't open file for writing

aa-status

root@GITSRV:/home/gitadmin# aa-status
apparmor module is loaded.
5 profiles are loaded.
5 profiles are in enforce mode.
   /sbin/dhclient3
   /usr/lib/NetworkManager/nm-dhcp-client.action
   /usr/lib/connman/scripts/dhclient-script
   /usr/sbin/mysqld
   /usr/sbin/tcpdump
0 profiles are in complain mode.
0 processes have profiles defined.
0 processes are in enforce mode :
0 processes are in complain mode.
0 processes are unconfined but have a profile defined.

etc_apparmor.d_usr.sbin.mysqld

# vim:syntax=apparmor
# Last Modified: Tue Jun 19 17:37:30 2007
#include <tunables/global>

/usr/sbin/mysqld {
  #include <abstractions/base>
  #include <abstractions/nameservice>
  #include <abstractions/user-tmp>
  #include <abstractions/mysql>
  #include <abstractions/winbind>

  capability dac_override,
  capability sys_resource,
  capability setgid,
  capability setuid,

  network tcp,

  /etc/hosts.allow r,
  /etc/hosts.deny r,

  /etc/mysql/*.pem r,
  /etc/mysql/conf.d/ r,
  /etc/mysql/conf.d/* r,
  /etc/mysql/my.cnf r,
  /usr/sbin/mysqld mr,
  /usr/share/mysql/** r,
  /var/log/mysql.log rw,
  /var/log/mysql.err rw,
  /var/lib/mysql/ r,
  /var/lib/mysql/** rwk,
  /var/log/mysql/ r,
  /var/log/mysql/* rw,
  /var/run/mysqld/mysqld.pid w,
  /var/run/mysqld/mysqld.sock w,

  /sys/devices/system/cpu/ r,
}

mount_mysql_datadir

#!/bin/bash

# goes something like this
sudo service mysql stop
sudo cp -Rp /var/lib/mysql/ /tmp/mysql_data/
echo sf_mysql_data /var/lib/mysql/ vboxsf uid=mysql,gid=mysql,dmode=700,fmode=660 0 0 | sudo tee -a /etc/fstab
sudo mount -a
sudo cp -Rp /tmp/mysql_data/ /var/lib/mysql/
sudo service mysql start
sudo rm -fR /tmp/mysql_data/

mysql_perms

/var/lib/mysql/:
total 20496
drwx------  3 mysql mysql     4096 2011-11-12 23:30 .
drwxr-xr-x 37 root  root      4096 2011-11-12 17:08 ..
-rw-r--r--  1 root  root         0 2011-11-12 17:08 debian-5.1.flag
-rw-rw----  1 mysql mysql 10485760 2011-11-12 23:30 ibdata1
-rw-rw----  1 mysql mysql  5242880 2011-11-12 23:30 ib_logfile0
-rw-rw----  1 mysql mysql  5242880 2011-11-12 17:08 ib_logfile1
drwx------  2 mysql root      4096 2011-11-12 17:08 mysql
-rw-rw----  1 root  root         6 2011-11-12 17:08 mysql_upgrade_info

/var/lib/mysql/mysql:
total 956
drwx------ 2 mysql root    4096 2011-11-12 17:08 .
drwx------ 3 mysql mysql   4096 2011-11-12 23:30 ..
-rw-rw---- 1 mysql mysql   8820 2011-11-12 17:08 columns_priv.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 columns_priv.MYD
-rw-rw---- 1 mysql mysql   4096 2011-11-12 17:08 columns_priv.MYI
-rw-rw---- 1 mysql mysql   9582 2011-11-12 17:08 db.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 db.MYD
-rw-rw---- 1 mysql mysql   2048 2011-11-12 17:08 db.MYI
-rw-rw---- 1 mysql mysql  10223 2011-11-12 17:08 event.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 event.MYD
-rw-rw---- 1 mysql mysql   2048 2011-11-12 17:08 event.MYI
-rw-rw---- 1 mysql mysql   8665 2011-11-12 17:08 func.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 func.MYD
-rw-rw---- 1 mysql mysql   1024 2011-11-12 17:08 func.MYI
-rw-rw---- 1 mysql mysql     35 2011-11-12 23:30 general_log.CSM
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 general_log.CSV
-rw-rw---- 1 mysql mysql   8776 2011-11-12 17:08 general_log.frm
-rw-rw---- 1 mysql mysql   8700 2011-11-12 17:08 help_category.frm
-rw-rw---- 1 mysql mysql  21497 2011-11-12 17:08 help_category.MYD
-rw-rw---- 1 mysql mysql   3072 2011-11-12 17:08 help_category.MYI
-rw-rw---- 1 mysql mysql   8612 2011-11-12 17:08 help_keyword.frm
-rw-rw---- 1 mysql mysql  88650 2011-11-12 17:08 help_keyword.MYD
-rw-rw---- 1 mysql mysql  16384 2011-11-12 17:08 help_keyword.MYI
-rw-rw---- 1 mysql mysql   8630 2011-11-12 17:08 help_relation.frm
-rw-rw---- 1 mysql mysql   8910 2011-11-12 17:08 help_relation.MYD
-rw-rw---- 1 mysql mysql  18432 2011-11-12 17:08 help_relation.MYI
-rw-rw---- 1 mysql mysql   8770 2011-11-12 17:08 help_topic.frm
-rw-rw---- 1 mysql mysql 417496 2011-11-12 17:08 help_topic.MYD
-rw-rw---- 1 mysql mysql  20480 2011-11-12 17:08 help_topic.MYI
-rw-rw---- 1 mysql mysql   9510 2011-11-12 17:08 host.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 host.MYD
-rw-rw---- 1 mysql mysql   2048 2011-11-12 17:08 host.MYI
-rw-rw---- 1 mysql mysql   8778 2011-11-12 17:08 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql   1024 2011-11-12 17:08 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql   8586 2011-11-12 17:08 plugin.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 plugin.MYD
-rw-rw---- 1 mysql mysql   1024 2011-11-12 17:08 plugin.MYI
-rw-rw---- 1 mysql mysql   9996 2011-11-12 17:08 proc.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 proc.MYD
-rw-rw---- 1 mysql mysql   2048 2011-11-12 17:08 proc.MYI
-rw-rw---- 1 mysql mysql   8875 2011-11-12 17:08 procs_priv.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 procs_priv.MYD
-rw-rw---- 1 mysql mysql   4096 2011-11-12 17:08 procs_priv.MYI
-rw-rw---- 1 mysql mysql   8838 2011-11-12 17:08 servers.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 servers.MYD
-rw-rw---- 1 mysql mysql   1024 2011-11-12 17:08 servers.MYI
-rw-rw---- 1 mysql mysql     35 2011-11-12 23:30 slow_log.CSM
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 slow_log.CSV
-rw-rw---- 1 mysql mysql   8976 2011-11-12 17:08 slow_log.frm
-rw-rw---- 1 mysql mysql   8955 2011-11-12 17:08 tables_priv.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 tables_priv.MYD
-rw-rw---- 1 mysql mysql   4096 2011-11-12 17:08 tables_priv.MYI
-rw-rw---- 1 mysql mysql   8636 2011-11-12 17:08 time_zone.frm
-rw-rw---- 1 mysql mysql   8624 2011-11-12 17:08 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql   1024 2011-11-12 17:08 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 time_zone.MYD
-rw-rw---- 1 mysql mysql   1024 2011-11-12 17:08 time_zone.MYI
-rw-rw---- 1 mysql mysql   8606 2011-11-12 17:08 time_zone_name.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 time_zone_name.MYD
-rw-rw---- 1 mysql mysql   1024 2011-11-12 17:08 time_zone_name.MYI
-rw-rw---- 1 mysql mysql   8686 2011-11-12 17:08 time_zone_transition.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql   1024 2011-11-12 17:08 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql   8748 2011-11-12 17:08 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql      0 2011-11-12 17:08 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql   1024 2011-11-12 17:08 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql  10466 2011-11-12 17:08 user.frm
-rw-rw---- 1 mysql mysql    376 2011-11-12 17:08 user.MYD
-rw-rw---- 1 mysql mysql   2048 2011-11-12 17:08 user.MYI

proper_mounting

root@GITSRV:/home/gitadmin# ls -l /var/lib/mysql/
total 20488
-rw-r--r-- 1 root  root         0 2011-11-12 17:08 debian-5.1.flag
-rw-rw---- 1 mysql mysql 10485760 2011-11-12 23:30 ibdata1
-rw-rw---- 1 mysql mysql  5242880 2011-11-12 23:30 ib_logfile0
-rw-rw---- 1 mysql mysql  5242880 2011-11-12 17:08 ib_logfile1
drwx------ 2 mysql root      4096 2011-11-12 17:08 mysql
-rw-rw---- 1 root  root         6 2011-11-12 17:08 mysql_upgrade_info
root@GITSRV:/home/gitadmin# cat /etc/fstab | grep sf_mysql_data
sf_mysql_data /var/lib/mysql/ vboxsf uid=mysql,gid=mysql,dmode=700,fmode=660 0 0
root@GITSRV:/home/gitadmin# mount -a
root@GITSRV:/home/gitadmin# ls -l /var/lib/mysql/
total 0
-rw-rw---- 1 mysql mysql 0 2011-11-12 19:45 test

stop_apparmor

root@GITSRV:/home/gitadmin# sudo /etc/init.d/apparmor stop
 * Clearing AppArmor profiles cache                                 [ OK ]
All profile caches have been cleared, but no profiles have been unloaded.
Unloading profiles will leave already running processes permanently
unconfined, which can lead to unexpected situations.

To set a process to complain mode, use the command line tool
'aa-complain'. To really tear down all profiles, run the init script
with the 'teardown' option."
root@GITSRV:/home/gitadmin# touch /var/lib/mysql/touch_test
touch: cannot touch `/var/lib/mysql/touch_test': Protocol error

stop_selinux

root@GITSRV:/home/gitadmin# echo 0 > /selinux/enforce
root@GITSRV:/home/gitadmin# touch /var/lib/mysql/touch_test
touch: cannot touch `/var/lib/mysql/touch_test': Protocol error
root@GITSRV:/home/gitadmin# sudo -u mysql touch /var/lib/mysql/touch_test
touch: cannot touch `/var/lib/mysql/touch_test': Protocol error