Ask HN: Editing SQL DB via Remote desktop? (minor emergency)
5 comments
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.
StackOverflow?
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...
My second piece of advice would be to get a better host and sysadmin...
[email protected] is the gtalk email address
The server should have the standard cmdline MYSQL admin installed on it (one imagines).
Try opening a command prompt and running:
If you want an SQL prompt then mysql on the commandline (will 100% be there) will work
Try opening a command prompt and running:
mysqladmin
If you want an SQL prompt then mysql on the commandline (will 100% be there) will work
mysql -u <user> -p <password>
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.
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.
it should have mysql - that is part of the standard install package (I think it's auto installed too).
but eyh - your way sounds like a good methid, esp if your happier with a GUI
but eyh - your way sounds like a good methid, esp if your happier with a GUI
connect command: mysql -u<username> -p<password> <database_name>
update command: update <table_name> set <column> = '<your_change>' where <some_column> = <some_condition>;
update command: update <table_name> set <column> = '<your_change>' where <some_column> = <some_condition>;
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?