*sigh<\/p>\n
Where to begin ?<\/p>\n
Because I was in a catch-22 with Go-Daddy, I found a new fast, friendly host and created a new domain. Purely for testing purposes. The idea was that I could setup a clone of cncpics.com and then once it was all working, simply make some dns changes and all would be good.<\/p>\n
Behind the scenes of cncpics.com there is a heavily customized version of an off-the-shelf gallery product which uses a mysql database to store data. It is not enough to simply grab a copy of the photographs and install a nice shiney new copy of gallery, because they I would need to add 45,000 photographs to the gallery and this is a heck of a task.<\/p>\n
So the three components are the code, the photo’s and the database.<\/p>\n
The code and the database are fairly easy to FTP from my old host, but because I am in ‘violation’ I was unable to get to the control panel to backup the databases.<\/p>\n
So at 10AM I asked godaddy for a backup of the databases. The third person I spoke to told me that they where doing the job and that they were no ‘all there’. So I FTP’d them to my windows box and tried to upload them to the new host. Sadly there are a few hundred thousand records in some of the tables and the restore failed. So I jumped over to Linux land and found a tool that will no only connect to the remote database, but it will also load the data in much smaller chunks.<\/p>\n
The downside is that this takes a long time and if there is any other traffic on the internet it is slower too.<\/p>\n
Many hours later the database restore has finished and after a few minor tweeks to a configuration file the site worked.<\/p>\n
Except the galleries ended in the middle of November 2009.<\/p>\n
The database backup was several months old.<\/p>\n
Somehow I was calm when I called godaddy, somehow I persuaded the support rep to snag a new backup and somehow it looks like he did a good job.<\/p>\n
I am obviously now a long way behind, I need to leave the database upload running overnight and then most of tomorrow will be taken up with allowing the photographs to upload too.<\/p>\n
Then it will be more configuration changes and more tweeking,<\/p>\n
Hopefully on Friday I will be able to tell Godaddy that I no longer need their services….<\/p>\n","protected":false},"excerpt":{"rendered":"
Max Continues to battle with GoDaddy<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,6],"tags":[],"class_list":["post-115","post","type-post","status-publish","format-standard","hentry","category-life","category-photography"],"_links":{"self":[{"href":"https:\/\/nealon.uk\/blog\/wp-json\/wp\/v2\/posts\/115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nealon.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nealon.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nealon.uk\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nealon.uk\/blog\/wp-json\/wp\/v2\/comments?post=115"}],"version-history":[{"count":0,"href":"https:\/\/nealon.uk\/blog\/wp-json\/wp\/v2\/posts\/115\/revisions"}],"wp:attachment":[{"href":"https:\/\/nealon.uk\/blog\/wp-json\/wp\/v2\/media?parent=115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nealon.uk\/blog\/wp-json\/wp\/v2\/categories?post=115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nealon.uk\/blog\/wp-json\/wp\/v2\/tags?post=115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}