Tuesday, May 17, 2016

Import/Export Database in command line

Import mysql DB in command line
>
---------------------------------------------------


  • C:\wamp\bin\mysql\mysql5.6.12\bin>mysql -u(username) -p (database) < path
    Enter password: *******   
  • C:\wamp\bin\mysql\mysql5.6.12\bin>

  • e.g.
     C:\wamp\bin\mysql\mysql5.6.12\bin>mysql -u root -p db_avm < C:\wamp\www\AVMV1\db_avm.sql
    Enter password: *******



    C:\wamp\bin\mysql\mysql5.6.12\bin>



    Export mysql DB in command line>
    ---------------------------------------------------



  • C:\wamp\bin\mysql\mysql5.6.12\bin>mysqldump -u(username) -p (database) > path
    Enter password: *******   
  • C:\wamp\bin\mysql\mysql5.6.12\bin>

  • e.g.
     C:\wamp\bin\mysql\mysql5.6.12\bin>mysqldump -u root -p db_avm > C:\wamp\www\AVMV1\db_avm.sql
    Enter password: *******

    C:\wamp\bin\mysql\mysql5.6.12\bin>


    No comments:

    Post a Comment