While restoring i get Mysql 1136 Error

How old is this backup file? Are you really using WordPress 3.3?

Sorry, im using 3.2.1.
But i dont think that its the problem.
I just backed up today.

How old is this backup file?

As i said.
It’s new, from today.

Why are you trying to restore a backup from today into your site? W3hat did you use to create the backup?

There were some datas to replace.
I just replaced the data but i didnt do anythng wrong.
If you check the link, which i gave, after i do these steps, i get again the error ;

create table user(id int PRIMARY KEY AUTO_INCREMENT, name varchar(10));
–ok

insert into user values(“Hello World”);
–error : #1136 – Column count doesn’t match value count at row 1

I have all my datas restored. But i deleted the code which is for wp_posts.

Now i have restored but they are without my posts.
What can i do now ?

What exactly did you delete?

Mr. Esmi,
As i said……
I didnt delete or add something. I just wanted to restore, what i backed up.

But i deleted the code which is for wp_posts.

What exactly did you delete?

aha..

i restored my database but without wp_posts table..

Well that would certainly create problems…

Yeah, surely… ??

My DB gives errors when i do this steps too ;

create table user(id int PRIMARY KEY AUTO_INCREMENT, name varchar(10));
–ok

insert into user values(“Hello World”);
–error : #1136 – Column count doesn’t match value count at row 1

I think there is either something wrong with your backup file or with the way in which you’re trying to restore it.