Re: Mysql backup

Hi Rory, ----- Original Message ----- From: "Rory McKinley" <rorym@nebula.co.za> To: "Binay" <binay@oliveinternet.com>; <php-general@lists.php.net> Sent: Friday, November 28, 2003 7:30 PM Subject: Re: [PHP] Mysql backup > Binay > > If the tables for both versions are MYISAM the steps are as follows: > > 1. Stop mysql on both systems. > 2. Copy the contents of the 3.23.37 data folder to the 3.23.58 data folder using your ------------ 1) Does the format in which 3.23.37 stores data in data folder differ with format that 3.23.58 uses?? I mean is it compatible with 3.23.58 2) What will happen to the index file ... will it automatically be activated once u copy the folder and start the mysql service?? 3) And most important have you tried it before ?? I mean are you sure its gonna work.. cuz i have to do in my production server ... so lil cautious... ---------- > OS tools (cp, file management tools, Windows explorer etc) > 3. Start mysql on both systems. > > HTH > > Rory > > On 28 Nov 2003 at 17:17, Binay wrote: > > > Hi all ! > > > > I know this is more of mysql issue than PHP but then i always get my problem > solved here.. and hope the same this time also ... > > > > I have two systems. > > one with mysql-version: 3.23.37 > > other with mysql-version: 3.23.58 > > > > now i want to take the backup of 3.23.37 data and copy to 3.23.58 ... > > > > i know i can take backup using mysqldump command ....... and then copy using > mysql commands.... > > > > but as mysql create folder for each database ..... > > is it possible to copy the particular folder(database) to 3.23.58 and then running it > smoothly ... > > > > Any body got any idea ??? > > > > Please help me out.. > > > > Thanks in advance > > > > Binay > > > > > Rory McKinley > Nebula Solutions > +27 82 857 2391 > rorym@nebula.co.za > "There are 10 kinds of people in this world, > those who understand binary and those who don't" (Unknown) > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php