Results 1 to 3 of 3

Thread: how to open an sql file?

  1. #1
    garfish's Avatar
    garfish is offline I'm Not Sure.
    Join Date
    May 2009
    Posts
    775
    Blog Entries
    12
    Thanks
    144
    Thanked 51 Times in 48 Posts

    how to open an sql file?

    i've acquire a database thats about 600mb but i can't open it.
    was surprise notepad and notepad++ can't open an sql files thats about 600mb, anyone tried opening a 600mb sql file? what program did you use?

  2. #2
    Will.Spencer's Avatar
    Will.Spencer is offline Skipper
    Join Date
    Dec 2008
    Posts
    5,032
    Blog Entries
    1
    Thanks
    1,008
    Thanked 2,322 Times in 1,258 Posts
    I create a database in MySQL and import the file.
    Code:
    $ mysqladmin -hDBHOST -uDBUSERNAME -pDBPASSWORD create garfish
    $ mysql -hDBHOST -uDBUSERNAME -pDBPASSWORD garfish
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 36802652
    Server version: 5.1.41-3ubuntu12.7-log (Ubuntu)
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> source garfish.sql;
    ...
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

  3. Thanked by:

    garfish (14 June, 2011)

  4. #3
    JackGreen is offline Unknown Net Builder
    Join Date
    Oct 2011
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Open it also in another SQL softwares like sql server.

Tags for this Thread

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
  •