Import / Export MySQL DB 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

Parallels Power Panel

Parallels Virtual Automation : Parallels Power Panel Parallels Power Panels (PPP) is a...

OS Templates

We Provide the Following Operating System Templates which is helpfull for your all Technical...

Networking

Address MaskBit combination used to describe which portion of anaddress refers to the network...

Importance Of IPv4 Addresses in Hosting

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

Change Kloxo Password

Change Kloxo Password through SSH:To change password:/script/update --class=client --name=admin...

Powered by WHMCompleteSolution