[solved] Moving Established Site to a new server - how to

[friar778]

Hi:
I have made the searches for a striaghtforward way to move a currently operating CMS Made Simple site to a new server.  I found the page in the documentation that describes this, but I don't have access to PhpMyAdmin on the new server in order to import the old database onto the new server.

Plus, I am not even sure how to export correctly from the old server, what filename to use, etc.  PhpMyAdmin on the old server has something about file name parameters, not sure how to use this feature and can't turn it off.

Should I name the export database file the exact same thing as the old database file?

Any help in migrating would be most appreciated.

Thanks,
friar778

[Dr.CSS]

There is this, but sounds like you may have read it...

In my 'myPHPadmin' I click the DB name and then hit the export button and make sure all tables are hilited then tell it to write to a gzip file and then let it run in default and it spits out a selfnamed file and then go to next one and make new DB and then import it...

Then just move all folders/files and make necessary changes in config.php for DB and paths, if all else fails you can add the install folder and try install/upgrade.php, last ditch with install folder run install/ just uncheck "create tables" at the DB page of it...

[friar778]

I am not sure what changes need to be made to the config.php files.  Tried a different username/password

this is what I get either  way:

Database Connection Failed
Error: Access denied for user 'lppsr'@'localhost' (using password: YES) (1045)
Function Performed: CONNECT
Host/DB: localhost/lppsr
Database Type: mysql


Maybe this is just a username/password problem? or could it also be related to the path settings?


  Not sure about the paths, Are they relative to site root or server machine root?

Thanks,
Friar

[Dr.CSS]

When moving you import the DB to a new server? ok then you have a new DB name, user, password, so you need to change config.php to reflect the changes, and the path to your folders/files will have to reflect all new changes...

A real easy way to get all the path stuff is to just upload new cmsms to a sub folder and run install then when it is up and running look in it's config.php to see how the paths are written...

[friar778]

Ok:

Well, now the database connects , but now I get this error:

ERROR: The CGExtensions module could not be found.
ERROR: The CGExtensions module could not be found.

Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\vhosts\lppsr.org\httpdocs\modules\NMS\NMS.module.php:45) in C:\Inetpub\vhosts\lppsr.org\httpdocs\lib\classes\class.admintheme.inc.php on line 161

Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\vhosts\lppsr.org\httpdocs\modules\NMS\NMS.module.php:45) in C:\Inetpub\vhosts\lppsr.org\httpdocs\lib\classes\class.admintheme.inc.php on line 164

Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\vhosts\lppsr.org\httpdocs\modules\NMS\NMS.module.php:45) in C:\Inetpub\vhosts\lppsr.org\httpdocs\lib\classes\class.admintheme.inc.php on line 167

Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\vhosts\lppsr.org\httpdocs\modules\NMS\NMS.module.php:45) in C:\Inetpub\vhosts\lppsr.org\httpdocs\lib\classes\class.admintheme.inc.php on line 168

Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\vhosts\lppsr.org\httpdocs\modules\NMS\NMS.module.php:45) in C:\Inetpub\vhosts\lppsr.org\httpdocs\lib\classes\class.admintheme.inc.php on line 171

Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\vhosts\lppsr.org\httpdocs\modules\NMS\NMS.module.php:45) in C:\Inetpub\vhosts\lppsr.org\httpdocs\lib\classes\class.admintheme.inc.php on line 176


The CGExtensions module is installed and active.  At the bottom of the modules window there is a message saying tha thie modules folder is not writable, but It is writable.  I checked this with the Host Provider and even with their tech support.
Any ideas would be helpful.  It is an IIS Windows Server.

Thanks
Friar

[Nullig]

You could try re-uploading the files - perhaps the FTP program you're using didn't transfer all of the files properly.

Nullig

[friar778]

Hi Nullig:

Yes I tried that, still the same problem.  Anyone out there have another suggestion?  I am stumped

[timstl]

I've always had trouble uploading entire sites unless I zip it, upload the zip file, then extract on the new server. Not sure if that's the case here or not, but it prevents the risk of some files not uploading properly.

[Nullig]

I would try uninstalling/reinstalling the NMS module and the CGExtensions module.

Nullig

[friar778]

Nullig:

I cannot uninstall those modules, they say "Cannot Remove"

tmstl:

I cannot zip to the server.  It's an IIS Windows Server, doesn't give me shell access

Anything else I can try?

Thanks,
Friar

[Nullig]

You could try the solution here:

http://forum.cmsmadesimple.org/index.ph ... 549.0.html

Also, clear the cache in Admin.

Nullig

[friar778]

Nope, didn't work either

[Nullig]

Delete the NMS directory with your FTP program.

Nullig

[friar778]

still the same, only now I have a bunch of smarty tag errors as well as the original errors

[Nullig]

Is there a lot of data already entered for this site? If not, I'd be tempted to do a complete reinstall of the base system, then add the modules one by one, to see which one may be causing the problem.

You could also create a subdomain/subdirectory to do a fresh install in, using a different db prefix, just to see if the system will work in your environment.

Nullig