Localhost to Remote Host server

[leco]

Not sure if this should be in the How do I . . . forum or in here, but I'm sure someone will put me right if it's in the wrong place.

Having created my EdugeekJoomla web site and got it how I want it on my local machine (not that I have yet but a bit of forward planning has got to be a good thing). How do I transfer that to a remote server? Do I have to install the package on the remote host and then re-create the site or is there a way of uploading that preserves the design?

Sorry if this is a really stupid question but I'm more used to a flat site, just uploading changed pages, not done a database based site before.

[Edu-IT]

You should just be able to upload everything to your host. You will need to backup the database though on your local machine and restore this backup to your host.

[Ric_]

Sorry... this should be on the wiki...

1. Back up the MySQL database on the local machine
2. Extract the database on your remote host
3. FTP all the files to the remote host
4. Edit the configuration.php file (depending on your hosting provider you may find it easiest to install a new copy on the server, run through the setup and copy the configuration.php before blitzing the lot - you will then have a known good configuration.php file)
5. Check all the file/directory permissions are correct

[leco]

Sorry... this should be on the wiki...

1. Back up the MySQL database on the local machine

1. OK so far
   
   

2. Extract the database on your remote host

[Ric_]

Extracting the SQL:
If you have something like phpmyadmin simply stick the file (proabably something.sql) into the relevant box. You may even have remote MySQL access and can just use MySQL Administrator.

To edit the configuration.php file:
Just open in your favourite text editor (I like vi but wordpad would do on Windows).

[leco]

Thanks again Ric_ I'll have a practice. I'll need to ask my remote host about MySQL admin access. I have phpMyAdmin, just starting to have a look around that. As I mentioned I'm not used to dealing with databases for web sites. Wish me luck:-)

[Edu-IT]

Thanks again Ric_ I'll have a practice. I'll need to ask my remote host about MySQL admin access. I have phpMyAdmin, just starting to have a look around that. As I mentioned I'm not used to dealing with databases for web sites. Wish me luck:-)

Who is your host? Do they use cPanel?

[leco]

Who is your host? Do they use cPanel?

Host is YHGfL, sorry I've no idea if they use cPanel (whatever that is)

[Edu-IT]

Host is YHGfL, sorry I've no idea if they use cPanel (whatever that is)

They wouldn't. I forgot that this is a school site and not a personal one.

Have you managed to import the database?