Search code examples
mysqllinuxteraterm

how to export database?I'm using teraterm


Does anybody know how to export database?

I'm using TeraTerm and i want to export the database for backup purpose. I tried searching on google about the command but i can't find it.

EDIT:

Thank you for your time and effort in answering my question.The database was already exported. I use this :

    mysqldump -u root -ptest test_db > backup.sql

Solution

  • You can use the mysqldump command this way:

    mysqldump -u root -ptest test_db > backup.sql
    

    Where username is root, root password is test and database name is test_db