MySQL Forums
Forum List  »  MySQL Workbench

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
Re: my entire MySQL database was wiped out?
220
January 27, 2017 01: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.