Open .Sql File Extension

[dinobot]

Hi guys About 3 weeks download "Database.with.5.million.Releases-YUNOLEECH", its database with Scene releases, and can't open it. I'm noob at this sql thing. I tried, Microsoft sql server, notepad++(open it but very buggy and its bad), about 4-5 more sql readers, can't remember names, i uninstalled it all.
How can i open this, the file is: backup (520MB), sql file when click on it with the mouse. I think it's some backup of website with releases. What software i need to open and to view it under windows7x64 ultimate?

[anon]

Xampp will have phpmyadmin installed.

Type

http://localhost/phpmyadmin (or whatever phpmyadmin is named in your configuration) into your web browser

Log into phpmyadmin with your username and password.

This will connect you to mysql. Choose databases. In the tabs along the top you will see one for imports. Browse to the sql file and hit go.

All should import. If there are any problems with the import it may be because client version of phpmyadmin may be too low for the sql file being imported in which case you will have to run sql file directly from a command line in the mysql client itself.

Try that.

[dinobot]

Tried this, don't open, is said that maximum file size must be 2048KB, and mine is about 500MB, any other suggestions?

[Mihai]

Weird how you couldn't open it with notepad++. I always did that and it worked. Try these methods here.

[dinobot]

Notepad++ is open the file but after few seconds says" the program is not responding", same with others, installed too Xampp, the type into browser "http://localhost/phpmyadmin" go to insert, select the file and don't work.

[MelvinMeow]

2MB is the largest the file can be on most webservers to upload unless you change the allowed size in the php.ini file.

log into ssh
locate your file
ill call it pow.sql
then go to pma 0r myphpadmin etc..
make a new db
ill call it powdb
then back in a shell
enter this
mysql -u root -p powdb < /path/to/pow.sql
when you press enter it will ask you for a password. Enter the database password.
It should hang for a few minutes... once you get the prompt back your database should be imported.
I do this on my site with 300mb sql files so it should be similar if your trying to load it on a server.
Debain is the os I use this commad on but it should work on most other linux bases os.