MySQL Forums :: MySQL Workbench :: my entire MySQL database was wiped out?


Advanced Search

Re: my entire MySQL database was wiped out?
Posted by: Mike Lischke ()
Date: January 27, 2017 01:50AM

Hi,

I might misunderstand you but I don't really get what you did. By "MySQL settings" you mean you changed the default collation in the configuration file? If so it would not have the mentioned effect that your database is empty suddenly.

It rather sounds to me as if you look at the wrong server or schema now. When you change the charset of an object (say a schema or a table) it may convert your text to that new encoding, depending on what is set for individual sub elements like columns, but it will certainly not wipe out your database. So, I'd say there is something else involved here, not just changing.

And finally, there is no single command in MySQL which would allow to remove all data in one go. You will have to drop elements with several commands (like DROP table, DROP procedure, DROP schema etc.).

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
MySQL Workbench on Twitter: https://twitter.com/MySQLWorkbench
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/5.7/en/

Options: ReplyQuote


Subject Views Written By Posted
my entire MySQL database was wiped out? 282 Bradley Rogers 01/25/2017 06:03PM
Re: my entire MySQL database was wiped out? 129 Peter Brawley 01/25/2017 07:51PM
Re: my entire MySQL database was wiped out? 138 Bradley Rogers 01/26/2017 02:10PM
Re: my entire MySQL database was wiped out? 128 Peter Brawley 01/26/2017 05:28PM
Re: my entire MySQL database was wiped out? 175 Mike Lischke 01/27/2017 01:50AM
Re: my entire MySQL database was wiped out? 138 Bradley Rogers 01/27/2017 09:56AM


Sorry, only registered users may post in this forum.

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.