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