| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> !man match
<1> (Full-Text Search Functions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
<0> AaronCampbell: enjoy the read
<2> jink: you're a genius!
<2> thanks a TON
<0> np
<3> Anyone have experience of setting up mysql on a mac (intel specifically). I have apache/php running, and I have just installed mysql, and started it to the best of my knowledge. But I get a so
<4> hello, may i ask a short question please ?
<4> mysqldump -pfoo -ubar mydatabase > mydatabase.sql ... this dump contains a table called 'mytable' with a column 'mycolum' is there a way to only restore 'mycolumn' .. i ask because i need to convert the database into utf8 but i have to restore 'mycolumn' which contains binary data (that shouldn't be converted in utf8). is there an easy way to restory just that one column ?
<5> Well hello ther.
<5> there even, anyways.
<5> I can'r remember what the keyword/whatever was, that you put infront of the query (that's using LIMIT), so that you can get how many total rows matched, using a query after.
<5> Ah, SQL_CALC_FOUND_ROWS, thanks :-]
<0> plundra: sales at your local ikea?
<6> hmm
<6> is there a vulnerability in MySQL ?
<6> did something come out new?
<7> yes
<7> a few
<7> all fixed in 4.x (i forget)
<6> nm a critical vulterability in Microsoft Server
<6> Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
<7> there was one in MySQL a little while ago
<7> an advisory
<6> hmm
<6> every server on SQL server 8, you can get anything you want...
<7> lol
<7> but then again, it was a serious issue w/ mysql
<6> hmm
<6> i thought it was for MySQL , cause the vulnerability in SQL server, was that I could place a query in the URI and it will give me the result as root
<8> m0: That's not really a fault of the db server behind the application. It's the fault of the application for providing direct access like that.
<8> m0: Don't blame SQL Server for that. Blame the guy how wrote the web application.
<9> anyone here worked with replication?
<8> m0: You could easily write a web application that exposed Oracle or MySQL in the same way.
<8> jak2000: There are often both developers from MySQL as well as users here. Just ask and give them a chance (time) to respond to the actual question.
<7> jak2000, ask away
<7> see Xgc's responce ;)
<9> i am beginner, in replication, where start? reading wich url? thanks
<6> Xgc - no, I any server running 8 sql server, you can do that
<6> i think it is a private vulnerbiliity now ;x
<10> I copied my-small.cnf to /etc/my.cnf and changed the placement of the socket for client and mysqld. Then ran mysqladmin shutdown and finally mysqld_safe &
<10> Yet now I am unable to logon to the mysql server
<10> Any ideas why?
<11> is there a good program for mapping out a database design? showing all of the different tables and how they're going to link, etc?
<12> AppleBoy: take a look at mysql workbench
<12> its far from finished though
<11> :(
<12> alternatively DBDesigner .. which is unmaintained AFAIK but fairly decent
<13> i think phpmyadmin can generate table schema
<13> you have to config a few things
<13> DBDesigner is great .... fabforce.net
<14> [[Special:Contributions/68.215.134.103]] -- rock on :)
<15> Hello, please could you tell me how to remote conect to a mysql server?
<15> the host is localhost, how could I connect remotely?
<15> anyone here?
<16> JinRoh: yes
<16> sometimes you have to wait more than one minute for people to speak
<17> JinRoh: err, "the host is localhost"?...
<15> yes, mmm
<15> the host is a website
<15> jinroh.org
<15> and the host is localhost
<15> how can I remote connect?
<15> I don't have phpadmin
<17> JinRoh: please explain what you are actually trying to do. Waht you are saying does not make much sense...
<15> -_-
<15> I want to remotelly connect to my mysql server, but I only have this info: Database Host: localhost database name : ... database user: ... database p***word: etc
<15> I don't have phpmyadmin
<17> so.. the database is on the web server
<15> yes
<17> and you ant to access the database directly, from your home box
<17> is that right?
<15> yes
<17> well, in theory, isstall the mysql client and use it to connect to the database at the webserver (using the hostname jinroh.org).
<17> but in practice, this is unlikey to work
<15> so how can I get it to work?
<17> the database server should not be accessible directly from the "wild" internet - that's dangerous.
<17> well, the simplest thing would be to install phpmyadmin on your website.
<17> you can access that with your browser
<17> alternatively, install the mysql client and use an ssh-tunnel to connect to the databse.
<17> that requires ssh-access to the webserver, and a little bit of networking knowledge
<17> and an ssh client, obviously
<15> mysql-client
<15> I have installed it
<17> basically... ask your hosting people what solution they would prefer. or is that your own box?
<15> how to use it?
<15> how can I run it?
<15> mysql-client doesn't work
<17> mysql -h <host> -u <user> -p <database>
<17> host would be jinroh.org - if the database is accessible from the web, which it's probably not
<15> ERROR 2003 (HY000): Can't connect to MySQL server
<17> right
<15> :'(
<17> it does nto accept connection from the wild internet
<17> as it should
<17> well, as it shouldn't :)
<15> so what can i do
<17> as i said: either use a web interface to the database (i.e. use phpmyadmin)
<17> or set up an ssh-tunnel (if you have ssh access)
<17> if you set up an ssh-tunnel on port 8899, the command would be:
<17> mysql -h localhost -P 8899 -u <user> -p <database>
<15> ok thx I will try
<18> do you how to use 'union' for return a standar value when select fails?
<17> err?
<16> you could use coalesce() to provide a default value for a column if it's returned null
<7> arrase, pseudocode: something like a if(select returns 0 rows) { return defsult value } ?
<7> so that i understand your question better
<18> example: if SELECT p***word FROM users WHERE name='arrase' fails because 'arrase' is not in users table return 'nobody'
<18> better? :)
<7> i'd say try a subselect + COALESCE()
<16> I'd say do it in the application
<7> that would work too :)
<16> you're trying to return a magic value, It hink you'd be best off actually returning a failure and let the business logic handle how it wants to ratehr than having to decode that "nobody" means it failed rather than "nobody" is the user's p***word
<18> i can't use COALESCE, is a restriction
<16> huh?
<18> osfameron : yes
<16> arrase: restriction because a) it's a school exercise or b) there are good technical reasons or c) some fool decidede you can't use coalesce out of superstition?
<12> :)
<18> a
<18> :)
<17> arrase: it'S a trick question then :) the answer is "don't, it's stupid" :P
<12> then use CASE or IF ;)
<17> hm... for something completely different:
<17> is there a good plugin for handling recursive structures?
<16> if you really want a union, maybe it's stupid thing like: select foo from ( select p***word from blah UNION select "nobody") limit 1; ?
<17> like, if there's a record for A,B and one for B,C, "simulate" a record A,C?
<19> Hello
<7> anyone know why MySQL AB uses a Windows/Mac proprietary player for presentations? I want to view this: http://www.mysql.com/news-and-events/on-demand-webinars/mysql-performance-tuning.php
<7> but guess what my problem is ;-)
<7> is there an "open format" version of that presentation? (mpg, avi, ogg, flak, xvid.... hell pdf would work for me at this point)
<16> what format is it in?
<7> wfm
<7> .wfm
<7> or something like that
<16> does ffmpeg convert that?
<17> wmf, perhaps?
<7> .wrf sorry
<7> http://www.webex.com/lp/player/download.html
<7> osfameron, i doubt
<7> hmm, connection issue at work... odd
<7> Duesentrieb, if it was wmf then i could run it ;)
<17> yea...
<17> mick_linux: wfm -> dBASE Form Designer Form Object, according to http://filext.com/detaillist.php?extdetail=WFM
<16> "However, WebEx has committed to releasing recorded webinar viewers for Linux and Solaris in their next product release, Meeting Center 7.0. We encourage users to contact WebEx technical support to register their interest in support for additional platforms"
<7> ah it was zelezney (or whatever that server is)
<17> so... take it up with dbase ;)
<7> wrf :-P
<7> to me... "wfm" still means "works for me" :-P
<20> Hi all. Does anyone have an opinion of the best way of using bitfield values in mysql? I read bad things here --- http://www.xaprb.com/blog/2006/04/11/bit-values-in-mysql/ --- and wondered if there was a bette approach
<8> Duesentrieb: The SQL specification contains support for hierarchical constructs. MySQL doesn't. There has been a fair amount of research on the subject.
<8> Duesentrieb: If you look into it, you might find there are methods of storing that type of data that allow you to obtain the information you need, without using a linked list approach.
Return to
#mysql
or
Go to some related
logs:
ubuntu dapper gtk-config
get substring from string + python
try except ioerrer in python
pxperl dos file path
zen timeout suse
#osdev
mounting media failed
ubuntu ISO_Level3_Shift
#perl
#ubuntu
|
|