| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Comments:
<0> I think it might be that all the data was multiplying with thier paralel colums :/
<1> !m redimido replication
<2> redimido: (Replication in MySQL) : http://dev.mysql.com/doc/mysql/en/Replication.html
<3> why is it all records are stored in a memory in mysql cluster?
<3> when would it saves to the hard drives?
<4> thanks guys!
<4> *now to read* hehehe
<3> why is it all records are stored in a memory in mysql cluster?
<5> Because that's how it works?
<3> huh
<3> anybody
<3> ?
<1> wow, is he asking questions with everyone in the channel on ignore?
<3> hehe
<3> coz there maybe new ideas from more intuitive knowledgeable person
<1> noone is smarter than will. he is a JEENYUS.
<6> will is so cute, too!!
<6> kernel20: mysql cluster is an in-memory database. many databases that operate similarly to the way mysql cluster operates are in-memory databases; it is a common feature of this kind of product;
<6> beginning with 5.1, there is support for storing non-indexes columns on disk!! yay!
<7> Therion: moo
<5> flupps, http://img462.imageshack.us/img462/6807/imagejpeg02pb.jpg <-- that's "moo"
<5> litheum, Still think I'm cute?
<1> will[werk]: which one are you?
<5> The fat one.
<1> and don't say, "The one in black and white"
<1> kk
<1> Oops, my AOLbonics trigger went off there. Let me fix that.
<4> he
<4> thanks to all
<4> bytes
<5> bits!
<3> <6> beginning with 5.1, there is support for storing non-indexes columns on disk!! yay!<- where did u get this info?
<8> kernel20, http://dev.mysql.com
<9> hi, i am trying to do this: select distinct id, * from table
<9> but the * breaks it
<9> maybe i am understanding distinct incorrectly
<9> i want to get all the fields, but i don't want duplicate table1.id ... i am leftjoining other rows which means that it may return table1 rows more than once
<9> is anyone here ? :)
<10> hi
<9> hi
<10> lol. say i forgot to SET NAMES=utf8 and inserted a bunch of data (as utf8), but its not really now. any way i can force it back into proper utf8?
<11> lol?
<11> not for long :)
<10> lol any ideas.
<12> dongs: dump the db, make changes to the .sql-file, and then import it again
<10> im not sure what i would be changing.
<10> i cant even figure out what charset it ended up as
<11> well, what languages are we talking about?
<13> How do you rename a database?
<11> it it's english, no big deal.
<11> if it's asian, then lots of headaches
<10> hm
<10> lemme export and see what the hell it loks like
<14> hello people
<15> hello all
<15> hey gina
<13> hello world
<10> allright
<12> Hi Zakabog, im world! :D
<10> so i exported a test table and it looks like junk
<10> its not utf8
<10> but its not anythign i can recognize either.
<13> lol
<14> can anyone explain how i would go about importing a very large database (600mb) into mysql?
<11> what's the large db?
<14> csv
<10> same way you'd import a very small db
<14> hows that?
<10> i'd suggest load data infile
<14> yes but i am very new to mysql
<10> i jsut gave you the keywords to search for.
<14> i tried load data infile in phpmyadmin
<14> but it diddnt work?
<10> http://www.google.com/search?q=%E4%BC%9A%E7%A4%BE+C3A4C2BCC5A1C3A7C2A4C2BE&start=0&ie=utf-8&oe=utf-8 < how the **** does
<10> so on the left is my string in utf8
<10> and on the right is what it ended up as with HEX(field)
<10> gina: http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
<14> could anyone possibly give me a hand with it?
<14> i have tried that dongs, but im new to mysql & i dont really understand
<14> so could someone pretty please help me out
<10> i duno about load data infile and phpmyadmin. i dont think that works.
<14> ok how would i do it then?
<10> all i know is i emport few 100megs of csv **** daily wiht it andi t works
<10> import? even.
<14> through what?
<10> though php file upload + load data infile.
<14> load data infile through phpmyadmin?
<10> but with 600megs you will need to adjust php.ini settings for max post size
<10> and for max upload file size
<10> defaults are like 5 megs or some****.
<10> and it'll jsut quit wihtout doing anything.
<10> ifyou go over limit.
<14> well i cant change the php.ini, so is htere any other alternatives?
<14> can i do it through shell?
<10> i believe mysqladmin allows some limited csv importing.
<10> or rather 'mysqlimport'
<14> ?
<14> ok but can i do it through shell?
<10> < gina> can i do it through shell?
<10> < dongs> or rather 'mysqlimport'
<10> you use mysqlimport.
<14> whats that?
<10> it appears the syntax is identical to load data infile.
<14> what if i have uploaded the csv to the server?
<14> how would i go about it then?
<10> yes thats part of hte process
<14> :/
<12> gina: you can import using --from-file i think
<14> im so confused
<10> mysqlimport takes a csv file and its params match that of load data infile closely.
<10> so you can upload the file, run mysqlimport on the data and specify load params.
<14> ok so what is mysqlimport? a program?
<7> mysqlimport --help
<10> < gina> ok but can i do it through shell?
<10> i ***umed oyu knew what you were talking about.
<12> flupps will help you, he is the expert :)
<10> lol i really need halp with this charset issue.
<14> wheres flupps?
<14> flupps help
<7> dongs: what's your issue?
<10> ive described it a few times already.
<10> i inserted a ****load of data into mysql without specifying set names=utf8 and now its all ****ed; example: http://www.google.com/search?q=%E4%BC%9A%E7%A4%BE+C3A4C2BCC5A1C3A7C2A4C2BE&start=0&ie=utf-8&oe=utf-8 string on the left (in utf8) ended up as the trash on teh right.
<10> need to convert somehow to normal utf8.
<16> dongs: what is the column charset? and what is the data charset?
<7> dongs: how much is a ****load?
<10> flupps: reinserting it is not an option
<10> lokus: utf8
<10> lokus: and data came from webpage, with charset=utf8
<10> BUT
<10> set names utf8 wasnt setup
<12> gina: http://dev.mysql.com/doc/refman/5.0/en/load-data.html <-- check that one
<10> so i'm guessing it used default connection encoding
<10> of like swedish_1_ci
<16> dongs: can yuo check if the data that goes in is utf8 or not
<10> or whatever
<12> that was the thing i was talking about, just me confused ;)
<10> its not, i just pasted hex() of one of the fields
<10> %E4%BC%9A%E7%A4%BE < proper utf8 C3A4C2BCC5A1C3A7C2A4C2BE < this is how its in DB
<7> dongs: still, how much data is a ****load?
<14> fraggeln: i doesent work :/, everyone gives me that link
<12> ahh, then i dont know :/
<12> well, time to get to work, l8r guys
<10> how does it NOT WORK. of course it works.
<16> dongs: what is it in the db, try a simple select hex(col) from table limit 1
<17> I am not able to use transactions feature with creation and deletion of tables. Does it works only while adding/deleting data?
<10> lokus: C3A4C2BCC5A1C3A7C2A4C2BE < in db
<16> dongs: anything that goes to the clien might be converted already
<16> dongs: from the select hex() ?
<10> yes
<7> efuzzyone: any DDL (CREATE, DROP, etc) will implicitly commit before executing
Return to
#mysql
or
Go to some related
logs:
poweriso daa cdrecord linux
#perl
gentoo access violation
ctrl-f terminal ubuntu
reverse engeniring under windows
#osdev
#kde
apt-build C compiler cannot create executables
#fedora
shellexecute, linux
|
|
