I accidentally deleted the database, what can i do?

[mtcarpenter]

I was trying to install a message board, couldn't get the mysql stuff to work so i thought it'd be better to get the databases organized and delete what I thought I didn't need.....

 

well it turns out i had the database for the store labeled "Auctions"....so thinking it was a database created at an old attempt of mine to put up a auction site i deleted it....now...the store is not functional

 

i get the following error

1146 - Table '*databasename*.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

[MartinM]

Did you ever make a backup?

[mtcarpenter]

well I pay another person for hosting, i don't own the server in my house.....

 

so would they probably have backed it up?

 

I didn't manually do anything, i don't even see any spot to save a database unless you do it in the phpmyadmin part

[Jack_mcs]

There is a backup/restore option in admin->tools->backup. If a backup was done using that option, then there will be a file in admin/backups. If that exists, you can restore your database using that file. Otherwise, you will have to start over with a fresh database.

 

Jack

[MartinM]

well I pay another person for hosting, i don't own the server in my house.....

 

so would they probably have backed it up?

 

No idea, I'm afraid. Doesn't hurt to ask.

 

I didn't manually do anything, i don't even see any spot to save a database unless you do it in the phpmyadmin part

 

For future reference; you can use phpMyAdmin to backup your database, but you can also do it through osC's admin area. Just go to admin -> Tools -> backup. It's pretty much self-explanatory from there, as is restoring any backups you make in this way.

[mtcarpenter]

well the most recent thing i see there is

*database name*-20051130144750.sql

 

is that what i'm looking for?

 

and also is there a chance my host could've saved something yesterday? or is the /admin/backup the only backup optino?

[Jack_mcs]

You should use the one that is most recent.

 

Jack