| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> !m DeMiNe0 create table
<1> DeMiNe0: (CREATE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
<2> i tryed that
<2> not table i mean
<2> I mean database
<2> !m demine0 create database
<1> demine0: (CREATE DATABASE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html
<0> you can also do '!man searchterm'
<2> im pretty sure i have that command right too
<0> !man searchterm
<1> Nothing found.
<0> etc.
<0> 'create database foo'
<2> mysql> create database test123
<2> ->
<2> just brings me to that next -> line
<2> i need the ending ; don't i?
<3> yes
<4> <4> http://www.challenge-tv.com/index.php?mode=demodetail&demo=31023&dl=3
<2> thats what i thoughts :)
<4> <4> nice article on microsoft future plans
<2> i'm still having problems getting max-log installed though
<2> any idea why i was getting that error?
<2> http://pastebin.com/624495
<5> is there any posibility to connet from commandline from another server to that server from wich i want the dump?
<6> blueshark: as long as you have the privilege and the server allows you to connect
<2> blue
<2> do you have cpanel on that server by chance?
<5> i don't think so
<2> Do you know if that server allows remote connections to mysql?
<5> well, that is not my server,
<5> but how can i check that
<2> try connecting to it from another server
<2> use the servers hostname, and the username and p***word for that database
<5> well, can you give me the commandline, how to do that
<2> try
<2> mysqldump -uUSERNAME -pP***WORD -hHOST DATABASENAME > /PATHTOFILE.sql
<0> -hHOST is not necessarily necessary
<2> if he wants to connect to a remote server it is.
<0> true, but I doubt it would allow that
<7> !perror 12
<1> System error: 12 = Cannot allocate memory
<5> well, i guess that error 1130: ... is not allowed to connect to this MySQL server when trying to connect
<5> means that is not posibile
<8> hello, can anyone tell me when i try to insert a sql query I'm getting this error
<8> #1067 - Invalid default value for 'logind'
<8> trying to import
<8> into my punbb forums database
<8> logind timestamp DEFAULT 'CURRENT_TIMESTAMP',
<6> try remove the quotes
<6> Dustin_: and what version? may need 4.1 or above
<8> its mysql 5
<3> blueshark: are you sure that you cannot override the max timeout? the php doesn't respect the .htaccess property?
<6> Dustin_: then try remove the quotes
<8> from current_timestamp
<5> I thought to change the max timeout you have to change the php.ini
<6> Dustin_ yes
<5> how can i do that with .htaccess?
<0> php.net/ini_set
<3> blueshark: what Darien said
<3> Darien: do you know why i was banned from #php?
<3> * ##php
<8> lokus: executed fine , thanks. You experienced with punbb forums?
<6> no
<5> that semms to work
<5> thx
<9> !kick will
<10> hi everyone, anyone use eventum?
<10> i'd like to know the default pw\
<10> as i think that i'm still using the default (only i forgot it)
<10> i thougfht it was:
<10> user: admin@example.com
<10> pw: admin
<11> How is that related to MySQL?
<10> the faq doesn't have any info (nor does the wiki)
<10> will, created by MySQL
<10> MySQL AB*
<11> Oh
<10> so i see it as pertenent
<12> mick_linux: um, can't you edit database? :)
<11> Sure
<12> mick_linux: did you try eventum's website? :)
<10> yes
<10> they have a wiki there too
<12> anyway, original author sometimes sits on this channel :)
<10> but no info on that
<12> mediawiki!!! :)
<10> yup :)
<10> got to love MW
<10> i think i'll just rest via the db
<10> domas, know the nick?
<10> I'd like to say thanks :)
<12> you can find it out
<12> if you lurk here :)
<12> ha ha
<10> we use it for ClamWin now to manage fan mail and support requests
<10> it has made us a lot more productive
<11> Regarding the username/p***word issue, have you looked at the system tables?
<11> Like domas suggested?
<10> will, i'm going to reset it like that
<12> hehe, I use eventum every day
<10> i just didn't want to accidentally corrupt the db with a typo ;-)
<12> mick_linux: set --i-am-a-dummy :-D
<10> eventum really does kick
<10> hey i have fat fingers and i have an old compaq kb with a split space bar
<10> so that makes my typing prone to mistakes ;)
<13> hi. i have put into my.conf file the line: set-variable = long_query_time = 5. But he anyway logs all querries.. # Query_time: 0 Lock_time: 0 Rows_sent: 7 Rows_examined: 28
<13> any idea?
<11> I don't think you need "set-variable" in my.cnf
<11> You can check if it did set correctly by SHOW VARIABLES;
<13> | log_long_queries | ON |
<13> | long_query_time | 2
<13> hm
<13> set-variable=long_query_time = 2
<13> yes, is set corectly
<11> I thought you wanted 5?
<13> no, sorry, 2
<13> i have put 5 initially, then changed to 2
<11> And it is logging all queries?
<11> Maybe you should change it back to 5?
<13> | log_long_queries | ON |
<13> | long_query_time | 5
<13> # Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 4
<14> hey anyone around
<10> helos, yes
<6> xmlaxis: maybe it is logging query that does not use index
<14> mick_linux quick question if you dont mind
<14> if i have the follwoing
<14> Where capacity <= ALL (select capacity 2 blah blah etc) // where do i put the order by in here?
<14> Select name, size, id Where capacity <= ALL (select capacity 2 blah blah etc) // where do i put the order by in here? i want to order by name size and id
<14> ignore the fact i forgot the FROm :)
<6> !m helos select
<1> helos: (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/SELECT.html
<14> dude i already know that
<6> there is order by in the syntax
<13> lokus, no
<6> so, if yo know the syntax, you should know where to put the order by
<14> lokus i know the syntax of order by
<11> So why are you asking?
<14> but when i try with the <= in there it doesnt work
<14> the examples dont have <= another select
<6> you don;t need order by inside the subquery
<11> How about showing us your query.
<14> lokus i want it outside
<11> heh
<6> helos: put order by at the end
<14> nope doesnt work
<11> lokus, HE KNEW THAT ALREADY!
<6> helos: then pastebin the query
<14> ok
<15> Hey there
Return to
#mysql
or
Go to some related
logs:
enlightenment nm-applet
#ldap
rounded edges gimp
#perl
ubuntu postfix configuration internet site smarthost satellite
#linuxhelp
#linux
ubuntu 64 enemy territory
#bash
#lgp
|
|