| Rawplayer | kimseong: can you give an example to prevent it? with the example from the second url |
| kimseong | i did not read the url myself, usually the prevention method is proper quoting and escaping of characters |
| seekwill | Double check your data. Use prepared statements. |
| Diego_Rocha | ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) ??? |
| kimseong | !perror 2 |
| the_wench | OS error code 2: No such file or directory |
| Diego_Rocha | what command to resolving this |
| kimseong | does the file exist? |
| Diego_Rocha | no |
| kimseong | is mysqld running? |
| Diego_Rocha | no |
| kimseong | start the mysqld first, before connecting |
| Diego_Rocha | this error is in mysql start |
| kimseong | Diego_Rocha: mysql is the client, mysqld is the server, server must be running before client can connect |
| jsoftw | Hey 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_Rocha | kimseong, what command start the mysql server ??? |
| sensei | If 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? |
| karsten | sensei: If you can stand to lose data, just truncate the file: >/file |
| sensei | karsten: What kind of data do you mean? |
| karsten | sensei: The data in the file. |
| sensei | Just the slow queries ? Oh ok, yeah no problem at this point :) Thanks |
| karsten | sensei: To avoid this problem in general, use syslog rather than direct writes to files, and any log rotator can help you. |
| OmiKrOn | hi 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 |
| sensei | karsten: Good point, I'll look into that |
| OmiKrOn | anyone? |
| sensei | Grr, 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 |
| mnguyen | hat java type corresponds to a MySQL DATETIME? Sorry Im still confused by the conversions page |
| seekwill | mnguyen: ? DATETIME is 2007-05-17 22:47:12 |
| mnguyen | nm |
| seekwill | chadmaynard: Where are you now? State GA? |
| chadmaynard | why? |