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] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
