| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> heh
<1> ty
<2> or fetsch in freebsd
<2> fetch
<3> skramX -- once im in my.conf, what do I put in there to activate the slow query log?
<3> i dont see anything in my.conf that talks about a slow query log
<4> I3ooI3oo, r u 2 lexis then?
<5> http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
<6> Anyone alive ?
<6> I got a pretty urgent problem
<4> yup, but i'm a newbie
<7> golly
<1> nope... wait what is that ??
<7> define "urgent"
<1> Define : alive
<4> I3ooI3oo, Toyota's Lexus has a nice model called the I300
<1> but i am I3oo
<4> ah
<1> note the lack of zero's
<4> right
<4> I3ooI3oo, sorry
<6> andrewbryson: Upgraded my customer server, but now mysql segfaults after around 20seconds when i try to import my old database file (~90MB) with this command: mysql -u root -p -h localhost -f < allsql_5_april.sql
<1> so many get it wront my hightlight in windows is on both
<6> leaving this errors in the logs:
<6> Apr 7 00:15:53 digitaljunk mysql[14349]: segfault at 00007fffff981000 rip 00002aaaabc6ad81 rsp 00007fffff980198 error 6
<6> Apr 7 00:00:28 digitaljunk factorial[31138]: segfault at 0000000000021841 rip 0000000000402eb2 rsp 00007fffff8f48d0 error 4
<1> what i don't know what that was i just type
<7> stigma: so have you tried to see what command is causing it to break ?
<4> what does I3ooI3oo stand for then?
<1> BooBoo
<6> andrewbryson: how would i check that ?
<7> a .sql flle usually contains sql commands so you should be able to just go through it and figure out where it is breaking
<1> a nick name i have had with friends for 16 years
<4> I3ooI3oo, nice
<5> stigma is it a mysql binary
<6> andrewbryson: yep, but going through 90MB of sql data, including BLOB
<1> it's normaly registared but BooBo always is
<7> stigma: what of it ?
<6> andrewbryson: yep, but going through 90MB of sql data, including BLOB's looking for an error is pretty hard
<7> nonsense
<1> insert Not in tha tlast line
<7> try running half the file and see if it works
<7> if it does then try the other half
<7> repeat until you find the problem :)
<7> should not take more than a few minutes
<6> andrewbryson: it's an sql backup created with mysqldump --alldatavases -u root
<6> --all-databases*
<7> cool it will just be text then
<6> andrewbryson: hmm, any simple way to split the file in half ?
<7> unless the format has change :P
<7> well it is only 90MB
<7> i suspect that many text editors will handle files of that size
<6> # file allsql_5_april.sql_
<6> allsql_5_april.sql_: ASCII text, with very long lines
<7> since it will fit into ram
<6> yep, vim does
<6> but, it kinda would be better if mysql could tell me where to look
<7> oh it probably can
<6> isn't there some way to get verbose output while importing ?
<7> but i have not had a problem of that nature before so i do not know what it is :P
<6> :P
<5> stigma is it a mysql binary
<6> uhm ?
<5> did you compile it
<6> yes
<7> well if you load it into a text editor do you see commands or do you see random looking characters ?
<5> then download a binary from mysql.com
<6> or i did "emerge" it using gentoo
<6> which again compiles it for me
<7> oh you mean for mysql :P
<6> 00:24 < stigma> # file allsql_5_april.sql_
<6> 00:24 < stigma> allsql_5_april.sql_: ASCII text, with very long lines
<6> i see text
<6> i suspect it could be something with mysql's buffer sizes
<6> andrewbryson: figured it out :)
<8> trying to wrap my head around the REPLACE command. Is this valid SQL? REPLACE INTO table1 (field1, field2, field3) VALUES (value1, value2, value3) WHERE field1=value1 AND field2=value2
<9> user 'l_user' can log in to mysql on command line; however, PHP's mysql_connect says "Access denied for user 'l_user'@'localhost' (using p***word: YES)...). something in PHP I need to check (PHP folk suggested i come here)
<10> delinka, When you log in via the command line, what do you type in?
<10> bjohnson, REPLACE is like an INSERT. You don't use WHERE in INSERT. You also need to quote your strings.
<9> will: mysql -u l_user l_db -p
<11> delinka: Sounds like PHP uses different p***word
<11> bjohnson: No this is not valid syntax
<9> salle: oy ... two channels one answer; i'm gonna try a two char pwd ... let you know
<11> bjohnson: You better consider INSERT ... ON DUPLICATE KEY UPDATE ... syntax
<10> Or maybe just UPDATE?
<11> will: If he want's new row in case old one doesn't exist simple UPDATE can't help :)
<9> salle: did you know there's more than one way to spell l_user? omg... thx
<11> delinka: Like 1_user vs l_user? :)
<9> sumthin' like than ;-)
<11> delinka: Or l_user vs l_us5r ?
<11> delinka: Once I spent days trying to find why piece of PHP code doesn't work. I narrowed it down to: $a = 1; print $a; -> result was 0
<10> heh
<11> delinka: Took me many hours before I realized one 'a' was latin while other was cyrrilic ;)
<12> anyone looking for cheap, reliable phone service?
<13> hardly
<5> piece of string and two tin cans
<13> doesn't sound too reliable imo
<13> and a bit hard to expand
<13> and inflexible
<13> ever made a three-way tin can phone system?
<13> might even be possible
<14> is there a way to p*** commands directly into a mysql server?
<15> how to allow ip to acess remote?
<15> ...
<10> Tortel, ?
<10> Guest110949, What error message are you getting that says you can't?
<15> will: [Fatal Error]: Host '208.98.16.27' is not allowed to connect to this MySQL server
<16> why do so many people just sit in this room? most of them never talk
<10> !m Guest110949 adding new user
<10> blobaugh, Let's kick them all out.
<10> !kick will
<10> Stupud bot.
<10> And me...
<17> together you would have very stupid children
<10> Guest110949, You need to grant the user permission.
<10> Look up "Adding New Users" in the manual.
<18> i hate dialup, i get disconnected way to much
<18> did you see my suggestion for SQL will ?
<10> No
<18> tell SQL to kick anyone who doesnt talk in 4 hours
<18> :D
<10> heh
<10> Na.
<17> that would vacate 80% of the channel
<18> thats the point
<18> most of the people in here never talk
<18> there are more join/parts than talking in here alot of the time
<17> no
<10> I agree hehe
<10> I hate all these join/parts. But I don't want to cancel them completely.
<10> Probably could hackup Xchat to only show if they join/parted if they spoke within the last 24hours.
<10> Good ole loggin
<5> sometimes we pounce on joiners
<18> hmmm... has evil i deas of building an irc with a hidden kick for not talking feature
<5> they had a clearout in #php the other week, back up to the usuall qty of lurkers within hours
<10> [RainMkr] did that a few months ago. That was fun.
<18> thats cool
<19> Is there a configuration parameter to enable auto-complete in the mysql client?
<20> Could someone DWIM-ify this for me?
<20> INSERT INTO T SET i=SELECT MAX(i)+1 FROM T, c='a';
<18> i like that quit message
<18> usually true
<4> it usually is blobaugh
<4> i hadn't thought about it though
<16> ha, i stole my nick back from myself!
<21> arjen around today?
Return to
#mysql
or
Go to some related
logs:
#ai
#web
dymoum netlink_kernel_create
#fedora
max ubuntu burn speed
Partitions de Nick Lachey - What's Left Of
cubepanel +gentoo
conky
#web
debian unstable no /dev/psaux
|
|