hamed5034

Member
Nov 21, 2013
24
0
1
cPanel Access Level
Root Administrator
Hello,
I have a problem in getting backup for some of my databases.

Code:
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

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
It appears there could be corruption with that database. Try checking the database on the server to verify that with a command such as:

Code:
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

Member
Nov 21, 2013
24
0
1
cPanel Access Level
Root Administrator
Hello,

The out put of:
Code:
mysqlcheck rebecmus_a
is:
Code:
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

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Is it possible there was InnoDB corruption at some point and you disabled InnoDB or deleted data associated with it?

Thank you.
 

hamed5034

Member
Nov 21, 2013
24
0
1
cPanel Access Level
Root Administrator
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
 

hamed5034

Member
Nov 21, 2013
24
0
1
cPanel Access Level
Root Administrator
Hello again,

There are no error during restarting mysql:
Code:
[email protected] [~]# service mysql restart
Shutting down MySQL....                                    [  OK  ]
Starting MySQL..                                           [  OK  ]
[email protected] [~]#
And this is my /etc/my.cnf :
Code:
[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

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
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.