otuatail Posted August 14, 2010 Share Posted August 14, 2010 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. Quote Link to comment https://forums.phpfreaks.com/topic/210709-database-replication-help-needed/ Share on other sites More sharing options...
fenway Posted August 14, 2010 Share Posted August 14, 2010 I don't follow -- just upgrade the DB after following mysql's instructions. Quote Link to comment https://forums.phpfreaks.com/topic/210709-database-replication-help-needed/#findComment-1099302 Share on other sites More sharing options...
otuatail Posted September 2, 2010 Author Share Posted September 2, 2010 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. Quote Link to comment https://forums.phpfreaks.com/topic/210709-database-replication-help-needed/#findComment-1106534 Share on other sites More sharing options...
fenway Posted September 10, 2010 Share Posted September 10, 2010 Well, if you have access to both servers via php, you can SELECT from one and INSERT into the other. Quote Link to comment https://forums.phpfreaks.com/topic/210709-database-replication-help-needed/#findComment-1109649 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.