Hi guys, I have this problem. Because I can't log-in to my wp-admin so this means I can't do anything. I need to get all the posts and reinstall the blog and import all the posts again. How do I get the posts by not logging in to my admin? It has something to do with my database I think
In the table wp_users enter your md5-hashed password in the user_pass column. you can easely find md5 encryption tools with a simple search in google.
- Control Panel > phpMyAdmin > Select Database > Export > - Select All tables > Select "Save as file" (Check the compression to "gzipped" if you want) > Go
Found this great article about backing up and restoring Wordpress databases, hopefully this helps! http://www.webdesignerwall.com/tutorials/exporting-and-importing-wordpress/
If you know your database user name and password, you can also access all of your data from an external script. I had to do this once.
I have hosting at godaddy and hostgator. Trying to move wp Mysql is a nightmare. You can't do a simple copy and paste of file and restore is only half the battle. You lose permalinks, widgets and other stuff too. Arrrrrggggg