voodish logo
tweet rss book of faces Linked In

Import Export sql database the easy way via SSH

Sick of faffing about with phpMyAdmin, cutting up databases that are too large. Save yourself the hassle and use SSH.

Export A MySQL Database

This example shows you how to export a database. It is a good idea to export your data often as a backup.

  1. Using SSH, execute the following command:

    mysqldump -u username -p database_name > dbname.sql

  2. You will be prompted for a password, type in the password for the username and press Enter. Replace username, password and database_name with your MySQL username, password and database name.

Import A MySQL Database

The file must be in .sql format. It can not be compressed in a .zip or .tar.gz file.

  1. If you haven’t already done so, create the MySQL database.
  2. Using SSH, navigate to the directory where your .sql file is.
  3. Next run this command:

    mysql -p -u username database_name < file.sql

  4. Note: The -p will prompt for your account’s password.

    Note: username is the user with rights to the database.

    Related Articles

Comments RSS Feed

No Comments Yet

You can be the first to comment!

Leave a comment