Restore a backup on a remote server from localhost using mysql

mysql -h hostname-of-the-server -u mysql_user -p database_name < file_to_restore.sql
Restore a remote database from the local machine from an .sql file also stored on the local machine.

Useful for restore 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.