Error in database backup
Hello,
I have a problem in getting backup for some of my databases.
And size of my sql file is lower than my database size. What should I do to resolve this issue? Regards
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 failedAnd size of my sql file is lower than my database size. What should I do to resolve this issue? Regards
-
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.0 -
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 OK0 -
Is it possible there was InnoDB corruption at some point and you disabled InnoDB or deleted data associated with it? Thank you. 0 -
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 0 -
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: [url=http://dev.mysql.com/doc/refman/5.5/en/mysqlcheck.html]MySQL :: MySQL 5.5 Reference Manual :: 4.5.3 mysqlcheck Thank you. 0 -
Hello again, There are no error during restarting mysql: root@server [~]# service mysql restart Shutting down MySQL.... [ OK ] Starting MySQL.. [ OK ] root@server [~]#
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? Regards0 -
[quote="hamed5034, post: 1590511">There are no error during restarting mysql: root@server [~]# service mysql restart Shutting down MySQL.... [ OK ] Starting MySQL.. [ OK ]
That shows there were no errors output from that command, but did you check the MySQL error log when restarting it? Thank you.0 -
[quote="cPanelMichael, post: 1590532">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. Regards0 -
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. 0
Please sign in to leave a comment.
Comments
9 comments