Are you a spammer

Please note, that the first 3 posts you make, will need to be approved by a forum Administrator or Moderator before they are publicly viewable.
Each application to join this forum is checked at the Stop Forum Spam website. If the email or IP address appears there when checked, you will not be allowed to join this forum.
If you get past this check and post spam on this forum, your posts will be immediately deleted and your account inactivated.You will then be banned and your IP will be submitted to your ISP, notifying them of your spamming. So your spam links will only be seen for an hour or two at most. In other words, don't waste your time and ours.

This forum is for the use and enjoyment of the members and visitors looking to learn about and share information regarding the topics listed. It is not a free-for-all advertising venue. Your time would be better spent pursuing legitimate avenues of promoting your websites.

Text Editor for *.sql Files

Topics not related to Ultimate Edition.
Post a reply


Text Editor for *.sql Files

Postby John$ » Fri Apr 22, 2011 4:07 pm

Hi,

The default text editor does not let me edit the MySql sql files. I am relocating a data base and need to edit internal links with a
Find: Old URL
Replace: New URL

When I used a Teco editor, I am from that time in history when this was popular, it dropped characters that invalidated my sql script. I have never used the vi editor or similar product.

Any suggestions would be greatly appreciated.

Thanks,
John
Asus M4A78T-E with AMD 790GX/SB750
AMD Phenom II X4 955 BE @3.2GHz
8gb OCZ DDR3 ram @ 1333 MHz
Pioneer BDR-205 Blu Ray Burner
32" Westinghouse 1080i screen
PYRO A/V Link Video Capture
User avatar
John$
U.E. Newbie
U.E. Newbie
 
Posts: 8
Joined: Wed Oct 20, 2010 4:12 pm
Location: Lowell, Mass USA
Age: 81
Operating System: Ultimate Edition 3.2 32 BIT
Top


Re: Text Editor for *.sql Files

Postby pclinuxguru » Fri Apr 22, 2011 4:20 pm

http://packages.ubuntu.com/dapper/sql-editor
pclinuxguru is deceased.R.I.P
pclinuxguru
U.E. God
U.E. God
 
Posts: 1712
Joined: Sun Oct 17, 2010 2:28 am
Age: 50
Operating System: Ubuntu Gusty Gibson
Top


Re: Text Editor for *.sql Files

Postby John$ » Fri Apr 22, 2011 4:29 pm

That sounds like it should work.

I downloaded the sql-editor and I will check it out for the task at hand.

Thanks,
John
Asus M4A78T-E with AMD 790GX/SB750
AMD Phenom II X4 955 BE @3.2GHz
8gb OCZ DDR3 ram @ 1333 MHz
Pioneer BDR-205 Blu Ray Burner
32" Westinghouse 1080i screen
PYRO A/V Link Video Capture
User avatar
John$
U.E. Newbie
U.E. Newbie
 
Posts: 8
Joined: Wed Oct 20, 2010 4:12 pm
Location: Lowell, Mass USA
Age: 81
Operating System: Ultimate Edition 3.2 32 BIT
Top


Re: Text Editor for *.sql Files

Postby John$ » Fri Apr 22, 2011 5:26 pm

From what I could determine, this was a sql data base editor. I need an editor that will work with an insert load script.

john@Ultimate:~/sql-editor/usr/bin$ file big.sql
big.sql: UTF-8 Unicode English text, with very long lines, with CRLF line terminators


The text editors that have not worked are "Text Editor" and "Juff Ed". The ones I have not tried yet are jEdit, nEdit, and Bible edit. Those seem to be the available ubunta choices.

Many years ago I used the vi editor. It was hard to understand very much like that teco text editor I mentioned earlier.

This script file big.sql is a file that is imported from a client site into a host server's data base using the MySql Admin tool. That teco text editor functioned properly, however it dropped some of those embedded control characters.

Thanks for being patient with me.

John
Asus M4A78T-E with AMD 790GX/SB750
AMD Phenom II X4 955 BE @3.2GHz
8gb OCZ DDR3 ram @ 1333 MHz
Pioneer BDR-205 Blu Ray Burner
32" Westinghouse 1080i screen
PYRO A/V Link Video Capture
User avatar
John$
U.E. Newbie
U.E. Newbie
 
Posts: 8
Joined: Wed Oct 20, 2010 4:12 pm
Location: Lowell, Mass USA
Age: 81
Operating System: Ultimate Edition 3.2 32 BIT
Top


Re: Text Editor for *.sql Files

Postby John$ » Wed Apr 27, 2011 9:36 am

I was able to resolve this issue by using the teco editor with the proper settings for a binary file.

John
Asus M4A78T-E with AMD 790GX/SB750
AMD Phenom II X4 955 BE @3.2GHz
8gb OCZ DDR3 ram @ 1333 MHz
Pioneer BDR-205 Blu Ray Burner
32" Westinghouse 1080i screen
PYRO A/V Link Video Capture
User avatar
John$
U.E. Newbie
U.E. Newbie
 
Posts: 8
Joined: Wed Oct 20, 2010 4:12 pm
Location: Lowell, Mass USA
Age: 81
Operating System: Ultimate Edition 3.2 32 BIT
Top
Post a reply

Return to General Discussion - Birthdays-Welcome to the Forums - Introduce yourself here!

Who is online

Users browsing this forum: No registered users and 40 guests

Powered by phpBB® Forum Software © phpBB Group
{ ASACP_CREDITS }