Help - Deleted my "pixelpost_pixelpost"-table with phpadmin

[Litograph]

Hello,

my problem. I'm not a programmer but i have tried to install
the background-switcher-template from jasonspix. And as i
started i did something stupid: I deleted my table: pixelpost_pixelpost.

Can somebody help me. what should i do?

Many greetings...
i'm desperate

[se.nsuo.us]

Ask your host/ISP if there is a backup and if that can be restored... there usually are backups.

Other than that I guess you have to start all over again

[Litograph]

They don't restore anything. It will cost 200€.

Is it possible to reedit the deleted entry's in phpadmin?
Who has a draft?

What can i do?
i'm really sad...

And if i can't change the php-files, what should i do then
as my first step?

thanks

[Connie]

well, it would be interesting for me to know how you managed to delete a PP_table when updating / uploading another template or so

when you want to administer PP, you will never never have the need to use PHPMyadmin, everything relevant for PP is done through the admin area

now I see that you lost one table but not all?

you can re-create the table by PHPAdmin:
open the SQL in the SQL-area:

a) if you use no special prefix for PP-tables, use this code:

CREATE TABLE IF NOT EXISTS pixelpost (
id int(11) NOT NULL auto_increment,
datetime datetime NOT NULL default '0000-00-00 00:00:00',
headline varchar(150) NOT NULL default '',
body text NOT NULL,
image text NOT NULL,
category varchar(150) NOT NULL default '',
KEY id (id))

b)
if you used a prefix for the PP-tables, use this code:
CREATE TABLE IF NOT EXISTS prefix_pixelpost (
id int(11) NOT NULL auto_increment,
datetime datetime NOT NULL default '0000-00-00 00:00:00',
headline varchar(150) NOT NULL default '',
body text NOT NULL,
image text NOT NULL,
category varchar(150) NOT NULL default '',
KEY id (id))

this at least will re-create your table, but all the blog-entries will be gone

what to do?

From my experience, I would say this is quite helpful, because we germans say aus Schaden wird man klug (any damage makes you more clever)
and you have learned that you never never will delete any table in a database accidentally

and the next step, for the future:
you can do backups of your tables with PHPAdmin yourself, so you are not in risk or dependant from your hoster:
you can export your tables in SQL-format, using :

Structure:
check "Add IF NOT EXISTS"
check "Add AUTO_INCREMENT value"

Data:
check "Extended inserts"
export type "INSERT"

save as file, zipped...

when an accident occurs, you can reconstruct that table which is in problem..

[Litograph]

...ich bin auch Deutscher... aus München.
Und ich hab schon mit Jason Spix gemailt. Hatte sein Template ausprobieren wollen und dabei aus versehen die Tabelle gelöscht.

[eon]

...ich bin auch Deutscher... aus München.
Und ich hab schon mit Jason Spix gemailt. Hatte sein Template ausprobieren wollen und dabei aus versehen die Tabelle gelöscht.

But this forum is English. ;)

... I am also from Germany ... from Munchen.
And I have already asked Jason Spix.... Sorry the rest is to difficult to translate.

[Connie]

...ich bin auch Deutscher... aus München.
Und ich hab schon mit Jason Spix gemailt. Hatte sein Template ausprobieren wollen und dabei aus versehen die Tabelle gelöscht..

he mailed already Jason Spix. He wanted to test Jason's template and by that by mistake he deleted the table


I am still wondering how it is possible to delete a table when changing templates? It's a mystery for me..

[Litograph]

Hi,

i had read over the WARNING-message "Delete Table...blablabla". I just wanted to delete the field. And so the problem starts.

But now everything is allright again. AND i know now how to install the colorchanger.

AND yes i know that this is an English forum....unfortunately ;-)

[Connie]

AND yes i know that this is an English forum....unfortunately ;-)

it would be possible for sure to have a german section here in the forum if there were more german users ...

stop, we have a lot of german users

.... more german users willing to volunteer ;=)

I do not want to do everything :=)

but at www.blimage.de you find a community of photobloggers and there is PP discussion as well! in german

tschüß,

Connie

[Litograph]

Yes, this would be a good thing.... but the problem is that i will only be the asking one ;-)

Blimage? a okay, lets visit ....