*nix pipes vs mysql dump

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

i know enough to ask a few good questions, then get lost in the answers... that being said, can anyone address why it would be a good/bad idea to use *nix pipes compared to mysqldump when setting up the schema and database folders in version control?
* 3:31 - How to export a database schema for version control

Last seen: 2 years 15 weeks ago
Joined: 2011-07-12
the reason this came up...

so, the reason i initially brought this up is because i encountered this error:

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

after executing this code:

mysqldump --no-data --tables -u loc.admin -p loc.gitsite > gitsite-schema.sql

the strangest thing... it actually creates the schema folder, but doesn't populate it with any of the table info.

thought the *nix piping may be a viable alternative if i can't get this resolved.

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.