| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
<dammit> ;-))))
<dammit> 'diecommie'
<Therion> But there are so many other things
<dammit> now that was nice
<Therion> hehehe
<Leithal> !diecommie41
<Therion> will[werk]: The belligerent op stuff will be there, too. ;)
<Therion> That stuff is easy...taking care of search first
<Therion> Since it is most complicated
<Therion> !kick Leithal TINAB
<Leithal> heh
<Leithal> My car has to be the most useles **** ever. It has an onboard computer that does checks such as break pads, oil level, windscreen wash level etc.
<Leithal> And it also has another thing which is miles to go on petrol in tank etc.
<Leithal> the miles to go starts flashing when you're low
<Leithal> However when the windscreen wash gets low, it cancels out the miles to go on petrol warning
<Therion> hee
<solemnwarning> does mysql put carriage-returns on each line of a longtext field?
<dammit> ;-)
<Leithal> Like THAT is more important
<Therion> My car cannot seem to understand that it consumes gasoline when it is not moving
<dammit> solemnwarning: what?
<dammit> solemnwarning: no!
<solemnwarning> k
<Therion> So that it's "miles to go" calculation is waaaaaaaay off.
<Therion> solemnwarning: It stores what you tell it to store, generally
<Leithal> You can't go anywhere, BUT YOU CAN'T WASH YOUR WINDSCREEN WHILST YOU'RE NOT GOING THERE!!!!
<Therion> Any particular feature requests for the bot?
<Therion> Since I don't have to deal with python/twisted I'm more interested in working on it
<dammit> Therion: function list?
<Therion> dammit: help output from mysql client sufficient?
<Leithal> seen is useful, the man search, google, "tell us",
<Leithal> oh and you could write a syntax checker ;p
<Leithal> See you in 5 years
<Therion> am not writing a syntax checker
<Leithal> I do not blame you
<dammit> Therion: oh yes!
<litheum> Therion: are you adding a thing like "define" and "tell" to the new bot?
<dammit> did you get flood exceptions from freenode folks already?
<Therion> litheum: yes
<Leithal> perror
<Therion> dammit: nope
<dammit> yeah, a proper perror
<litheum> Therion: wil you make it show a list of what things are defined? :)
<Leithal> and an error message overview would be nice
<Therion> litheum: yes
<Therion> Leithal: overview?
<litheum> yay
<Leithal> short description
<Therion> Heh
<Therion> perror 127
<Therion> U R SCREWED
<Therion> Like that?
<Therion> ;)
<Leithal> not specifically perror
<Leithal> but I wouldn't expect you to fill all that in
<Leithal> perhaps a define for error descriptions as well
<Leithal> !errno
<Leithal> etc.
<Therion> Sure
<dammit> Therion: full error descriptions at least
<dammit> for upper level errors
<Therion> !perror 1064
<Therion> ;)
<Darien> hah
<Leithal> like !error 1267 - "DON'T EVER USE DIFFERENT CHARACTER SETS IT WILL BE THE DEATH OF YOU!!2222"
<Therion> !perror 150
<SQL> MySQL error: 150 = Foreign key constraint is incorrectly formed
<Therion> I have never quite understood why we only have SOME of the errors there
<Therion> Might be easiest to just fix perror
<Leithal> indeed
<Therion> o/` grandma got run over by a reindeeer o/`
<Leithal> That is such a cl*** song
<zdennis_> hey all, i 've got a winbox, which won't let mysql start, because it is looking in an old installation directory for the errmsg.sys file
<Leithal> isn't is Kenny Bloody Wilson?
<Leithal> someone like that
<zdennis_> I can't find the bad path in the system registry
<Therion> c:\my.cnf
<Therion> c:\windows\my.ini
<Therion> etc
<eventualbuddha> any tips on migrating a mysql database over to another computer?
<zdennis_> anyone know what may be up and how to fix? We have installed and uninstalled a few times
<Therion> Or check service configuration to see what defaults-file is in use
<zdennis_> ok, will check, thx Therion
<Leithal> <basedir>\my.ini as well
<Leithal> eventualbuddha: mysqldump
<Leithal> load with "mysql -u user -p dbname < file_output_by_mysqldump"
<dammit> Therion: ah
<Leithal> Right I'm off to watch a video with my good lady wife, before I get heckled to death
<dammit> I remembered one feature request
<Therion> Hmm, need to list a fill_help_tables.sql script from somewhere
<Therion> s/list/lift/
<dammit> !rawsql and !benchmark
<dammit> ;-D
<Therion> !nothankyou
<eventualbuddha> Leithal: i did something like mysqldump -ace --all-databases > somefile
<eventualbuddha> but when loading it i get this: ERROR 1064 at line 28: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 18
<Therion> If dumping from 4.1 or later and loading on 4.0 or earlier, need to specify --compatible options
<Leithal> eventualbuddha: moving from 4.1 to < 4.1 probably
<Leithal> Therion: The one in /scripts not good enough?
<yel> i need som help guys with this : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) i was messing with postfix issue and since im running postfix chrooted i have made a symlink from the mysql.sock to the chroot aread and restarted mysql now i get the error mentioned
<Therion> Leithal: Would be great
<yel> ill be thankfull for any help
<Leithal> Therion: but..?
<Therion> Leithal: Why don't you email it to me ;)
<Leithal> sure
<Therion> -- fill_help_tables.sql - this file is a placeholder to satisfy build dependencies -
<Therion> -- it will be replaced with the appropriate content by the Boostrap script that
<Therion> -- creates the official source distribution.
<Therion> ;)
<Leithal> Oh ****it
<Therion> I'm not much interested in cloning that work just now
<dammit> Therion: you can use embedded into java sql for that!
<dammit> it's absolutely secuer!!!!
<dammit> java==secure
<eventualbuddha> Leithal: yep, that's it. 4.1.10a-Debian_2-log to 4.0.24_Debian-10ubuntu2-log
<porkpie> Hi, are there any scripts available for running hot copy backups
<Therion> such as......mysqlhotcopy
<eventualbuddha> Therion: didn't see any --compatible option on mysqldump
<Therion> dellis@niflheim:~/bk/mysql-5.0/scripts> mysqldump --help | grep compatible
<Therion> --compatible=name Change the dump to be compatible with a given mode.
<Leithal> help tables could do with having more regular expressions info in
<tradergt> can you specify versions with man?
<will[werk]> NIFLHEIM
<eventualbuddha> Therion: hmm, man page didn't mention it. odd
<tradergt> man 4.0 create
<Leithal> purely due to the fact that it's something I wanted to do when offline and had no manual available
<Leithal> I'm sitll chatting and my wife is staring at me with daggers, I think I may go now.
<Leithal> Night all!
<will[werk]> Leithal: Wait!
<Leithal> will[werk]: ONLY IF YOU MARRY ME INSTEAD!
<Leithal> BYE!
<will[werk]> :(
<porkpie> Therion:mysqlhotcopy: Command not found.
<will[werk]> porkpie: Try looking elsewhere..
<Therion> tradergt: I'm going to support something like that, yes
<tradergt> coolio..
<Therion> Usage: /usr/local/mysql/bin/mysqlhotcopy db_name[./table_regex/] [new_db_name | directory]
<tradergt> probably still going to be a lot of people using old versions
<Therion> porkpie: Looks like you do not have complete installation
<porkpie> will[work]: ? what do you mean
<Therion> porkpie: Or perhaps you are on Windows ;)
<dammit> mysqlhotcopy ****s
<Therion> yep
<litheum> Leithal: download the pdf manual
<Therion> But better than nothing for MyISAM
<Therion> Not better than filesystem snapshot
<dammit> Therion: replication for myisam!!!
Return to mysql
or
Go to some related
logs:
k9copy
windowsxp
|
|