Hi Taylor To quote from MySQL (2nd ED) by Dubois (pg 725) - "InnoDB and BDB tables can be dumped using mysqldump, just like any other kind of tables."
So the answer is: nope nothing different. Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world, those who understand binary and those who don't" (Unknown) ----- Original Message ----- From: "Taylor Lewick" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 3:45 PM Subject: Re: Backup, move, restore..? > OKay, thanks, any idea if something has to be done differently for > InnoDB tables? > > >>> "Rory McKinley" <[EMAIL PROTECTED]> 10/09/03 03:46AM >>> > Hi Taylor > > While I have only used mysqldump to backup MyIsam files, I have found > the > process to be fairly painless. Mysqldump creates "batch" f iles which > effectively rebuild your database structure + database data. To restore > the > data all you need to do is run the backup files as a batch file i.e. : > > mysql -u root -p your_destination_db_name < your_backup_file_name > > Then sit back and wait.... > > Rory McKinley > Nebula Solutions > +27 82 857 2391 > [EMAIL PROTECTED] > "There are 10 kinds of people in this world, > those who understand binary and those who don't" (Unknown) > ----- Original Message ----- > From: "Taylor Lewick" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, October 08, 2003 8:49 PM > Subject: Backup, move, restore..? > > > > Hi all. I am needing to do a backup of two smalldatabases, both live > on > > the same server and under the same Mysql binary installation... > > > > I would like to back them up, dump them into a file(s), make my > move, > > install the same database, and then restore/load this dumped > > information > > back into the new database. > > > > I am using mysql-max 4.0.13 on HP-UX 11.00, 64 bit... I am also > using > > some InnoDB tables... > > > > Is it as simple as doing mysqldumps and taring/zipping up those > files? > > If so, how do I load these files back into the new database? > > > > Thanks > > > > **************************************************************** > > Please Note > > The information in this E-mail message is legally privileged > > and confidential information intended only for the use of the > > individual(s) named above. If you, the reader of this message, > > are not the intended recipient, you are hereby notified that > > you should not further disseminate, distribute, or forward this > > E-mail message. If you have received this E-mail in error, > > please notify the sender. Thank you > > ***************************************************************** > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > **************************************************************** > Please Note > The information in this E-mail message is legally privileged > and confidential information intended only for the use of the > individual(s) named above. If you, the reader of this message, > are not the intended recipient, you are hereby notified that > you should not further disseminate, distribute, or forward this > E-mail message. If you have received this E-mail in error, > please notify the sender. Thank you > ***************************************************************** > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
