Loading ...
Sorry, an error occurred while loading the content.

how to Import data by Mysql command

Expand Messages
  • Raquibul Islam
    Hello experts.How can i import any .sql file in a database and how can i export any database using command line ?
    Message 1 of 2 , Feb 2 11:21 AM
    • 0 Attachment
      Hello experts.How can i import any .sql file in a database and how can
      i export any database using command line ?
    • Zakir Hossain
      For export: mysqldump database_name file.sql example: mysqldump testing dump.sql for backup first create a database (Create database newdb;). then run
      Message 2 of 2 , Feb 2 11:34 AM
      • 0 Attachment
        For export:
        mysqldump database_name > file.sql

        example:
        mysqldump testing > dump.sql

        for backup first create a database (Create database newdb;). then run
        mysql newdb < dump.sql

        Thanks


        On Feb 3, 2008 1:21 AM, Raquibul Islam <rana_cse_05@...> wrote:
        >
        >
        >
        >
        >
        >
        > Hello experts.How can i import any .sql file in a database and how can
        > i export any database using command line ?
        >
        >



        --
        Best Regard,
        Raju
        http://hungrycoder.xenexbd.com
        ----------------------------
        Incredible Bangla Portal
        www.projanmo.com
      Your message has been successfully submitted and would be delivered to recipients shortly.