Changing forum URL

As part of securing my website, I am getting rid of all references relating to Dolphin. Right now when people load my forum, the address bar reads as follows:

http://www.mydomain.com/orca

I'd like it to read http://www.mydomain.com/forum

I know its not just a matter of changing the folder name because there are other things that reference back to orca. What are all the things I need to change in order to get mydomain.com/forum to function correctly across the board?

http://www.boonex.com/trac/dolphin/wiki/GenDolFAQs#HowcanIrenamefolderorcaintoforum

Have fun.

sounds great! But if I'm not using phpmyadmin, how do I run this command from shell?

update `TopMenu` set `Link` = replace( `Link` , 'orca', 'forum' ) where `Link`='orca/#action=goto&my_flags=1' OR `Link`='orca/#action=goto&my_threads=1' OR `Link`='orca/#action=goto&search=1'

Wow. I though everyone had phpmyadmin available from their hosting company.  How did you manage to get by so long without accessing your database?

I have one site that does not have anything in the control panel except an interface for managing email accounts - very bizarre - but yes - they are out there. For this site I use sequel pro - http://www.sequelpro.com/ to remotely administer the database - all you need is the same info you used for installing dolphin - database address / username + password.

Sequelpro is for OSX, but for Linux I can recommend using 'EMMA' - it should be available via most source repositories. For Windows I have previously used mysql administrator, but I am sure there are others.

It is also possible to install phpmyadmin in your webroot - but it will not be secure as it normally resides above the webroot. Not advisable - but possible as a last resort.

HTH

/DM

Of course you can also access mysql from the command line - pretty simple to do, but depending on how your server is configured and what access your user account has you may have to do it differently

Basically..

First log into mysql

Type mysql at the commend prompt - it should then ask you for your username and password. This should log you in to mysql. You can also specify this as one command -

mysql -u user -p password 

Now depending on what permissions you have been granted - you may be able to simply run mysql statements straight away - this may be true if you only have been granted access to one database, if you have other priviledges, you may need to explicitly select your database or include it within your sql

I'm glossing over this - as it's been a while, but it really isn't too hard - best thing is to Google for a command cheat sheet or simply type help once you are logged in

/DM

Ok cool. I'm half way there. But mysql -u user -p just connects me to mysql. The command listed here updates a particular database's table. So I'm guessing that there is a command needed before hand to connect to the DB itself.

What would be the order of commands to execute in order to get what the command below is supposed to accomplish?

update `TopMenu` set `Link` = replace( `Link` , 'orca', 'forum' ) where `Link`='orca/#action=goto&my_flags=1' OR `Link`='orca/#action=goto&my_threads=1' OR `Link`='orca/#action=goto&search=1'

And Deano: I don't use a hosting company. I configured my own servrs here. So I just manage my databases locally using MySQL Administrator :-p