well , the best way to repair it is using navicat (navicat rules
)
download navicat (use the light version if you dont find a pro version)
then be sure to disable the firewall , and on cpanel use whm to enable remote acces for root account
how to do it ??
well , go to whm (2086) and login as root
go to phpmyadmin (click that link)
then go to mysql table (there stands a database called mysql)
go to users
and by root you see this text
change that to
now you still cant acces it because you dont have the root pass of mysql (its a random generated password o.O)
so go to the button in whm that says , change mysql root pass
click it , fill in your nice pass and restart mysql (press that button)
now in meantime you downloaded navicat
open navicat and click new host
add your ip to it with those parameters
Code: Select all
ip = your host
username = root
password = your fresh password
if that is done and succesfull then you can see your complete database from all your users
then open your table of your user account (your user upload with table XFS for example)
so open upload_XFS
then select everything with the shift key
press right click
press repair
press extended repair
you see a popup with a progress bar and a lot of info that says what tables are corrupt and what are fine
normal if the damage isnt to bad then it repairs invalid tables
if that is done , upgrade again and lets do the mysql security again
repead above steps of how you gain conection and change it back to localhost
press reset mysql pass and your done
mysql is repaired on the easy way and your db is back secure
Greets From PowerChaos