how do I move my Elxis site from the local machine to an online server?

[ROUBOS]

I have not installed Elxis on the webserver and worked on that. Instead I've been using apache on my computer to develop the site.
Now its time to upload the site.

Should be simple enough... just don't want to make a mistake.

I guess uploading the files (FTP) and then trying to fix the database connection in the cPanel is the way... right?

thanks in advance

[ks-net]

1- copy files via ftp (preserve permissions)
2- install-update db (first fix paths urls ...search for them in text-editor)
3- update configuration.php (fix paths urls etc)
4-  softdisk =>update-system

hope not missing something....

you can do an updiag-check to be sure that all files are there

[ROUBOS]

will try,
hope I don't stuff it up. I should upload to a sub directory on the server.

Will it be easier if I install from scratch on the server? (but then I'll have to set the pages up again)


softdisk =>update-system ---- ?? how do I do that? what's softdisk ?

[ROUBOS]

or is it easier to just fto through the administrator?

[ks-net]

administrator/component/softdisk/update-sytem

will try,
hope I don't stuff it up. I should upload to a sub directory on the server.

try as many times as you want.. your local site will always be there..
upload to any dir you want... but if you want to have this as your primary site for you domain then upload to the root

do as says here:
http://wiki.elxis.org/wiki/Move_Elxis_from_a_sub-dir_to_the_root_dir
is the same process.. the only difference that the root dir this time is in a public server

use ftp to upload

[ROUBOS]

thank you.
will do it tonight and keep you informed here.

thanks again

[ROUBOS]

OK, how is the database uploaded? is it sitting in the elxis folder? so when i upload the elxis folder everything gets uploaded?

OK I have uploaded the site into a subfilder on the server (" /httpdocs/subfolder/ "). I edited the configuration.php as per this: http://wiki.elxis.org/wiki/Move_Elxis_from_a_sub-dir_to_the_root_dir

Now how do I upload the database? How do I backup the database on the local machine?

The server is using a Plesk control panel.

Sorry, but could someone explain the process in detail?

thanks and sorry if this seems so stupid

[ks-net]

at your cpanel create db and  with your server's phpmyadmin import the file that you have previously export from your local db through your local phpmyadmin.

before importing the db open with text editor and modify paths urls etc..

[ROUBOS]

So I need to install phpMyAdmin onto the online server as well .... ?

any particular options required in order to export the db properly? or default ok?

[ks-net]

default usually is ok... you will immediately see it, if it is not ok!


99% cpanels out there have a phpmyadmin, which cpanel is?

[ROUBOS]

its the Plesk Control Panel 8.6

and were do I find the exported database?

I selected my database to export, I left all option as they were, and hit go...
I got a phpMyAdmin SQL Dump in the form of a text file shown in the browser.. where do i go from there?

OK i created a database on the server, created a user for it and now can access the phpMyAdmin so I should be able to import the db.
Where does the exported DB go? and to i ftp it to a folder in the server?

[ks-net]

in plesk it is called as DBwebadmin

[ROUBOS]

sorry did not check "save as file"
sorry... must be the time of the night and the bacardi breezer ... 

[ROUBOS]

oops got an error when importing

character set error
CREATE DATABASE `mydatabase` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


MySQL said: 
#1007 - Can't create database 'mydatabase'; database exists



Tried once more, looks like there is an issue with the character set. When I choose to import, ii has only the 'utf8' choice. no 'utf8_general_ci'

[ks-net]

the db exists ..

you shouldn't add the  create database  option  when export the db...


in your file that you export from localhost delete all text above....

CREATE TABLE IF NOT EXISTS `elx_banner` (