Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2009
    Posts
    2

    Unanswered: small help in MySQL

    i already create my database and i create all the tables and done with all insert data....but i need to save the database as file in my USB or in any other storage but i don't know how?

    i mean how to save it as (file.sql)?

    thanx :-)

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if you use MySQL Administrator you can schedule backups of db's. you can also do that via the MySQLDUMP command
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2009
    Posts
    2

    i see

    lets say my db`s name is cars.... so how to do it by the command MySQLDUMP??

  4. #4
    Join Date
    Nov 2009
    Posts
    2
    mysqldump -u <username > -p<password> --all-databases > <filename> it will take all backup all databases
    -- for particular database cars
    mysqldump -u <username> -p<password> cars > <filename> it will take particular database backup

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •