Hi Priscila and Andrew. Thanks for your help. I really appreciate it. I am just glad these issues showed before I am actually promoting my website www.yourcommonsongjams.com
Regarding Andrews requests,
I can put off the mysqldump incremental backup questions for now. I have not tried a recovery test yet. I was advised to install VirtualBox to test this on my home Win7 machine with Linux.
Regarding the disk drive check the Velcom support person got back to me and said; Quote: "Drives into our VPS carrier looks good, so your mysql corruptions not depend on our drives." EndQuote. I can not tell if they did a really good check. I explained that the problem is has gradually gotten worse. I am running a low end Virtual Private Server with Velcom. This is my first VPS (my first and only website). To see the specifications, it is the VPS1 package at this link.
http://www.velcom.com/vps-hosting/. I access the server by Putty, WinSCP and web pages.
I captured the whole mysqld.log for yesterday. I ran the " yum update mysql-server" command after 3:30pm EST and I included a note in the middle of the log about this. It is fairly big. Do I just dump it in here.
I will run your very last test next and create another post. If you want details as to the size of my database tables and the structure I can get that too you.
I ran this just now 2015/April/30 09:30
bash-3.2# rpm -qa | grep -i mysql
mysqlclient15-5.0.67-1.el5.remi
mysql-libs-5.5.43-1.el5.remi
mysql-server-5.5.43-1.el5.remi
perl-DBD-MySQL-3.0007-2.el5
php-mysqlnd-5.5.22-1.el5.remi.1
mysql-5.5.43-1.el5.remi
I ran this just now 2015/April/30 09:35
bash-3.2# yum upgrade mysql-client mysql-shared mysql-shared-compat
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: less.cogeco.net
* epel: fedora-epel.mirror.iweb.com
* extras: centos.mirror.rafal.ca
* remi: fr2.rpmfind.net
* remi-php55: fr2.rpmfind.net
* updates: less.cogeco.net
base | 1.1 kB 00:00
epel | 3.7 kB 00:00
epel/primary_db | 2.7 MB 00:00
extras | 2.1 kB 00:00
remi | 2.5 kB 00:00
remi/primary_db | 733 kB 00:00
remi-php55 | 2.5 kB 00:00
updates | 1.9 kB 00:00
Setting up Upgrade Process
No Match for argument: mysql-shared
No package mysql-shared available.
No Match for argument: mysql-shared-compat
No package mysql-shared-compat available.
No Packages marked for Update