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. |
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) |
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 |
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 ? |
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 |
Re: please rename HPB bots hostname
nice work, that's the way to do things :D
|
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.