What is mysqldump ?


Posted On: Feb 22, 2018


    1 Answer Written

  •  devquora
    Answered by Farheen

    Mysqldump is a tool that is a part of the MySQL relational database package. This tool consents you to ‘Dump’ a collection of databases or even a single database for alteration to any other SQL server or for backup.

    The server which the database might be transferred to does not have to be an SQL server for this. The main purpose of this tool is to dump the database as a text file which is a set of SQL statements.

    Command to download the complete MySQL database from the command line.

    mysqldump -u [uname] -p db_name > db_backup.sql

Related Questions

Please Login or Register to leave a response.

Related Questions

Mysql Interview Questions

What is MySql ?

MySql is a multi-threading, multi-user open source SQL database management system . It is typically used for web applica..

Mysql Interview Questions

In which language MYSQL it is written ?

MySql is written in C and C++ programming and SQL parser written in yacc...