SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard Aes's Avatar
    Join Date
    Jun 2001
    Location
    Oklahoma
    Posts
    3,392
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Moving Database from Server to Home Computer

    I have the contents of a database in a .dump file. I have PHPMyAdmin installed (although I prefer the command prompt, I do not know how to use it from a Windows XP machine with PHPDev4). How do I load the database into MySQL so that I may use it to develop at home instead of on the server all of the time? Thanks.

    -Colin
    Colin Anderson
    Ambition is a poor excuse for those without
    sense enough to be lazy.

  2. #2
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    the mysql client (mysql.exe) isn't installed with PHPDev4??? if it is, you can use the command line. if mysql is in your path, just run

    Code:
    mysql -uuser -ppass database < path\to\file.dump
    if it's not in your path, just replace `mysql' with the full path. or you can just run mysql.exe by double-clicking it (assuming the default user/pass will work) and run

    Code:
    mysql> source path\to\file.dump
    make sure your database is selected first (`USE database').


    does that help? i thought you already knew how to import with mysql. if PHPDev4 doesn't come with mysql, it really sucks.
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR


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
  •