13,468
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
→Troubleshooting of MySQL command
m (→Preparation) |
|||
| Line 79: | Line 79: | ||
#* old command which caused error {{kbd | key=<nowiki>mysqldump -h 127.0.0.1 -u root -p --force --single-transaction DATABASE_NAME | pv | gzip -c > DATABASE_NAME.sql.gz</nowiki>}} | #* old command which caused error {{kbd | key=<nowiki>mysqldump -h 127.0.0.1 -u root -p --force --single-transaction DATABASE_NAME | pv | gzip -c > DATABASE_NAME.sql.gz</nowiki>}} | ||
#* new command {{kbd | key=<nowiki>/Applications/XAMPP/xamppfiles/bin/mysqldump -h 127.0.0.1 -u root -p --force --single-transaction DATABASE_NAME | pv | gzip -c > DATABASE_NAME.sql.gz</nowiki>}} | #* new command {{kbd | key=<nowiki>/Applications/XAMPP/xamppfiles/bin/mysqldump -h 127.0.0.1 -u root -p --force --single-transaction DATABASE_NAME | pv | gzip -c > DATABASE_NAME.sql.gz</nowiki>}} | ||
==== ERROR 2002 (HY000): Can't connect to local MySQL server ==== | |||
condition on Windows Cygwin terminal: | |||
<pre> | |||
$ mysql -u root -p | |||
Enter password: | |||
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql.sock' (2) | |||
$ mysql -h localhost -u root -p | |||
Enter password: | |||
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql.sock' (2) | |||
</pre> | |||
solution: | |||
* {{kbd | key=<nowiki>-h localhost</nowiki>}} 變數值改成指定 {{kbd | key=<nowiki>-h 127.0.0.1</nowiki>}} | |||
=== further reading === | === further reading === | ||