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>


    Tuesday, February 2, 2016

    Fix insufficient storage in android devices(mobile)

    Fix insufficient storage in android devices(mobile)


    If, for some reason, when you delete a few apps and still getting this error, then you need to do a dump state clearance.
    >Enter your Dialer
    >Dial *#9900#
    >This will access the SysDump menu