SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Zealot
    Join Date
    Nov 2009
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Transferring my DB onto another WAMP server onto my external HD

    Hi,

    i have WAMP installd on my home laptop which contains a database called, ijdb_v2. Now, i also have a external hardrive. If i install WAMP onto my external hd, and make sure it works fine, what is the easiest and quickest way of transferring my ijdb_v2 from my laptop onto my external hardrive which would contain my WAMP server? without having to recreate my db from scratch.

    Is this possible?
    Please help if you can

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Stop the MySQL service, then copy the entire MySQL data directory to the other hard drive.

  3. #3
    SitePoint Zealot
    Join Date
    Nov 2009
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Once i stop MySQL service on my WAMP controller, how do i gain access to the MYSQL data and copy it to my external hardrive?

  4. #4
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I don't know where WAMP puts it. Your my.ini file should tell you. The database is just a set of files and directories on your hard drive. A subdirectory is created for every database you create. The users and permissions you set up are stored the same way, in a database called "mysql" which is a subdirectory in the same location.

  5. #5
    SitePoint Zealot
    Join Date
    Nov 2009
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Dan Grossman View Post
    I don't know where WAMP puts it. Your my.ini file should tell you. The database is just a set of files and directories on your hard drive. A subdirectory is created for every database you create. The users and permissions you set up are stored the same way, in a database called "mysql" which is a subdirectory in the same location.

    Yeah, i found it, in my.ini file there is a line, datadir=c:/wamp/bin/mysql/mysql5.1.36/data

    so i located the path for this and discovered my db's and tables stuff, thanks


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
  •