MySQL Forums
Forum List  »  Backup

Re: MySQL innoDBD Backup
Posted by: Nick Roper
Date: August 02, 2004 03:57PM


First of all, there is a difference in the way that MyISAM and InnoDB storage engines store table structuers and data. MyISAM creates separate format (.frm), index (.MYI) and data files (.MYD) for each table, but InnoDB only stores table format information in individual files; the data and index information for ALL InnoDB tables in the database is stored in a single logical tablespace which can consist of one or more files or raw partitions which, by default, are stored in the server's data directory and not the database directory.

If you want to copy the database to another computer, then use the mysqldump utility to create a .sql file than can then be used to re-build the database on the other machine.

Nick Roper

Options: ReplyQuote

Written By
August 01, 2004 07:44PM
Re: MySQL innoDBD Backup
August 02, 2004 03:57PM
August 04, 2004 08:36PM
August 05, 2004 02:51AM
August 06, 2004 01:46AM
August 06, 2004 04:13AM
August 09, 2004 03:50AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.