#mysql
13 November 2007
Total 28 pages. You are browsing page 3/28.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
01:32 <****> you guys use anything for osx?
01:32 <****> ok, let me rephrase... can someone recommend a good GUI program for linux (preferably free) for browsing/editing a SQL database? :)
01:32 <****> select field from table where field like 'abc%';
01:32 <****> isn't navicat pretty expensive?
01:32 <****> $100 clams. cheap for easy
01:32 <****> that's not too bad
01:32 <****> abc% says abc is in front of the text?
01:32 <****> testnick2: yes
01:33 <****> has built in ssh connections
01:33 <****> and %abc% would be anywhere?
01:33 <****> testnick2: yeah
01:33 <****> I don't have 100 clams :P
01:33 <****> ok thanks alot
01:33 <****> good thing too
01:33 <****> testnick2: also look for some like lcs algorithms
01:33 <****> cause they want 100 dollars
01:33 <****> pzt2: Works fine for me. Post your SQL.
01:33 <****> testnick2: err there are some c scripts that match for words like schwarzeneggar with schwarzzng
01:33 <****> its all gonna be one wordded plaintext
01:33 <****> and you can set the offset of characters
01:34 <****> well use the free one from mysql and make an ssh conneciton with putty
01:34 <****> to match, pretty cool stuff :)
01:34 <****> twobitsprite: are you on nix?
01:34 <****> envisean: linux, yes
01:34 <****> unfortunately im working with php
01:34 <****> testnick2: I'm sorry to hear that
01:35 <****> http://dev.mysql.com/downloads/gui-tools/5.0.html
01:35 <****> twobitsprite: that's the free stuff from mysql
01:35 <****> you can also match text with regular expressions
01:35 <****> just to clarify: a derived table is similar to a virtual table, and the v1 in this example is an aliasname for the new virtual table?
01:35 <****> aww i <3 php though
01:35 <****> ty for the help
01:35 <****> Cheef-Daniel: Yes.
01:35 <****> testnick2: what's wrong w/ php?
01:35 <****> nothing i said i love it :p
01:35 <****> testnick2: it's got an insane amount of support and it's speed is hard to rival :)
01:36 <****> the unfortunate part was that the script was in C and i dont know C
01:36 <****> www.toadsoft.com Toadsoft is free and full featured also
01:36 <****> Cheef-Daniel: Derived table is the standard name for the construct. Some people/texts refer to it as a virtual table or dynamic view.
01:37 <****> So I got a question for anyone running high load mysql. I have a server doing mean 2000 queries per second. Any recommend some hardware. Mines starting to bog down.
01:37 <****> m/lkp;
01:41 <****> Xgc found my error while i was pasting it :)
01:41 * Xgc nods
01:43 <****> ok now we are down to 3800 rows not the 660 i get from f1 f2 f3 distinct
01:48 <****> pzt2: Could be null related.
01:48 <****> Dauby: you got a second box handling partial load?
01:49 <****> no, mysql and apache on one box. gonna migrate to separate them out though
01:49 <****> gotta pick hardware first though
01:50 <****> mysql is reporting avg query per second 1024 but there is a 6 hour period where it is virtually 100% idle
01:54 <****> pzt2: If you allow nulls in the field making up the unique constraint, you'll run into that problem.
01:54 <****> s/field/fields/
01:55 <****> pzt2: To address that you may need to understand the article I showed.
01:56 <****> I'm allowing around 2.7GB of memory to mysql and letting the server use the rest
01:56 <****> 4GB total
02:00 <****> how do i test the result resource before getting "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource"?
02:01 <****> brick: most likely the query failed
02:01 <****> brick: error capture the mysql_query
02:01 <****> brick: examples available in php manual, i guess it is php
02:01 <****> kimseong, well, i did $resource = mysql_query ( $query ) or die ( "$query failed" . mysql_error() );
02:01 <****> you are correct
02:02 <****> that should work
02:02 <****> hrm...
02:04 <****> i think it is happening when my query is an INSERT and there is no result
02:04 <****> if no result why you do fetch the result?
02:04 <****> Xgc i dont think this is what i was looking for i am looking at the new table and instead of the text in one of the f3 it added the number of the times it was there
02:05 <****> brick no idea how to differentiate, maybe there is a way
02:05 <****> kimseong, i'm trying to use a wrapper function for all my db calls
02:05 <****> maybe i need to make a second one
02:05 <****> mysql_fetch_rows will tell you how many were inserted
02:05 <****> brick: i guess phpmyadmin can do it, maybe you can check out phpmyadmin code
02:06 <****> Dauby: it is not known if it is select or insert or anything else
02:06 <****> thanks Dauby, kimseong
02:06 <****> pzt2: Not possible, unless you decided to count or perform some aggregate calculation.
02:06 <****> It will tell you if it is either eh?
02:07 <****> pzt2: Post the SQL.
02:09 <****> Xgc i have to get going are you around this time here usually?
02:09 <****> arg, I mean mysql_affected_rows
02:09 <****> pzt2: I'm usually connected 24/7, but during sleep or work hours I'm not always responsive.
02:10 <****> ok thank you i will try and reach you
02:10 <****> pzt2: You can usually see me in the last 3 or 4 hours.
02:10 * Xgc nods.
02:19 <****> jbalint?
02:20 <****> what command is used to add a host to a user?
02:23 <****> mad: grant
02:23 <****> deadroot: ty
02:30 <****> Hello, if I offer through a user (somewhat public) page access to custom mysql queries, and they each have their own database selected, is it possible for them through an exploit/bug/etc to sellect a different DB or cause any damage to other databases other than their own?
02:32 <****> Hey, i'm having a problem
02:32 <****> http://jtaby.com:82/dump/Picture%201.png
02:32 <****> that picture shows you the query (top left), the db (top right) and the query results (bottom left)
02:32 <****> it should return 2 rows
02:32 <****> zaatar: PNG's no good with with such colourful screenshots :)
02:32 <****> vladuz, there is always the possibility of sql injection if steps are not taken
02:32 <****> deadroot: hi
02:33 <****> Dauby: yes, however, can they access other databases?
02:33 <****> jbalint: could i pm you?
02:34 <****> deadroot: yeah
02:34 <****> not if they are restricted by host and user/pass
02:35 <****> Dauby: I have this: php script that selects a db and lets the user run custom queries in that db. Can they do any damage/insert/etc to other databases on the same host?
02:36 <****> zaatar: try bracketing the OR statement
02:36 <****> !m vladuz grant
Total 28 pages. You are browsing page 3/28.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last