mysql-workbench Archives

mysql workbench visualization for schema

Go to Database Menu and select Reverse engineer, or simply press Ctrl+R (Windows) or ⌘+R (OS X).

Import MySQL data failed with error 1839

If you run a SHOW MASTER STATUS\G you’ll see something like this: mysql> show master status\G *************************** 1. row *************************** File: mysql-bin.000299 Position: … Read more

MySQL Workbench unable to restore workspace

by IT Nursery

Close the workbench then go to C:\Users\YOURUSER\AppData\Roaming\MySQL\Workbench\sql_workspaces and delete all data and directories there. Your last session will be not restored but the … Read more

Client to use the slave when the master is down in MySQL replication

by IT Nursery

Is it possible for the client to use the slave when the master is down in mysql replication? I have already setup a … Read more

MySQL Workbench asking for password

by IT Nursery

I am trying to set MySQL server on my Windows 7 64 bit machine. I have downloaded MySQL server and MySQLWorkbench. I have … Read more

MySQL Workbench copies Schema, but not data, from SQL Server 2008

by IT Nursery

I need to copy/migrate a database from MSSQL (SQL Server 2008) into MySQL. I am using the MySQL Workbench kit, and work through … Read more

Optimize a MySQL Database using MySQL Workbench

by IT Nursery

I actually have a few issues. First, I found this information about optimizing: https://stackoverflow.com/questions/5474662/mysql-optimize-all-tables The problem is, I don’t seem to have a … Read more