| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> mysqlhotcopy?
<1> not change it, but completely remove it (I know that this would normally be a bad idea)
<2> unclemantis: or just copy the files
<3> inviso: it says /var/lib/mysql/mysql-bin.1 not found
<0> is that part of the default instaliation
<0> this is on a shared host btw
<2> opapo: weird. Full error message please
<0> both servers are part of the same hosting company
<1> inviso, I dont think the bot is operational
<4> yes, I have got innodb in my system, but do where do I change the size of my innodb file, if necessary? I am planning to have a big database
<1> I didn
<1> t get anything
<5> how can i 'escape' keywords?
<2> kon: with `backticks`
<5> there is a field called "status" and this is regocnized as a keyword
<2> awww, where's SQL?
<5> ah, i only tried thanks
<2> SQL: Hey you
<3> inviso: you're asking a lot. there is no way to copy paste the message
<3> here it is though
<4> inviso: I have not found the /etc/my.cnf. Do I need to create one there?
<0> http://yro.slashdot.org/article.pl?sid=06/05/16/135257&from=rss
<0> about time!
<0> either use it or loose it!
<2> Deep6: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
<2> Azuos001: yeah, there are usually a couple default ones included. my-small.cnf, my-huge.cnf, etc
<3> file '/var/log/mysql/mysql-bin.1' not found (Errcode: 2)
<3> could not use /var/log/mysql/mysql-bin for logging
<0> can someone give me a mysqlhotcopy command line for copying a database from one account to another account?
<4> inviso: Do I need to change anything in this file? Why do I need it?
<6> hi. I am using vpopmail with mysql and I have a backup of the /var/lib/mysql/vpopmail folder. IS there a way to extract the users p***words from it? I am replacing the admin at this company I am working for and have no access to it
<1> inviso, thanks
<3> inviso: I created the /var/log/mysql folder and now mysql starts up fine
<3> inviso: I don't understand it but that is one less problem I have to worry about. Thanks for your help.
<2> Azuos001: not necessarily although you want to be very familar with all the settings. It's more so you explicitly know what it's using for a data_dir, tuning settings, etc
<2> opapo: that's another location that it sometimes wants to use for logs. Must have been setup that way.
<3> inviso: that folder must have been deleted when the power went out
<4> if I use innoDB, what would change in my sql commands? will the commands to create tables change?
<7> Azuos001: you can set the default table
<7> otherwise you can specify the ENGINE at the end of your create statement
<8> I would like to perform a query that returns like SELECT DISTINCT artist, COUNT(*) WHERE COUNT(*)-for-that-artist < 10 GROUP BY artist
<8> cant be impossible eh?
<9> !man Panama HAVING
<8> aha
<8> thats strange
<8> cant seem to find the manual pages
<8> guess I found them in topic here.
<10> ahhhh, having the correct indexes makes aaaall the difference
<11> Rock out!
<6> hi. I am using vpopmail with mysql and I have a backup of the /var/lib/mysql/vpopmail folder. IS there a way to extract the users p***words from it? I am replacing the admin at this company I am working for and have no access to it
<12> w0ls0n, probably not since its one way encryption
<6> ahh
<11> Encryption by definition is two way.
<6> if I make a vpopmail databse in mysql and then copy that data into it, any way to do that?
<11> Try it.
<11> Jy, Encryption implies decryption.
<6> how do I "look" at the users/p***words?
<6> once the data is loaded?
<11> SELECT * FROM table.
<10> !tell will[werk] about evil
<11> You broke the bot.
<11> shabbs, Join #willstest
<10> it was broken before
<11> !tell us about evil
<6> hmmm
<11> What?
<6> oh I think I entered the syntax wrong
<6> I tried SELECT * FROM table.vpopmail.frm
<6> and it just drops to the next line
<6> must not be the right table?
<11> Dude...
<11> Are you trying to hack?
<6> sorry I have never done this before
<6> no
<11> We don't do hacking.
<6> nope, I am not trying to hack
<11> I don't believe you. You didn't sound sincere.
<13> I have indexed a few columns of a table, and it's now slower than before to load those columns into a variable!! (?)
<6> heh
<13> did I do something wrong ?
<6> all righty, I am going to try to figure this out
<6> here is the scenario
<6> I am replacing someone who left who is using a centos box
<6> I want to install BSD as that is what I use
<6> I have a backup of vpopmail and a script in place to create all the users. I can reset everyones p***word but I really don't want to. I want to keep it the same.
<13> could it be because my KEY column isn't INDEXed ?
<10> KEY = INDEX
<13> then where could the problem come from ?
<14> how can i see what character sets mysql installation version supports?
<7> show charactersets
<7> or check the information schema if you are on mysql5
<7> SHOW CHARACTER SET
<14> Hmm neither of those work
<10> what version of mysql?
<10> charsets were introduced 4.1 iirc
<15> I seem to be having a problem with authdaemond and mysql.. if the authdaemon is left to idle for some time, and then someone tries to login, I get a "Mysql has gone away" error... (sql_error[3]) and then no one can login
<15> I have read and seen that this may be a bug with mysql 5.0 and some have setup to have the daemon shutdown and restarted hourly to stop this...
<15> does anyone know of any other potential fixes to this? I can downgrade to 4.0 in mysql if needed.. but trying to avoid that if there is a easier way to fix this
<11> Sounds like an authdaemond problem.
<11> Go to dev.mysql.com, and search for "gone away".
<15> yeah I have read up... they state bout setting wait_timeout to a high number so the server practically never times out...
<15> but I am wondering what this is gonna do to the system in a whole
<11> Why does it leave the connection open in the first place?
<11> it being authdaemond
<11> Why does it not reconnect?
<15> I have nooo idea why...
<11> I would be asking them :)
<15> I'm not entirely familiar with authdaemond other then its retrieving the p***word from the vpopmail database to authenticate a user
<11> I wonder if it uses a pconnect would it work better...
<15> it might, but how to change that is beyond me...
<16> how can i query for the following in the WHERE clause: back\double"single'
<16> it's stored in the database as such, but i'm having difficulty selecting by that field
<16> i've tried: select * from users where username like "back\double\"single'";
<17> DigitalStimulus: "back\\double\"single\'" should do it. The last \ is probably not neccessary.
<16> Duesentrieb: i've tried that as well, i think...lemme try that again
<16> negative for: select * from users where username like "back\\double\"single\'";
<17> rmove the last \ then
<17> that *should* work.
<17> unless you are doing this from the shell - in that case, you'll have to double-escape
<16> the query runs, but doesn't select the row
<16> mysql-query-browser
<16> (and php)
<17> never used it, but it should not require extra escapes
<17> try with the cli client
<16> k
<16> nope
<16> none of the escapes works with cli client either
<16> gah
<16> select * from users shows the row
<16> well my code is almost bulletproof, so if anyone tries to create a user with " then they'll just never be able to log in
<16> at least they can't break the sql statement
<17> strange
<16> there's no way to say "everything in between these markers is literal"?
<17> DigitalStimulus: i just tried with the cli client:
<18> Hi. I cannot connect with php to 127.0.0.1 mysql database (but to localhost yes). From command line i can connect. Anybody knows why this can happen?
<17> DigitalStimulus: this works: "back\\double\"single'"; so does this: "back\\double\"single\'"
<16> xmlaxis: try 'localhost'
<17> i have no idea what you problem is...
<18> DigitalStimulus, i cant..
<16> Duesentrieb: perhaps my data isn't stored literal
<18> DigitalStimulus, i have ~500 domains that are connecting to 127.0.0.1
<12> xmlaxis, cause your user is only setup to accept connections from the socket which is localhost.. not the tcp/ip 127.0.0.1
<17> xmlaxis: the reason is that "localhost" means "use unix socket", while 127.0.0.1 uses a tcp socket.
<18> all was working 5 min ago
<18> i had an error(when connecting from command line): Host 'host_name' is blocked because of many connection errors.
<18> i fixed this, now i can connect from command line
<18> but from php no..
<18> Jy, my user is root, accepting connections from %
<18> this is the most absurd thing that happens to me in the last 3 years..
<12> whats the error you are getting in php
Return to
#mysql
or
Go to some related
logs:
#fedora
#linux
#javascript
select_form predicate
#nvidia
dovecot unsupported dictionary type pgsql
ubuntu where start evolution-data-server
no acceptable c compiler xubuntu
#xorg
bandwidthd ebuild
|
|