SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast daliren's Avatar
    Join Date
    Oct 2001
    Posts
    68
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    opening database dump on local machine

    I have a dump of a database ( 'blahdb.sql' ) from the remote machine. I want to use it to create the database on my home machine. How do I do this? This question seems to be too easy for even the manual to address, but I sure can't figure it out.
    cheers,

    Darren Cassidy

  2. #2
    SitePoint Wizard silver trophy redemption's Avatar
    Join Date
    Sep 2001
    Location
    Singapore
    Posts
    5,269
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    On your command-line, run
    Code:
    $ mysql
    mysql> create database database_name;
    mysql> quit
    
    $ mysql database_name < blahdb.sql


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
  •