?
Solved

mysqldump gives syntax error

Posted on 2007-11-14
2
Medium Priority
?
1,013 Views
Last Modified: 2012-08-13
When I use the mysql dump command, I get an 'error in SQL syntax'.
Even this:
mysql> mysqldump --help;
gives the error

I see that mysqldump is in the bin directory, so it is there.
0
Comment
Question by:allelopath
2 Comments
 
LVL 20

Accepted Solution

by:
steelseth12 earned 1600 total points
ID: 20282387
You dont run mysqldump from within mysql.
You run it from the shell
For more info take a look at http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
0
 
LVL 3

Assisted Solution

by:bayesianmind
bayesianmind earned 400 total points
ID: 20282394
Here's an example usage:

from command line:
mysqldump database -u user -p > backupDB.sql
It will then prompt you for the pass for user and go on its way.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month16 days, 21 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question