Results 1 to 6 of 6

Thread: how to open an sql file?

  1. #1
    garfish's Avatar
    garfish is offline I'm Not Sure.
    Join Date
    May 2009
    Posts
    848
    Blog Entries
    12
    Thanks
    155
    Thanked 57 Times in 54 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 Retired
    Join Date
    Dec 2008
    Posts
    5,033
    Blog Entries
    1
    Thanks
    1,010
    Thanked 2,329 Times in 1,259 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.

  5. #4
    Join Date
    Jun 2012
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Its a software like sql and easy to use.

  6. #5
    richardcarl820 is offline Unknown Net Builder
    Join Date
    Sep 2012
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks for the info I think it's gonna help me too.

  7. #6
    xxcorrosionxx's Avatar
    xxcorrosionxx is offline Newbie Net Builder
    Join Date
    Oct 2012
    Posts
    30
    Thanks
    0
    Thanked 1 Time in 1 Post
    Using a sql server will all depend on the sql upload size. If it exceeded the upload size then it will not upload. If you're opening a sql file using notepad ++ and it isn't opening, then your computer performance must be bad.

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
  •