MySQL Forums :: Newbie :: backup database


Advanced Search

backup database
Posted by: raymon gompelman ()
Date: September 06, 2011 02:58AM

Hi,

Hopefully a fairly straight question:

If I want to make a copy of a database can I shut down the host database, copy all the MySQL files from the database folder to the new database folder (and change some file permissions if necessary). For some reason I cannot find this information easily on the net. Most of it want me to use mysqldump or mysqlhotcopy but this is all for running databases.

The database contains InnoDB and MyISAM tables, views, stored procedures, triggers etc.

Thanks.
Raymon

Options: ReplyQuote


Subject Written By Posted
backup database raymon gompelman 09/06/2011 02:58AM
Re: backup database Peter Brawley 09/06/2011 03:41AM
Re: backup database raymon gompelman 09/06/2011 03:51AM
Re: backup database Peter Brawley 09/06/2011 04:03AM
Re: backup database raymon gompelman 09/06/2011 01:01PM
Re: backup database Peter Brawley 09/06/2011 01:13PM
Re: backup database Adam Donnison 09/06/2011 11:09PM
Re: backup database Philip Morris 09/06/2011 11:53PM


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.