Results 1 to 2 of 2

Thread: Load Data

  1. #1
    Join Date
    Jan 2010
    Posts
    15

    Unanswered: Load Data

    Hi,
    For example we use mysqldump to backup one DB with several tables inside. Can we use 'LOAD DATA INFILE ' to extract it to one PC with Mysql inside, by auto. creating both the DB and all the tables?

    Many Thanks & Best Regards,
    HuaMin Chen

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by HuaMin View Post
    Can we use 'LOAD DATA INFILE ' to extract it to one PC with Mysql inside, by auto. creating both the DB and all the tables?
    yes, you can

    please follow instructions in mysql manual for LOAD DATA INFILE

    thank you

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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