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]
