Data dump problems - HELP!

[Ludachris]

HostRocket just suspended my account and I'm trying to get my VB database downloaded. When I do a dump, this is what the file has in it:

<br>
<b>Warning</b>: Supplied argument is not a valid MySQL result resource in <b>/usr/local/apache/htdocs/phpMyAdmin/libraries/build_dump.lib.php</b> on line <b>74</b><br>
<b>Error</b>
<p>
SQL-query&nbsp;:&nbsp;
<pre>
SELECT * FROM `dsmtune_forums`.`searchindex`
</pre>
</p>
<p>
MySQL said: <br />
<pre>
Can't open file: 'searchindex.MYD'. (errno: 145)
</pre>
</p>
<a href="tbl_properties.php?lang=en&amp;server=1&amp;db=dsmtune_for ums">Back</a>

</body>

</html>


This is the only database that gives me this error. Does this mean I'm screwed? HostRocket will likely not do anything to help, as they haven't done much for me at all up to this point anyway. Any help would be greatly appreciated. My site is down until I get this all uploaded to a new host. Obviously I wouldn't recommend HostRocket.

[Steve Machol]

The searchindex table is corrupted. You can fix this by uploading repair.php to your forum direcotry (it's in the 'extras' folder of the zip file) and running it from your browser. Use this syntax:

repair.php?html=1&check=1

[Ludachris]

The problem is I no longer have ftp access to my site. Is there a way to rebuild that table?

[Steve Machol]

How do you plan to move your database if they won't allow you ftp access? Do you still have access to CPanel? Couldn't you use this to upload repair.php. If you can't upload, then obviously you won't be able to download your db anyway.

[Ludachris]

Well, it's strange, but I still have access to phpMyadmin, where I can do a dump of the database. But I can't upload anything via ftp.

What I ended up doing was just emtying the searchindex table so I could download the db before I lost access to that too. I hope I can rebuild that table somehow...

[Steve Machol]

I was just going to suggest emptying the search index. Once you move your database to the new host you can rebuild it again.

[Ludachris]

Thank god!

Smachol, would you be willing to send me an private message/email on exactly how to rebuild it? Or can I find it somewhere in this forum?

Thanks so much.

[eva2000]

Originally posted by Ludachris
Thank god!

Smachol, would you be willing to send me an private message/email on exactly how to rebuild it? Or can I find it somewhere in this forum?

Thanks so much. to rebuild

vB admin control panel -> update counters -> empty index button and then hit reindex searchindex (make sure you do this at the least busy period during the day and with your forum closed)

[Steve Machol]

Yeah, what George said! ;)

[Ludachris]

Thanks guys, it's done.

[eva2000]

Originally posted by Ludachris
Thanks guys, it's done. no probs :)