← Back to team overview

mylvmbackup-discuss team mailing list archive

Re: InnoDB recovery doesn't work

 

On 09.09.2010 00:09 CE(S)T, Lenz Grimmer wrote:
> Do the files and directories on the snapshot
> belong to the "mysql" user as well? I wonder if the snapshot is mounted with
> some strange flags. What does /proc/mounts say about this? How do the
> ownerships of the files on the snapshot look like?

Here's some command output: (this is on the productive server already,
also Ubuntu 10.4, but 64 bit, and still in the configuration phase)

> 23:42 yves@mond ~ > sudo ls -al /var/cache/mylvmbackup/mnt/backup/var/lib/mysql
> insgesamt 28700
> drwx------  5 mysql mysql     4096 2010-09-08 20:56 .
> drwxr-xr-x 61 root  root      4096 2010-09-09 08:29 ..
> -rw-r--r--  1 root  root         0 2010-09-08 20:13 debian-5.1.flag
> -rw-rw----  1 mysql mysql 18874368 2010-09-09 22:49 ibdata1
> -rw-rw----  1 mysql mysql  5242880 2010-09-09 22:49 ib_logfile0
> -rw-rw----  1 mysql mysql  5242880 2010-09-08 20:13 ib_logfile1
> -rw-rw----  1 mysql mysql        5 2010-09-08 20:56 mond.pid
> drwx------  2 mysql root      4096 2010-09-08 20:13 mysql
> -rw-rw----  1 root  root         6 2010-09-08 20:13 mysql_upgrade_info
> drwx------  2 mysql mysql     4096 2010-09-08 20:19 pdns
> drwx------  2 mysql mysql     4096 2010-09-08 20:16 webadmin

> 23:42 yves@mond ~ > sudo cat /proc/mounts
> rootfs / rootfs rw 0 0
> none /sys sysfs rw,nosuid,nodev,noexec,relatime 0 0
> none /proc proc rw,nosuid,nodev,noexec,relatime 0 0
> none /dev devtmpfs rw,relatime,size=4088632k,nr_inodes=1022158,mode=755 0 0
> none /dev/pts devpts rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000 0 0
> /dev/mapper/vg0-root / ext4 rw,relatime,acl,barrier=1,data=ordered,usrquota 0 0
> none /sys/fs/fuse/connections fusectl rw,relatime 0 0
> none /sys/kernel/debug debugfs rw,relatime 0 0
> none /sys/kernel/security securityfs rw,relatime 0 0
> none /dev/shm tmpfs rw,nosuid,nodev,relatime 0 0
> none /var/run tmpfs rw,nosuid,relatime,mode=755 0 0
> none /var/lock tmpfs rw,nosuid,nodev,noexec,relatime 0 0
> none /lib/init/rw tmpfs rw,nosuid,relatime,mode=755 0 0
> /dev/mapper/vg0-backup /backup ext4 rw,relatime,barrier=1,data=ordered 0 0
> /dev/md0 /boot ext2 rw,relatime,errors=continue 0 0
> binfmt_misc /proc/sys/fs/binfmt_misc binfmt_misc rw,nosuid,nodev,noexec,relatime 0 0
> /dev/mapper/vg0-root_snapshot /var/cache/mylvmbackup/mnt/backup ext4 rw,relatime,barrier=1,data=ordered 0 0


-- 
Yves Goergen - mail & jabber im: yves@xxxxxxxxxxxxxxx
http://unclassified.de - Web-Labor, HD-Fotogalerie, Webhosting
Diese Nachricht ist standardkonform mit OpenPGP digital signiert.

Attachment: signature.asc
Description: OpenPGP digital signature


References