| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> hi I am using search where match against query and I am a bit confused with the three type of search, Although I understand the doc, I am not search to know what type I need. what I want is to search for the complete list of keywords, such as "sunny cloth" instead of a search that returns what contains "sunny" and what contains "cloth", how do I achieve that ?
<1> EyeCue: but i want to use the my-heavy-innodb-4G.cnf config
<0> anyone ?
<1> ist just perfect for me. but if i use it, he wont load innodb :-(
<1> so i have to know wich command disables the innodb storage engine
<2> bleed_ch bleed, at the very least it will deduct any conf specific overrides youre running in the conf
<2> it could be in the configure args, you may not have innodb support compiled in
<2> so regardless of your conf options, it may just not be there
<1> EyeCue: but it is.
<1> if i had disabled it in my configure command, i couldn't us it at all
<1> but i can use innodb if i move my.cnf to something.cnf
<1> so the .cnf is the problem
<3> I use LONGBLOB for storing php session data. I have problems with restoring data, which contains multibyte chars. All db, connecton, locale is in UTF-8. DO you think it can be MySQL "fault"?
<1> and btw, i configured manually and i know that i didnt disabled inno-db! :)
<0> can someone give me an hint on my problem ?
<3> a|ex: what is the problem?
<3> i was absent a minute ago
<0> zimnyx: thanks
<0> hi I am using search where match against query and I am a bit confused with the three type of search, Although I understand the doc, I am not search to know what type I need. what I want is to search for the complete list of keywords, such as "sunny cloth" instead of a search that returns what contains "sunny" and what contains "cloth", how do I achieve that ?
<0> s/search/sure
<0> zimnyx: ?
<3> ... WHERE FIND_IN_SET(column, 'sunny,cloth')
<3> a|ex: here you got FIND_IN_SET docs: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
<0> zimnyx: so it is not a match against query anymore, right ?
<0> is it that efficient ?
<0> ok I read
<3> you want to find rows which contains at least one of the word 'sunny, cloth' ?
<3> If so FIND_IN_SET is OK
<3> If you want efficiency index that column
<0> zimnyx: no I want to find "sunny cloth" anywhere in my db, I used to use match against and it works fine, however, I need to refine my search because at the moment if I p*** over the string "sunny cloth", it will look for anything that contains sunny OR cloth wheter I want it to search for sunny AND cloth
<0> is that not possible with match againt ?
<3> What you mean "anywhere in my db" ?
<0> in most of column I have full text indexed
<0> in most column
<3> ok, so you want to search on multiple columns, correct?
<4> does myisam (5.0) supports transactions (begin/commit)
<0> yes the maximum
<5> IceD^: silently ignores that
<3> IceD^: not at all, try InnoDB
<3> a|ex: Do you have list of those columns?
<0> zimnyx: yes
<0> I thought search match against was for this kind of search
<3> a|ex: yeah, use FULLTEXT search. http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
<4> thnx
<0> zimnyx: ok then that is what I am using and it works fine, the only thing is to be able to refine my search
<6> Alright lets try this channel
<6> I cant get mythtv to connect to its database which is mysql
<6> Someone please help
<2> Perhaps you should provide some useful information for us to help you with
<6> When I load mythtv-setup it just says "Cannot connect to the database" but the login and p***word are both correct
<2> Have you setup a mysql user with the correct permissions?
<2> Is mythtv and mysql on the same box?
<6> Yeah they are on the same box
<6> There should be a user yes
<2> 'should be' and 'is' are different things entirely
<2> mysql -u root -p
<2> use <mythtv databasename>'
<2> -'+;
<2> bah forget all that :)
<2> Check your mysql accounts
<6> How do I do that
<2> How did you add the mysql account?
<6> used dpkg-reconfigure mythtv-database
<2> I doubt the mythtv script created a mysql account
<2> mysql -u root -p
<2> select user,host from mysql.user where user='mythtvusername';
<2> paste record
<3> a|ex: refine? what you mean?
<6> EyeCue, That just leaves me with ->
<2> ;
<6> Empty set (0.02 sec)
<2> then you dont have an account setup for mythtv
<6> wait
<6> +--------+-------------+
<6> | user | host |
<6> +--------+-------------+
<6> | mythtv | % |
<6> | mythtv | 192.168.2.% |
<6> | mythtv | localhost |
<6> +--------+-------------+
<6> 3 rows in set (0.00 sec)
<6> I typoed
<2> whats mythtv's database name?
<6> mythconverg
<2> use mythconverg;
<2> show tables;
<2> is it all there, or empty ?
<6> theres stuff there
<2> have you 'flush priviledges;' ?
<2> try connecting to the database using mysql -u mythtvuser -p mythtvdb
<2> if you cant connect like that, then mythtv wont be able to
<6> It can
<2> Then its a mythtv config problem.
<6> Thanks
<2> Make sure mysqlclient support has been compiled in
<2> I dont know any mythtv specific things, but you might want to check the following: configure arguments before compiling, and the mysql config file
<2> ie, the MythTV MySQL config file.
<6> Someone said its cause I dont have a ~/.mythtv/mysql.txt file
<2> Possibly
<2> I have no idea.
<2> But i did read something about that file
<6> Thanks a ton :)
<2> Its in the mythtv documentation
<6> QSqlDatabase: QMYSQL3 driver not loaded
<6> QSqlDatabase: available drivers:
<6> How do I fix that
<2> no idea
<2> mythtv forums
<2> google the error
<7> Hey, anyone around?
<8> he's back, hide!
<7> lol
<7> I'm creating this website with members on it, and there's a database with a members table and I was wondering how I'd be able to do something like a contact list?
<7> I know that sounds weird, but I was trying to figure out how I'd store stuff like "This person is this other person's friend" in a database
<8> perhaps a self-referential link table?
<7> I have no idea what that is
<7> A fuse just popped in my brain when you said that, I used to be good at this stuff :-/
<8> members ( id, name, etc ); <-1-----MANY-> friends ( member_id, friend_member_id );
<7> Ohhh
<9> Hmm.. I've recently upgraded from 3.23 to 4.1. Since then my MyISAM tables keep getting corruped and require repairs after about 30% of Inserts I do. Anyone have any idea what might be happening?
<7> Thanks infi
<8> cheers
<8> dsc: not sure at all. it may not be being shutdown properly, though. I think the safe_mysqld and mysqld_safe (don't recall which one used which) changed names between those versions though, so perhaps it's not configured to shut down properly in your init script?
<8> dsc: going out on a limb there.
<8> !m dsc upgrading 3.23 4.1
<10> dsc: (Upgrading from Version 3.23 to 4.0) : http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html
<8> !m dsc upgrading 4.0 4.1
<10> dsc: (Upgrading from Version 4.0 to 4.1) : http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
<8> check through those also, and see
<8> normal inserts shouldn't affect it though, you could also set up query tracing to see what exactly is going on.
<11> is there a repository of mysql ab talk slides?
<12> lsmith: looking for anything in particular?
<11> yeah .. david's talk "history of mysql"
<6> ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<6> uh, ya, about that
<9> infi: I've just been starting and stopping in manually (while trying to diagnose the problem), and I've been checking that no mysql process have been running while trying to fix the tables. I've read through both of the upgrade guides, but can't see any issues that should be affecting the tables that I'm using.
<6> Someone know howto fix that quickly?
<11> where is a mysql ab community relations guy when you need him? ;)
<8> dsc: not sure then, that was the only thing that came to mind :\
<9> infi: No problem, thanks anyway, I'll keep looking into it. Sadly it's not reproducable, and only seems to happen sometimes (to the same tables) on write.
<8> I'd still trace the queries against those tables
<8> perhaps dump them, drop the tables, recreate them, and reimport them entirely.
<9> I'm not quite sure how to do that, is there a good guide to that somewhere? Does MySQL keep per table logs to see when they crashed?
<8> erm, probably
<9> (was referring to tracing queries, sorry for not being more specific)
<8> oh, heh
<8> !m dsc query log
<10> dsc: (The General Query Log) : http://dev.mysql.com/doc/mysql/en/Query_log.html
<3> I use LONGBLOB for storing php session data. I have problems with restoring data, which contains multibyte chars. All db, connecton, locale is in UTF-8. DO you think it can be MySQL "fault"?
<6> How can I correct ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<2> google the error
Return to
#mysql
or
Go to some related
logs:
expat-compat + suse
#perl
gnome clock saturday left
insatll debian
#math
netinstall floppy linux2.6
#python
erase files on ubundu linux
nachplus
eggdrop radio tcl
|
|