Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help Restoring Database


eddiev2001

Recommended Posts

Hey guys , i tried restoring a database i had with newly updates zones but got the following error.

1146 - Table 'dwain_kitchi.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

Can anyone tell me how i can restore my old DB as i'm no longer able to access the admin portion of the site

 

thanks

Eddie :'(

Link to comment
Share on other sites

Hey guys , i tried restoring a database i had with newly updates zones but got the following error.

1146 - Table 'dwain_kitchi.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

Can anyone tell me how i can restore my old DB as i'm no longer able to access the admin portion of the site

 

      thanks

          Eddie  :'(

 

FTP you latest backup to your local computer.

 

Use phpmyadmin from your hosting control panel. Go to the sql tab, click on browse and drill down to your latest backup and click on go.

The Knowledge Base is a wonderful thing.

Do you have a problem? Have you checked out Common Problems?

There are many very useful osC Contributions

Are you having trouble with a installed contribution? Have you checked out the support thread found Here

BACKUP BACKUP BACKUP!!! You did backup, right??

Link to comment
Share on other sites

I've located a previous backup i had made, FTP it to my local computer , ran phpmyadmin and then under the sql tab i selected my file and ran go. After these steps i exported the DB and reuploaded back and was unsuccessful. Can anyone help ?

1146 - Table 'dwain_kitchi.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

Thanks

Link to comment
Share on other sites

I've located a previous backup i had made, FTP it to my local computer , ran phpmyadmin and then under the sql tab i selected my file and ran go. After these steps i exported the DB and reuploaded back and was unsuccessful. Can anyone help ?

1146 - Table 'dwain_kitchi.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

Thanks

 

Once you run your sql file in phpmyadmin your database has been restored at that point. If the file you used was a good one you should not need to do anything else. Did you check to make sure that the table in the error message is actually in your database? If not that is the problem and you need to run the sql command that came with the contribution that is now asking for that particular table.

The Knowledge Base is a wonderful thing.

Do you have a problem? Have you checked out Common Problems?

There are many very useful osC Contributions

Are you having trouble with a installed contribution? Have you checked out the support thread found Here

BACKUP BACKUP BACKUP!!! You did backup, right??

Link to comment
Share on other sites

this same question he posted in other threads, and the same thing was mentioned in them . . this is i believe one of three threads which were started . . .

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...