import / export between servers

Hi all!

I hope someone can help me with this... :)

I am again moving a site to another server and I am again amazed how low the
script limitations are (upload file size), how cr***y the consoles are and
how unnerving the whole process is. It has taken me 3 hours just to move
the DB and I have just now noticed that the codepage is invalid - even
though I have specified it correctly in phpMyAdmin. Let's start again... :(

So the idea is - why not write two PHP scripts, one for the source and one
for the destination server? They have access to files and DB data we wish
to move, so we should just specify the connection details and they could
interoperate to move the data from source to destination.

I hear you say: "what about time limit, memory limit,...?" The work could be
split into tiny pieces - the destination script could be called
continuously until the work is done. Actually, you could point a browser to
the destination script and it would request another tiny piece from source
and use it. Then it would display HTML with JavaScript redirect to itself
(unless the work was done of course). You just have to wait, but who
cares - it would take a lot less of my bandwidth and would probably be
faster too.

Now the question is: is there something like this out there? :)
I have searched through google but couldn't find anything.

Thanks,

Anze

Re: import / export between servers

Anze wrote:
> Hi all!
>
> I hope someone can help me with this... :)
>
> I am again moving a site to another server and I am again amazed how low the
> script limitations are (upload file size), how cr***y the consoles are and
> how unnerving the whole process is. It has taken me 3 hours just to move
> the DB and I have just now noticed that the codepage is invalid - even
> though I have specified it correctly in phpMyAdmin. Let's start again... :(
>
> So the idea is - why not write two PHP scripts, one for the source and one
> for the destination server? They have access to files and DB data we wish
> to move, so we should just specify the connection details and they could
> interoperate to move the data from source to destination.
>
> I hear you say: "what about time limit, memory limit,...?" The work could be
> split into tiny pieces - the destination script could be called
> continuously until the work is done. Actually, you could point a browser to
> the destination script and it would request another tiny piece from source
> and use it. Then it would display HTML with JavaScript redirect to itself
> (unless the work was done of course). You just have to wait, but who
> cares - it would take a lot less of my bandwidth and would probably be
> faster too.
>
> Now the question is: is there something like this out there? :)
> I have searched through google but couldn't find anything.

There was a good script that made database dumps and you then imported
the file on the new server. The script was called mysqlphpbak, can be
difficult to find today.

It goes usually faster to use the console tools.



--

//Aho

Re: import / export between servers

Aho, thank you for the answer! Appreciate it!

>> Now the question is: is there something like this out there? :)
>> I have searched through google but couldn't find anything.
>
> There was a good script that made database dumps and you then imported
> the file on the new server. The script was called mysqlphpbak, can be
> difficult to find today.

Yes, but that's the same as phpMyAdmin can do. The problem is in the upload
size limit and the simplicity of setup...

> It goes usually faster to use the console tools.
Yes it does. :)
But I use a lot of different ISPs and most of them don't allow ssh access.

Well, I'll just write my own script, but it would be easier of it was out
there already.

Thanks again,

Anze

Re: import / export between servers

> >> Now the question is: is there something like this out there? :)

> Yes, but that's the same as phpMyAdmin can do. The problem is in the upload
> size limit and the simplicity of setup...

Your probably looking for something like Bigdump for the importing
portion.

http://www.ozerov.de/bigdump.php