Error in database backup

[hamed5034]

Hello,
I have a problem in getting backup for some of my databases.

Storing mysql dbs............
rebecmus_a.........
rebecmus_a.ggjbk0_TABLE_STATISTICS                 OK
rebecmus_a.ggjbk0_TABLE_STATISTICS_RAW             OK
rebecmus_a.ggjbk0_aiowps_failed_logins             OK
rebecmus_a.ggjbk0_aiowps_global_meta               OK
rebecmus_a.ggjbk0_aiowps_login_activity            OK
rebecmus_a.ggjbk0_aiowps_login_lockdown            OK
rebecmus_a.ggjbk0_commentmeta                      OK
rebecmus_a.ggjbk0_comments                         OK
rebecmus_a.ggjbk0_dlmc                             OK
rebecmus_a.ggjbk0_kklike
Error    : Table 'rebecmus_a.ggjbk0_kklike' doesn't exist
status   : Operation failed
rebecmus_a.ggjbk0_kklikeuser
Error    : Table 'rebecmus_a.ggjbk0_kklikeuser' doesn't exist
status   : Operation failed
rebecmus_a.ggjbk0_like_dislike_counters
Error    : Table 'rebecmus_a.ggjbk0_like_dislike_counters' doesn't exist
status   : Operation failed
rebecmus_a.ggjbk0_likeit                           OK
rebecmus_a.ggjbk0_links                            OK
rebecmus_a.ggjbk0_newsletter                       OK
rebecmus_a.ggjbk0_newsletter_emails                OK
rebecmus_a.ggjbk0_newsletter_stats                 OK
rebecmus_a.ggjbk0_options                          OK
rebecmus_a.ggjbk0_postmeta                         OK
rebecmus_a.ggjbk0_posts                            OK
rebecmus_a.ggjbk0_rating_scores
Error    : Table 'rebecmus_a.ggjbk0_rating_scores' doesn't exist
status   : Operation failed
rebecmus_a.ggjbk0_statistics_useronline
Error    : Table 'rebecmus_a.ggjbk0_statistics_useronline' doesn't exist
status   : Operation failed
rebecmus_a.ggjbk0_statistics_visit
Error    : Table 'rebecmus_a.ggjbk0_statistics_visit' doesn't exist
status   : Operation failed

And size of my sql file is lower than my database size.
What should I do to resolve this issue?

Regards

 

[cPanelMichael]

It appears there could be corruption with that database. Try checking the database on the server to verify that with a command such as:

mysqlcheck database_name

You should be able to use the mysqldump utility to backup a database successfully so you know it will work during the account backup generation.

Thank you.

 

[hamed5034]

Hello,

The out put of:

mysqlcheck rebecmus_a

is:

rebecmus_a.ggjbk0_TABLE_STATISTICS                 OK
rebecmus_a.ggjbk0_TABLE_STATISTICS_RAW             OK
rebecmus_a.ggjbk0_aiowps_failed_logins             OK
rebecmus_a.ggjbk0_aiowps_global_meta               OK
rebecmus_a.ggjbk0_aiowps_login_activity            OK
rebecmus_a.ggjbk0_aiowps_login_lockdown            OK
rebecmus_a.ggjbk0_commentmeta                      OK
rebecmus_a.ggjbk0_comments                         OK
rebecmus_a.ggjbk0_dlmc                             OK
rebecmus_a.ggjbk0_kklike
Error    : Table 'rebecmus_a.ggjbk0_kklike' doesn't exist
status   : Operation failed
rebecmus_a.ggjbk0_kklikeuser
Error    : Table 'rebecmus_a.ggjbk0_kklikeuser' doesn't exist
status   : Operation failed
rebecmus_a.ggjbk0_like_dislike_counters
Error    : Table 'rebecmus_a.ggjbk0_like_dislike_counters' doesn't exist
status   : Operation failed
rebecmus_a.ggjbk0_likeit                           OK
rebecmus_a.ggjbk0_links                            OK
rebecmus_a.ggjbk0_newsletter                       OK
rebecmus_a.ggjbk0_newsletter_emails                OK
rebecmus_a.ggjbk0_newsletter_stats                 OK
rebecmus_a.ggjbk0_options                          OK
rebecmus_a.ggjbk0_postmeta                         OK
rebecmus_a.ggjbk0_posts                            OK
rebecmus_a.ggjbk0_rating_scores
Error    : Table 'rebecmus_a.ggjbk0_rating_scores' doesn't exist
status   : Operation failed
rebecmus_a.ggjbk0_statistics_useronline
Error    : Table 'rebecmus_a.ggjbk0_statistics_useronline' doesn't exist
status   : Operation failed
rebecmus_a.ggjbk0_statistics_visit
Error    : Table 'rebecmus_a.ggjbk0_statistics_visit' doesn't exist
status   : Operation failed
rebecmus_a.ggjbk0_statistics_visitor
Error    : Table 'rebecmus_a.ggjbk0_statistics_visitor' doesn't exist
status   : Operation failed
rebecmus_a.ggjbk0_term_relationships               OK
rebecmus_a.ggjbk0_term_taxonomy                    OK
rebecmus_a.ggjbk0_terms                            OK
rebecmus_a.ggjbk0_usermeta                         OK
rebecmus_a.ggjbk0_users                            OK
rebecmus_a.ggjbk0_wti_like_post
Error    : Table 'rebecmus_a.ggjbk0_wti_like_post' doesn't exist
status   : Operation failed
rebecmus_a.ggjbk0_yarpp_related_cache              OK

 

[cPanelMichael]

Is it possible there was InnoDB corruption at some point and you disabled InnoDB or deleted data associated with it?

Thank you.

 

[hamed5034]

Hello,

Thank you.
Is there any solution for this issue? I did not disable InnoDB or delete data associated whit it. (Who could I check that everything is OK about InnoDB?)
Litespeed is running on my server with CloudLinux.

Regards

 

[cPanelMichael]

Check the MySQL error log when restarting MySQL and look for any entries associated with InnoDB in your /etc/my.cnf file. It's also possible that the database is simply corrupt and needs to be repaired:

MySQL :: MySQL 5.5 Reference Manual :: 4.5.3 mysqlcheck

Thank you.

 

[hamed5034]

Hello again,

There are no error during restarting mysql:

[email protected] [~]# service mysql restart
Shutting down MySQL....                                    [  OK  ]
Starting MySQL..                                           [  OK  ]
[email protected] [~]#

And this is my /etc/my.cnf :

[mysqld]
datadir = /home/mysql
#socket=/home/mysql/mysql.sock
innodb_file_per_table=1
default-storage-engine=MyISAM
max_allowed_packet=512M
query_cache_size = 4G
query_cache_type=1
thread_cache_size = 384
join_buffer_size=4G
max_connections=1000
local-infile=0
table_cache= 10000
open_files_limit = 81920
tmp_table_size=256M
max_heap_table_size=256M
wait_timeout=5

Do you see any problem? And do you think my DB is simply corrupt and needs to be repaired?

Regards

 

[cPanelMichael]

There are no error during restarting mysql:

[email protected] [~]# service mysql restart
Shutting down MySQL....                                    [  OK  ]
Starting MySQL..                                           [  OK  ][/QUOTE]

That shows there were no errors output from that command, but did you check the MySQL error log when restarting it?

Thank you.

 

[hamed5034]

That shows there were no errors output from that command, but did you check the MySQL error log when restarting it?

Thank you.

Hello,

There is no error in server.domain.com.err after restarting mysql too.

Regards

 

[cPanelMichael]

In that case, I suggest reviewing the link referenced in my earlier post or consulting with a qualified system administrator to determine if there are any specific problems with the tables.

Thank you.