How to import and export a mysql database using ssh.

User Rating: / 0
PoorBest 

Written by zinovsky | 06 March 2009
Posted in Linux tutorials - 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


Tags:
Comments (0)
Write comment
Your Contact Details:
Gravatar enabled
Comment:
[b] [i] [u] [url] [quote] [code] [img]   
:D:):(:0:shock::confused:8):lol::x:P:oops::cry:
:evil::twisted::roll::wink::!::?::idea::arrow:
Security
Please input the anti-spam code that you can read in the image.
< Prev   Next >