Topic: database replication help needed

[otuatail]

Hi I have a database version 4.x and I have now got another databe 5.x. I am lots of problems with the older on anda at the moment can't access it via phpmyadmin. If I can get access is there any tools available to move the data across.

The thought of writing a php page to open both and copy each one record by record would be very dificult when you think you
have 30 plus tables of difrent structures.

Is this achevable ???????

Desmond.

[fenway]

I don't follow -- just upgrade the DB after following mysql's instructions.

[otuatail]

I dont own the company or the server that the database is on. I pay yearly subscriptions. I have no direct access to the server any more and the company are not helping. I can from a website point of view still use it. Is there some code I could extract the field defs in order to create a new table. and is there a way to access the table as data. I can copy and past this but don't know how.

Desmond.

[fenway]

Well, if you have access to both servers via php, you can SELECT from one and INSERT into the other.