MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: MySQL server won't start (Apple OS)
Posted by: Phillip Ward
Date: November 08, 2018 08:56AM

Quote

why wouldn't a complete disk clone be an adequate backup?

Because most of your database's work is done in memory and can only be guaranteed to be on disk after you've shut down the database server.

Database != File

By taking a disk backup while the database is running, you run the risk of getting part of a database block written to disk, which will be unrecoverable when you start the database back up again.

Read up about mysqldump.

Regards,
Phill W.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL server won't start (Apple OS)
Mike Levin
October 28, 2018 04:57AM
Re: MySQL server won't start (Apple OS)
Peter Brawley
October 28, 2018 01:12PM
Re: MySQL server won't start (Apple OS)
Mike Levin
October 28, 2018 08:05PM
Re: MySQL server won't start (Apple OS)
Peter Brawley
October 28, 2018 08:21PM
Re: MySQL server won't start (Apple OS)
Mike Levin
October 30, 2018 03:45AM
Re: MySQL server won't start (Apple OS)
Peter Brawley
October 30, 2018 09:05AM
Re: MySQL server won't start (Apple OS)
Mike Levin
October 30, 2018 07:51PM
Re: MySQL server won't start (Apple OS)
Peter Brawley
October 30, 2018 08:14PM
Re: MySQL server won't start (Apple OS)
Mike Levin
October 31, 2018 04:24AM
Re: MySQL server won't start (Apple OS)
Peter Brawley
October 31, 2018 09:16AM
Re: MySQL server won't start (Apple OS)
Mike Levin
October 31, 2018 02:04PM
Re: MySQL server won't start (Apple OS)
Peter Brawley
October 31, 2018 07:05PM
Re: MySQL server won't start (Apple OS)
Mike Levin
October 31, 2018 07:35PM
Re: MySQL server won't start (Apple OS)
Mike Levin
October 31, 2018 07:59PM
Re: MySQL server won't start (Apple OS)
Peter Brawley
October 31, 2018 08:11PM
Re: MySQL server won't start (Apple OS)
Mike Levin
November 01, 2018 03:39AM
Re: MySQL server won't start (Apple OS)
Peter Brawley
November 02, 2018 10:57AM
Re: MySQL server won't start (Apple OS)
Mike Levin
November 03, 2018 04:00AM
Re: MySQL server won't start (Apple OS)
Peter Brawley
November 03, 2018 09:51AM
Re: MySQL server won't start (Apple OS)
Mike Levin
November 03, 2018 11:07AM
Re: MySQL server won't start (Apple OS)
Peter Brawley
November 03, 2018 12:20PM
Re: MySQL server won't start (Apple OS)
Mike Levin
November 04, 2018 05:27AM
Re: MySQL server won't start (Apple OS)
Mike Levin
November 04, 2018 05:29AM
Re: MySQL server won't start (Apple OS)
Mike Levin
November 04, 2018 05:38AM
Re: MySQL server won't start (Apple OS)
Peter Brawley
November 04, 2018 05:43PM
Re: MySQL server won't start (Apple OS)
Mike Levin
November 08, 2018 03:59AM
Re: MySQL server won't start (Apple OS)
Phillip Ward
November 08, 2018 08:56AM


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.