*nix pipes vs mysql dump
Thu, 2012-09-06 20:27
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
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.