| 00:01.04 | Korn_ | well |
| 00:01.21 | Korn_ | when i put reboot on blootbot,.... and i put !set up x |
| 00:01.25 | Korn_ | it says bugger all i dunno |
| 00:04.07 | Korn_ | any ideaS? |
| 00:07.11 | dondelelcaro | you don't have that factoid imported. |
| 00:08.05 | Korn_ | i do i made a directory |
| 00:08.22 | dondelelcaro | Korn_: check the database then and see if it's there. |
| 00:08.27 | Korn_ | Korn@debian:~/scripts$ ls |
| 00:08.28 | Korn_ | apt_dump.gz apt_dump_102404_080501.gz apt_dump_103104_080502.gz |
| 00:08.28 | Korn_ | apt_dump_101804_080501.gz |
| 00:08.32 | Korn_ | databasE?? |
| 00:08.35 | Korn_ | where is that? |
| 00:09.12 | dondelelcaro | Korn_: your mysql database. |
| 00:09.20 | dondelelcaro | Korn_: that's where the factoids actually reside. |
| 00:09.30 | Korn_ | elcome to the MySQL monitor. Commands end with ; or \g. |
| 00:09.31 | Korn_ | Your MySQL connection id is 12 to server version: 4.0.22-log |
| 00:09.31 | Korn_ | Type 'help;' or '\h' for help. Type '\c' to clear the buffer. |
| 00:09.34 | Korn_ | what else do i do? |
| 00:09.47 | dondelelcaro | select * from factoids where factoid_key='set up x' |
| 00:10.00 | Korn_ | -> select * from factoids where factoid_key='set up x' |
| 00:10.00 | Korn_ | <PROTECTED> |
| 00:11.04 | Korn_ | Threads: 1 Questions: 31 Slow queries: 0 Opens: 17 Flush tables: 1 Open tables: 11 Queries per second avg: 0.016 |
| 00:11.04 | Korn_ | -------------- |
| 00:11.26 | dondelelcaro | ; |
| 00:11.47 | Korn_ | before i us to put them with out trouble, |
| 00:11.55 | dondelelcaro | Korn_: you really need to learn how to use mysql at least a little bit before you even bother using a blootbot. |
| 00:12.01 | dondelelcaro | Korn_: read through the mysql tutorial on mysql.org |
| 00:12.24 | Korn_ | debian:/home/Korn/scripts# gzip -dc apt_dump.gz|grep 'INSERT INTO factoids'|sed 's/INSERT/REPLACE/'|mysql -p -u root blootbot; |
| 00:12.24 | Korn_ | Enter password: |
| 00:12.35 | Korn_ | debian:/home/Korn/scripts# and they dont event load the factoids |
| 00:16.04 | dondelelcaro | so query the blootbot's database, whatever that is, and figure out if the factoids have actually been added. |
| 01:51.09 | *** join/#debian-bots Melian- (~blootbot@68.45.22.122) |
| 01:51.42 | *** join/#debian-bots Melian- (~blootbot@pcp04354532pcs.glstrt01.nj.comcast.net) |
| 01:52.48 | *** join/#debian-bots Melian- (~blootbot@68.45.22.122) |