| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<Vanzetti> TodoInTX, it's not really for me, it's for AlternC, we develop for the stable version of debian so mysql 4.0
<TodoInTX> remember that if you granted access to a specific database or table you will need to revoke it explicitly as well.. REVOKE ALL ON *.* won't work.
<TodoInTX> that will only do for "global" privileges;
<Vanzetti> ok
<TodoInTX> Vanzetti: do this... SHOW GRANTS FOR user@host;
<TodoInTX> then change GRANT... TO with REVOKE... FROM
<myconid> while(ctype_alpha($value{$sub_string_count}) && $sub_string_count > 0){ $sub_string_count--; }
<myconid> oop
<TodoInTX> then "DELETE mysql.user... "
<Vanzetti> ok TodoInTX
<SMaction> 04 01What method does mysql recommend for connecting apps like Access 2003 to mysql database running on x64 Windows? Since myodbc does not work.
<myconid> Use myodbc
<domas> SMaction: did you try compiling odbc drivers on 64 bit windows? :)
<SMaction> myconid: mydodbc gives error does not work (see previosu posts) domas: I have not I have only used the 32 bit binary that is available. You think that might do it?
<domas> SMaction: well, odbc usually works.
<SMaction> domas: not in this corner of the universe. When I try to connect to the database from Access 2003 using myodbc either from the same (64 bit windows 2003 server) or a remote machine (win 2000 server) I get the "Access has encountered an unexpected error and shutdown....."
<domas> SMaction: that's because it couldn't link properly to binaries, *shrug*
<SMaction> hmmmmm
<rado1> wooo hooo got ndb clusters runnin...ain't bad for a gringo huh
<TodoInTX> shabbs: if mysql didn't log update events into the table and the binlog at the same time then it could still be safe if you logged to a federated table.
<TodoInTX> I'm looking for docs on the logging table still.
<rado1> now I gotta figure out how to get the databases into it
<shabbs> TodoInTX: that's true, but then you'd have to have a seperate instance of mysql running just for logging
<TodoInTX> if it's on another box that would be ideal.
<TodoInTX> think drive failure.
<shabbs> true
<shabbs> would make replication a pain though
<TodoInTX> ya,
<shabbs> and slow
<shabbs> send there, read back, send out again :D
<TodoInTX> shabbs: I think they added this feature just for NDB.
<shabbs> ah
<shabbs> TodoInTX: I can see that option for general/slow query log
<TodoInTX> http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-schema.html
<will> SMaction, I've had the same problem... all 32bit though.
<will> Well, not the same.
<will> Access 2003 crashes when connecting to Linux/MySQL
<Tac_Work> anyone have a link on how I pull the count of something into the query... I want to select from table A based on how many times A.id shows up in table B ......
<t432> is there any way to find out if mysql has been configured properly to work with php5? my php script is not seem to be working I kepping an error
<hydride> http://hashmysql.org/paste/1646, can someone help me with my query
<t432> error: Fatal error: Call to undefined function mysqli_init() in c:\Apache\htdocs\dbconnect.php on line 4
<shabbs> t432: create a script with echo php_info(); and see if there is a mysql section
<t432> ok thx
<shabbs> Tac_Work: use a subquery
<will> t432, You have to get PHP to work with MySQL. Not the other way around.
<domas> !man connector/php
<SQL> (MySQL Connectors) : http://dev.mysql.com/doc/mysql/en/MySQL_Connectors.html
<domas> \o/
<domas> t432: install connector/php !!! :)
<will> hydride, IN? Need =
<Mike> are there major replication enhancements in mysql 5 over 4?
<t432> i how do I check if this connector thing is already installed?
<will> domas, Ah, Windows...
<domas> Mike: in 5.1 - ABSOLUTELY! :)
<mendel> mike: I don't believe so, no
<mendel> domas: What's coming in 5.1?
<domas> row based replication
<mendel> ah
<Mike> oh really? that's awesome, so a lot less lag eh?
<domas> or more.
<domas> depends how you look at it.
<d-o> anyone know how to enumerate databases from the client cli?
<Mike> does it do row-based only with innodb? i ***ume
<domas> d-o: count, one-two-three-..
<domas> Mike: with all
<domas> it's just different type of binlog
<d-o> show databases
<Mike> really? thats cool. might have to schedule an upgrade from 4 when 5.1 is GA
<Mike> thanks for the info
<domas> 5.0 had differences over 4.1 though
<kokoko1> How to check if tables are innodb?
<domas> but minor ones as for replication
<domas> kokoko1: show table status
<kokoko1> Thanks
<ks> how do I create new table based on old one ?
<rado1> my original mysql data dir was /var/lib/mysql. I went to ndb clustering and now my new data dir is /usr/local/mysql/data/
<rado1> how to gracefully get my data back?
<domas> mv
<ks> symlink
<rado1> domas the dir structure seems different now
<kokoko1> domas, the Engine field shows that tables are innodb?
<domas> kokoko1: yes
<kokoko1> oki :)
<M> how would one go about making sure that certain rows in a table are not modified while a table of links to those rows is being updated?
<myconid> syntax for chaining order by's?
<fsweetser> M: brute force method would be to lock the table
<M> the links point to names, rather than ids, so I need to make sure that no names are changed/created/deleted while the links are being created
<domas> myconid: ORDER BY a,b,c
<fsweetser> if you have innodb, you might be able to do row level locking too
<domas> m: SELECT ... FOR UPDATE
<M> fsweetser: I need a somewhat elegant method. right now I'm leaning towards having the app do it, but I'd rather not
<domas> or of course, LOCK TABLES
<Davey> if I do a UNION is there any way to get only those rows found in both SELECTs?
<fsweetser> to truly guarantee it, you're going to have to have the db do some kind of locking
<M> hmm. I need only to prevent the change of the name field
<domas> Davey: isn't it what joins are for? :)
<rado1> rewind...the dir. structure is the same. Could I just step on the new databases and copy my old ones in it's place?
<Davey> domas: perhaps, but I **** at those ;)
<domas> m: you can't lock a cell, just a row
<M> domas: yeah. perhaps the answer is to let the application do it then?
<domas> m: depends.
<TodoInTX> shabbs: I found it... log-output is a new startup option.
<domas> database manages data, it can manage locks on data too.
<M> on if locking the row is really that bad? hmm
<TodoInTX> shabbs: supports "TABLE" , "FILE", "NONE", or a compination of "TABLE,FILE"
<M> (I'm reading up on select for update now, thankyou)
<domas> m: for update? it just means that nobody else will be able to edit the row.
<shabbs> TodoInTX: cool
<birdfish> I just installed mysql. But whenever I try to log into it, I get the error "-bash: mysql: command not found"
<M> domas: that might work for me, I think
<M> or maybe not. I need to prevent the row from being created also
<domas> um, it has next key locking actually.
<domas> but if you want to stop any edits, you can lock the table, sure.
<M> er, next key locking?
<M> I'd rather not lock the table
<Mike> man im just looking at 5.0's new features for the first time. looks effin awesome. is it fully backwards compatible with 4.x?
<domas> join syntax is a bit changed
<fsweetser> mostly
<domas> to be more standard.
<fsweetser> and there's some tweaks to decimal columns
<Mike> uh oh, thats a concern. ill have to look at that
<Davey> so, is there way to only grab the duplicates in a UNION?
<fsweetser> use intersection instead of union?
<Davey> hrm
<Davey> crap, that's alittle hard because I'm hacking around a library
<fsweetser> or (really ugly and slow) group by all of the columns, and select having count > 2
<Davey> hrm, that might work :)
<Davey> but I don't think so :)
<fsweetser> good =)
<Davey> I'm starting to wonder why I'm using a union here. I don't remember why :/
<M> domas: ah, ok, I think I see how next key locking works, thanks
<fsweetser> Davey: hate it when that happens...
<M> now I just have to figure out potential deadlock issues. is there any way to abort a transaction if it encounters a lock?
<{RA}> hello, I can't get a subquery to work: http://hashmysql.org/paste/viewentry.php?id=1647
<fsweetser> first off, ' = NULL ' won't work, you want 'is null' instead
<fsweetser> does that inner query work if you just run it on its own?
<{RA}> ahh yeah, I'm sure that's not the problem
<Jax> ID or Id
<Jax> latter right?
<Jax> prior would be an acronym
<M> ID
<Jax> why
<M> http://www.answers.com/topic/id-4?method=6
<{RA}> IS NULL didn't fix it. Same problem
<Jax> that entry is wrong >;/
<M> if you're talking about very proper naming
<fsweetser> right, it won't throw an error, it just wouldn't return anything
<Jax> i mean ID would imply that it's an acronym
<Jax> but it's not, it means IDentification
<Jax> and not Identification D...
<fsweetser> {RA}: did you try the subquery on it's own?
Return to
#mysql
or
Go to some related
logs:
realtek ac97 package for ubuntu dapper
gentoo gnome cannot mount volume
firstlite drivers
error cannot expand file
package latex ubuntu
#web
emerge+mask+qt4
ubuntu live cd modify grub hd
gnome-btdownload resume
#bash
|
|
