[RESOLVED] Move installation to new server

[haylau]

Hi

Could anyone advice how to move / copy our DMS installation to a new server.

I installed it one one host because i did not have access to enough databases on the main host. Now they have given us unlimited database so I want to move the whole installation without having to upload each file manually again.

If this is possible, some very easy step by step instructions would be very much appreciated

[steinm]

Hi

Could anyone advice how to move / copy our DMS installation to a new server.

I installed it one one host because i did not have access to enough databases on the main host. Now they have given us unlimited database so I want to move the whole installation without having to upload each file manually again.

If this is possible, some very easy step by step instructions would be very much appreciated

Just move the content directory to the new server and make a mysqldump of your database which you reinsert into the target system.

You may have to adjust some of the path in the settings.

Uwe

[haylau]

Hi

Could anyone advice how to move / copy our DMS installation to a new server.

I installed it one one host because i did not have access to enough databases on the main host. Now they have given us unlimited database so I want to move the whole installation without having to upload each file manually again.

If this is possible, some very easy step by step instructions would be very much appreciated

Just move the content directory to the new server and make a mysqldump of your database which you reinsert into the target system.

You may have to adjust some of the path in the settings.

Uwe

So on the new server, will I install letodms first, and create database, then copy across the content folder, then upload the sqldump?

[steinm]

Hi

Could anyone advice how to move / copy our DMS installation to a new server.

I installed it one one host because i did not have access to enough databases on the main host. Now they have given us unlimited database so I want to move the whole installation without having to upload each file manually again.

If this is possible, some very easy step by step instructions would be very much appreciated

Just move the content directory to the new server and make a mysqldump of your database which you reinsert into the target system.

You may have to adjust some of the path in the settings.

Uwe

So on the new server, will I install letodms first, and create database, then copy across the content folder, then upload the sqldump?

Yes, install letodms first, create an empty database, copy the content folder, upload the sqldump.

Uwe

[haylau]

So, I now have Letodms installed on the new server. I have created the database, copied the content folder

I have exported the sqldump from the original server, but when I try to import to the new database i get an error

"SQL query:

--
-- Database: `haylauic_quobay`
--
CREATE DATABASE `haylauic_quobay` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci

MySQL said: Documentation
#1044 - Access denied for user 'dbo375524523'@'%' to database 'haylauic_quobay'

Now, I know nothing about sql database, but that eror message actually makes some sense to me because the database has a different name, as do the tables

So, where to go from here? As i have the data on the new server, what I actually need to pick up is the folder, locations, comments etc. Can I do this somehow?

Any help gratefully received

[haylau]

So, I now have Letodms installed on the new server. I have created the database, copied the content folder

I have exported the sqldump from the original server, but when I try to import to the new database i get an error

"SQL query:

--
-- Database: `haylauic_quobay`
--
CREATE DATABASE `haylauic_quobay` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci

MySQL said: Documentation
#1044 - Access denied for user 'dbo375524523'@'%' to database 'haylauic_quobay'

Now, I know nothing about sql database, but that eror message actually makes some sense to me because the database has a different name, as do the tables

So, where to go from here? As i have the data on the new server, what I actually need to pick up is the folder, locations, comments etc. Can I do this somehow?

Any help gratefully received

[haylau]

Sorted.

I uses Export to export data only from the old system. I then opened the file and made one or two changes to make sure all was in order (name of new database, user names and passwords)

Then in the new database I cleared ALL the tables first, then imported the data and all is now working fantastic

---

Sorted.

I uses Export to export data only from the old system. I then opened the file and made one or two changes to make sure all was in order (name of new database, user names and passwords)

Then in the new database I cleared ALL the tables first, then imported the data and all is now working fantastic