MySQL database manipulation program for Windows? Like MS Access or MS SQL?

Question

Is there any program (preferably official) for Windows that can be used to manipulate MySQL data dumps?

For example, easily importing a MySQL text dump and create the database for all kinds of manipulations (you know, common data operations such as select, update, insert, delete, export into CSV, etc.) via a GUI interface. Much like what you can do with MS Excel and MS Access.

I know only phpMyAdmin which requires a local web server environment which might a little too much for what I need.

I thought http://dev.mysql.com/downloads/mysql/ was what I needed and installed to find out that it's not.

Any such tools exist? I ask this is actually because these MySQL dumps are for my users who know nothing about SQL or anything technical. This is for them, not me. After they downloaded the SQL I provided, they ask me: "How can I open it?"

I tried to provide them CSV, but CSV generated by this approach: http://www.kavoir.com/2010/11/mysql-export-table-to-csv-text-files-for-excel.html would contain stuff like \" if the original data contains ". When you open the CSV in Excel, \" are all over the place.

You could just set up an ODBC source with the MySQL connector and use Access. Wouldn't be quite the same as a native tool, but would handle most things you throw at it. — Marc B
– Marc B, Commented Feb 11, 2011 at 4:26

Brian Warshaw · Accepted Answer · 2011-02-11 04:27:16Z

1

http://www.webyog.com/en/

I used to use SQLyog at my last job. It's a pretty decent GUI tool for interacting with MySQL, either local or remote. It'll cost you $99 at the cheapest, but you can try it for 30 days. If you like it and it makes life easier, it could be worth the $99, as well.

answered Feb 11, 2011 at 4:27

Brian Warshaw

23k9 gold badges55 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Trevor · Accepted Answer · 2011-02-11 04:22:11Z

0

Running a local server is actually pretty easy. I use xampp which was really easy to install and came set up and ready to use phpMyAdmin. It's also really easy to shut the whole server (or just parts of it) down when it's not in use to conserve system resources.

answered Feb 11, 2011 at 4:22

Trevor

1481 silver badge10 bronze badges

Collectives™ on Stack Overflow

MySQL database manipulation program for Windows? Like MS Access or MS SQL?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related