mysqldump error

1 reply [Last post]
Last seen: 2 years 14 weeks ago
Joined: 2011-07-12


mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) when trying to connect

this error occured after running the command: mysqldump --no-data --tables -u [myusename] -p [nameofmysqldb] > [prefix].gitsite-schema.sql

BaM video reference:
* 3:31 - How to export a database schema for version control
@ 02:30

restarted MAMP, same error.
SQL server: red light
phpMyadmin reload, error 2002

haven't found any really useful help that is in plain enough english to solve this.


Last seen: 8 years 45 weeks ago
Joined: 2012-04-04
Broken LocalHost

Sounds more like that your MySQL is not running or it does not have the sock file that its looking for. I would definatly check to see if the sock file that its requesting actually exists first.

The error (2002) Can't connect to ... normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service

Check this out may help you

Add to playlist

Add to , or

Add to new playlist:

Add to playlist
This is a member-only feature
But, it's easy to become a member

Add to cart:

Contact us

Below are the supported keyboard shortcuts for our video player.

Start / stop video
Go to next video
Go to previous video
Increase or decrease player speed by 20%
Skip ahead or go back by 15 seconds
Jump to a percentage (2 is 20%, for example)
Toggle full screen
Videos Pricing More Search
BuildAModule Logo Icon BuildAModule Logo Icon
Become a member!
1 month
6 months
10% off
12 months
20% off
All memberships come with the following:
24 / 7 access to the entire 1800+ video library
An innovative video player with a rolling transcript
Extensive Drupal and cross-platform training
A thorough and thoughtful training style
Progress tracking
Take notes on specific video sections
Intuitive multi-user management
How many users?
Go solo with a single user, or give multiple team members access through one account and get discounts by bundling multiple users into a single membership.