SQL file editor?

Rand al'Thor

Member
Registered
Joined
May 25, 2016
Messages
23
Points
0
After backed up my Mysql databases of my websites to my PC, its data size is too large to open, I can not use tool as Notepad or Dreamweaver to open them, they have at least 300MB+ size for each file. Is there a SQL file editor to edit for large SQL text files? what are your recommendations?
 

HyperHost

Member
Hosting Provider
Registered
Joined
May 12, 2016
Messages
50
Points
8
You can try to use Sublime Text 3, it is easy and should work with big database
 

Rand al'Thor

Member
Registered
Joined
May 25, 2016
Messages
23
Points
0
Rand al'Thor
I have just do a research for Sublime Text 3 on Google and found this

is is the program you are speaking to?

Sublime Text 3.png

If so, it looks cool and I would give it a check.

Any one has other suggestions?
 

HyperHost

Member
Hosting Provider
Registered
Joined
May 12, 2016
Messages
50
Points
8
Yes, this is that program that I`ve meant. It`s cool :icon_mrgreen:
 

LJSHost

Well-known member
Hosting Provider
Registered
Joined
Jul 5, 2016
Messages
1,031
Points
63
Another thumbs up for Sublime here, it's the best text editor and can work with large files that would crash other editors.
Lots of features like advanced search and replace along with color coding for any type of file you could want.
 

Rand al'Thor

Member
Registered
Joined
May 25, 2016
Messages
23
Points
0
Rand al'Thor
I have installed and trying Sublime, it is a good editor tool, but there are 2 disadvantages as I am seeing now

It's not a free version

sublimetext.jpg

It didn't support to save file with encoding which developers can make mistakes on their programming files without knowing reasons why. Here's what I am having on an editor I am using on my PC. It supported encoding.

utf-8-without-signature.jpg
 

GswHosting

Well-known member
Registered
Joined
Aug 23, 2016
Messages
233
Points
0
That is great share and worth knowing for these kind useful programs.
thanks HyperHost and LJSHost
 

LJSHost

Well-known member
Hosting Provider
Registered
Joined
Jul 5, 2016
Messages
1,031
Points
63
Atom is an open source port based on Sublime and is decent if you are looking for a free editor but I've never used Visual Studio Code.
 
Older Threads
Replies
4
Views
6,658
Replies
7
Views
8,807
Replies
5
Views
2,684
Newer Threads
Replies
7
Views
5,662
Replies
2
Views
2,863
Replies
3
Views
8,413
Latest Threads
Replies
1
Views
23
Replies
0
Views
175
Replies
1
Views
37
Replies
2
Views
81
Recommended Threads
Replies
9
Views
5,261
Replies
17
Views
6,666
Replies
5
Views
3,894

Latest postsNew threads

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top