From: Shreyas on 2 Jun 2010 19:16 All, Finally, the 28th reply seems to have brought this thread to an end. Yes, persistence finally got me there! Special thanks to Ash. I am able to run both my Java code and php code on the same port (though nothing database conversations are happening) from the same machine. Here's the set-up : MySQL Server 5.1 + Query Browser : port 3306. This has a schema called as NS which is referenced by my Java code. EasyPHP : This is running in a diferent location with its stack in C:\. Fix : I knew all I had to do was a drop of my NS schema to a folder called data and from nowhere I crashed into this : C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data. I dropped my NS schema there; checked the query browser and there it was! Compiled my Java code and I was able to get back to my previous environment. So, no port conflicts, no different usernames. So far so good. Talk to you all soon as I am gearing up with programming questions now. --Shreyas On Thu, Jun 3, 2010 at 1:02 AM, Shreyas <shreyasbr(a)gmail.com> wrote: > Bob, > > That was a separate installer. It was nothing to do with another software. > > --Shreyas > > > On Wed, Jun 2, 2010 at 7:19 PM, Bob McConnell <rvm(a)cbord.com> wrote: > >> From: Shreyas >> >> > What would be the exact installer which will let me have the MySQL >> Server >> > and the Query browser? I know this is the wrong forum but I am just >> giving >> > it a shot. When I do Start -> All Programs -> MYSQL, I used to get >> only >> > above options. I have lost the installer and the actual MySQL website >> has >> > quite a lot of things. >> >> I don't know anything about the MySQL toy, but from scanning this thread >> you already have a server installed if your java app is talking to it on >> port 3306. You are now trying to install a second server on the same >> computer, which can only be done if you change the port number. >> >> How did you install the first server? Was it part of the java install or >> did one of the other packages you installed put it there? Do you still >> have the documents for that package with the default users and >> passwords? >> >> Bob McConnell >> > > > > -- > Regards, > Shreyas > -- Regards, Shreyas
From: shiplu on 2 Jun 2010 19:22 Actually you just restore your NS schema in the new EasyPHP stack. Shiplu Mokadd.im My talks, http://talk.cmyweb.net Follow me, http://twitter.com/shiplu SUST Programmers, http://groups.google.com/group/p2psust Innovation distinguishes bet ... ... (ask Steve Jobs the rest)
From: Shreyas on 3 Jun 2010 06:27 Shiplu, Not sure what you meant by that. I never had to restore anything. Would be happy to know if I have misunderstood anything. Regards, Shreyas On Thu, Jun 3, 2010 at 4:52 AM, shiplu <shiplu.net(a)gmail.com> wrote: > Actually you just restore your NS schema in the new EasyPHP stack. > > Shiplu Mokadd.im > My talks, http://talk.cmyweb.net > Follow me, http://twitter.com/shiplu > SUST Programmers, http://groups.google.com/group/p2psust > Innovation distinguishes bet ... ... (ask Steve Jobs the rest) > -- Regards, Shreyas
From: "Bob McConnell" on 3 Jun 2010 08:29 From: Shreyas > Not sure what you meant by that. I never had to restore anything. Would be > happy to know if I have misunderstood anything. > On Thu, Jun 3, 2010 at 4:52 AM, shiplu <shiplu.net(a)gmail.com> wrote: > >> Actually you just restore your NS schema in the new EasyPHP stack. >> The fact that you were able to add your schema by simply copying it into the correct directory is a happy coincidence, or more likely a serious bug in MySQL. There may be some system tables that were not updated to reflect the presence of that schema, so some features may not work with it. The correct way to move a database is to back it up on the original server, then restore it on the new one. That way all system tables would be correctly updated by the server. Bob McConnell
From: Ashley Sheridan on 3 Jun 2010 09:37
On Thu, 2010-06-03 at 08:29 -0400, Bob McConnell wrote: > From: Shreyas > > > Not sure what you meant by that. I never had to restore anything. > Would be > > happy to know if I have misunderstood anything. > > > On Thu, Jun 3, 2010 at 4:52 AM, shiplu <shiplu.net(a)gmail.com> wrote: > > > >> Actually you just restore your NS schema in the new EasyPHP stack. > >> > > The fact that you were able to add your schema by simply copying it into > the correct directory is a happy coincidence, or more likely a serious > bug in MySQL. There may be some system tables that were not updated to > reflect the presence of that schema, so some features may not work with > it. > > The correct way to move a database is to back it up on the original > server, then restore it on the new one. That way all system tables would > be correctly updated by the server. > > Bob McConnell > On more than one occassion I've just copied the data files from one location to another to move the database from one server to another. You do have to ensure that the MySQL service has been stopped while you do this, but aside from that there's nothing wrong with doing this. Thanks, Ash http://www.ashleysheridan.co.uk |