Tag Info

New answers tagged

0

Install power query ad-din http://www.microsoft.com/en-us/download/details.aspx?id=39379 And you still might want to install MySQL workbench to test your connection.


0

Simply answer NO to this question. It is just a confirmation if you only want to delete the figure on the canvas or the db object (in the model) as well.


0

Was trying to solve the same problem and stumbled here... It's a year late, but better late than never... OSX uses iODBC as ODBC layer, so FreeTDS must be compiled against iODBC for MySQL Workbench to connect. Since I struggled with iODBC as well, what I ended up doing was to create a custom "library installation" to run this. Steps are as follows: ...


0

It looks like the table is deleted in the "model" only. The original database is not harmed. One also can filter tables via the reengineering wizard in advance.


0

Did you tried MySQL Administrator (v. 1.1.9)? With this program you can't use Excel to look into tables but you still have a very clear vision of the database and you can edit tables data like in Excel.


1

I think a GUI tool like SQLyog can help you in your case. The tools like Import External Data, Sync, Scheduling a job with the required query or even a time based scheduling will let you do what you are asking for. Also you can run batch scripts and execute queries as you want in the case of XML files. I would suggest you to try it once.


0

Try this: SELECT t1.name AS 'Parent Name', t2.Name AS 'Child Name' FROM tblname t1 INNER JOIN tblname t2 ON t1.id = t2.parent-id;


0

Explicitly setting the NOT NULL is simply an additional action to make this fact clear also for the non-experienced users. It doesn't hurt and you can safely ignore it.


0

I've just upgraded my MySQL server version and this problem is fixed. It must have been an issue related to using MySQL Workbench with an older version of MySQL server.


3

Assuming that your dataset is larger than your buffer pool, having it at 95% usage is not only normal, but a desired state. You want as much information as possible on memory- hardware and resources are there to be used- so that both next reads and writes can be done faster than having to access disk. A different thing is if that memory usage is being used ...


0

MySQL Workbench is primarily a tool to work with the MySQL database server and hence all implemented migrations ultimatively use MySQL as target. No other target is supported.


0

MySQL Workbench doesn't have that capability. However, migrating away from MySQL is probably one of the easiest RDBMSs migrations possible. Migrating data is easy- just export in CSV format and import to the desired target, or use ODBC as a compatibility layer. The complicated thing is something common to any migration- porting the schema, server-side ...


0

Having researched and tested out a few ideas I have now found a solution. 1) Access or Excel and utilise VBA to Save the CSV files to the FTP of where your website is. 2) After the SaveAs VBA statement I then had another line of code that fires open a web browser which loads a PHP page and executes a INSERT with LOAD DATA LOCAL INFILE... Even with a 50mb ...


1

Scanning the source code of MySQL Workbench you can see a few places where SHOW INDEX is sent out. The application needs to run quite a number of queries for its tasks, e.g. the index view or the table editor. Some of them are only active when you open a view from the management section. Others, like the SQL editor need a SHOW INDEX to find info about PK ...



Top 50 recent answers are included