Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Posts
    1

    Unanswered: How do you transfer a mysql database?

    Exactly as the title says.... how do you transfer a mysql database?

    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    dump it to a sql file

    copy the sql file to the new server

    run the sql file
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    I have written a mini article MySQL – copying a database, users and privileges between two servers IT Integrated Business Solutions about how this can be done and includes additional information about permissions and having these copied across too.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

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