Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Ask HN: Editing SQL DB via Remote desktop? (minor emergency)

news.ycombinator.com

Post reply on HN
Print view View original

1–10 of 13 posts

Ask HN: Editing SQL DB via Remote desktop? (minor emergency)

#1

Post by mr_bill »

I apologize in advance for the stupidity of this but maybe the task will be interesting for someone.

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.

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.

Anyone have 10 minutes to troubleshoot this over gchat?

Re: Ask HN: Editing SQL DB via Remote desktop? (minor emergency)

#3

Post by ErrantX »

The server should have the standard cmdline MYSQL admin installed on it (one imagines).

Try opening a command prompt and running:

  mysqladmin
[obviously with username and password] If it is there us should let you run the SQL commands you want. (ref: http://www.manpagez.com/man/1/mysqladmin/)

If you want an SQL prompt then mysql on the commandline (will 100% be there) will work

  mysql -u  -p
http://www.manpagez.com/man/1/mysql/

Re: Ask HN: Editing SQL DB via Remote desktop? (minor emergency)

#4

Post by piers »

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 - http://www.makeyougohmm.com/20040609/806/

My second piece of advice would be to get a better host and sysadmin...

Re: Ask HN: Editing SQL DB via Remote desktop? (minor emergency)

#5

Post by piers »

piers wrote: post #4

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 - http://www.makeyougohmm.com/20040609/806/ My second piece of advice would be to get a better host and sysadmin...

email@piersonthe.net is the gtalk email address

Re: Ask HN: Editing SQL DB via Remote desktop? (minor emergency)

#7

Post by flooha »

piers wrote: post #5
piers wrote: post #4

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 - http://www.makeyougohmm.com/20040609/806/ My second piece of advice would be to get a better host and sysadmin...

email@piersonthe.net is the gtalk email address

Invited you on google talk, but you're listed as not connected.

Re: Ask HN: Editing SQL DB via Remote desktop? (minor emergency)

#9

Post by mr_bill »

ErrantX wrote: post #3

The server should have the standard cmdline MYSQL admin installed on it (one imagines). Try opening a command prompt and running: mysqladmin [obviously with username and password] If it is there us should let you run the SQL commands you want. (ref: http://www.manpagez.com/man/1/mysqladmin/ ) If you want an SQL prompt then mysql on the commandline (will 100% be there) will work mysql -u -p http://www.manpagez.com/man…

doesn't appear to have mysqladmin on it.

i've downloaded some mysql guis and am e-mailing them to myself so I can get them onto the server. I found a few portable ones so I don't have to install anything and tick them off.

Post reply on HN