Solved

mysqldump gives syntax error

Posted on 2007-11-14
2
1,009 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 20

Accepted Solution

by:
steelseth12 earned 400 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 100 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql_mode 1 33
I want to echo out my field names with its values into a table 10 39
category table 2 36
mysql date time 14 43
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

749 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