#mysql
19 October 2007
Total 26 pages. You are browsing page 3/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
00:59 <****> What chmod and owner/group should it be?
00:59 <****> Yes
00:59 <****> mysqld --user=mysql
00:59 <****> -rw------- 1 root root 0 2007-10-19 02:33 /var/log/syslog
00:59 <****> No, I'm talking syslog
00:59 <****> that will print errors to stdout.
00:59 <****> /var/log/mysql* ?
00:59 <****> Oh
00:59 <****> _Narada, all empty.
01:00 <****> chadmaynard, ooh, interesting
01:00 <****> any locations in my.cnf?
01:00 <****> w3: just pastebin the entire output
01:02 <****> chadmaynard, I'm restarting machine, don't know what else to do
01:02 <****> Because
01:02 <****> It says that port 3306 is being occupied, and there are no apparent processes running to signify that
01:02 <****> and netstat -ap isn't showing mysqld
01:02 <****> does ps ax show mysqld?
01:04 <****> try with lsof -i
01:05 <****> lsof?
01:05 <****> How can I make my mysql accept connections from anywhere?
01:05 <****> why do you want to do that?
01:05 <****> comment bind-address in my.cnf and then add appropriate user accounts
01:06 <****> ssh tunnel
01:06 <****> When I connect from the command line client, it's working
01:06 <****> but when I connect using zmysqlda (zope product) I get: (1045, "Access denied for user 'eguides'@'localhost' (using password: YES)")
01:07 <****> the command line even connects ok from other machines on the net
01:07 <****> and deep in the error log it says something like cannot access /var/run/mysq/mysql.socket
01:07 <****> (with zmysqlda)(
01:07 <****> I just want it to work so I can get on with my work
01:07 <****> chadmaynard, no, that's what I was doing
01:07 <****> It's only a test machine
01:07 <****> Anyway
01:08 <****> My reboot fixed it
01:08 <****> one has to wonder what a reboot fixes
01:08 <****> Somewhat to my dismay
01:08 <****> Yes, exactly
01:08 <****> mysqld was already running
01:08 <****> i suppose
01:09 <****> It must have been - though it was nowhere to be seen
01:10 <****> could someone with fresh eyes please tell me why there is an SQL syntax error here : CREATE TRIGGER BEFORE INSERT ins_cat ON categories FOR EACH ROW new.createdd=now();
01:11 <****> what does MUL mean?
01:11 <****> rgr, perhaps you're using table types that don't support trigger?
01:12 <****> matiu: what types would they be? And why would I get a syntax error?
01:12 <****> to see the structure
01:13 <****> rgr: did you set the delimiter
01:13 <****> rgr, all I know is mysql supports different "storage types" or something, and some (perhaps all) of them don't support triggers
01:13 <****> rgr I'm a bit out of date..
01:13 <****> chadmaynard: its all on one line so I dont have to do I?
01:13 <****> rgr: yes
01:13 <****> PaulB: The MUL value indicates that multiple occurrences of a given value are allowed within the column.
01:13 <****> btu assuming the delimiter (which I did set in a test) should the trigger syntax I posted be ok?
01:14 <****> !man describe
01:14 <****> (DESCRIBE Syntax (Get Information About Columns)) : http://dev.mysql.com/doc/mysql/en/describe.html
01:14 <****> _Narada: thank you
01:14 <****> look on above link
01:14 <****> chadmaynard: this is in a SQL script I import using phpmyadmin btw.
01:14 <****> what's the easiest way to load a .sql file into mysql that's 600mb+?
01:15 <****> PaulB: are you asking what MUL means or how to see schema?
01:15 <****> bleh i always do imports through cmd line
01:15 <****> i don't trust pma
01:15 <****> when i do source file.sql from the command line i'm getting a:
01:15 <****> ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes
01:15 <****> mysql < file.sql
01:15 <****> kuito: mysql -hhostname -uusername -ppassword database < file.sql
01:15 <****> chadmaynard: what it means
01:16 <****> i just dont get why you would have to put it there
01:16 <****> add encoding if need be
01:16 <****> why not just duplicate it
01:16 <****> without putting that there
01:16 <****> PaulB: literally "multiple" It means multiple occurences are allowed. It could be a composite key
01:16 <****> _Narada, ERROR 1153 (08S01) at line 7: Got a packet bigger than 'max_allowed_packet' bytes .. is what i get
01:16 <****> chadmaynard: thanks
01:17 <****> Wow. These triggers are really hard to trouble shoot in mysql. Almost no indication of what the error might be.
01:17 <****> kuito: uhh; maybe increase that option in my.cnf? no sure
01:17 <****> kuito: Google max_allowed_packet , see what it is, and adjust accordingly.
01:17 <****> s/no/not/
01:17 <****> hehe i've done that the command line options on mysql.com doesn't work for some reaosn
01:17 <****> does the bot support config settings look ups?
01:17 <****> !man max_heap_size
01:17 <****> Nothing found.
01:17 <****> kuito: you should have used extended inserts ;)
01:18 <****> hehe right
01:18 <****> SQL is improv bot
01:18 <****> see /topic
01:18 <****> rgr: show the entire create trigger statement.
01:19 <****> spanish optional? heh wtf
01:19 <****> i wonder what's in store in 6.x.x
01:20 <****> Er
01:20 <****> and i protest in being required to have a sense of humour
01:20 <****> chadmaynard: that was it.
01:20 <****> Does the mysql user by default have a password?
01:20 <****> rgr: the delim?
01:20 <****> DELIMITER |
01:20 <****> CREATE TRIGGER BEFORE INSERT ins_cat ON categories FOR EACH ROW new.createdd=now();
01:20 <****> |
01:20 <****>
01:20 <****> delimiter // create trigger NAME before insert on TABLE for each row begin set new.COLUMN = now(); End; //
01:21 <****> all on one line in my sql script?
01:21 <****> sure
01:21 <****> lines mean nothing
Total 26 pages. You are browsing page 3/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last