Skip to content

Instantly share code, notes, and snippets.

@codewizard13
Last active July 19, 2018 11:24
Show Gist options
  • Save codewizard13/77c801d476aa9e5e9abe7cff8cdd3254 to your computer and use it in GitHub Desktop.
Save codewizard13/77c801d476aa9e5e9abe7cff8cdd3254 to your computer and use it in GitHub Desktop.
Tutorial Notes: Derek Banas MySQL tutorial error + links searched
16:37:08 mysqldump -u root -p mysql_banas > banas.sql Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u root -p mysql_banas > banas.sql' at line 1 0.000 sec
mysqldump --databases test > dump.sql
>mysqldump -u root -p mysql_banas > banas.sql
Enter password: ****
mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061) when trying to connect
https://stackoverflow.com/questions/8575356/error-while-taking-backup-with-mysqldump-in-mysql-command-line
## LINKS I SEARCHED ALREADY, TO NO AVAIL:
- https://stackoverflow.com/questions/3031412/how-to-export-a-mysql-database-using-command-prompt
- https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
- https://serversforhackers.com/c/mysqldump-with-modern-mysql
- https://www.linode.com/docs/databases/mysql/use-mysqldump-to-back-up-mysql-or-mariadb/
- https://stackoverflow.com/questions/22415082/why-wont-my-mysql-command-line-dump-on-an-individual-table-work-but-i-can-dum
- https://dba.stackexchange.com/questions/121268/how-to-run-mysqldump-from-windows-command-prompt
- https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html
- https://dev.mysql.com/doc/refman/8.0/en/mysqldump-sql-format.html
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment