: How to download a dump of the mysql database from the server's /root/ I have tried to install Let's Encrypt free SSL and somehow I messed up my whole server. I have 2 websites on it, a

@BetL925

The command that you used does not export the database. It imports whatever was in file.sql into the database. The < points from the file to the database.

If you want to export your database into a file, that you can download, you should use:

mysqldump --opt -p -u username database_name > file.sql


Note that the > points towards the file, and it is using the command mysqldump.

That file will usually be created in your home directory and can be downloaded from there.

If you want to create it somewhere else, you can specify the full path:

mysqldump --opt -p -u username database_name > /home/my_unix_user/www/file.sql


When you know exactly where the file will be, you can then get it using SFTP.

Vote Up Vote Down