The mysql-workbench tag has no wiki summary.
-1
votes
1answer
33 views
Copying raw mysql files to Windows 7 MySQL 5.6 obtained via mysqlhotcopy from Linux MySQL 5.1 [closed]
Assuming I only have access to the raw files (.myd, .myi, .frm), would I simply copy+paste mysql db files obtained from /var/lib/mysql/mydb to C:\Program Files\MySQL\MySQL Workbench CE ...
1
vote
1answer
51 views
Debian server, Workbench client or server side?
We have a server running Debian squeeze with mysql and until now we manage the db through phpMyAdmin.
In this question I was told that Workbench represents a better choice than PMA in terms of ...
2
votes
3answers
195 views
unable to install MySql Workbench
When I try to install MySql Workbench using the yum command :
yum install mysql-workbench-gpl-5.2.45-1fc17.i686.rpm
I get these errors :
Error: Package: mysql-workbench-gpl-5.2.45-1fc17.i686 ...
0
votes
0answers
426 views
MySQL Workbench is not finding MySQL service? [closed]
I set up a local MySQL server, currently with no databases. I'm trying to create a new server instance profile in MySQL Workbench to manage the server, and during the Create New Server Instance ...
1
vote
1answer
166 views
Create dump of database schema remotely
I have a connection to remote Mysql database. (i'm using MySQL Workbench).
I'd like to copy whole structure of the database, (without data) to create identical structure on my local machine. Is it ...
1
vote
1answer
456 views
How to find table engine in MySQL Workbench?
I've just installed MySQL Workbench 5.2.39 and I'm currently viewing one of my databases through the 'Schema' panel in a 'SQL Editor' tab. I can see all of my database's tables under 'Tables', but no ...
1
vote
3answers
1k views
MySQL Workbench: Orphaned document changes detected
Each time I open MySQL Workbench, I get this annoying message at the bottom of the screen saying "Orphaned document changes detected". It comes up whether I close all the SQL Editor workspaces or not. ...
1
vote
2answers
670 views
Cannot connect to a MySql Server using MySql Workbench with no apparent reason
I can't connect via TCP/IP to the MySQL server.
The server is installed in a Debian Linux and there's a PostGreSQL server running at the same time. (which is working fine and has tcp/ip connection ...
3
votes
1answer
421 views
How to send logs to table so that we can view them in Workbench?
At log tab, it shows :
Your current Log Destination is set to FILE.
For logs to be viewed within Workbench they must be configured to be sent to TABLE.
This ...
0
votes
1answer
982 views
Exporting MySQL without trigger data?
I'm using the MySQL Workbench tool to export a database. However, the database data includes trigger data as well. How can I ignore the triggers and not include them in the generated SQL dump file?
1
vote
1answer
268 views
Tunnel to MySql via workbench not working when regular ssh tunnel works
I am trying to access a mysql server via an SSH tunnel. My understanding is that this should be supported natively in Mysql Workbench (5.2.35 on Ubuntu 10).
The following works:
Open shell
ssh -f ...
1
vote
0answers
90 views
How to stop logging activity from MySQL workbench?
I have enabled the query and slow_query logging in MySQL, but I'm getting new entries every second of the type:
2 Query show global status
110925 21:18:18 1 Query select 1
I've ...
3
votes
1answer
197 views
MySQLWorkbench Connection Problems
I have problems connecting to my MySQL server using MySQLWorkbench. I believe it's some type of permissions issue, to ensure I am able to use this, can you help me with the necessary setup steps? I ...
0
votes
1answer
1k views
Why can I manage my server using MySQL Worckbench (WMI Status…)
I'm trying to manage my mysql server using Workbench 5.2.31 CE Rev 7115 with mysql 5.5.8 on Windows Server 2003 but I'm getting this error:
RuntimeError: Could not initialize WMI interface: ...
0
votes
2answers
202 views
MySQL maxed out memory usage problem
I am currently ingesting millions of rows of data into a MySQL database. I am monitoring the server status locally on my machine using MySQL Workbench. The application is showing that the memory is ...
0
votes
2answers
627 views
Using cPanel to setup SSH for MySQL
Using cPanel as the only way to access the server, is it possible to setup a connect to MySQL so I can administor the MySQL database remotely? i.e using MySQL WorkBench?
0
votes
2answers
564 views
MySQL Workbench HTTP tunnel
Is there way in MySQL Workbench to connect to a database via HTTP Tunnel?
I've used http tunnel for a while with Navicat but i would like to use the same way to connect to remote databases with MySQL ...
0
votes
0answers
358 views
error exporting data using mysql workbench
i have been getting warning of version mismatch when i was trying to export data dump using mysql workbench.
So, i copied mysqldump from mysql server folder and placed it in workbench folder.
Now when ...
1
vote
2answers
918 views
Unknown MySQL server host - connection problem
I am new to databases and I have been asked to look at a few tables and see how many records they have and some other information. I cannot access phpMyAdmin through cPanel, which is how I've always ...
