#mysql - Fri 18 May 2007 between 00:08 and 01:11

NY Lost Funds



Rawplayerkimseong: can you give an example to prevent it?
with the example from the second url
kimseongi did not read the url myself, usually the prevention method is proper quoting and escaping of characters
seekwillDouble check your data. Use prepared statements.
Diego_RochaERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) ???
kimseong!perror 2
the_wenchOS error code 2: No such file or directory
Diego_Rochawhat command to resolving this
kimseongdoes the file exist?
Diego_Rochano
kimseongis mysqld running?
Diego_Rochano
kimseongstart the mysqld first, before connecting
Diego_Rochathis error is in mysql start
kimseongDiego_Rocha: mysql is the client, mysqld is the server, server must be running before client can connect
jsoftwHey um, the GRANT stuff to a database, is the ONLY place that is stored in mysql.db ?
So if I copy the relevant rows from there, and insert it into another database, I should be away? (assuming that the database exists on the other server)
Diego_Rochakimseong, what command start the mysql server ???
senseiIf I'm logging slow queries to a .CSV file, and it's a bit too big.. can I just stop mysql, move the file to another machine and touch slow_log.CSV and restart mysql, or are there any indexes etc involved?
karstensensei: If you can stand to lose data, just truncate the file: >/file
senseikarsten: What kind of data do you mean?
karstensensei: The data in the file.
senseiJust the slow queries ?
Oh ok, yeah no problem at this point :) Thanks
karstensensei: To avoid this problem in general, use syslog rather than direct writes to files, and any log rotator can help you.
OmiKrOnhi
any ideea why this fails?
LONGBLOB in statement [CREATE TABLE SLIDECHUNKS (slidechunk_id INTEGER NOT NULL, slidechunk_size INTEGER NOT NULL, slidedata LONGBLOB]
mysql 4.x
senseikarsten: Good point, I'll look into that
OmiKrOnanyone?
senseiGrr, this database is giving me quite some grief! It keeps getting stuck on 'Opening tables', but only when it tries to access larger partitioned tables
mnguyenhat java type corresponds to a MySQL DATETIME? Sorry Im still confused by the conversions page
seekwillmnguyen: ?
DATETIME is 2007-05-17 22:47:12
mnguyennm
seekwillchadmaynard: Where are you now?
State
GA?
chadmaynardwhy?

Page: 2 9 16 23 30 37 44 51 58 65 

IrcArchive

NY Lost Funds