Import and export mysql database via ssh

You can import and export mysql database via SSH:

To export a MYSQL database run:

# mysqldump -u username -p database_name > mysqlfile.sql

and then fill in the password for the "username".

To import a MySQL database run:

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

and then fill in the password for the "username".
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Linux rebuild broken software raid array - CENTOS

With this article I will show you how to look if a raid array (in our case a RAID1 array) is...

Block IP from your server

You can block an IP (12.12.12.12) from your server with the following command:# iptables -I INPUT...

Check port used in linux

If you want to see which process is using which port, you can do it with the following command:#...

Empty mail queue in exim

So you have a lot of mails in the mail queue, from f.e spam accounts?First check how many mails...

SATA drive not recognized in linux

If your SATA drive does not get recognized when installing linux (happens on older linux...