I know how to export and import wordpress blog posts,pages&details to a new domain or blog. But as of now I lost my wordpress blog connection for the old blog. I need to know what all I need to copy and paste to my new blog keeping all the previous contents using FTP and not using wordpress dashboard.
Yes you can do it copy all files on wp-upload folder and put them in new wordpress folder using FTP . Then you are done !! ENJOY
NO, the post above me is very wrong be careful, the posts won't be displayed or anything if you just copy, you need to Dump and Restore the MYSQL backup to successfulnessly transfer a blog, you can't just use FTP, well, you can dump the MYSQL And fetch it with FTP, but you need to restore it with phpmyadmin or MYSQL Command Line.
don't forget your plugins and theme in wp-content/plugins, wp-content/themes, .htaccess, robots.txt, wp-config.php in root as well
When I tries to import the mysql its showing ERROR 1062 (23000): Duplicate entry '113715-303' for key 2 What to do now?
Do you want to do this repetitively ( i.e mirroring sites ), or just once ? If only just once why not using the default export and import ? Your blog post, pages, and contents ( except images, and files ) are stored on the database, you need to dump the corresponding tables and then import it. If you find duplicated entry i think its the "Hello word" post ( the default once you've installed wordpress ), remove it ( and the default comment too ) from your new blog and see what happen. Also be careful since the configurations & user management ( login & password ) is on the database too, don't select it or you new blog wont be accessible anymore ( unless you update the config table again .. ).
Using cpanel? If yes then do a full backup, then on the new domain, ask your host to restore the full backup to the new domain. (if you have WHM, then you can do this by yourself.)
actually this is not good method IMO. since you would had your old wp locations still on your config table, and when you load your new blogs on the new domain it wouldn't show ( security stuff ), unless you change/update your wp locations and other necessity config on that corresponding table on database.
My wordpress blog is disabled as I lost my domain,someone stole my domain,so I have to transfer it through the cpanel only.