Database migration

[arigatox]

Hi, this is my first post to the forum, so I hope to do it correctly and in the correct place.
I have an old cmsmadesimple site (version 1.0.8 ) that is currently online.
I'm working on a new site in a test sever with version 1.4 installed from source.
I wanted to know if there is a way to migrate the databases from v1.0.8 to v1.4
I tryed the most simple way: Copying the database from one site to the other, but didn't work.
Searching in this forum I could found some information about upgradings procedures, but it was always upgrading over the same site.

I have full access to the servers.

Thanks for this wonderfull tool!

Natalio.

[Dr.CSS]

You copied the DB how?...

Did you move all the folders/files to new/old site server from the 1.4...

If you don't care about the old site you just copy/replace old folders/files with the new ones and then import new DB...

[arigatox]

I copied the content of /var/lib/mysql/cms from one server to the other, and created the "cms" user with the correct permisssions.

I will try copying the entire old site, and then upgrading it.

Thanks.

[alby]

I copied the content of /var/lib/mysql/cms from one server to the other, and created the "cms" user with the correct permisssions.

I will try copying the entire old site, and then upgrading it.

you cannot copy file to new server only (depend from your distributions, if you have different mysql ID/group owner, mysql versions, ....)
my advide is: use mysqldump for backup/restore or mysqlhotcopy .....

Alby

[arigatox]

The servers were both similars in platform and OS's, so there was no problem in the copy procedure.
I Finally copy the old site to the new server, and proceed with a standard upgrade.
I loss some tweaks I made in the new server, but it was faster to re-do them, than keep fighting for a database-only upgrade.

Salutti.