Google Plus

How to import and export a mysql database using ssh.

Written by M. Zinoune on . Posted in Frequently Asked Questions

Question :How to import and export a mysql database using ssh.

 

Answer :

     To export a database use:

 

            mysqldump -u root -p db-name > backup.sql 

To import a database:

        mysql -u root -p db-name < backup.sql

For questions please refer to our Q/A forum at : http://ask.unixmen.com

Like us on Facebook

This week Top Posts

Write for us

Recent Comments

SK

|

Yes we can. What kind of help you need? We are doing outsourcing and technical support for Linux and Open source worldwide. To know more about the details visit here.

ClintB

|

After install as above, run shell script /opt/Citrix/ICAClient/wfica.sh manually and note lib errors still occur. I had the x64 motif loaded but had to manually install the x86 too. Got that from http://rpmfind.net/linux/rpm2html/search.php?query=libXm.so.4 Even after that, I still had to do a “yum install alsa-lib.i686 alsa-lib.x86_64″ to resolve any additional libasound.so.2 errors. Once those two lib issues were resolved, Citix Web Interface launched apps fine by telling browser to open launch.ica using /opt/Citrix/ICAClient/wfica.sh. Good luck Ernesto!

AD

|

I need some Help on Linux,can you guide me ?

Edson Carlos

|

In debian no found. I need link download install in linux debian

jacky can

|

You can actually unzip your secret archive by leaving out the -t option, instead using:

unzip newPhoto.jpg

 
IDG Tech Network
Copyright © 2008-2013 Unixmen.com .
Maintained by Anblik .