Re: Corruptions like crazy

[John Bowles]

Hi Andrew. It seems to be working well under InnoDB format. Thanks for your help. I included the logs you requested for after I stopped and started the mysqld service. Also I have a few questions. John


Q1
I backup with phpMyAdmin and also mysqldump (both every day). Normally when I return I use phpMyAdmin. However I don't see a way to return to InnoDB format with phpMyAdmin. Am I missing something or do I need to return with mysqldump now?

Q2
When I pointed the database and did my webpage tests I immediately ran this command that I found on the web. I also test the tables every morning. Is this the command I should use from now on for my daily test of the tables?

mysqlcheck -u root -pMyRootPassword --check --databases musiciansjamnetwork

Q3
Normally I stop and start mysql with "service httpd stop" and "service httpd start". Is this the same as "service mysqld stop" and "service mysqld start" or should I switch over to the commands you used?



150430 15:38:54 [Note] /usr/libexec/mysqld: Normal shutdown

150430 15:38:54 InnoDB: Starting shutdown...
150430 15:38:56 InnoDB: Shutdown completed; log sequence number 3313883
150430 15:38:56 [Note] /usr/libexec/mysqld: Shutdown complete

150430 15:38:56 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150430 15:39:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150430 15:39:06 [Note] /usr/libexec/mysqld (mysqld 5.5.43-log) starting as process 16251 ...
150430 15:39:06 [Note] Plugin 'FEDERATED' is disabled.
150430 15:39:06 InnoDB: The InnoDB memory heap is disabled
150430 15:39:06 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
150430 15:39:06 InnoDB: Compressed tables use zlib 1.2.3
150430 15:39:06 InnoDB: Using Linux native AIO
150430 15:39:06 InnoDB: Initializing buffer pool, size = 128.0M
150430 15:39:06 InnoDB: Completed initialization of buffer pool
150430 15:39:06 InnoDB: highest supported file format is Barracuda.
150430 15:39:08 InnoDB: Waiting for the background threads to start
150430 15:39:09 InnoDB: 5.5.43 started; log sequence number 3313883
150430 15:39:10 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150430 15:39:10 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150430 15:39:10 [Note] Server socket created on IP: '0.0.0.0'.
150430 15:39:10 [Note] Event Scheduler: Loaded 0 events
150430 15:39:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.43-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi