+- LetoDMS Community Forum (https://community.letodms.com)
+-- Forum: LetoDMS Support (https://community.letodms.com/forumdisplay.php?fid=4)
+--- Forum: General Questions (https://community.letodms.com/forumdisplay.php?fid=15)
+--- Thread: [RESOLVED] Move installation to new server (/showthread.php?tid=318)
[RESOLVED] Move installation to new server - haylau - 07-13-2011
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
RE: Move installation to new server - steinm - 07-20-2011
(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
RE: Move installation to new server - haylau - 07-22-2011
(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?
RE: Move installation to new server - steinm - 07-23-2011
(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
RE: Move installation to new server - haylau - 07-24-2011
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
RE: Move installation to new server - haylau - 07-24-2011
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
RE: Move installation to new server - haylau - 07-25-2011
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