#mysql
29 September 2007
Total 14 pages. You are browsing page 3/14.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
01:25 <****> a database users password, that is
01:25 <****> !help
01:25 <****> help
01:25 <****> !m [name] [function] !man [function] !m41 !m50 !m51 !man !man41 !man50 !man51 !manmt !manndb !manqb manwb see aide (fr) hilfe (de) ayuda (es)
01:25 <****> !manndb ndb_init
01:25 <****> Sorry - I have no idea what function you're talking about! but try http://dev.mysql.com/ndb\_init
01:25 <****> !manndb ndb
01:25 <****> see http://dev.mysql.com/doc/ndbapi/en/overview-ndb-record-structure.html
01:25 <****> seekwill: the first thing it seems to do is run this mysql_safe. which in that my.cnf file it has a setting called nice=192.168.0.2. I was asking if that should be this box's IP. Becasue that is not it.
01:25 <****> Shrews iirc the ndb stuff got mangled
01:26 <****> archivist: really?
01:26 <****> !manndb ndb_cluster_connection
01:26 <****> see http://dev.mysql.com/doc/ndbapi/en/class-ndb-cluster-connection-get-next-ndb-object.html
01:26 <****> seems to work well enough
01:26 <****> excessive doc changes /me not updating the xml reader
01:26 <****> err, actually
01:27 <****> yeah, that's a bit off
01:27 <****> the buggers never put anything on the doc mailing list
01:27 <****> archivist: no one inside mysql really likes dealing with ndb api :-)
01:28 <****> heh
01:28 <****> or external users ov the xml
01:28 <****> of
01:28 <****> :-)
01:28 <****> gumbl
01:28 <****> eh, gotta run anyway... laters
01:28 <****> grumble
01:29 <****> home time for mee
01:30 <****> i reset the password, but when i try to log in using "mysqladmin" i get the usage
01:31 <****> oh wait
01:31 <****> i don't need to use mysqladmin, just mysql
01:39 <****> hrm
01:40 <****> so if i want to import a sql dump, i can just do something like: mysql -u root -p pass DB < dump.sql
01:40 <****> right?
01:40 <****> yes
01:40 <****> hrm... i am getting the mysql usage
01:42 <****> can you query the whole command to me in a query? maybe I can see why this happens...
01:42 <****> sure
01:43 <****> better in a pastebin
01:43 <****> or ther
01:48 <****> I am having problems with my MySQL server. MySQL use to work but now it was not running. When I tried to load it by "sudo /etc/init.d/mysql start" it fails. If I do "sudo mysqld &" it will load. I am not sure what is wrong. Can anyone help?
01:55 <****> hey ki77a77 you still there?
01:57 <****> is there a way to timestamp a record the first time its inserted i know when we modify the records the timestamp changes
01:57 <****> yes
01:58 <****> can you enlighten me ?
01:58 <****> yes hold on i've forgotten how i do it :P
01:58 <****> insert now() or use timestamp type
01:58 <****> damn
02:06 <****> hmmm
02:06 <****> but will it automatically do it like timestamp ?
02:07 <****> we have ton of scripts empty to that table
02:08 <****> raden_work: the whys and wherefors of timestamp: http://dev.mysql.com/doc/refman/5.0/en/timestamp.html
02:09 <****> NemesisD: I am here
02:09 <****> ki77a77, much appreciated bro : )
02:09 <****> (though simulataneously watching Fast Money)
02:12 <****> 90GB
02:12 <****> well it works then
02:13 <****> a bug if it did not
02:13 <****> erm
02:13 <****> <
02:14 <****> NemesisD: of course, you're using text, so you'll have problems with 1, 2 and 3 digit comparisons"
02:14 <****> as I said earlier store the number in an int, partly that is to sort numericly
02:15 <****> and to make searching ranges easy
02:15 <****> ki77a77, ah, and there's no way around that other than turning the field to a tinyint and taking off the GB part?
02:15 <****> or a space to fix the text order
02:15 <****> NemesisD: not without a crapload of application code.
02:16 <****> ah a space will do it?
02:16 <****> '100' ' 90'
02:16 <****> better to use 2 fields
02:16 <****> ;^) wow, that's ugly
02:17 <****> hmm
02:19 <****> allways more than one way of skinning a cat, an ugly way and the right way
02:21 <****> I thought all skinned cats were ugly
02:24 <****> I have fields a, b, c, and d, along with 'user' and 'time'. Is there a single sql query I can use to get the most recent a, b, c, and d where a, b, c, and d are not 0 (eg there could be 15 rows, and a could come from a different row than b)
02:24 <****> Or am I better off to get each one with a separate query
02:25 <****> Could someone point me in the direction of a tutorial that explains what views are and how best to use them?
02:26 <****> ]views
02:26 <****> Hmm, never mind ;)
02:27 <****> No, but good try :D
02:27 <****> !views
02:28 <****> view
02:28 <****> views
02:28 <****> VIEWs are in the manual at http://dev.mysql.com/doc/mysql/en/create-view.html and in the forums at http://forums.mysql.com/list.php?100
02:32 <****> Does mysql support clustered keys?
02:37 <****> how do i create a mysql user with access to only one particular database?
02:37 <****> i keep seeing *.* in all the GRANT examples i come across
02:39 <****> oh wait, dbname.*
02:39 <****> cool
02:45 <****> theshadow: are clustered keys the same as composite keys?
02:45 <****> hi
02:46 <****> is there any limit to insert binary value? and how to change it?
02:48 <****> http://dev.mysql.com/doc/refman/5.0/en/data-types.html
02:48 <****> thx
02:57 <****> ugh
02:58 <****> i keep locking myself out of mysql
02:58 <****> i renamed the root account, but now cannot seem to log back into mysql
02:59 <****> hey guys
03:00 <****> anyone was on sox compliances?
03:19 <****> i'm using mysql 5.1 and i heard you can configure mysql to not store all table data in memory... anyone know what configuration that is?
03:31 <****> looking for recommendations on graphical mysql clients for windows
03:33 <****> rawake: Out of curiosity... why would you want to do that? :|
Total 14 pages. You are browsing page 3/14.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last