Help Restoring Database

[eddiev2001]

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 :'(

[ozcsys]

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  :'(

<{POST_SNAPBACK}>

 

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.

[eddiev2001]

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

[ozcsys]

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

<{POST_SNAPBACK}>

 

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.

[Guest]

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 . . .