Results 1 to 6 of 6

Thread: how to open an sql file?

  1. 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. 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. #3
    Open it also in another SQL softwares like sql server.

  4. #4
    Its a software like sql and easy to use.

  5. #5
    Thanks for the info I think it's gonna help me too.

  6. #6
    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
  •