Re: Capitalize Input via Auto Complete?
On Wed, Sep 15, 2010 at 12:50 AM, Daevid Vincent dae...@daevid.com wrote: You do know you can use ssh tunnels and such to connect to your server from your desktop right? I do it all day long. It's pretty easy to do and built in to these programs. You can't multi-jump, though. Yes, that's common in my environment :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: Capitalize Input via Auto Complete?
Johan De Meersman wrote: On Wed, Sep 15, 2010 at 12:50 AM, Daevid Vincent dae...@daevid.com wrote: You do know you can use ssh tunnels and such to connect to your server from your desktop right? I do it all day long. It's pretty easy to do and built in to these programs. You can't multi-jump, though. Yes, that's common in my environment :-) What do you mean by multi-jump? I commonly set up a tunnel to the SSH server at the office and then another tunnel from that server to my development rig, so I can run MySQL WB at home on my database at work. Is that what you mean? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Capitalize Input via Auto Complete?
On Wed, Sep 15, 2010 at 3:39 PM, george larson george.g.lar...@gmail.comwrote: I commonly set up a tunnel to the SSH server at the office and then another tunnel from that server to my development rig, so I can run MySQL WB at home on my database at work. Is that what you mean? Pretty much, yeah. I've not got just the one database, though, so it's usually too much of a bother to set up all the tunnels, and I just SSH straight through and use the commandline :-) Still, the SSH tunnel capability in the client is nice for hosts that are only one jump away. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
GRANT ALL error - newbee
I'm attempting to set up a Linux Apache Mysql PHP (LAMP) system for the first time. On my internal network (behind firewall) I have a computer (cruncher) that is acting as the web server. Another computer (supercrunch) is being used as the home for Dupal6. I connected to the cruncher system from supercrunch with mysql -u root -h cruncher -p. This seemed to work fine. But, one of the setup statements follows along with the result. I can't find the error. Help! mysql GRANT ALL PRIVILAGES ON *.* TO 'g...@supercrunch' IDENTIFIED BY 'password' WITH GRANT OPTION; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRIVILAGES ON *.* TO 'g...@supercrunch' IDENTIFIED BY 'qatip' WITH GRANT OPTION' at line 1 Leaving out the quotes makes no difference. Gary R -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: GRANT ALL error - newbee
On Wed, Sep 15, 2010 at 12:10 PM, Gary Roach gary719_li...@verizon.netwrote: I'm attempting to set up a Linux Apache Mysql PHP (LAMP) system for the first time. On my internal network (behind firewall) I have a computer (cruncher) that is acting as the web server. Another computer (supercrunch) is being used as the home for Dupal6. I connected to the cruncher system from supercrunch with mysql -u root -h cruncher -p. This seemed to work fine. But, one of the setup statements follows along with the result. I can't find the error. Help! mysql GRANT ALL PRIVILAGES ON *.* TO 'g...@supercrunch' IDENTIFIED BY 'password' WITH GRANT OPTION; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRIVILAGES ON *.* TO 'g...@supercrunch' IDENTIFIED BY 'qatip' WITH GRANT OPTION' at line 1 Leaving out the quotes makes no difference. Gary R Gary, if that is the actual command, you've misspelled PRIVILEGES. HTH, David
RE: GRANT ALL error - newbee
PRIVILAGES should read PRIVILEGES -Original Message- From: Gary Roach [mailto:gary719_li...@verizon.net] Sent: Wednesday 15 September 2010 19:11 To: mysql@lists.mysql.com Subject: GRANT ALL error - newbee I'm attempting to set up a Linux Apache Mysql PHP (LAMP) system for the first time. On my internal network (behind firewall) I have a computer (cruncher) that is acting as the web server. Another computer (supercrunch) is being used as the home for Dupal6. I connected to the cruncher system from supercrunch with mysql -u root -h cruncher -p. This seemed to work fine. But, one of the setup statements follows along with the result. I can't find the error. Help! mysql GRANT ALL PRIVILAGES ON *.* TO 'g...@supercrunch' IDENTIFIED BY 'password' WITH GRANT OPTION; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRIVILAGES ON *.* TO 'g...@supercrunch' IDENTIFIED BY 'qatip' WITH GRANT OPTION' at line 1 Leaving out the quotes makes no difference. Gary R -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=azzopa...@eib.org Les informations contenues dans ce message et/ou ses annexes sont reservees a l'attention et a l'utilisation de leur destinataire et peuvent etre confidentielles. Si vous n'etes pas destinataire de ce message, vous etes informes que vous l'avez recu par erreur et que toute utilisation en est interdite. Dans ce cas, vous etes pries de le detruire et d'en informer la Banque Europeenne d'Investissement. The information in this message and/or attachments is intended solely for the attention and use of the named addressee and may be confidential. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error and that any use of it is prohibited. In such a case please delete this message and kindly notify the European Investment Bank accordingly. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
extract text from table to file, and recover damage.
Hello I am still fighting with the crashed hard disk and its db. I had a look at the tables mysql -u wikiuser -p maqwiki and then select * from searchindex (This is the only table which seems to have useful information.) However the information is written so fast on the screen that it is impossible to read, I also can scroll since a lot of --- Lines are produced. - how can I write the result of the above command to file? The obvious does not work. I think I see stuff like anu8c3a1lisis which makes me thing the table is corrupted, of course it could be also the UTF8 representation of the word análisis. Anyhow I run a mysqlcheck -u wikiuser -p maqwiki searchindex And got: maqwiki.searchindexOK Is this proof enough that the table is ok? Uwe Brauer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: extract text from table to file, and recover damage.
if on unix/mac: $ echo select * from searchindex | mysql -u wikiuser -p maqwiki myfile.txt you can probably do something similar on windows.. On Wed, Sep 15, 2010 at 4:00 PM, Uwe Brauer o...@mat.ucm.es wrote: Hello I am still fighting with the crashed hard disk and its db. I had a look at the tables mysql -u wikiuser -p maqwiki and then select * from searchindex (This is the only table which seems to have useful information.) However the information is written so fast on the screen that it is impossible to read, I also can scroll since a lot of --- Lines are produced. - how can I write the result of the above command to file? The obvious does not work. I think I see stuff like anu8c3a1lisis which makes me thing the table is corrupted, of course it could be also the UTF8 representation of the word análisis. Anyhow I run a mysqlcheck -u wikiuser -p maqwiki searchindex And got: maqwiki.searchindex OK Is this proof enough that the table is ok? Uwe Brauer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: extract text from table to file, and recover damage.
You could try SELECT ... INTO OUTFILE ... Also, if you just want to look at the data a page at a time, try setting your pager variable to your favorite pager program. mysql pager /usr/bin/less and unset it with \n mysql \n -Travis -- From: Uwe Brauer o...@mat.ucm.es Sent: Wednesday, September 15, 2010 2:00 PM To: mysql@lists.mysql.com Subject: extract text from table to file, and recover damage. Hello I am still fighting with the crashed hard disk and its db. I had a look at the tables mysql -u wikiuser -p maqwiki and then select * from searchindex (This is the only table which seems to have useful information.) However the information is written so fast on the screen that it is impossible to read, I also can scroll since a lot of --- Lines are produced. - how can I write the result of the above command to file? The obvious does not work. I think I see stuff like anu8c3a1lisis which makes me thing the table is corrupted, of course it could be also the UTF8 representation of the word análisis. Anyhow I run a mysqlcheck -u wikiuser -p maqwiki searchindex And got: maqwiki.searchindexOK Is this proof enough that the table is ok? Uwe Brauer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=travis_...@hotmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org