I have a 400 MB Wordpress Database file that was on different domain name and Now I have installed a New Wordpress Blog and I want to restore the Posts and Categories only from the Old Database File, Is this possible ? Also How can I do it in the easy way, please guide me with details.
If you have latest version of Wordpress you can export the posts, pages, comments, custom fields, categories, and tags from wordpress admin. Login to you blog as an admin and go to tools -> Export. I never tried to export 400 MB but I think it should work. Kailash
You can try to open the SQL file with wordpad and manually edit things into smaller chunks (don't use notepad or a wimpy cpu & be prepared to sit awhile)... or look for a PHP file called bigdump to assist you.
If you have only SQL file then just create a blank database and restore your MySQL contents and then you will need to replace the domain name with your new domain name in the tables. You can use search functionality from PHPMyAdmin or other tool which you are using to manage your MySQL database to search from your database. Kailash