Re: apple2clones.com is moving (glitch)

[Warren Ernst <wernst@gmail.com>]

On Sep 22, 8:24 am, "History-Student" <nos...@nospam.com> wrote:
> "History-Student" <nos...@nospam.com> wrote in message
>
> bfCdnejjt5R6ZHLbnZ2dnUVZ_uOmnZ2d@comcast.com">news:bfCdnejjt5R6ZHLbnZ2dnUVZ_uOmnZ2d@comcast.com...
>
> > Hey, folks
>
> > FYI alert:
>
> > I am going to be moving apple2clones.com to a new host, so the site might
> > be down for a day or two. This should begin either Tuesday (Sept. 18th) or
> > Wednesday (Sept. 19.) Once the site is moved and working properly, I will
> > then be giving it a structural upgrade, and perhaps a general facelift as
> > well.
>
> > Thanks.
>
> > E.
>
> Sorry folks, I ran into a problem moving the site. My database is almost 600
> megs, and the connection times out after about 4 hours into the database
> import -from my local computer to the server. I am trying to work something
> out with the host company, and we'll see how that goes over the weekend.
>
> E.

I'm sure you'll get lots of advice anyway but here's mine.

I'm assuming you're using MySQL for your site's database, and that you
are therefore using phpMyAdmin to backup the databse on the old host
and restore it on the new host.

If so, then be sure to enable Gzip compression when backing up the
database. That has, for example, reduced a 16MB database to 900k, just
for me last week when moving a site to a new host.

I usually follow the directions at:
http://fragments.turtlemeat.com/mysql-database-backup-restore-phpmyadmin.php

and it all works out fine.

But I'm sure your hosting company has already suggested something
similar.

-Warr