LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   How to import and export database (https://www.linuxquestions.org/questions/linux-newbie-8/how-to-import-and-export-database-709552/)

umwai 03-06-2009 01:19 AM

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

bathory 03-06-2009 02:00 AM

To export a database use:
Code:

mysqldump -u root -p db-name > backup.sql
To import a database:
Code:

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


All times are GMT -5. The time now is 12:54 AM.