Re: MySQL innoDBD Backup
Posted by:
Nick Roper
Date: August 02, 2004 03:57PM
Hi,
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
Subject
Views
Written By
Posted
4807
August 01, 2004 07:44PM
Re: MySQL innoDBD Backup
3434
August 02, 2004 03:57PM
3454
August 04, 2004 08:36PM
3546
August 05, 2004 02:51AM
3294
August 06, 2004 01:46AM
3539
August 06, 2004 04:13AM
3888
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.