| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> fix-: http://dev.mysql.com/doc/migration-toolkit/en/
<1> infi, yes that was the one i used
<2> fix-: well, of course we have migration consultants who may do work on-site
<1> but it didn't do the trick
<1> dammit, but it's prolly not included in the network subscription right :)
<2> but support may know oracle too ;-)
<2> well, if it concerns mysql side, then it is ;-)
<3> can anybody answer my question?
<3> what guarantee have I that a FOUND_ROWS() result will correctly correlate to the query I wanted it to be ***ociated with?
<3> what happens if multiple people are hitting the query at once?
<3> will the result counts be screwed up?
<4> I would ***ume FOUND_ROWS is connection based
<4> just like LAST_INSERT_ID
<2> fix: :-)
<1> dammit, :) it always concerns mysql as that is the new data storage medium
<1> but when we get there, you'll here some more from me
<1> the people over here were very interested in the platinum support
<1> as that included performance help
<1> :)
<1> they are scared its much slower then oracle
<2> nonsense!!!
<2> :)
<1> dammit, how does speed compare ?
<1> I saw some reports a couple of years ago
<5> does anyone know of a good free mysql gui for windows?
<2> you can't publish oracle benchmarks!
<1> dammit, why not ?
<2> forbidden by license
<6> Xgc, what would happen if the SELECT INTO found many rows?THen the var would contain the last one by the end of the command?
<2> and arbitration would be settled where they want ;-)
<1> hmmm, strange
<1> well doesn't matter, any idea if there's much difference in speed between them?
<3> Melbell: the official one, MySQL Query Browser is good
<2> mysql can be faster
<1> although you're prolly byast
<2> =))
<4> biased
<1> shabbs, thnx wasn't sure
<1> :)
<5> kapowaz, thanks, will look into that
<2> fix: check pm ;-)
<2> shabbs knows I'm biased ;-)
<4> only slightly
<4> I'm biased towards blondes
<2> I'm biased towards efficiency
<2> wooo
<4> :D
<7> can an older version of a mysql database (3.23.54) be migrated into a newer mysql environment (4.1.14) - or would it be better to rebuild the database if possible?
<4> Aw0L: dump and restore
<2> but it can.. too... :)
<4> and make sure you read the upgrade notes
<7> shabbs: so there won't be a problem with the different versions?
<4> !m Aw0L upgrading 3.23 4.0
<8> Aw0L: (Upgrading from Version 3.23 to 4.0) : http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html
<4> !m Aw0L upgrading 4.0 4.1
<8> Aw0L: (Upgrading from Version 4.0 to 4.1) : http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
<7> so I'd have to upgrade the mysql version on the 3.23.54 machine and then dump and restore on the 4.1.14 machine?
<7> hmm..
<4> right
<7> doh
<7> okay, thanks guys
<4> best thing to do is setup a test 4.1 server and try the dump/restore
<9> last i knew, i had no problems :D
<4> work out the details then make the move to production :D
<9> mysql fix grant tables for the win
<10> morning all
<11> is there a better way to kill a mysql process, like kill -9 or something?
<11> more forcefull way I mean
<2> mysqladmin shutdown
<12> psofa: That's an error, just as WHERE blah=(SELECT ...) -- would fail if the select returned more than one row.
<2> ;-)
<13> kill -15 is the correct way -9 may/will damage data
<2> -9 will not damage data for innodb with proper settings
<6> hmm btw what does SELECT into has to do with storedprocedures?
<12> psofa: The use of that form in engines like Oracle are using to set local variables in procedures and functions.
<13> example here http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
<12> psofa: It doesn't apply to the normal non-procedure use, at least with Oracle. MySQL probably does something different.
<6> Xgc, so ill have to create a procedure to use it?
<12> psofa: No. Ignore my comment. I was just showing one way it's done, outside of MySQL.
<14> hey when i wanna update a something in a table.. i use the UPDATE sometable SET blabla=blabla WHERE id=somethingelse ?
<12> psofa: Oh. Sorry. Yes. Your question only applies to procedures and functions.
<12> psofa: A standard select, as issued via JDBC, probably can't use @variables.
<15> hey guys our backups were messing up non standard characters and after importing a backup of one of the tables im left with search and replacing the messed up characters, i cant seem to search for "% %" its suposed to be
<15> how can i search for that
<15> searching for "% %" returns all a characters
<15> hmm no one knows?
<13> try setting binary on your search
<13> for exact match
<15> hmm
<15> how exactly is that done
<13> part here http://dev.mysql.com/doc/refman/5.0/en/charset-binary-op.html
<13> and read this lot http://dev.mysql.com/doc/refman/5.0/en/charset.html
<16> hello.. anybody using DBDesinger 4 with mysql 5.x ?
<17> I installed mysql out of openbsd ports and it doesn't seem to be honoring open_files_limit.. is there documentation on this somewhere?
<17> this would be mysql 5.0.18 on obsd 3.9
<16> Installed Connector/ODBC 5.0...and next step?
<6> hmm i think i did what i wanted with this: SELECT @mplex:=mplexid FROM dtv_multiplex d WHERE d.frequency=11117000
<6> so what i think this does is the following
<6> mysql takes each row from the dtv_multiplex table
<6> for each row it attaches a virtual column with the value of @mplex
<13> \monster\, and this http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html
<6> if the row is ok by the WHERE thing it shows it to me
<6> it continues that thing until it has parsed the whole table
<6> im i right?
<16> oh.. sorry.. DBDesigner 4
<18> ERROR 1130 (00000)
<6> can anyone confirm im making any sense?
<18> i can't connect to mysql server
<19> psofa: I would expect you have a variable with the value of mplexid from the last row "processed", but I'll admit I don't mess with user variables much.
<19> sidoli: full error?
<18> ERROR 1130 (00000): Host '192.168.2.14' is not allowed to connect to this MySQL server
<6> inviso, yes thats my goal
<6> but im trying to understand what mysql does
<19> psofa: why do it that way? Why not use limit 1 and order by?
<6> inviso, im trying to save the mplexid columns value so thati use it on a next statement
<6> *column's
<18> inviso what's wrong with mysql
<19> !m sidoli adding users
<8> sidoli: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<19> sidoli: pay attention to the user@host part
<15> binary search definetly isnt working it just cant match whats in the database
<19> psofa: It's still not clear why that's necessary. Also, I'm be very specific about the value you were retrieving if I *were to store it in a user variable. You're leaving the actual row picked up to the whim of the engine
<19> s/I'm/I'd/
<15> db has "parmi les prt- -manger les plus prfrs pour" WHERE response like "%- -%" WHERE binary response like "%- -%" WHERE response binary like "%- -%" will not match it, i also tried with % %
<6> inviso, i didnt understand anything :)
<19> psofa: ok. Back to the beginning. What are you trying to do in a broad sense?
<13> \monster\, maybe you need another collation
<15> im using the default latin1_swedish_ci
<6> inviso, find the row that has a specific frequency column and save this row's mplexid to a var.Im gonna later insert this var's value into another row will instert into another table
<13> try a binary collation eg latin1_swedish_bin
<19> psofa: Let me restate that. You want to copy a mplexid for a specific freq into another table?
<6> hmm yes
<19> as a new row?
<15> theres latin1_bin
<6> as part of a new row yes
<19> !m psofa insert ... select
<8> psofa: (INSERT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT.html
<19> bah
<20> hmm
<19> !man insert select
<8> (INSERT ... SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html
<19> there it is
<19> psofa: using insert ... select, I can't see why you wouldn't do that with a single statement
<18> mysql -u root
<18> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using p***word: NO)
<18> inviso
<19> sidoli: mysql -u root -p
<18> oks
<18> sorry inviso because i'm new here
<18> :)
<17> darn, forgot that would log me out.
Return to
#mysql
or
Go to some related
logs:
sudo unable to lookup via gethostname()
#fedora
a8r-mvp usb wake up
#qemu
Table 'tracker.addedrequests' is read only
#ai
lshal unplug
#web
Philosophae Naturalis Principia Mathematica
xgl on centos
|
|