Problem with restoring database

[yongsan]

Hi,

 

I have an account with OScommerce installed but it accidently got deleted recently including the database as well. Now I tried to restore the account and restored the database from backup. This backup is a backup of the whole server by rsync not the backup option in OScommerce.

 

Now I have an error when I tried to launch the OScommerce:

 

1016 - Can't open file: 'configuration.ibd' (errno: 1)

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

Please advise...

 

Thanks

[yongsan]

No one has any solutions?

[Barbie]

No one has any solutions?

 

Looks like your database file is corrupt and needs to be repaired.

 

The following SQL statement can be executed when the database server is still running. Be sure to put in your database table name:

 

repair table <database table name>;

 

For more help go to SOLUTIONS/DOCUMENTATION/ and do a search for error 1016 (or any other for that matter) and you will find detailed explanations that could be useful.

[yongsan]

Looks like your database file is corrupt and needs to be repaired.

 

The following SQL statement can be executed when the database server is still running. Be sure to put in your database table name:

 

repair table <database table name>;

 

For more help go to SOLUTIONS/DOCUMENTATION/ and do a search for error 1016 (or any other for that matter) and you will find detailed explanations that could be useful.

 

Hi,

 

Thanks. Tried doing the repair...

 

mysql> repair table address_book;

+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table | Op | Msg_type | Msg_text |

+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| sgcondo_osc.address_book | repair | error | Can't open file: 'address_book.ibd' (errno: 1) |

+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.02 sec)

[Barbie]

Hi,

 

Thanks. Tried doing the repair...

 

mysql> repair table address_book;

+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table | Op | Msg_type | Msg_text |

+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| sgcondo_osc.address_book | repair | error | Can't open file: 'address_book.ibd' (errno: 1) |

+----------------------------------------------------------------------------------------------------------------------------------+------------+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.02 sec)

 

 

Where did you get 'address_book.ibd' ... the extension.ibd is not in any files I know.