How do I access server administration console in MySql workbench 6.0 community edition? I cant seem to find it in my downloaded version. I guess I need it to backup my database and the stored procedures associated with it. 

To perform server administration tasks in MySQL Workbench 6.0, you can use the following features:

Server Status: To view the server status, navigate to the "Server" menu and select "Server Status." This will show you information about the server, such as version, uptime, connections, and more.

User Administration: To manage users and their privileges, go to the "Server" menu and choose "User and Privileges." Here, you can create and manage users, set their access privileges, and change passwords.

Schema Administration: For database management and schema-related tasks, go to the "Server" menu, and then select "Data Export" or "Data Import" to perform backup, restore, and migration operations.

Startup / Shutdown / Restart: You can start, stop, or restart the MySQL server by using the "Server" menu and selecting the appropriate options.

Logs: To view server logs, navigate to the "Server" menu and select "Server Logs."

Please note that the options and interface may vary slightly depending on your operating system and the specific version of MySQL Workbench 6.0 you are using. Additionally, newer versions of MySQL Workbench may have different features and improvements, so consider upgrading to the latest version if possible.

Where to find Server Administration in MySQL Workbench Community 6.0?

I am learning to write stored procedures. What is best practice for where to store / save them until they are ready to be used in production? I don't want to add them to a huge list of existing stored procedures on the database I will be writing them for. Should I create a sandbox database and create them there, using the tables from the production database? 

Advice on how to set up an environment for Stored Procedures

I am working on a project where we use lots of stored procedures. Currently, we unit test stored procedures by:

1) Writing a sql script that calls the stored procedure and uses select statements to print output values.

2) Then by comparing a good output with the test output for declaring whether the test has passed or not.

Is there an inbuilt support for Unit Testing in MySQL? What is the industry standard way of doing this?

stored-procedures

Trending Blogposts on stored-procedures

Popular Discussions on stored-procedures

openWhere to find Server Administration in MySQL Workbench Community 6.0?

1

1

0

openAdvice on how to set up an environment for Stored Procedures

1

0

0

openHow to write unit tests for stored procedures in MySQL?

1

0

0

PRODUCTS

QUICK LINKS

LEGAL