| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> ah
<0> ok
<0> I think it works now
<0> Thanks
<1> np
<2> Can somebody tell me how I can "autofill" a field in a database with the username of the user who made the last changes?
<3> hello
<3> is there any easy way to sort a time field that's been formatted as 12-hour strings (ie, '10:00 AM', '12:00 PM', '1:00 PM', etc.)
<4> not sure why I can't set the query cache size above 88MB, anybody heard of this ?
<3> I'm currently doing this, but it puts 12:00 PM *after* 1:00 PM:
<3> ORDER BY RIGHT(alt_slot_start, 2) ASC, EXTRACT(HOUR_MINUTE FROM alt_slot_start) ASC
<1> work_superk: try ORDER BY TIME(alt_slot_start)
<3> throws an error
<3> syntax error
<1> what version of mysql?
<3> 4.0.x
<3> maybe 4.1.x
<3> I can't remember exactly
<5> what does it say when you login?
<1> time() is as of 4.1.1
<3> 4.0.18
<3> this also does not work: ORDER BY DATE_FORMAT(alt_slot_start, '%H:%i') ASC
<6> Any debian mysql users in here?
<7> Petaris: I have one debian server running mysql
<6> zeitoun: Did you use the debian package?
<6> Or the binary distribution?
<8> hey
<7> Petaris I used a deb package from dotdeb
<8> i'm running mysql 4.1.14 and i'm wondering what happens if i drop a database but don't delete the privileges users have to access the database and recreate a db with the same name. do the users still have access to the new db? (and if yes, will deleting all entrys from mysql.db with db='olddbname' work?
<6> zeitoun: ok, I was wondering about using the binary package (from mysql.com) with the debain packages of postfix and dovecot
<6> I may just use all source packages
<1> chrisba: yes, they'd still have access, but just deleting from mysql.db might not work if there were also table level privileges
<8> shabbs: okay, table-privileges are not important for me at the moment, if that problem comes up i have to overthing a few things anyway ;)
<8> too bad revoke doesn't like user-wildcards
<3> fixed my sorting issue... if anyone cares: http://tfug.pastebin.com/533877
<9> hi ppl
<9> how can i update my MySql query ?
<8> Extreminador: that question makes no sense
<8> Extreminador: what do you want to update?
<9> i have here a script and i am traying to install it
<9> the firts step is says
<9> Go to db admin of the hosting cpanel. Open your db and upload database which is named db1.sql to MySql query
<9> what is this mean ?
<1> upload!=install
<9> ?
<1> means go to your cpanel, open your database and upload the database file called 'db1.sql' which contains, no doubt, queries
<9> what mine cpainel ?
<8> phpmyadmin for example
<9> myslq painel ?
<9> ahhh
<9> i think i got it
<9> i will try
<9> thnaks
<9> *thanks
<8> no problem
<10> chrisba: cpanel is not phpmyadmin
<11> can i recover data that ha sbeen deleted in transaction, and transaction was commited?
<10> zimnyx: not without some serious magic
<10> or a recent backup :)
<8> inviso: but i guess pma is what he was looking for ;)
<10> chrisba: unlikely
<11> inviso: bin log won;t help?
<10> zimnyx: bin log records statements, afaik. It would have DELETE from table and COMMIT, but it wouldn't have "I'm about to nuke row #412323123 with data blah, blah, and blah"
<11> inviso: thanks.
<10> if it was inserted recent enough, you could get that from the bin logs though. And any updates that effected that row.
<11> i got you.
<12> what privs should I give to a read-only user? I need them to be able to do mysqldumps
<10> select is enough
<12> cheers
<1> might need lock tables
<12> why do I need to lock tables for read-only?
<1> for mysqldump
<1> to get a consistant snapshot of the data
<12> so they don't change while I'm dumping, you mean?
<13> I'm getting the error: "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld-500.sock'" which makes sense because the socket is /var/run/mysqld/mysqld.sock. Any ideas why 'mysql' is looking for the wrong socket?
<1> Authority: chech your my.cnf under [client] or [mysql] for socket=
<13> shabbs: the [client] section has the same socket defined
<1> the correct one or the wrong one?
<13> shabbs: the "right" one
<1> weird
<9> shabbs i do t have any commd called phpmysqladmin... i have one called mysqladmin
<9> for what i have undestunf i have to creade a new db called db1.sql right ?
<1> Extreminador: edit your db1.sql and see what it says. chances are it will create the database for you, in which case you need to run something like 'mysql -uroot -p < db1.sql'
<9> shabbs i dont have any file called that
<1> Extreminador: well whatever instructions you're reading ***umes you do
<9> i will see gain in the tar file
<9> to see if has escape any file
<9> i will test other script
<9> with other script, after done the instalation and when i am traying to go in off the administrator area using login and p***w it give me this error
<9> MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<9> *go in to the administrator area
<14> evening
<15> update Jogadores set N_Equipa = '1' where ID = '1' and equipa = '1', set N_Equipa = '12' where ID = '2' and equipa = '1'13 <--- this works not
<15> how do i update several things in one query?
<16> hello
<16> is there a way to view queries in real time like with mssql's profiler?
<15> how do i do several updates in one query?
<9> notice DeVeRaS olha uma gajo tuga
<9> ups
<17> how do I remove all access restrictions from a database?
<15> eh eh
<15> Extreminador viva
<17> like, is there anything like GRANT ALL PRIVILEGES ON *.* TO anyone whatsoever?
<15> Extreminador pah, dois updates numa query. Tens ideia?
<9> DeVeRaS eu nem um update sei fazer lol
<9> DeVeRaS tu que me vais ajudar ainda lool
<15> entao pq ts aqui???
<15> diz l se souber
<15> que eu vou ao manual ver esta... :(
<10> DeVeRaS: you trying to update several rows or several columns?
<9> i am having this error when traying tyaying to connect to the admin site --> MYSQL ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<9> can someone help me ?
<10> asymptote: you can do user@'%', but it's not terribly safe for obvious reasons
<10> Extreminador: contact your host
<9> inviso i am the host
<15> yup, i had that error too bedore, what a problem of the hosting
<10> Extreminador: do you have shell access?
<9> is on my house
<17> inviso, I know it's unsafe but authentication isn't working
<9> yes i have
<10> Extreminador: ok, is mysqld running?
<10> asymptote: that isn't a reason to moon the world
<9> yup inviso
<10> asymptote: what exactly is happening?
<10> Extreminador: what are you trying to connect with?
<9> i dont have any file called mysqld.sock
<18> Hi, I have a newbie question. I want to do a full text search from PHP on all the fields in a particular table in my DB. I can't see how to do it. Any know the trick?
<10> !m BlackShuck full text
<19> BlackShuck: (Full-Text Restrictions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Restrictions.html
<10> ...
<10> !m BlackShuck full text index
<19> BlackShuck: Nothing found
<9> well inviso this is a script that i have download from net and i have follos the instructions
<10> bah, anyway. Create a full text index and use the full text search
<20> !man fulltext
<19> (Full-Text Search Functions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
<9> know i was taying to login on my adminitrator account
<10> through what?
<9> but this error append
<9> mysql i think
<10> So, you say you started up Doom to play a little deathmatch and that error appeared?
<18> Do I need a add a full text index? How do I do this, to a table that already exists. (Can it be done in PHPMyAdmin?)
<9> inviso nop using php on the firefox
<10> BlackShuck: Yes, See the docs, Don't know
<9> and according to the error he is traying to connect using socktes
<10> Extreminador: and what are you using for the hostname in the webapp?
<18> hmm, read the docs several times, and it still makes no sense... :-(
<21> hi
<10> !m BlackShuck create index
<19> BlackShuck: (CREATE INDEX Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_INDEX.html
Return to
#mysql
or
Go to some related
logs:
#perl
#bash
bittorent meta file ubuntu
secondlife-bin: error while loading shared libraries
#linux
#suse
#ubuntu
compiz g400
#proftpd
from __future__import division
|
|