please rename HPB bots hostname

[Terran]

The underscore in hpb_bot.bots-united.com is an "illegal" DNS character.
Renaming the site to hpb-bot.bots-united.com would be appropirate as this causes errors by some proxies. Or at least add this as an alternative hostname.

[Pierre-Marie Baty]

Eek! Thanks for the tip.

Could you tell memed about this ? I'm over busy right now and I don't think I'll have time to change it but memed can help. Tell him to do a grep on /home/bots-united.com and change all the links that point to hpb_bots.bots-united.com as well.

Thanks again! (and thank him for me btw )

[Onno Kreuzinger]

ok, i made a full search (4 results) and i completly sed'ed the database. no more links to hpb_bot.... should be found.
(yes i did dump, sed and re-import the whole database, _thats_ what i like on db's you can dump and work on them ...)

cheers

p.s. for the interessted, thats why i like beeing a DBA:

 mysqldump -c --add-drop-table -u <some-user> -p<some-pass> botsunited_database |grep -v "^--"|sed  's/http://hpb_bot.bots-united.com/http://hpb-bot.bots-united.com/g'>botsunited_vb3-04032004-restore.sql ;mysql -u <some-user> -p<some-pass> botsunited_database < botsunited_vb3-04032004-restore.sql

[Pierre-Marie Baty]

you rock, memed

Just for my information, what did the grep -v "^--" do ? what's the characteristic of a ^-- pattern in a database dump ?

[Onno Kreuzinger]

that grep -v is just to remove the comments starting with -- which mysqldump prints out by default. one of these silly default options i refuse to correct by looking for command line options. i just use the tools i know, like grep

p.s. grep -v "^--" removes all lines starting with "--", obviously no sql statement

p.p.s.
FYI:
the db is 24 mb in size

[Terran]

nice work, that's the way to do things

[Onno Kreuzinger]

hmm most "planners" and "chief programmers" don't like my way, its too pwerfull i guess and heck, mistakes are less often if you do it the KISS way [KEEP IT STUPID SIMPLE].