|Move my databases for comics?|
Move my databases for comics?
Aug. 16th, 2006 @ 09:23 pm
Hello all of you geniuses.
I am currently trying to switch servers from an atrocious one to dreamhost, which I have heard good things about. I have my account set up and am in the process of moving files. Simple, right?
Well, I am also moving an OScommerce store and a wordpress blog. I've managed to export my databases but that's where I'm stuck. Despite multiple wikis and support pages I just can't do this. I have run into brick wall after brick wall after brick wall, and I think it is just over my head. It is also somewhat of a time sensitive issue, as we run a few sites and a business off our web space and we've already been down/not updating for a week now. Even if i could figure out how to import these (I did manage to export them... I think...) I certainly wouldn't know how to test them to make sure they're working correctly before setting up the new DNSes and going live. Since I will hopefully never have to do this again, I'd like to just find someone to help me out with this and get it over with.
Remember that business I was talking about? We run a comic book publishing company, and for your trouble of moving two databases for me, I will send you a big box of really awesome comics and graphic novels by some of the coolest artists and writers you've (n)ever heard of. You will also receive my ETERNAL GRATITUDE.
Sound like a good deal?
Drop me a line at email@example.com
or AIM me at: well read robot
I will relinquish passwords and you will help me and I will be happy and send you comics and the world will be a better place. Ideally I'd like to take care of this tonight or tomorrow.
I just went through the same process to Dreamhost. Exporting the databases was the easy part. If you have shell access, do a mysqldump into a text file (name it whatever.sql). Once you get over to DH, create a database through their webpanel (you can't create it via the shell, AFAIK). once that's created, access your new DB through phpMyAdmin and import it from there.
Transitioning my site over to DH was an... interesting experience, to say the least. Made me realize just how insecure my coding was. DH *hates* php includes.
|Date:||August 17th, 2006 02:44 am (UTC)|| |
Is that the case? I heard nothing but good things about them before signing up. What did you end up doing as far as the includes?
I was forced to use CURL as a workaround. I understand their rationale for not allowing includes; it was just a pain in the ass to fix when I moved my include-heavy site over only to find they'd disabled them.
|Date:||August 17th, 2006 02:59 am (UTC)|| |
yeah, I wish I'd realized that too. My site isn't HEAVY with includes, persay, but I use quite a few.
What's CURL? Or should I just google that?
For instance, to include "header.php", rather than using
I had to use
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "header.php");
curl_setopt($ch, CURLOPT_HEADER, 0);
For the exact same effect. I've been assured through DH and people on here that it's far more secure, for whatever reason. I don't know the mechanism behind it, but it worked for me!
|Date:||August 17th, 2006 03:12 am (UTC)|| |
You just saved me another day of trouble.
You are my hero!
|Date:||August 17th, 2006 03:28 am (UTC)|| |
If it were on a seperate host I could understand that (insecure and all), but... They wouldn't let you use include('header.php'); for a file on the same host!? That makes absolutely no sense at all.
I completely agree. With the amount of business DH does, I guess you can't fault them for being careful, if not paranoid
|Date:||August 17th, 2006 04:37 am (UTC)|| |
From looking at their help wiki, it seems they do allow absolute file paths or one relative to the current directory. You may have to set the include path using a .htaccess directive.
*shrug* I don't have a DreamHost site so I can't say. I've been quite satisfied with who I'm with.
|Top of Page
||Powered by LiveJournal.com|