SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot p2ranger's Avatar
    Join Date
    Jan 2001
    Location
    Colorado, USA
    Posts
    149
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Moving MySQL data from one machine to another

    I'm running MySQL on my Win98 machine here at home right now. It has Database stuff on it already.

    My web host offers MySQL and if I decide to use that instead, will I be able to transfer the information easily on to their Unix machine?

    I know where the MySQL data files reside on my computer now. Is it a matter of moving the files over or will I have to insert the informaion manually?

    Thanks

    Jason
    ><>

  2. #2
    SitePoint Guru prequel's Avatar
    Join Date
    Nov 1999
    Location
    Brisbane, Australia
    Posts
    682
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yup..

    i have nusphere installed on my home pc

    just dump/backup the database

    mysqldump --opt -u root -p dbname > C:\nusphere\apache\htdocs\dump.sql

    upload to your site a/c and reimport into a database you need to create on the site a/c

    i..e newdatabase

    mysql -u root -p newdatabase < /path/to/dump.sql

  3. #3
    SitePoint Zealot p2ranger's Avatar
    Join Date
    Jan 2001
    Location
    Colorado, USA
    Posts
    149
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Right on!

    Thanks

    Jason
    ><>


Bookmarks

Posting Permissions

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