LinuxQuestions.org - How to import and export database

- 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 07:49 PM.