MySQL Forums
Forum List  »  Newbie

Re: Corruptions like crazy
Posted by: John Bowles
Date: April 30, 2015 07:44AM

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

Options: ReplyQuote


Subject
Written By
Posted
April 29, 2015 11:33AM
April 29, 2015 11:49AM
April 29, 2015 12:20PM
April 29, 2015 12:40PM
April 29, 2015 01:04PM
April 29, 2015 01:36PM
April 29, 2015 01:48PM
April 29, 2015 02:00PM
April 29, 2015 02:59PM
April 29, 2015 03:30PM
April 29, 2015 04:24PM
Re: Corruptions like crazy
April 30, 2015 07:44AM
April 30, 2015 07:48AM
April 30, 2015 08:44AM
April 30, 2015 08:57AM
April 30, 2015 08:59AM
April 30, 2015 09:40AM
April 30, 2015 10:19AM
April 30, 2015 01:45PM
April 30, 2015 02:42PM
April 30, 2015 03:36PM
April 30, 2015 07:36PM
April 30, 2015 10:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.