Database import or export via SSH

Often, it is more convenient to import and export databases not through the phpMyAdmin interface, but using terminal commands, connecting to the server via SSH. This is especially useful when you need to load or unload a large database.

Database import:
1. Pre-upload the database dump file via FTP or through the control panel

2. Connect to the server via SSH and enter the command:

mysql -u db_user -p db_name <db_dump_file.sql

Import to remote server:

mysql -h Server_type -P port -u db_user -p db_name <db_dump_file.sql

Export (create backup):
1. Connect to the server via SSH and enter the command:

mysqldump -u db_user -p db_name> filename.sql

Export from a remote server:

mysqldump -h Server_type -P port -u db_user -p db_name> file_name

A dump of the database named filename.sql will be saved to the root directory

  • 81 Users Found This Useful
Was this answer helpful?

Related Articles

Remote Access for MySQL Server

IntroductionThe MySQL server has the ability to listen on specific addresses to accept incoming...

CRON Scheduler

The Scheduler is a tool for automatically executing tasks on the server that repeat at a...

Creating a Mail Domain

Mail domain is a collection of mailboxes linked by one domain name. Each mailbox has an email...

Adding a domain to hosting

Adding a domain to an existing hosting takes place in the control panel 1. In the "WWW" section,...

Create FTP user

An FTP user is needed to upload or download files to the server via ISPmanager. It only has...