Site Migration :: The War on Terror!!

Don't be affraid to connect the dots, investigate things you don't know, use common sense, and ask questions, and share what you know with others. Knowledge is free, don't believe everything you read.

This is a mere guide, not instructions. The routine maybe a little bit different if you using a different OS or host. I tried this on Ubuntu 8.04LTS and  Amazon EC2(ubuntu 8.04LTS, clean install). Worked, with minor headaches.

Why: because I need to move a site.

How: read below.

what: Migrate you boonex site; This may not be for you IF:

-You do not know how to toubleshoot error

-you can't follow *guidelines*, as opposed to instructions.

-you have not made a recent backup of your site and database

-you want someone to hold your hand while you read.

PULL

====

1. Copy your whole site folder.Note any missing files, so you can grab them from a clean install later. I mean files like dolphin JPGs or MP3s only, make sure you get all other files and note the files your missing.

1.b Note all your site settings and configurations.

I.e.

- admin,database,PhPMyAdmin  - user:pass combos

- www/mysitedocs/inc/config.inc.php

1.c (optional) Note: Licenses - If your not changing you domain name, it should not a problem, if so they may need to be re-registered via boonex.

2. Export your database via PhpmyAdmin.

NOTE use these options:

-ANSI compatibility

-sql file type

REMOVE "Extended Inserts"!!

!! If you have the table ZIPCodes installed, DO NOT INCLUDE in the main dump. You have been warned.!!

3.(optiona) Export ZIPCodes table, or find the original sql file.

PUSH

++++

1. Place your site docs similar to how they were before.

ex.  - www/mysitedocs/

If you moving the location(NOT RECOMENDED), edit - www/mysitedocs/inc/config.inc.php

2. Inject site sql tables into the database using the IMPORT tab.

2.1 To reinstall ZIPCodes.sql.

2.1a Via phpmyadmin execute this query to create the table structure.

Use this query for !!dolphin v6.1!!

CREATE TABLE `ZIPCodes` (
`ZIPCode` varchar(8) default NULL,
`ZIPCodeType` char(1) default NULL,
`City` varchar(28) default NULL,
`CityType` char(1) default NULL,
`County` varchar(25) default NULL,
`CountyFIPS` varchar(5) default NULL,
`State` varchar(30) default NULL,
`StateCode` varchar(2) default NULL,
`StateFIPS` varchar(2) default NULL,
`MSA` varchar(4) default NULL,
`AreaCode` varchar(3) default NULL,
`TimeZone` varchar(10) default NULL,
`GMTOffset` int(11) default NULL,
`DST` char(1) default NULL,
`Latitude` double default NULL,
`Longitude` double default NULL,
KEY `Latitude` (`Latitude`),
KEY `Longitude` (`Longitude`),
KEY `ZIPCode` (`ZIPCode`)
)

2.1b

with SSH or server commandline:

nolo@fish$ mysql -p -u root Community.ZIPCodes < ZIPCodes.sql

- it will ask for you password. Type it then press enter.

This may take ahile depending on how fast you server is. How do I check if its done? Use phpmyadmin and visit the processes tab. It will show you all running process, your process should show up as

ex... id 1000 ssh_user_name   status should be 'query'

Details Logic: Most queries run by the site only take a few secs to run at the most. This injection on a average server should take about 3-8 mins.

Took me 5 mins over ssh. and I ended up having to kill the connection *after* I knew it was done for sure.

3. While that is doing its thing, place all your site files. Don't worry if you missing files. From a clean install note the permissions and (!!I'm only talking about JPGs or MP3s!!), copy the missing files *for your version*. Make sure to set the right file permissions.

4. Check on you zipcodes sql query. Done?! Good. Login, re-configure your site, and check if everythings is working okay. Point your DNS server to your new site location. Check the registration licenses, if you have changed your domain. Contact boonex if you need to re-register them.

No? Check errors if any. Errors will generally arrive from the size of the file, the time_out for your sql configuration. Hanging ssh connection? check the process through phpmyadmin, like I mentioned above. If the status is not  query or sleeping it should be okay to kill the ssh_connection via your commandline. Do this with severe caution.

You can always drop the 'ZIPCodes' tables alone and try it again.

Godspeed,

~Nolochemical