@@SERVERNAME equivalent in mysql

Posted on 2008-11-17
Last Modified: 2012-05-05
Hi, we are migrating our DB from mssql to mysql.
please let me know @@SERVERNAME equivalent in mysql
Question by:vijji_lakshmi
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    with due respect, but despite the requests of the moderators, you still have 33 questions open (including this one).
    EE is a collaborative site, and you have to follow EE rules.

    technically, as I repeated in several questions, your migration from MS SQL server to MySQL is just fool work, especially as you seem to know NOTHING about MySQL, apart from the fact that NOTHING that mssql has apart from the standard sql language is present in MySQL, so WHY do you continue migrating/asking these questions BEFORE even searching the docs/google/? ...

    LVL 26

    Expert Comment

    Even I requested in my several posts about open questions but no luck...forget the open/close issues.. you never turn back whether the provided solution works or not.. I'm sure you never look into it once you got the solution otherwise you wouldn't have posted some many comments.... at least you should communicate the end person who is spending time in helping others..

    About the comparison and all those things... Im completely agree with Angell..

    Author Comment

    hey angelIII/ushastry:
     i am sorry for not closing the open qtns.
    but the sentence you made "as I repeated in several questions, your migration from MS SQL server to MySQL is just fool work"...
    this is our project,we should do it.
    we are not doing it for time pass...
    you said i am asking qtns with out searching in google... is completely wrong.
    after searching in google only iam posting qtns.

    LVL 26

    Expert Comment

    BTW, Did you happen to check the Migration Tool kit provid3ed by MySQL for converting MSSQL->MySQL ?\

    Please check and see if that can help you in any way. Take a look at the download section of

    Author Comment

    Hi ushastry,
        we should not use any tools to migrate.
    please let me know the anser to my qtn "@@SERVERNAME equivalent in mysql"
    LVL 26

    Accepted Solution

    This way you can get the details..

    select @@hostname;
    show global VARIABLES like 'hostname';

    Please close your questions so that anyone will pickup your question and will answer.. if you don't close your questions on time.. then I'm afraid nobody will care to attempt.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now