.:: Bots United ::.

.:: Bots United ::. (http://forums.bots-united.com/index.php)
-   HPB_bot (http://forums.bots-united.com/forumdisplay.php?f=35)
-   -   please rename HPB bots hostname (http://forums.bots-united.com/showthread.php?t=981)

Terran 04-03-2004 11:49

please rename HPB bots hostname
 
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 04-03-2004 13:00

Re: please rename HPB bots hostname
 
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 :D)

Onno Kreuzinger 04-03-2004 15:02

Re: please rename HPB bots hostname
 
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:
Code:

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 04-03-2004 15:25

Re: please rename HPB bots hostname
 
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 04-03-2004 15:29

Re: please rename HPB bots hostname
 
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 :D

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 04-03-2004 15:54

Re: please rename HPB bots hostname
 
nice work, that's the way to do things :D

Onno Kreuzinger 04-03-2004 16:30

Re: please rename HPB bots hostname
 
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].


All times are GMT +2. The time now is 11:02.

Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.