How to Import/Export MySQL Databases with SSH

To export a MySQL database, access your VPS via SSH and run:
 
# mysqldump -u username -p database_name > dumpfile.sql
 
To import a MySQL Database, run:
 
# mysql -u username -p database_name < dumpfile.sql

 

  • payment
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Install and Run UnixBench on CentOS or Debian VPS

  UnixBench is a popular server benchmarking tool. To install and run UnixBench, just do the...

How to Update cPanel License Key / Run License Script

To run the cPanel License Key update script (perhaps if you've upgraded from a trial license, or...

How to Update VPS Timezone (OpenVZ)

Your OpenVZ will reflect the host server's time settings by default; however, it is possible to...

How to Setup Ruby on Rails for CentOS/Fedora VPS

This tutorial will walk you through the setup of a basic Ruby on Rails environment, including:...

How to Install rTorrent/ruTorrent Seedbox on Ubuntu VPS

This tutorial will guide you through the installation of libtorrent 0.13.0, rTorrent 0.9, and the...