#mysql
08 October 2007
Total 24 pages. You are browsing page 3/24.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
01:29 <****> how do I check what character set? according to phpmyadmin it's utf8 for the database
01:29 <****> or for the entire mysql I guess
01:29 <****> no idea on the db level..
01:30 <****> looks like tobals are utf8_general_ci
01:30 <****> tables, not tobals
01:33 <****> hmm not sure then... the only charset related USE flag I see is latin1
01:33 <****> is there a way to update without changing timestamps?
01:33 <****> can i 'transplant' my database files from /var/lib/mysql/SOME_DB to a fresh install and somehow get it to recognize the old db files ?
01:34 <****> I try to store all mp3 tags in mysql, and some artists and albums use accent marks. It's really annoying having to manually correct it.
01:35 <****> lloyd4, i think you can as long as the mysql versions are compatible
01:35 <****> lloyd4: mysqldump is recommended over moving files
01:35 <****> andresmh: elaborate
01:36 <****> ToeBee, andresmh: thing is my old installation got screwed on permissions so bad i couldn't do anything, but the directories+files for all the databases were intact there. so i copied them aside, and now trying to transplant them into a fresh install. but it's not responding too well
01:36 <****> TomCox: hmm wait what do you mean by accent marks? letters with accents above them or the character ' ?
01:36 <****> letters with accents over them
01:36 <****> ah ok. I thought maybe you just weren't escaping ' and it was terminating the string early
01:36 <****> i keep getting errors like 'cant find the file ./db_name/some_table.frm' (errno: 13)
01:37 <****> although the file is there...
01:37 <****> lol no. I can get ' and " in there
01:37 <****> but I thought it would just put in a ? character, not actually truncate the sting...
01:37 <****> *string
01:38 <****> yeah it truncates teh string
01:38 <****> thumbs, i have table with a timestamp field. When I do "update from table where foo = bar" the value of the timestamp field gets updated to today's date. Which fine most of the time. But right now I want to do a masssive update without touching the timestamp.
01:39 <****> What is the correct condition that returns true if that column is defined for that entry? SELECT field FROM tbl WHERE HASAVALUE(field) ?
01:40 <****> andresmh: then remove the function from the table prior to running the update,
01:40 <****> !man exists
01:40 <****> see http://dev.mysql.com/doc/refman/5.0/en/exists-and-not-exists-subqueries.html
01:40 <****> sdz: ^^
01:40 <****> tobben: ,andresmh : it works, the restored files lacked 'write' permissions on some users
01:41 <****> thubmb: what function?
01:41 <****> thubmb: what function? do you mean the field?
01:41 <****> yes, the function associated with the field.
01:41 <****> lloyd4: huh?
01:42 <****> thumbs, but there is no function associated with the field that i know of
01:42 <****> tobben: i copied back mysql data files into a fresh installation. didn't work at first due to lack of permissions on restored files
01:42 <****> okey
01:42 <****> when executing the "update table" query i am not updating the timestamp
01:42 <****> not explicity
01:43 <****> explicitly
01:44 <****> !man timestamp
01:44 <****> see http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
01:44 * Simetrical glares
01:44 <****> !man timestamp data type
01:44 <****> see http://dev.mysql.com/doc/refman/5.0/en/date-and-time-type-overview.html
01:44 <****> lets see
01:44 <****> Is there a length of string function built into SQL?
01:44 <****> sdz: length()
01:44 <****> andresmh: you said it's inserting now()
01:45 <****> andresmh, why don't you just do SET timestamp=timestamp?
01:45 <****> Simetrical, ah, good idea!
01:45 <****> doh
01:46 <****> HAVING is basicly a 'WHERE' for pesudo columns?
01:48 <****> hmm
01:48 <****> TomCox: I did just find this... http://bugs.mysql.com/bug.php?id=13662
01:52 <****> ToeBee: Thanks :-) I'm doing it through php tho
02:10 <****> TomCox: look at http://213.136.52.29/doc/refman/5.0/en/faqs-cjk.html
02:10 <****> specifically section 28.11.17
02:12 <****> thanks tobee, that makes sense
02:13 <****> although, an accent mark? like an e with a tick over it?
02:13 <****> I suppose I can switch the table to ucs2 though and see if it fixes the problem :-p thanks!
02:13 <****> yeah I don't know... seems like mysql is kind of lacking on character support if thats really what is going on
02:34 <****> i keep getting this on my replication server:
02:34 <****> mysqld[16767]: 071007 17:30:35 [Warning] Aborted connection 3527740 to db: 'nest' user: 'nest_mail' host: '10.8.0.9' (Got an error reading communication packets)
02:34 <****> i can't seem to find any solutions via the web, does anyone know what this means/how to fix?
03:01 <****> I have aWHERE clause and I want the column value to be matched to multiple values
03:01 <****> in
03:01 <****> would I just string them together with AND?
03:03 <****> "WHERE mycolumn IN (1,2,3,4)" or "WHERE mycolumn IN ('1','2','3','4')" depending on the column type
03:06 <****> thoughtful: thanks
03:07 <****> well, in all honestly jbalint deserves thanks as well. while the soul of brevity, he was also right.
03:07 <****> also, you're welcome!
03:18 <****> hey, are there any setup docs about mysql+ldap ?
03:29 <****> I'm sure google has tons
03:30 <****> Hey guys is this a validate Datetime in mysql 5 '0000-00-00 00:06'
03:32 <****> mysql SSL connection error, can someone help me?
03:32 <****> vbabiy-Laptop: you're missing the seconds
03:34 <****> thumbs: would that then be valid
03:34 <****> SHOW VARIABLES LIKE 'have_openssl' is "yes", but client connection error
03:36 <****> I have an issue with an UPDATE query. The query itself is, at times, being sent but not updating anything at all, and that tells PHP it failed to update it, but doesn't output an error.
03:37 <****> can someone help me fix the ssl connection? plz
03:37 <****> actually, I think I've got it
03:39 <****> sensez: exactly what error
03:40 <****> gynterk: thanks
03:40 <****> my server SHOW VARIABLES LIKE 'have_openssl' is "yes"
03:41 <****> gynterk: but the client connect say ERROR 2026 (HY000): SSL connection error
03:42 <****> gynterk: the client set "require ssl"
03:42 <****> mysql version ?
03:43 <****> are certs okay ?
03:43 <****> mysql 5.0.38-0ubuntu1
03:44 <****> gynterk: yes , the certs is all okay
03:44 <****> does key have passpharse?
03:45 <****> simple TEXT field Q: if I have a TEXT field, and I export using phpMyAdmin, how to coerce the hex to ASCII ??
03:45 <****> darkblueB: write a script which parses exported data
03:46 <****> and converts needed hex to ascii
03:46 <****> script?? in what scripting language
03:46 <****> php
03:46 <****> bash
03:46 <****> really
03:46 <****> if you export as plain sql then it's quite easy thou
03:46 <****> if wou know what field names contain that hex data
Total 24 pages. You are browsing page 3/24.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last