mikebreeze

I could not get access to the WP database via command line. I was able to ssh to the server, I found the login/pwd in the php-config file. However, when I tried to access the database I got a socket error. So it looks like one can only access the WP database from the WP dashboard. And I was told by GoDaddy that you can’t rename tables in WP. I worked with GoDaddy half of Monday trying to delete staging and sync production back to staging. But it would not sync because of the corrupted tables. So I ended up “resetting” the production server (essentially blowing it away) and started from scratch. Thank goodness this is a very simple site so I think that I can get it back up quickly. The last few weeks have not been fun..

Now I’m really in trouble. I had planned on deleting my staging server tomorrow and recreate/sync my production server to staging next week. However, today I logged into my production dashboard and saw that the wp Google Maps plugin needed to be updated. I did and it broke my production server. I’ll notify the authors of this plugin. I will also call GoDaddy tomorrow to see if they can’t help me fix production. Happy Thanksgiving.

Is PHPMYADMIN the plugin by Puvox Software? Can one access the database tables within WordPress via command line using mysql -u username -p ? I’m debating whether to go the plugin route or just have godaddy.com blow away my present staging server, reinstall it and just copy everything over from production. I’ve read that the repair command only works about 50% of the time for corrupted tables. Your thoughts?