Ran repair.php to optimize database and messed up everything. ..

[ryancooper]

Hopefully someone here can help me so i do not have t ogo redo 2 years of work. I had a huge database 2.7 gigs and had to try to shrink it so I ran repair.php.

now I am recieveing the following error. . .


Database error in vBulletin 2.2.6:

Invalid SQL: SELECT post.postid, post.userid, post.pagetext, post.topic, user.username as username, attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
FROM post LEFT JOIN user ON (post.userid = user.userid) LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE threadid=11529 ORDER BY postid LIMIT 1
mysql error: Can't open file: 'post.MYI'. (errno: 144)

mysql error number: 1016

Date: Wednesday 09th of April 2003 06:46:31 PM
Script: http://www.talkdisney.com/forums/
Referer:


Please can anyone help?? :dead:

[amykhar]

Close your board.

Log into SSH and run the command you see in this post:

http://www.vbulletin.com/forum/showpost.php?postid=403894&postcount=3

Note: Don't put a space between the -u and your username and the -p and your password. It should look like -umyusername -pmypassword

Hope that helps.

Amy

[ryancooper]

Thank you so much amy, I will give it a try. . .

[ryancooper]

I get the following error:

You should give only options, no arguments at all, with option
--all-databases. Please see mysqlcheck --help for more information.
bash-2.05$
\
So i checked the mysqlcheck --help and saw a option for (true or false)

OK so i tried

mysqlcheck -o -u root -p --all-databases=true and got

bash-2.05$ mysqlcheck -o -utalkdis_ryancoop root -p******** --all-databases=true
mysqlcheck: Got error: 1044: Access denied for user: 'talkdis_ryancoop@localhost' to database 'root' when selecting the database

username and pass are correct. . ???

[Edit: I took out your db password. No sense letting everyone know what it is. - Steve]

[amykhar]

you have a space between the -u and root.

Amy

[ryancooper]

ahh I thought i copied it exactly. Will try again. Thank you so much for your help. . . :)

Question. . .

mysqlcheck -o -u root -p --all-databases

is what is says to run so I need

mysqlcheck -o -uUSERNAME root -pPASSWORD --all-databases

or

mysqlcheck -o -uUSERNAMEroot -pPASSWORD --all-databases

no space -uUSERNAMEroot

[amykhar]

mysqlcheck -o -uroot -p(put your password here) --all-databases

Amy

[ryancooper]

ahh thanks. . . will try. ..