MYSQL backup for MYISAM engine type

General support questions
Post Reply
saurabh.dua
Posts: 1
Joined: 2020/05/05 06:20:44

MYSQL backup for MYISAM engine type

Post by saurabh.dua » 2020/05/05 06:49:39

Hi,

i am migrating my host from Solaris Bare-metal to centOS6 VM. Iam using backup type =ZFS on solaris. which is defined as

zfssnap.conf.1 = var_tellme:24:2:0:0
zfssnap.conf.2 = .:0:0:0:0
zfssnap.mysql.lock = yes

while on centOS i defined it as
snap.conf.1 /var/tellme/:var_tellme:24:7:4:0

i am not sure for zfssnap.mysql.lock = yes parameter, do i need this parameter and whether this is supported on centOS6 and if yes how to define this. My storage engine type is MYISAM.

Thanks

User avatar
TrevorH
Forum Moderator
Posts: 28514
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: MYSQL backup for MYISAM engine type

Post by TrevorH » 2020/05/05 08:11:37

I think this is a mistake and you should review it. CentOS 6 is nearly dead and no-one and nothing should be migrating anything to it at this point in its life. In November this year, all updates will cease and you'll be needing to migrate it again to something else.

We don't support ZFS at all.

I would be looking at migrating your mysql data using mysqldump as it's more portable.
CentOS 6 will die in November 2020 - migrate sooner rather than later!
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 is dead, do not use it.
Full time Geek, part time moderator. Use the FAQ Luke

Post Reply

Return to “CentOS 6 - General Support”