HP intranet hosting

[ballsricky]

I know some people have already got this up and working but I just have a few general questions.



I have activated mambo and it has installed itself in /cms/ folder, does this mean i now have to redirect to here from the main index page?



I also have a booking system currently running that I would now like to move over, it's running php and mysql.  Does anyone know how I can go about this?  There are thousands of enteries in this database and I like to be able to just copy it over without having to recreate anything.



I have never used anything like plesk before so any help would be much appreciated.

[casper]

Simply create a blank index.html page and put this in the head



<META http-equiv="refresh" content="0;URL=http://your_intranet/CMS">



As for the database:



Backup the database

Recreate it in the Control Panel on your intranet site - try and give it the same Name/User/Password etc

Then import the backup you did and this should recreate all the tables and insert the data.

Then upload your existing files for the script. You many have to tweak some of the setting in the script e.g absolute path etc.



This should work

[ballsricky]

how do you import?



i can only see an export option.  this is in the databases > dbwebadmin ? or should i be somewher eelse

[casper]

Sorry should have mentioned this

You should see SQL in the DB Admin. In there there is an option to browse to your backup file. Then just click 'go'

[ballsricky]

hey,



i managed to find the import but now i'm getting an error:



SQL-query:



-- phpMyAdmin SQL Dump

-- version 2.6.0-pl3

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Mar 29, 2006 at 12:29 PM

-- Server version: 4.1.8

-- PHP Version: 5.0.3

--

-- Database: `mrbs`

--

CREATE DATABASE `mrbs` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci



MySQL said:  



#1044 - Access denied for user 'root'@'%' to database 'mrbs'



how come i'm being denied access when root is the only user i have made for this database?





by the way, thanks for the help

[ballsricky]

I'm a bit confused.



I want to call the database mrbs, and for some reason it thinks that it already exists.



Would anyone know why?

[casper]

Your intranet is on a shared hosting server so someone else has already created a database called 'mrbs'. The safest option is to put your DENI number before the name of the database e.g db12345678_mrbs

[ballsricky]

thanks for the reply,



eventually my brain started working today.  I guessed as much and once I got the database made, i put the deni number in front, I realised that my sql file was actually trying to create the database as well as update the tables.



Did a of editing and now I am up and running!!!



Now I just have to do a crash course in mambo followed by another in phpBB.  



Just as a matter of interest, do you provide username and password for the intranet site and phpBB or do you not bother with that?  Connecting to the LDAP would be the best option but I asked and they said no.

[ciaran]

here did anyone get a call from c2k about hosting wesites with them? approx £195 per annum , they give you a free 2 week trial to see what you think of the setup.

[casper]

Yea I got that too

[ciaran]

have you had your two weeks free trial?