Wordpress databases gone...

Hi..
Yesterday my wordpress site's database accidentally deleted so I have the site with just interface but not the posts.
Today I extract the database .sql file and tried phpmyadmin to upload it to the database.It is 200mb .So, every time I open the .sql and try to paste into the database, computer goes hang.
Is there any other ideas so that I could upload the .sql file easliy.
Thanks.

bikram,baglung

 

No wonder, the db is 200mb !!!! Just upload it using ftp and import into phpmyadmin using the bigdump script (http://www.ozerov.de/bigdump.php)

 

Whippet75,
I have gone to the site but couldnot understand how to do it?
Could you plz give me the simple steps?
Thanks.

 

And also Whippet75,
where(in which folder)should I have to upload the .sql file?

 

Dude Simple Stuffs Crazy Guy....

Go to PhpMYAdmin

Select Your database

take import

You get an option to upload the database

Upload as SQL text file, or as ZIp, or tar

It will validate the Database and all the stuffs would be back..!

If you are not sure to do these things, Rent Some one to do that

 

Please check out ur system first. If you do step by step then it would posssible to upload 200 mb data. Upload 100mb rest later.

 

Thanks for giving the steps for uploading sql files...!!

 

if u have shell access use mysql shell to import the file thats fast and better solution