Import / Export MySQL DB

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

Introducing cPanel

cPanel is a Unix based web hosting control panel that provides a graphical interface and...

Dedicated IP

A Shared Hosting Client can Order an Extra Dedicated IP for a SSL or Dedicated IP for...

Lost Data?

Backups and Data Loss :Inetwebhost is not responsible for files and/or data residing on your...

Kloxo FileManager

Using the File Manager for File Uploads :Instead of uploading your files through the Kloxo...

Install Fantastico on cPanel / WHM

How to install Fantastico on cPanel/WHM ? You don't need to download any files in order to...

Powered by WHMCompleteSolution