Jump to content
xisto Community
YungOdo

Viewing A Sql

Recommended Posts

im trying to open up a sql to modify a database but my computer im using is kinda slow and everytime i open it up in wordpad it freezes lol does anybody know a good program or text editor i can use to view sql files?..

Share this post


Link to post
Share on other sites

An sql file is basically a text file, but the problem is that if the Database gets large, and you do a full data dump, the file gets too big to load into the editor. I've had that before, so what I do on a large database is use phpmyadmin to dump one table at a time for the large tables, and a couple of smaller ones together in the dump.Then you can load the resulting file into the text Editor.I use ConText Editor for many Web tasks because you can open an entire site all at the same time as a 'Project' and do multiple search and replaces at the same time. I've had up to 60 files open at once, and once I loaded an full Database sql file which was huge, and it worked great.Wordpad is not the best editor for large files. It has a small file size limit.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.