acarlsson Posted August 5, 2013 Share Posted August 5, 2013 Our existing IPB rests on a OS X 10.4 server with PHP 4. Now it's finally time to move the domain and IPB to a new server, which is an OS X 10.8 and PHP 5. So, how is the easiest way to do this? I thought I'd seen a tutorial on this, but I can't find it at the moment. Moving the domain etc is no problem. The problems are; What should the SQL database be named? Are there any PHP scripts that should be copied? Etc...? Help appreciated, /andreas Link to comment Share on other sites More sharing options...
Dmacleo Posted August 5, 2013 Share Posted August 5, 2013 well I am not sure how it all works on OSX, so take this with grain of salt, but I have done many moves from centos to cent or debian and even ubuntu, what I always do is take a full backup of the public_html folder (maybe OSX uses www ??) into a zip and transfer (scp usually) that to new server. on new server I extract to a backup folder and then (still using that new server or file manager on it) copy the files to new public html. then make sure ownership and permissions are correct. then I import the database into the new one and edit conf_global php db name and user. then once in acp edit the paths as needed and do all the rebuilds of skin data and all the recaches. usually its not too hard, it sounds more daunting then it is. the way I do it I always have a backup (old server) just in case. Link to comment Share on other sites More sharing options...
Rhett Posted August 5, 2013 Share Posted August 5, 2013 Here is the guide for you > https://www.invisionpower.com/support/guides/_/maintenance-and-server-configurations/transferring-community-to-a-new-server-r20 Link to comment Share on other sites More sharing options...
acarlsson Posted August 6, 2013 Author Share Posted August 6, 2013 Thanks! Link to comment Share on other sites More sharing options...
acarlsson Posted August 8, 2013 Author Share Posted August 8, 2013 Aargh... Exported the SQL database, resulted in "Error 127". Found the defect table; ibf_core_share_links_log Did the SQL Query "REPAIR TABLE" and it did the following: - info: Wrong bytesec: 0- 0- 0at 234412; Skipped - warning: Number of rows changed from 1969 to 1957 - status: OK Copied the now error-free database to the new machine. Importing (with Sequel Pro) results in the following error message: "[ERROR in query 1] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '??#' at line 1" Help! What should I do? :( Link to comment Share on other sites More sharing options...
Rhett Posted August 8, 2013 Share Posted August 8, 2013 Try exporting with mysqldump and importing via the command line. Link to comment Share on other sites More sharing options...
acarlsson Posted August 8, 2013 Author Share Posted August 8, 2013 Thanks, I changed the format from UTF-16 "Little Endian" to UTF-8, and the import worked! (With a lot of errors though, but still...) I'll try to use the import and we'll see what happens. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.