Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[RESOLVED] Move installation to new server
07-13-2011, 07:58 PM, (This post was last modified: 07-25-2011, 03:05 AM by haylau.)
#1
[RESOLVED] Move installation to new server
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
Reply
07-20-2011, 08:12 PM, (This post was last modified: 07-20-2011, 08:12 PM by steinm.)
#2
RE: Move installation to new server
(07-13-2011, 07:58 PM)haylau Wrote: 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
Reply
07-22-2011, 05:37 AM,
#3
RE: Move installation to new server
(07-20-2011, 08:12 PM)steinm Wrote:
(07-13-2011, 07:58 PM)haylau Wrote: 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?
Reply
07-23-2011, 06:21 PM,
#4
RE: Move installation to new server
(07-22-2011, 05:37 AM)haylau Wrote:
(07-20-2011, 08:12 PM)steinm Wrote:
(07-13-2011, 07:58 PM)haylau Wrote: 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
Reply
07-24-2011, 05:13 PM,
#5
RE: Move installation to new server
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

Reply
07-24-2011, 05:13 PM,
#6
RE: Move installation to new server
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

Reply
07-25-2011, 03:04 AM, (This post was last modified: 07-25-2011, 03:04 AM by haylau.)
#7
RE: Move installation to new server
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

Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)

Contact Us | LetoDMS Community Forum | Return to Top | | Lite (Archive) Mode | RSS Syndication