Make a backup on a remote server using mysqldump

mysqldump -h hostname-of-the-server -u mysql_user -p database_name > file.sql
Make a backup on a remote server using mysqldump installed on the local machine. You do not need mysqldump on the server where the database is hosted! You only need mysqldump in your local machine.

Useful for backing up large MySQL databases.

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.