MySQL – Recover Dropped Performance Schema Database

Earlier today I saw the question in an online forum where the user was looking for ways to recover Dropped Performance Schema Database in MySQL.

MySQL - Recover Dropped Performance Schema Database droppedb-800x416

Honestly, it is very easy to recover your dropped performance schema database. Here is the command for the same.

Open Command Prompt and run the following command:

mysql_upgrade --user=root --password=password --force

Once the code above is successful, you will have to restart your MySQL server. Once completed, you will have your new Performance Schema database. However, the new database will not have your data in it. As the MySQL Server run it will contain new performance schema related data.

Here are my few recent videos and I would like to know what is your feedback about them. Do not forget to subscribe SQL in Sixty Seconds series. I hope you appreciate learning about the last few SQL in Sixty Seconds Video.

If you have any questions, you can always reach out to me on Twitter.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

,
Previous Post
SQL SERVER – Script to Estimate Compression
Next Post
SQL SERVER – Most Used Database Files – Script

Related Posts

Leave a Reply