Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Workbench, Navicat, TOAD for MySQL?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Workbench, Navicat, TOAD for MySQL?

    I am wondering which of the above most people are using with MySQL?
    Gary S. Traub, Ph.D.


  • #2
    Re: Workbench, Navicat, TOAD for MySQL?

    Gary,

    WorkBench & Toad are free. Navicat is $200?

    As you know WorkBench is from the developers of MySQL. It's powerful but, shall we say, an unusual interface. I rarely use it. But it is good for killing run-away processes from hell - like when you create a test query on a view with a zillion tables only to find out it will take 3-years to run. Open WorkBench and kill it.

    Personally, I don't use Toad. It's also a little strange & quirky, IMO.

    Navicat, which has its faults for sure, I use every day. I find it very easy to navigate in Navicat. But the best thing is, unlike the other two, Navicat allows you to publish to remote locations. You can publish tables, views, etc, synchronize table structures, access remote data directly (no need to copy files or anything). As a matter of fact, Navicat lets you do anything to a remote located database that you can do locally. This makes it so much easier to work with MySQL than the others. It's worth the $200 or whatever they are charging today.
    --

    P.S. Long time no hear?
    Peter
    AlphaBase Solutions, LLC

    Peter@AlphaBaseSolutions.com
    https://www.alphabasesolutions.com


    Comment


    • #3
      Re: Workbench, Navicat, TOAD for MySQL?

      I use Navicat as well, and would describe the others just as Peter did. Navicat has what you need for 95% of the time. It is also ultra cool when it comes to doing data dumps and sync'ing structure or data with a sister copy. The other tools make that more difficult, and I sync structure a dozen times a day because I develop on a local copy, sync with my server copy.

      P.S. Long time no beer?
      Steve Wood
      Join the ALPHA DEVELOPERS NETWORK
      There is no Cloud. It's just someone else's computer.
      Web - Mobile - Hosting - Products - Frameworks - Developer Resources
      AlphaToGo | IADN (100% Alpha Anywhere Websites)

      Comment


      • #4
        Re: Workbench, Navicat, TOAD for MySQL?

        Hi Peter,

        Thanks for those words of wisdom.

        Great to hear from you - we've got to catch up!
        Gary S. Traub, Ph.D.

        Comment


        • #5
          Re: Workbench, Navicat, TOAD for MySQL?

          And thanks for your input too Steve!
          Gary S. Traub, Ph.D.

          Comment


          • #6
            Re: Workbench, Navicat, TOAD for MySQL?

            Just noticed the beer part
            Gary S. Traub, Ph.D.

            Comment


            • #7
              Re: Workbench, Navicat, TOAD for MySQL?

              navicat lite is free
              does almost everything.
              thanks for reading

              gandhi

              version 11 3381 - 4096
              mysql backend
              http://www.alphawebprogramming.blogspot.com
              ggandhi344@gmail.com
              Skype:ggandhi344@gmail.com
              1 914 924 5171

              Comment


              • #8
                Re: Workbench, Navicat, TOAD for MySQL?

                As far as I know, Navicat Lite has been discontinued as of about a year ago. And Navicat Lite didn't allow remote access, synch or publishing - the best features of Navicat.
                Peter
                AlphaBase Solutions, LLC

                Peter@AlphaBaseSolutions.com
                https://www.alphabasesolutions.com


                Comment


                • #9
                  Re: Workbench, Navicat, TOAD for MySQL?

                  i do not know it was discontinued. but you can download from cnet, i am sure.

                  And Navicat Lite didn't allow remote access, synch or publishing - the best features of Navicat
                  .
                  by remote access you mean accessing remote mysql database, yes i do access the remote database with proper credentials using mysql lite.
                  synch - i have not done it so no comment there.
                  publishing - you mean putting all the content of your databse on the remote server, yes i do that with dump and execute sql.

                  ps: synch is mysql feature itself i think, not of navicat
                  thanks for reading

                  gandhi

                  version 11 3381 - 4096
                  mysql backend
                  http://www.alphawebprogramming.blogspot.com
                  ggandhi344@gmail.com
                  Skype:ggandhi344@gmail.com
                  1 914 924 5171

                  Comment


                  • #10
                    Re: Workbench, Navicat, TOAD for MySQL?

                    If you someday decide to replace MySQL with MariaDB then you get integrated HeidiSQL for MariaDB . With HeidiSQL you can do the basic maintenance/synchronizing locally or remotely so no need to install any separate product.

                    Comment


                    • #11
                      Re: Workbench, Navicat, TOAD for MySQL?

                      i do not know it was discontinued. but you can download from cnet, i am sure.

                      Didn't know you could get it at Cnet?

                      by remote access you mean accessing remote mysql database, yes i do access the remote database with proper credentials using mysql lite.
                      synch - i have not done it so no comment there.
                      publishing - you mean putting all the content of your databse on the remote server, yes i do that with dump and execute sql.


                      No. I mean you can edit tables, restructure, create indexes, views, etc on a remote machine directly. No SQL dump/execute files needed. You can synchronize structure remotely, etc as Steve says.

                      ps: synch is mysql feature itself i think, not of navicat

                      ?
                      Peter
                      AlphaBase Solutions, LLC

                      Peter@AlphaBaseSolutions.com
                      https://www.alphabasesolutions.com


                      Comment


                      • #12
                        Re: Workbench, Navicat, TOAD for MySQL?

                        i just checked cnet. they have mysql lite for download. thank goodness i saved the original download so if i need for some reason to install again, i have a copy. i just have to make sure i don't lose it.

                        once you connect to the remote database withe server name, user name and password you do all those stuff from your local computer.

                        for synchronization i thought you set it up in mysql - well i have not done it so you may know more on that,.

                        publishing is just as easy dumping and executing- really painless.

                        ps: i think synchronization and replication are the same.. if so then it is mysql part, you set it up in mysql.
                        Last edited by GGandhi; 03-12-2013, 02:12 PM.
                        thanks for reading

                        gandhi

                        version 11 3381 - 4096
                        mysql backend
                        http://www.alphawebprogramming.blogspot.com
                        ggandhi344@gmail.com
                        Skype:ggandhi344@gmail.com
                        1 914 924 5171

                        Comment


                        • #13
                          Re: Workbench, Navicat, TOAD for MySQL?

                          By "sync" Peter and I mean Navicat's abilty to synchronize database structure and/or data between two copies of the same database. Like I work on my local copy, the one my local Alpha app points to, then when ready to publish I need to make sure the remote copy has any changes I made in my local copy. We can "sync" the two copies with absolute ease; a couple mouse clicks. Any other program I have found makes that process much more difficult.
                          Steve Wood
                          Join the ALPHA DEVELOPERS NETWORK
                          There is no Cloud. It's just someone else's computer.
                          Web - Mobile - Hosting - Products - Frameworks - Developer Resources
                          AlphaToGo | IADN (100% Alpha Anywhere Websites)

                          Comment


                          • #14
                            Re: Workbench, Navicat, TOAD for MySQL?

                            Thanks for all of these comments. Navicat here I come ....
                            Gary S. Traub, Ph.D.

                            Comment


                            • #15
                              Re: Workbench, Navicat, TOAD for MySQL?

                              Just seen this thread. Have to concur Navicat all the way. Absolutely brilliant not jist for all the reasons stated but the ease in which you can build/test/build/test/build/test (you get the idea) pretty complex views/procedures/queries has saved me so much time!
                              Glen Schild



                              My Blog

                              Comment

                              Working...
                              X