Mike- check out http://www.mysql.com/doc/en/SHOW_VARIABLES.html for information on which variables to SET for configuring MySQL Hth, Martin ----- Original Message ----- From: "ComCity" <[EMAIL PROTECTED]> To: "Peter J. Milanese" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, June 02, 2003 8:05 PM Subject: Re: DISASTER recovery...hopefully
> Doing more research...found a file called my.cnf. That appears to be the > right file. It has the datadir in there. So if I just point the datadir to > the right place it will simply wake up mySQL to the /datadir/mysql system > table and the databases huh? > > I found out that the previous version was 3.22 and now this is 3.23 but that > doesn't sound like its that big of a deal since it appears that 4 can read > 3.2X databases. The only other unknown is. > > The only other unknown in there is basedir? Whats that? Do I need to > change this as well? > > Thank You very much. > Michael Barber > --------------------- > > From: Peter J. Milanese > To: ComCity > Cc: [EMAIL PROTECTED] > Sent: Monday, June 02, 2003 4:28 PM > Subject: Re: DISASTER recovery...hopefully > > > Should be no big deal.. > > Look in the mysql.server startup script.. > > There's a 'datadir=' line... set the path to the location of the data files. > It should reflect the ROOT of the data, where database name is the > directory, and the M-files are under it. > > let me know.. I'll be here... > > P > > -----"ComCity" <[EMAIL PROTECTED]> wrote: ----- > > To: <[EMAIL PROTECTED]> > From: "ComCity" <[EMAIL PROTECTED]> > Date: 06/02/2003 06:56PM > Subject: DISASTER recovery...hopefully > > Newbie doing disaster recovery...oh my. > > I'm trying to do some diasaster recovery on a machine running mySQL. I > could use a little bit of help...even if its pointing me in the right > direction only... > > I can see I have some .MYD, .MYI, and .frm files that look to be the > original database files. I've had to reinstall 3.23.54 mySQL from scratch > on a version 9 machine. The original install was 3.23.54 on version 7 I > believe. How do I get it to recognize these database files and wake up to > them. Is there a way to load this information back into the new system > tables? > > Also, in there an .ini file that tells mySQL where to store the database > files...maybe if I could just update that...it would find these files...I > believe I see the system table as well if its the mySQL database. I've > searched everywhere for maybe a mySQL.ini or something that saves the path > to store the database files but haven't find anything. > > Thanks in advance. > > Thank You very much. > Michael Barber > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
