How to open 80gb .mysql file in iMac

[jattz]

Hello guys.

I am stuck. I want to open 80gb database file in my imac. But i dont have any tool. its keep hanging why i am trying to open with notepad

 

[jattz]

anyone?

 

[Fernando Torres]

You can't open an 80GB file from notepad or anything that will attempt to load the whole file in memory.
What you need is an editor that will stream this huge file.

Try using Sublime text, although there is no guarantee 80 gigs will load there either
https://forum.sublimetext.com/t/sublime-text-performance-with-very-large-files/9832/27

 

[dead_beef]

Run mysql server (docker can be used), and then load database dump into it.
After that any mysql client can be used to view data (eg mysql workbench).

But if you want to see contents of the dump, you can use command line utils like less.

Hope this helps and sorry for my english.

 

[The Gambler]

I've used a software called "Dbeaver" to open a 10GB SQL file, I think it will work for bigger files too.

 

[Swagmonster]

Try installing phpMyAdmin and upload the .sql file there. Although, it still might crash while uploading, so you will need to adjust the settings.

 

[MisterXYZ]

notepad can not such big files.

Best thing is to install mysql and import this file.

 

[Gogol]

Import the dump. Even of you manage to open the file somehow, you would not be able to do anything remotely practical with such a huge file.

 

[jattz]

Thanks guys

 

[67MAD54]

It sounds like an interesting file

 

[Swagmonster]

It sounds like an interesting file

Yeah share the file here we will open it for you