Page 1 of 1

Database migration

Posted: Sat Aug 23, 2008 1:03 am
by 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.

Re: Database migration

Posted: Sat Aug 23, 2008 2:05 am
by 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...

Re: Database migration

Posted: Mon Aug 25, 2008 5:46 pm
by 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.

Re: Database migration

Posted: Mon Aug 25, 2008 6:55 pm
by alby
arigatox wrote: 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

Re: Database migration

Posted: Mon Aug 25, 2008 7:05 pm
by 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.