?

Log in

No account? Create an account
 

Move my databases for comics? - Web Developer

About Move my databases for comics?

Previous Entry Move my databases for comics? Aug. 16th, 2006 @ 09:23 pm Next Entry
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 coreymarie@gmail.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.
Leave a comment
[User Picture Icon]
From:luminairex
Date:August 17th, 2006 02:31 am (UTC)
(Link)
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.
[User Picture Icon]
From:p_x_l
Date:August 17th, 2006 02:44 am (UTC)
(Link)
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?
[User Picture Icon]
From:luminairex
Date:August 17th, 2006 02:57 am (UTC)
(Link)
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.
[User Picture Icon]
From:p_x_l
Date:August 17th, 2006 02:59 am (UTC)
(Link)
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?
[User Picture Icon]
From:luminairex
Date:August 17th, 2006 03:08 am (UTC)
(Link)
For instance, to include "header.php", rather than using

include "header.php";



I had to use


$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "header.php");
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_exec($ch);
curl_close($ch);



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!
[User Picture Icon]
From:p_x_l
Date:August 17th, 2006 03:12 am (UTC)
(Link)
You just saved me another day of trouble.

You are my hero!
[User Picture Icon]
From:luminairex
Date:August 17th, 2006 03:54 am (UTC)
(Link)
Glad I can help! :)
[User Picture Icon]
From:zimzat
Date:August 17th, 2006 03:28 am (UTC)
(Link)
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.
[User Picture Icon]
From:luminairex
Date:August 17th, 2006 03:56 am (UTC)
(Link)
I completely agree. With the amount of business DH does, I guess you can't fault them for being careful, if not paranoid
[User Picture Icon]
From:zimzat
Date:August 17th, 2006 04:37 am (UTC)
(Link)
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.
(Leave a comment)
Top of Page Powered by LiveJournal.com