Move site to new hosting space [SOLVED]

[ROUBOS]

Hi all,
I want to backup a site and move it to a new hosting server.
So what do I do?

Do I:
backup the database,
save the template,
then import the database,
install elxis (latest version, the site currently has an older version),
and install the template again
?

[xmanhattan]

Hello ROUBOS,

If you have cpanel you can use the file manager to compress all the files in your public_html area into a zip.
Yes, export the sql using phpadmin or using the elxis database manager complete sql backup.
Download your zip to your local system and then upload to your new host.
Using cpanel at the new host, you can use the file manager to upload the zip into your public_html area and then uncompress (unzip).
Create the same database name and user then use phpadmin to import your sql file.
Basically that's it.

Regarding your comment about tophost:  I have used them but only for Greek domain names and I have not had a problem.
I do not use them for hosting.

[ROUBOS]

OK so I got into phpmyadmin and did an export of the database (small file). Hope I did it right. Check the screenshots of my export options if I did it right.

And since I have no access to SHELL, or a backup utility in the control panel, I used FTP to download the entire httpdocs/ folder.

Should this cover me?

[xmanhattan]

The second image looks correct.

[ROUBOS]

so now since I got the backup, I just upload the files to the new hosting space, use phpmyadmin to import the database, then make changes to config php file and we're set?
this is a very old elxis version. How about if I install the latest elxis version and just upload the old template. will this work too?

[xmanhattan]

Not really.  There were database changes between some versions.  You would have to load it the way it is and then upgrade version by version.

[ROUBOS]

cool thanks. will do it soon and let you know what happened or if I have more issues...

[ROUBOS]

when I import the database, do I create a database and import the tables from the backup, or does the import create the database again ?

[xmanhattan]

You have to create the database and add a user to access it through cpanel.
Don't forget to use the same database name and user name and password.

[gmelis]

Best working solution to this problem: Backup the *whole* of your elxis site. That leaves out the database(s). sqldump your database(s), then import them in your new installation.

If you don't stick to the rules though, you *can* just copy the directory with the database(s), then just fix the access rights in your new installation, but there are cases where this might not work (hadn't had any problems till now, but I am the server owner...). As a word of caution, in order to do such a database directory copy, you better have full access to the new server. For example, you might have to put them in "/var/lib/mysql", and you'll only be able if you've server admin rights (like root, for example).

[ROUBOS]

ok, uploaded all the files to the new server,
created the database and the user using exactly the same names and passwords,
and now I'm waiting till the nameservers are changed so that the domain names point to the new server.
I guess I can change the ip in the configuration.php file where the domain name is if I want to access the site using the ip address.

using phpmyadmin I imported the database tables from the backup I've made.

So far I think I'm on the right track right?

[xmanhattan]

When you call the site, it may not work at first.  You might even have to call the admin page using index.php\administrator.
Log in then go to tools, clean cache and it should work normally assuming that you did everything correctly.

[ROUBOS]

at the moment I'm getting a 404 not found error. when I use the http://IP/index.php.
But I have not altered the config file.
Waiting for the name servers to point to the new hosting space

[ROUBOS]

they say they've fixed the nameservers, so how do I know if the site now is working and not pointing to the old server?

[xmanhattan]

Try this:  https://grweb.ics.forth.gr/ and check whois for gr.