Import Large SQL Database

[ChoboSeki]

I have this SQL file which is 598 MB, and 127 MB gzipped.

What I would like to do with this is host it on one of my computers, but I'm not sure the best route for a software solution. I have tried using NetServer's MySQL to import it but it wouldn't import a file over 8 MB, it would say "Unknown Query".


Does anyone know which SQL software I could use that would be able to import a file as large as this without cutting it down? I can't really cut it in parts due to the freezing of whatever program I try using.

Thanks

[faulkner132]

What kind of SQL database is it and how was it created?

Microsoft SQL Server?
MySQL?
PostgreSQL?

You will need to know how the file was created so you can restore appropriately.

[mairving]

More info would be helpful as mentioned.

If it is a MySQL dumpfile then it can be imported quite easily from the command line:
mysql database_name -u username -p < pathtofile/filename.sql .
It will take quite awhile though.
If it is the data file from the MySQL directory then you can drop it in the proper directory, reset the permissions and you are done.
If it is a SQL Server backup then you can either restore the file to the database if it was a backup or detach/reattach it if it was the datafile.

[ChoboSeki]

Sorry for the delay in response.

I have no idea how it was exported. I just know it's a backup, and .SQL.

mairving: What server program should I use for a server? It will be running on Windows, not nix.

[ChoboSeki]

edit:

I think I got it. Thanks!