Cannot proceed because system tables used by Event Scheduler were found damaged

azn_romeo_4u

• April 25, 2016 02:11

I am trying to transfer the mysql databases from one server that has maria db to another server that has mysql. When I use the whm transfer tool, I get that error. mysqldump: Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start I did some google searches, but wanted to hear what the experts on whm say first. The database seem to be working 100% fine on the live websites.

• 

  Ameya Barwe

  • April 25, 2016 07:22

  Have you tried repairing database on the old server?

  0
• 

  azn_romeo_4u

  • April 25, 2016 16:00

  Yes, I did repairs and optimize. Everything was good. Other than a few messages saying, storage engine doesn't support repair. Hmmm...base on what I read, I don't think mysql_upgrade was properly done when the server was updated to mariadb. I will try to do a mysql dump of everything and ftp to my new server. Then drop all the data into the new server to see what's up. Edit. Running into so many problems. LOL. Ready to give up.

  0
• 

  cPanelMichael

  • April 25, 2016 19:40

  Other than a few messages saying, storage engine doesn't support repair.

  
  Hello :) This suggests an issue with the database on the source server. I suggest using the "mysqldump" utility to backup the database and ensure it completes successfully before attempting to transfer the database to the destination server. Thank you.

  0
• 

  azn_romeo_4u

  • May 26, 2016 21:47

  I just did a mysql dump of one of the files. It dump perfectly. Did a few that failed, and same thing. No errors when dumping. If one server has a different version of mysql or mariadb, it won't dump properly?

  0
• 

  cPanelMichael

  • May 27, 2016 18:57

  I just did a mysql dump of one of the files. It dump perfectly. Did a few that failed, and same thing. No errors when dumping. If one server has a different version of mysql or mariadb, it won't dump properly?

  
  Hello, You typically backup the database with the "mysqldump" utility on the server where the database is hosted. Could you elaborate on which particular step is not working at this point? Thank you.

  0
• 

  azn_romeo_4u

  • June 03, 2016 04:32

  I am trying to do a cpanel account transfer through whm. But failing at mysql dump on 90% of the accounts. Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577) Failed to dump database: The subprocess reported error number 2 when it ended. When I run mysqldump on source server, it works. Doesn't display any errors. The databases, are on a remote server, running mariadb.

  0
• 

  azn_romeo_4u

  • June 03, 2016 04:41

  Well...I think I finally succeeded. After backing all the databases. mysqldump --all-databases > all_databases.sql Then I ran mysql_upgrade -u root -h localhost -p --verbose --force Then I rebooted server /sbin/reboot Then I did the account transfer. Everything seemed to have work. Only downside was that, I had already manually restore all the database, and cpanel instead of overwriting them databases, it added the same ones in and renamed them. Did the same for the users as well.

  0
• 

  cPanelMichael

  • June 07, 2016 15:50

  Hello, The following document explains how to use the database map utility to control which database and database usernames are owned by the accounts: Database Map Tool - Documentation - cPanel Documentation You may find this tool helpful when attempting to manage the duplicate databases. Generally, it's advised to copy over the accounts and databases at the same time, or to skip the database transfer if you have already uploaded the databases manually. The "Copy Databases" option is documented at: Transfer Tool - Documentation - cPanel Documentation Thank you.

  0

Please sign in to leave a comment.