Cloud SQL provides PostgreSQL, SQL Server, and MySQL databases. So this does includes two answers to the original post, but mostly it's extra information for those searching to have their own way. How long are instances shut down during restart. The latter may be the only way to sort unsaved SQL tabs. (In the example above, the tab to be displayed second would be loaded tenth.) Or you could simply rename the tab files accordingly. In the SQL Editor, if a table was edited with the Edit Data facility, and table values changed, no warning was given if an attempt was made to close the tab. Using the UI to display more than nine saved SQL files in a specific order requires anticipating the tab file names (which will be created sequentially during loading), sorting them alphabetically, and using the sorted tab file names to specify the sequence in which to load the saved SQL files so that they display in the desired order, left to right. For example, if there are 11 such tabs, the display order would be 1.filename, 10.filename, 11.filename, 2.filename, etc. I actually used Mike's solution.)įor tabs displaying saved SQL (at least), the tab file names determine the display order: alphabetical. Note: If you are migrating an entire database from a supported database server (on-premises, in AWS or Google Cloud) to a new Cloud SQL instance, you can use the Database Migration. (I discovered the way to delete stubborn tabs from the UI was to start from the left, but you could also delete stubborn tab files here. To export data from Cloud SQL for use in a MySQL instance that you manage, see Exporting and importing using SQL dump files or Export and import using CSV files. The files representing tabs that display unsaved SQL will be named. As a quick fix, I deleted the connection and added a new one. filename and will contain the filename of the saved SQL. After the error was closed, 1366 the Administration tab became unresponsive and MySQL 1367 Workbench did not shut down properly. 7 Strangely, after an upgrade, MySql Workbench crashed each time it connected to Server. The files representing tabs that display saved SQL will be named. If this option is enabled, SQL Workbench/J. With a valid connection established, and the connection tab for it. Some DBMS require that all open transactions are closed before actually closing the connection to the server. View the current status of the MySQL instance.
#MYSQL WORKBENCH SQL TABS STAY OPEN WHEN SHUT DOWWN CLOSED WINDOWS#
If you go to the workspace directory ("C:\Users\\AppData\Roaming\MySQL\Workbench\sql_workspaces\-.workspace" in Windows 7), you'll see files that represent the tabs. Start up and shut down the MySQL instance.
I know this is a bit off-topic, but this post was only half of my problem I wanted my remaining tabs to show up in a specific order - a problem if there are more than nine tabs.