15,013
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
→references
m (→references) |
|||
| Line 55: | Line 55: | ||
# mysql> {{kbd | key=exit;}} to leave the MySQL command. | # mysql> {{kbd | key=exit;}} to leave the MySQL command. | ||
=== troubleshooting of MySQL command === | |||
==== command not found: mysqldump ==== | |||
# locate the mysqldump command | |||
#* {{kbd | key=<nowiki>sudo find / -iname mysqldump</nowiki>}} for {{Mac}} or {{Linux}} | |||
#* And find {{kbd | key=<nowiki>/Applications/XAMPP/xamppfiles/bin/mysqldump</nowiki>}} from [https://www.apachefriends.org/index.html XAMPP] for {{Mac}} | |||
# input the complete path of mysqldump command | |||
#* 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>}} | |||
=== references === | === references === | ||