Search for "mysql dump" | Tutorial Shares

MYSQL Dump from Command Line

Oct 17, 2024 by Michael Salafia in Linux

Back up your database from the command line using mysqldump. This works in most Linux based terminals / SSH.

$ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]

1	$ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]

[uname] Your database username [pass] The password for your database (note there is no space between -p and the … Continued