MySQL DB Import / Export Through SSH

Follow the Steps :

- How  to  use  SSH  import  database  into  mysql?

# mysql -u username -p database_name < file.sql
 

- To export a mysql dump using SSH, execute the following command:

mysqldump -u username -p dbname > db_dump.sql

username -> your mysql username
dbname   -> databse name

- Enter password when prompted. and you are done.



  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Installation of cPanel on VPS/Dedicated Server.

Installation of cPanel on VPS/Dedicated Server.1st ) Login in SSH of VPS/Dedicated Server using...

VNC SERVER Installation

VNC SERVER Installation1) To install VNC just press Ctrl+Alt+T on your keyboard to open Terminal....

Uses of IPv4 Addresses

It’s widely reported that the online platform is evolving rapidly, with social media, mobile and...

CloudLinux OS

What is CloudLinux? CloudLinux is a Kernel-level technology that helps provide for a more...

Access Previleges

  In computing, the superuser is a special user account used...

Powered by WHMCompleteSolution