Strange Backup Problem

New Member Joined: Oct 18, 2002 Posts: 21

Hi There,

Well, I have hit a new problem!

When I went to back up today using Nuke's backup it basically backed it up but the backup file was only 9 kbs, when usually it is around 7Mbs. i opened the file and it appeared to stop and die at the table 'nuke_amazon_cache'. The backup file ends with this:

Code:




# --------------------------------------------------------


#


# Table structure for table 'nuke_amazon_cache'


#





<b>  </b><p>Can't open file: 'nuke_amazon_cache.MYI'. (errno: 145)<br><a href="javascript:history.go(-1)"></a>

When I tried to look at the table via phpadmin, I get this error:

Can't open file: 'nuke_amazon_cache.MYI'. (errno: 145)

Error

SQL-query :

SHOW KEYS FROM `nuke_amazon_cache`

MySQL said:
#1016 - Can't open file: 'nuke_amazon_cache.MYI'. (errno: 145)

Not too sure where to go from here. Any ideas?

Thanks,

ConViCt
[/code]

Posted: Fri Aug 13, 2004 6:39 pm

Try running REPAIR on that table from phpmyadmin if it fails you'll have to recreate it from a backup or scratch.

Posted: Mon Aug 16, 2004 8:57 am

Yes I tried runing REPAIR but it never worked, phpmyadmin kept saying the table was in use.

I basically just deleted the table and created a new one as suggested.

Thanks Six! It is back up and running now.

Hangin' Around Joined: Jul 21, 2004 Posts: 47

That happens to me to sometime(data is missing),i recommend backing it
up again,preferably using phpmyadmin Very Happy