-----Original Message----- Message: 1 Date: Thu, 26 Jun 2008 17:41:45 +0300 From: "Saar Machtinger" <saar.machtinger(a)optitex.com> Subject: [Mediawiki-l] How to move MYSQL from windows to godaddy.com To: mediawiki-l(a)lists.wikimedia.org Message-ID: <a4634a470806260741g780c5c02w8874fa0ccffada83(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi all, Been trying to move a MW database that we have stored in our LAN over to godaddy.com hosting services (I am not promoting, it just that this is the service I ue, and if anyone has prior experiance with it, id love to hear it) Anyway, my original tables and the ones on the auto install are different. And I can not figure out how to direct the web to access my old names. I have copied my tables to the new names strucutre. This seems to be a bad idea, as there is also a version difference between the 2. I am not a php guro, but where in the script does it start to mention to which table to connect? I have looked all over in icnludes, setup, maintenance , can't find anything. Would love to hear your advise. Thanks, Saar -- Saar Machtinger - CIO OptiTex Ltd. | www.optitex.com | saar.machtinger(a)optitex.com Tel: +972-3-904 9979 | Fax: +972-3-904 2710 * Think green before you print ------------------------------ <saar.machtinger@optitex.com><a4634a470806260741g780c5c02w8874fa0ccffada83@mail.gmail.com><sancelot@free.fr><mediawiki@thegadgetdoctor.com><mediawiki-l@lists.wikimedia.org><a.v.a@home.nl><rob@colorist.org><cd347288-9e8b-4871-a918-9d38716e41ae@colorist.org><borepstein@gmail.com><mediawiki-l@lists.wikimedia.org><mediawiki@thegadgetdoctor.com><onekopaka@gmail.com><mediawiki-l@lists.wikimedia.org><mediawiki@thegadgetdoctor.com><meyer7@mindspring.com><mediawiki-l@lists.wikimedia.org><christensenc@battelle.org><mediawiki-l@lists.wikimedia.org><rob@colorist.org><mediawiki-l@lists.wikimedia.org><a7d6284a-5838-4b16-98b1-ef6e45584e0b@colorist.org><rob@colorist.org><mediawiki-l@lists.wikimedia.org><ab6be61d-8865-49ba-8269-58f9b4a867a4@colorist.org><daniel.bolser@gmail.com><mediawiki-l@lists.wikimedia.org><meyer7@mindspring.com> <saar.machtinger@optitex.com><a4634a470806260741g780c5c02w8874fa0ccffada83@mail.gmail.com><sancelot@free.fr><mediawiki@thegadgetdoctor.com><mediawiki-l@lists.wikimedia.org><a.v.a@home.nl><rob@colorist.org><cd347288-9e8b-4871-a918-9d38716e41ae@colorist.org><borepstein@gmail.com><mediawiki-l@lists.wikimedia.org><mediawiki@thegadgetdoctor.com><onekopaka@gmail.com><mediawiki-l@lists.wikimedia.org><mediawiki@thegadgetdoctor.com><meyer7@mindspring.com><mediawiki-l@lists.wikimedia.org><christensenc@battelle.org><mediawiki-l@lists.wikimedia.org><rob@colorist.org><mediawiki-l@lists.wikimedia.org><a7d6284a-5838-4b16-98b1-ef6e45584e0b@colorist.org><rob@colorist.org><mediawiki-l@lists.wikimedia.org><ab6be61d-8865-49ba-8269-58f9b4a867a4@colorist.org><daniel.bolser@gmail.com><mediawiki-l@lists.wikimedia.org><meyer7@mindspring.com>If you upgrade the original wiki to the latest version (or the same version as your godaddy.com wiki), the tables should be identical (or very nearly so) and you will have far fewer hassles migrating. <saar.machtinger@optitex.com><a4634a470806260741g780c5c02w8874fa0ccffada83@mail.gmail.com><sancelot@free.fr><mediawiki@thegadgetdoctor.com><mediawiki-l@lists.wikimedia.org><a.v.a@home.nl><rob@colorist.org><cd347288-9e8b-4871-a918-9d38716e41ae@colorist.org><borepstein@gmail.com><mediawiki-l@lists.wikimedia.org><mediawiki@thegadgetdoctor.com><onekopaka@gmail.com><mediawiki-l@lists.wikimedia.org><mediawiki@thegadgetdoctor.com><meyer7@mindspring.com><mediawiki-l@lists.wikimedia.org><christensenc@battelle.org><mediawiki-l@lists.wikimedia.org><rob@colorist.org><mediawiki-l@lists.wikimedia.org><a7d6284a-5838-4b16-98b1-ef6e45584e0b@colorist.org><rob@colorist.org><mediawiki-l@lists.wikimedia.org><ab6be61d-8865-49ba-8269-58f9b4a867a4@colorist.org><daniel.bolser@gmail.com><mediawiki-l@lists.wikimedia.org><meyer7@mindspring.com> <saar.machtinger@optitex.com><a4634a470806260741g780c5c02w8874fa0ccffada83@mail.gmail.com><sancelot@free.fr><mediawiki@thegadgetdoctor.com><mediawiki-l@lists.wikimedia.org><a.v.a@home.nl><rob@colorist.org><cd347288-9e8b-4871-a918-9d38716e41ae@colorist.org><borepstein@gmail.com><mediawiki-l@lists.wikimedia.org><mediawiki@thegadgetdoctor.com><onekopaka@gmail.com><mediawiki-l@lists.wikimedia.org><mediawiki@thegadgetdoctor.com><meyer7@mindspring.com><mediawiki-l@lists.wikimedia.org><christensenc@battelle.org><mediawiki-l@lists.wikimedia.org><rob@colorist.org><mediawiki-l@lists.wikimedia.org><a7d6284a-5838-4b16-98b1-ef6e45584e0b@colorist.org><rob@colorist.org><mediawiki-l@lists.wikimedia.org><ab6be61d-8865-49ba-8269-58f9b4a867a4@colorist.org><daniel.bolser@gmail.com><mediawiki-l@lists.wikimedia.org><meyer7@mindspring.com>Alternatively, depending on how much system access godaddy.com let you have, it may be easier just to import your database dump into a clean database, and move your wiki folder directly into your new system (updating database information etc as required). Upgrading is still a pretty good idea, though... <saar.machtinger@optitex.com><a4634a470806260741g780c5c02w8874fa0ccffada83@mail.gmail.com><sancelot@free.fr><mediawiki@thegadgetdoctor.com><mediawiki-l@lists.wikimedia.org><a.v.a@home.nl><rob@colorist.org><cd347288-9e8b-4871-a918-9d38716e41ae@colorist.org><borepstein@gmail.com><mediawiki-l@lists.wikimedia.org><mediawiki@thegadgetdoctor.com><onekopaka@gmail.com><mediawiki-l@lists.wikimedia.org><mediawiki@thegadgetdoctor.com><meyer7@mindspring.com><mediawiki-l@lists.wikimedia.org><christensenc@battelle.org><mediawiki-l@lists.wikimedia.org><rob@colorist.org><mediawiki-l@lists.wikimedia.org><a7d6284a-5838-4b16-98b1-ef6e45584e0b@colorist.org><rob@colorist.org><mediawiki-l@lists.wikimedia.org><ab6be61d-8865-49ba-8269-58f9b4a867a4@colorist.org><daniel.bolser@gmail.com><mediawiki-l@lists.wikimedia.org><meyer7@mindspring.com> <saar.machtinger@optitex.com><a4634a470806260741g780c5c02w8874fa0ccffada83@mail.gmail.com><sancelot@free.fr><mediawiki@thegadgetdoctor.com><mediawiki-l@lists.wikimedia.org><a.v.a@home.nl><rob@colorist.org><cd347288-9e8b-4871-a918-9d38716e41ae@colorist.org><borepstein@gmail.com><mediawiki-l@lists.wikimedia.org><mediawiki@thegadgetdoctor.com><onekopaka@gmail.com><mediawiki-l@lists.wikimedia.org><mediawiki@thegadgetdoctor.com><meyer7@mindspring.com><mediawiki-l@lists.wikimedia.org><christensenc@battelle.org><mediawiki-l@lists.wikimedia.org><rob@colorist.org><mediawiki-l@lists.wikimedia.org><a7d6284a-5838-4b16-98b1-ef6e45584e0b@colorist.org><rob@colorist.org><mediawiki-l@lists.wikimedia.org><ab6be61d-8865-49ba-8269-58f9b4a867a4@colorist.org><daniel.bolser@gmail.com><mediawiki-l@lists.wikimedia.org><meyer7@mindspring.com>Richard