mysql crash?

Post Reply
Fett
Posts: 85
Joined: Tue Feb 28, 2017 1:23 pm

mysql crash?

Post by Fett »

hello, When I list trade I get this:



Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 130 (Incorrect file format 'links') (db_link) in query select sum(num) as clicks, trader from links where link = 'hidden' group by trader. (knockoutteens.com) ' in /home/blackhat/domains/knockoutteens.com/public_html/scj/includes/db_modules/mysql.php:72 Stack trace: #0 /home/blackhat/domains/knockoutteens.com/public_html/scj/includes/db_modules/mysql.php(103): db_error('select sum(num)...', 130, 'Incorrect file ...', 'db_link') #1 /home/blackhat/domains/knockoutteens.com/public_html/scj/admin/files/trade.php(0): db_query() #2 /home/blackhat/domains/knockoutteens.com/public_html/scj/admin/index.php(0): unknown() #3 {main} thrown in /home/blackhat/domains/knockoutteens.com/public_html/scj/includes/db_modules/mysql.php on line 72


what can I do to proceed?
Fett
Posts: 85
Joined: Tue Feb 28, 2017 1:23 pm

Re: mysql crash?

Post by Fett »

try to repair database in bash, I get this:

Repairing tables
blackhat_KNOscj.browsers
Error : Incorrect file format 'browsers'
error : Corrupt
blackhat_CZAscj.ips
Error : Incorrect file format 'ips'
error : Corrupt
blackhat_CZAscj.language
Error : Incorrect file format 'language'
error : Corrupt
blackhat_CZAscj.links
Error : Incorrect file format 'links'
error : Corrupt
blackhat_CZAscj.out_ips
Error : Incorrect file format 'out_ips'
error : Corrupt
blackhat_CZAscj.out_ips2trader
Error : Incorrect file format 'out_ips2trader'
error : Corrupt
blackhat_CZAscj.refs
Error : Incorrect file format 'refs'
error : Corrupt
Fett
Posts: 85
Joined: Tue Feb 28, 2017 1:23 pm

Re: mysql crash?

Post by Fett »

Can you help me? What is this? and mysql error log (from scj admin panel) full of data
Fett
Posts: 85
Joined: Tue Feb 28, 2017 1:23 pm

Re: mysql crash?

Post by Fett »

the following tables are corrupt. On all my sites on this server?????

corrupted tables:

browsers
ips
language
links
out_ips
out_ips2trader
refs


Trying to access them in phpmyadmin,

#130 - incorrect file format
Fett
Posts: 85
Joined: Tue Feb 28, 2017 1:23 pm

Re: mysql crash?

Post by Fett »

update: managed to repair corrupt tables in phpmyadmin by running this command:


repair table table_name use_frm

...

It was a power failure at host company! So not to do anything with scj :-)
Fett
Posts: 85
Joined: Tue Feb 28, 2017 1:23 pm

Re: mysql crash?

Post by Fett »

by the way I want to ask on this note is this possible to create backup at a a different time, not midnight because ALL my scjs start to create backup in the same time PLUS interestingly all my streamrotators also choose the exact same minute to create backups, and guess this is a HUGE load ony my server of course.

Is there a solution somehow please to manually set when you want to backup? Like not in the same minute for all sites please
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: mysql crash?

Post by admin »

Actually it should spread the time it makes backups along the day, are you sure it attempts to do it at the same minute? Did you check cron.log for 'backup' word ?

You can switch off autobackup and add a regular 'mysqldump' into crontab.
Don't forget to run script update
Fett
Posts: 85
Joined: Tue Feb 28, 2017 1:23 pm

Re: mysql crash?

Post by Fett »

thank you for tips so far. I still have trouble,

Mysql error:: 126 (Incorrect key file for table './scj-database/settings.MYI'; try to repair it)


I checked with phpmyadmin but I dont find this table, where is it?
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: mysql crash?

Post by admin »

You can copy this table from any other DB or get it from scj/scj2.sql file
Don't forget to run script update
Post Reply