Elxis CMS Forum

Support => Database => Topic started by: MarD on June 20, 2007, 06:29:25

Title: Importing from the old server problem.
Post by: MarD on June 20, 2007, 06:29:25

I moved my account into a new server and I wanted to move elxis too with phpmyadmin. I followed the guide from forum's faq and I got my website working but with missing content. I tried the same steps on the same (old server) account with different mysql database and different pathname but still when I change something applies to both of them.

Title: Re: Importing from the old server problem.
Post by: eliasan on June 20, 2007, 08:03:18

Hi,

For sure you are doing something wrong. The question is what.

Lets assume that you have taken a backup of the database using phpMyAdmin. That would be an .sql file.

You edited the contents of the .sql file and replaced all occurences of references to your old environment with references to new one. For example, http://www.oldserver.com/images, becomes http://www.newserver.com/images

You copied all files from the old environment to the new one.

You created a new database to the new environment and used the edited .sql to populate it.

You edited configuration.php to reflect changes to paths, database, usernames and passwords for the new environment.

You took care of directory permissions.

If you done all that, I see no reason why you are having a problem, especially when you say that "I change something applies to both of them".

Title: Re: Importing from the old server problem.
Post by: MarD on June 28, 2007, 15:58:44

Ok, for "when I change something applies to both of them" was because I missed a path in configuration file. Still, after changing permissions and after alot of time checking and checking, some of the contents are not displaying(the most of them. Like News, Photos within News, Main Menu links, actually displays only two of them). Can I find a guide with step by step instructions? My customer want a website and I'm in a big trouble with this... If not, I will start a fresh elxis installation, but what I wanted, it's to have ready a sample elxis installation and just modifying it. I really need to get this working  :(

Title: Re: Importing from the old server problem.
Post by: eliasan on June 28, 2007, 16:09:49

Idea!

Go to Tools menu, and select the "Fix Language".
I have seen it making wonders in such cases.

Title: Re: Importing from the old server problem.
Post by: MarD on June 28, 2007, 19:52:54

Nothing changed, it was everything ok...

Title: Re: Importing from the old server problem.
Post by: Ivan Trebješanin on June 28, 2007, 21:10:50

Are your DB content entries surrounded with ticks(`) instead of single quotes(')?

EDIT: Sorry I meant field names...

Title: Re: Importing from the old server problem.
Post by: datahell on June 29, 2007, 00:08:38

Read this:

https://forum.elxis.org/index.php?topic=941.msg5294#msg5294

Title: Re: Importing from the old server problem.
Post by: MarD on July 03, 2007, 00:44:07

ok, my problem it's now fixed. I used phpmyadmin mysql4.0 compatibility mode (same mysql versions, dunno why it was needed) and then I took all the data properly. Thanks guys