I apologize in advance for the stupidity of this but maybe the task will be interesting for someone.<p>I'm a web designer who's setting up a Wordpress site for a client. Our hosting situation is not good and the sysadmin is not helpful.<p>There are two rows in a specific table of the Wordpress site that I need to edit in order to get it working, however I don't have phpmyadmin or another gui to edit the DB. I'm able to remote desktop into the server with the DB on it, but I have no idea what to do with the .FRM and .MYD files. I'm in way over my head on this one and the sysadmin's not interested in helping.<p>Anyone have 10 minutes to troubleshoot this over gchat?
How quick this was answered/people helped is remarkable. Kudos to the HN community! Maybe there's a startup idea here - or maybe it already exists. Typically I spend hours searching for answers online to programming/tech questions or I end up chatting to a guru friend of mine - for the answers.
My advice - leave the .FRM and .MYD files well alone. If you can remote desktop in (is it running on a windows server?) then bring up a command prompt and edit it using that. Have a look at this - <a href="http://www.makeyougohmm.com/20040609/806/" rel="nofollow">http://www.makeyougohmm.com/20040609/806/</a><p>My second piece of advice would be to get a better host and sysadmin...
The server should have the standard cmdline MYSQL admin installed on it (one imagines).<p>Try opening a command prompt and running:<p><pre><code> mysqladmin
</code></pre>
[obviously with username and password]
If it is there us should let you run the SQL commands you want. (ref: <a href="http://www.manpagez.com/man/1/mysqladmin/" rel="nofollow">http://www.manpagez.com/man/1/mysqladmin/</a>)<p>If you want an SQL prompt then mysql on the commandline (will 100% be there) will work<p><pre><code> mysql -u <user> -p <password>
</code></pre>
<a href="http://www.manpagez.com/man/1/mysql/" rel="nofollow">http://www.manpagez.com/man/1/mysql/</a>