#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    37
    Rep Power
    15
    on the command line:

    mysqldump -h hostname -u myname -p databasename > backup.sql

    mysqldump: mysql error: Can't connect to mysql server on hostname (146)

    Do a make a mistake?
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Sounds like the mysql daemon hasn't been started.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    37
    Rep Power
    15
    what can i do about it? Is it my provider's problem?
  6. #4
  7. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    Can you access the regular MySQL client using
    mysql -u myname -h hostname -p?

    Your hostname might be wrong. Sometimes when you are telnetting into a server to access MySQL, you still need to use a hostname of 'localhost' to access mysql.
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    37
    Rep Power
    15
    I use telnet often to access mysql so it should be no problem.

    i do not first have to access mysql and then ask for a dump?

    [This message has been edited by pepweb (edited September 14, 2000).]

Similar Threads

  1. Replies: 5
    Last Post: February 2nd, 2005, 12:28 AM
  2. UTF-8 problem in 4.1.1a
    By mehran20 in forum MySQL Help
    Replies: 1
    Last Post: February 8th, 2004, 02:21 PM
  3. WinNT4 problem
    By sandipguha in forum Windows Help
    Replies: 0
    Last Post: January 27th, 2004, 02:06 AM
  4. weird java problem..please help
    By suwandy in forum Java Help
    Replies: 1
    Last Post: January 26th, 2004, 04:13 AM
  5. Replies: 1
    Last Post: January 22nd, 2004, 07:56 AM

IMN logo majestic logo threadwatch logo seochat tools logo