| |
| |
| |
|
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> stestagg: okey
<1> what does it say?
<0> InnoDB: Started
<0> ready for connections ...
<0> and :
<0> the version of mysql
<0> file of the socket
<0> port
<0> and ..
<0> source distribution
<0> anymore
<2> Hit enter less.
<1> dats: does it stop running?
<0> i have started the database web server
<0> mmmm
<0> i'm recompiling the kernel ..
<0> it don't go very fast ... ....
<0> stestagg: no, it isn't stop
<0> it is running well
<2> use this space over here too
<1> so your problem is??
<0> stestagg: that the database's server going down ...
<0> and i don't know why it does it
<0> this is the true problem :S
<1> how long does it stay up for?
<0> mmm
<0> i don't know exactly ...
<0> one or two days aprox ..
<1> what does your syslog say?
<0> my syslog don't say anything ...
<0> :S
<0> one moment please
<0> i look for this question into log's files
<0> one moment, i going into my phpmyadmin
<3> hi all... i want to make it so my page inserts $last into a table called 'authorize', field named 'last_login', what would be the correct code for this please?
<1> nebmo: www.mysql.com
<3> thanks =] ... i was actually looking for the easy way out, and someone just telling me :P
<3> thanks anyway.... i have to learn myself someday
<4> quick question: what's wrong with the following: SELECT * FROM table WHERE name LIKE '%jack%'
<5> what does mysql say
<6> floppyears: Who says it's wrong? :)
<4> I don't get any results
<6> floppyears: And why do you think that's "wrong"?
<4> I thought I should be getting results.
<4> I have to go out for lunch. I'll come back. thanks a lot
<6> floppyears: Why do you think so?
<6> floppyears: using reserved words for table names is quite bad idea you know
<5> bit silly using a reserved word like table without backticks
<6> floppyears: But the fact you don't care to read the syntax error message is another story
<0> stestagg: i'm in my phpmyadmin
<1> ok...
<0> but ....
<0> i don't find anything ...
<0> it a ****!!!
<0> it's a ****!!!
<0> :(
<3> ok noob over here... $sql ="INSERT INTO authorize VALUES
<3> (WHERE last_login = '$last')";
<7> nebmo: what are you trying to do?
<3> the 2nd line is wrong and dont know why... im looking on the mysql website
<3> i want to make it so my page inserts $last into a table called 'authorize', field named 'last_login',
<7> !m nebmo insert syntax
<8> nebmo: (INSERT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT.html
<3> thanks
<0> can anyone help me ?
<1> I don't know what your problem is. you have an empty database.
<0> :( i don't know what is happens with my database server, it go down, but i don't have any log ...
<0> stestagg: no, i don't have an empty database
<2> dats: Try to start it. Observe what happens.
<1> dats: quote:i don't find anything ...
<0> mendel: but it stop at anymoment ....
<0> not now ...
<0> after 2 hours ..
<0> 3 o 4 ...
<2> Then solve the problem of not knowing where your logs are, and then two hours from now check the logs.
<2> I am not going to talk to you if you keep hitting enter after every two or three words.
<1> dats: run it from the command line and leave it running. when it quits it should spit the error message out to std. out.
<2> Or that.
<2> Although I'd still recommend figuring out why it's not logging, because logs are useful.
<0> then i'm going to do it now
<0> thanks
<0> i will come back when i have my sistem hangup
<0> bye
<7> damn it, one can't even look at porn at work in peace
<9> that would depend on where you work shabbs.
<9> I would imagine there are certain web hosting companies where it would be expected.
<10> hello
<7> we don't host the websites
<11> you guys have an icon i can use on my web site ?
<12> hi all
<12> can somebody tell me how to import a database from mysql 4.1.14 to 4.0.15-Max ??
<12> nobody?
<13> export it from 4.1 via phpmyadmin and set compatibilty to mysql 40
<14> How do I set key_buffer_size on mySQL 3.x?
<9> You do not.
<14> mhillyer: Umh, it shows the variable in the mysqld --help...
<9> Upgrade.
<9> 3.x is of t3h d3v1l!
<9> Or if for some reason you cannot you set it in your configuration file.
<15> <3 4.0
<9> mysqld --set-variable=key_buffer_size=10K
<14> mhillyer: ok, thanks
<16> where i can download lib for mysql5 libmysqlclient.so ?
<17> ZID: it is part of the mysql install
<4> salle: I was just using "table" as the tablename in the example. the real table name is eas_users
<4> salle: also I don't get any syntax errors. I just get no results
<6> floppyears: Empty result set is perfectly valid result
<4> salle: could you tell the bot to give me some links on how to use LIKE ?
<5> better off using a fulltext index
<5> as the '%blah%' could not use an index
<6> floppyears: Why don't you ask the bot :)
<4> well, I don't know how to :(
<5> !man like
<8> (String Comparison Functions) : http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html
<5> !man fulltext
<8> (Full-Text Search Functions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
<4> thanks
<18> Hey guys, I gotta quick question
<2> ready, set, GO
<18> ah good
<18> I need to reset my MySQL p***word to the original
<18> uh how
<18> I guess 5.0.18 uses different p***word hashing methods
<18> and it's incompatible with everything else I've got
<2> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
<5> !man reset root
<2> oh, wait
<8> (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<18> So I can no longer access my forums
<18> using terminal
<5> !man oldclient
<8> Nothing found.
<2> http://dev.mysql.com/doc/refman/5.0/en/old-client.html
<2> hah, take that, SQL
<7> !man old client
<8> (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<18> okay in http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
<18> it says to save a text file and boot mysql with it
<18> but to where should I save it?
<2> Wherever you like
<19> wherever mysql has permissions to read from
<18> Okay, and doing this just sets a new p***word?
<18> I mean, would it solve the issue of p***word hashing difficulties?
<19> mysql will issue any query you put in that file
<19> you should put one that resets your p***word :)
<18> Right. But the problem arose because I did change my p***word
<7> then read the above pasted link
<7> about old-client
<18> Okay, and now I'm getting the error "ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'"
<18> But here's what I entered mysql> SET P***WORD FOR
<18> -> 'root'@'localhost' = OLD_P***WORD('XXXXX');
Return to
#mysql
or
Go to some related
logs:
index tickling files
mplayer-essentials
Forwarded connection refused by server
mp3 support for amrok
perl http continuation header
#lisp
xserver-xorg AIGLX debian
#css
quantum physics oh shi
#suse
|
|