Backup of mysql DB not being created

Question

i want to write mysql DB on CD. I've followed the steps of creating backup. i've created server instance in server administration. now when i double click it to open it, it gives an error "Error starting Workbench Administrator; Exception: Current profile has no WMI enabled".

i went to administrative tools. enabled wmi for all users in Root Security. but its still giving the same error. What to do?

Answer 1

This error Exception: Current profile has no WMI enabled is occurred due to newly created server is not updated in server instances.

If you got below error when click on Manage Import / Export option

Follow the steps

Step 1: Click on Manage Server Instaces

Step 2: Click on Manage Connections button, Manage DB Connections window will be opens.

Step 3: Select instance and click on Store in Vault button, Store Password For Connection window will be opens.

Step 4: Enter Password then click on OK button.

Step 5: Click on Test Connection button for check database is connected with mysql or not, Connected to Mysql at 127.0.0.1:3306 with user root window will be opens.

Step 6: Click on OK button then Close button.

Step 7: Click on Close button to close Manage Server Instances window.

Step 8: Click on Manage Import / Export.

Step 9: Finally Import and Export browser will be opens.

Answer 2

I was getting the WMI exception you mention trying to make a new server instance under the "Server Administration" of mysql's "Workbench Central". I had been trying "Take Parameters from Existing Database Connection" and choosing my local DB when I got the exception.

In that first "Specify the Host Machine the Database Server is running on" screen, I needed to choose the first option, "localhost".

This let me create a connection to my local server through which I could import data that I had exported from another database. The export was made into a flat .sql file.

You might try simply exporting to a .sql file and then putting that file on a CD.