How to dump database in mysql using command line [duplicate]












-1
















This question already has an answer here:




  • Error while taking backup with mysqldump in mysql command line

    5 answers




I want to dump my database into one file with .sql extension using command line.
I've tried all the possible actions suggested in https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html 



mysqldump test > dump.sql


but it gives me this error:




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 gamescholar > dump.sql' at line 1




so why I am getting this error and how to fix it?



note--> the database is already there I checked it using show databases; command.






mysql







share|improve this question















marked as duplicate by GMB, Shadow mysql
Users with the  mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Jan 3 at 0:28


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.














  • 1





    Run the "mysqldump" command from the command line, not from inside the mysql client. It's not an SQL command.

    – Progman
    Jan 2 at 22:28
















-1
















This question already has an answer here:




  • Error while taking backup with mysqldump in mysql command line

    5 answers




I want to dump my database into one file with .sql extension using command line.
I've tried all the possible actions suggested in https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html 



mysqldump test > dump.sql


but it gives me this error:




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 gamescholar > dump.sql' at line 1




so why I am getting this error and how to fix it?



note--> the database is already there I checked it using show databases; command.






mysql







share|improve this question















marked as duplicate by GMB, Shadow mysql
Users with the  mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Jan 3 at 0:28


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.














  • 1





    Run the "mysqldump" command from the command line, not from inside the mysql client. It's not an SQL command.

    – Progman
    Jan 2 at 22:28














-1












-1








-1









This question already has an answer here:




  • Error while taking backup with mysqldump in mysql command line

    5 answers




I want to dump my database into one file with .sql extension using command line.
I've tried all the possible actions suggested in https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html 



mysqldump test > dump.sql


but it gives me this error:




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 gamescholar > dump.sql' at line 1




so why I am getting this error and how to fix it?



note--> the database is already there I checked it using show databases; command.






mysql







share|improve this question

















This question already has an answer here:




  • Error while taking backup with mysqldump in mysql command line

    5 answers




I want to dump my database into one file with .sql extension using command line.
I've tried all the possible actions suggested in https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html 



mysqldump test > dump.sql


but it gives me this error:




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 gamescholar > dump.sql' at line 1




so why I am getting this error and how to fix it?



note--> the database is already there I checked it using show databases; command.





This question already has an answer here:




  • Error while taking backup with mysqldump in mysql command line

    5 answers







mysql




mysql






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 2 at 22:32









GMB

20.6k41028




20.6k41028










asked Jan 2 at 22:25









loay mansourloay mansour

346




346




marked as duplicate by GMB, Shadow mysql
Users with the  mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Jan 3 at 0:28


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.









marked as duplicate by GMB, Shadow mysql
Users with the  mysql badge can single-handedly close mysql questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Jan 3 at 0:28


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.










  • 1





    Run the "mysqldump" command from the command line, not from inside the mysql client. It's not an SQL command.

    – Progman
    Jan 2 at 22:28














  • 1





    Run the "mysqldump" command from the command line, not from inside the mysql client. It's not an SQL command.

    – Progman
    Jan 2 at 22:28








1




1





Run the "mysqldump" command from the command line, not from inside the mysql client. It's not an SQL command.

– Progman
Jan 2 at 22:28





Run the "mysqldump" command from the command line, not from inside the mysql client. It's not an SQL command.

– Progman
Jan 2 at 22:28












1 Answer
1






active

oldest

votes


















2














you need to execute mysqldump command inside shell



you are trying to run command inside MySql Client






share|improve this answer






























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    2














    you need to execute mysqldump command inside shell



    you are trying to run command inside MySql Client






    share|improve this answer




























      2














      you need to execute mysqldump command inside shell



      you are trying to run command inside MySql Client






      share|improve this answer


























        2












        2








        2







        you need to execute mysqldump command inside shell



        you are trying to run command inside MySql Client






        share|improve this answer













        you need to execute mysqldump command inside shell



        you are trying to run command inside MySql Client







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Jan 2 at 22:33









        Derviş KayımbaşıoğluDerviş Kayımbaşıoğlu

        15.7k22042




        15.7k22042

















            Popular posts from this blog

            MongoDB - Not Authorized To Execute Command

            Image
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 I have successfully enabled authorization on MongoDB and I have created an account on the admin database and then I created an account for my database called test. The following connection string to connect to my test database works successfully: mongo --host 192.168.17.52 --port 27017 -u user1 -p password --authenticationDatabase test Only problem I have now is, I cannot execute commands such as: show dbs. I get the following error when I try to do so: "errmsg" : "not authorized on admin to execute command { listDatabases: 1.0, lsid: { id: UUID("a1d5bc0d-bc58-485e-b232-270758a89455") }, $db: "admin...
            Read more

            How to fix TextFormField cause rebuild widget in Flutter

            Image
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 I've got the same issue at #9280. I tried all solutions from that topic with/without GlobalKey for Scaffold and Form but the problem wasn't fixed. I tried to build a authentication form with login and signup. But the keyboard doesn't show when I tap the TextFormField at the first time. Then I try to input some letter from physical keyboard, the widget is rebuilt. Like this: login screen Nothing to be log when I run flutter run --verbose, so I logged manually. Every tapping on field, the widget called dispose -> init -> build. [√] Flutter (Channel beta, v1.0.0, on Microsoft Windows [Version 10.0.17763.195], ...
            Read more

            Npm cannot find a required file even through it is in the searched directory

            Image
            up vote 0 down vote favorite I got that error: users-Air:pdfuploader user$ npm run start client@0.1.0 start /Users/user/Documents/pdfuploader react-scripts start Could not find a required file. Name: index.html Searched in: /Users/user/Documents/pdfuploader/public npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! client@0.1.0 start: `react-scripts start` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the client@0.1.0 start script. npm ERR! This is probably not a problem with npm. There is likely additional logging output above. npm ERR! A complete log of this run can be found in: npm ERR! /Users/user/.npm/_logs/2018-11-19T10_19_14_555Z-debug.log users-Air:pdfuploader user$ And the file is in /Users/user/Documents/pdfuploader/public as you can see in my github repository: https://github.c...
            Read more