AutoGallery SQL - changing host provider

[tortus32]

Hey all,

I'm in the middle of changing hosting providers. I have an IP address and I moved everything over. I'm trying to see if everyting is running right, but friggin Autogallery SQL won't let me run it on the IP address. It just tells me that the software is licensed for use on the domain name only.

What a pain in the ass! Do I have to change the DNS info at the registrar and just wait and see if it works once that goes through?

Bill

[drizzt]

Bill,

You should be able to have your current DNS provider setup a forward to the new IP you have until your DNS is completely changed over. That woudl make downtime and transfer a little less stressful.

D

[Cleo]

You need to contact them and tell them that you have changed hosts so that they can give you a new license key.

[cd34]

Are you sure it isn't looking at the hostname that you are sending in the header?

If so, and since you're running on a Mac (?, I think you mentioned that in another thread), try:

edit /etc/hosts

put

1.2.3.4 www.domain.com domain.com


where 1.2.3.4 is the IP address of the new site, and domain.com is of course the domain. Shut down your browser, reopen it, then go to domain.com and see if it pulls up the 'new' site as the domain (it should). If it does, and you still get the error, then, you need to contact the Autogallery people.... but, I suspect they are looking at the hostname sent in the request rather than some hardcoded domain identifier somewhere.

[Cleo]

Wrong
##
# Host Database
#
# Note that this file is consulted when the system is running in single-user
# mode. At other times this information is handled by lookupd. By default,
# lookupd gets information from NetInfo, so this file will not be consulted
# unless you have changed lookupd's configuration.
#
# localhost is used to configure the loopback interface
# when the system is booting. Do not change this entry.
##
127.0.0.1 localhost
255.255.255.255 broadcasthost
::1 localhost

[Cleo]

/Applications/Utilities/NetInfo Manager

[cd34]

so they aren't running true FreeBSD

[Cleo]

They are if you hold down "Command S" at boot and don't mind not having a GUI but I'm told by my *nix using friends that there are still small differences.

Here if you are bored.
http://developer.apple.com/darwin/

[tortus32]

Ok, I moved everything over, the DNS info has propagated - or however you spell that.

My major problem now is the the data back up/restore didn't work. I've lost all the galleries. I did the back up and restore exactly how they tell you to, but everything is gone.

I still have access to the old files on my old provider's server, and I tried downloading the back up .txt files and uploading them to the new server with no luck.

Having a bad day - lol!

Bill

[cd34]

Even FreeBSD in gui mode supports /etc/hosts -- it is nice to see that Apple addressed that issue in a better way. They have done a lot of work to remove many of the common management problems that make it difficult for someone to move from Windows.

[Cleo]

NetInfo Manager is from the NeXT days. There actually is very little Apple left in what now is Apple. Basically Apple was taken over by Steve and the NeXT people. Ironic that Apple fired Steve back in the eighties and now he is running Apple along with the NeXT people.

Back to tortus32 problem, seems odd that the restore doesn't work.

[tortus32]

I'm changing the DNS info back to the old server so I can do another back up, then I'll change the DNS info back to the new server so I try the restore again.

Uhg!

Bill

[cd34]

Originally Posted by tortus32

I still have access to the old files on my old provider's server, and I tried downloading the back up .txt files and uploading them to the new server with no luck.

Do you have phpmyadmin or ssh access?

If phpmyadmin, you can backup the database and restore it specifically. Log in, select the database, Export (or backup depending on the version), Select all, hit go. it will then chug for a few minutes, then you should get a 'save file' dialog box. Save it, import it on the other side.

If you have ssh access, you can use mysqldump to do the same thing.

mysqldump -u username -p -q databasename > file.sql

download file.sql

Once you get it to the other side, you can import it either through mysql/ssh or phpmyadmin.

Or, we can figure out why the import didn't work.

Its possible that their import routine uses /usr/bin/mysql and the path for mysql might be different on the machine, i.e. /usr/local/bin/mysql or something.

[tortus32]

I have phpmyadmin on both servers, and I was able to export from my old server, but I can't figure out how to import to the new one.

Bill

[cd34]

Strange, the newer versions don't have a specific import:

when you are in, does the database have any tables?

If not, then it just needs to be imported. Is the import file larger than 8mb? If not, go to

Database, Select the Database, Location of textfile, Browse, select the file, upload.

If you already have tables there, then I would say we need to figure out what part of the process failed in the backup/restore through Autogallery.

[Cleo]

Did you run the installer on the new server or just copy the files over? I ask because the installer creates the tables and all that good stuff that are needed before you can do an import.

[tortus32]

Yeah, I did and it created empty tables. I go a hold of tech support at my new provider and they were able to fix it. I just had to email them the old database.

Now I just have to get TTT working - lol!

Bill

[Cleo]

Fuck I hate changing hosts.

If we used Mac OS X Servers we could just use Carbon Copy Cloner to clone the drive to the new server and be up and running hassle free in about a hour.

I've got so much shit running on the server where my LL is that it keeps me awake at night thinking what if I ever had to move it.

[tortus32]

Ok, I think I'm finally done. I had to install the FreeBSD version of TTT.

I feel like I've had a work out! It's 7:45PM and I'm ready for bed - LOL!

I'll do the rest of the domains tomorrow.

I would love to be able to have my own server in my house. I have no clue what's involved in setting that up.

Bill