Mysql dump sql command4/4/2024 ![]() $ mysqldump -u abhi -p sports > sportsdb_bkp.sqlĮnter your password when prompted. The syntax for using MySQLDump is: $ mysqldump -u username -p database_name > backup_filename.sqlįor example, to backup a single database called ‘ Sports‘ to a backup file called ‘ sportsdb_bkp.sql‘, we can run: $ mysqldump -u root -p sports > sportsdb_bkp.sql The output can be then redirected to a file, and the file can be moved or copied over to another system and contents deployed in the database on that system. The tool MySQLDump is basically used to output the dump of one or more databases in MySQL. Today, in this article, we will learn how to backup all MySQL databases using the MySQLDump utility in Linux. Apart from this, the user who wants to backup the database must be an administrator (root user) or the user must have privileges to backup databases. MySQL Client should be already installed in your system, and it should be configured with either a remote or local MySQL Server. There are cases when MySQL databases need to be backed up and saved to a file: for example to secure a copy of the data as a backup, or to copy the databases to another system. They install not only the MySQL Client and Server but also some other database utilities. In Linux, MySQL is available in standard installation packages of almost all major Linux distributions. MySQL is a relational database management system and is used widely all over the IT industry for efficient data storage. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |