XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / Editing database as tesxt file and repacking with win-gz
Register
1
carnuke
Editing database as tesxt file and repacking with win-gz

  • 2004/4/10 20:33

  • carnuke

  • Home away from home

  • Posts: 1955

  • Since: 2003/11/5


I've been trying to sort out the best way to carry out several text and URL changes in my database. I am considering this option. DOwnload DB, decompress GZ file, open in plain text editor. Use Find and replace for the editing I require. saving as .txt file and recompressing back to GZ using win-GZ

Has anyone done this method successfully or can offer further advice??

Thanks Richard
2
Dave_L
Re: Editing database as tesxt file and repacking with win-gz

  • 2004/4/10 21:46

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


It should work, as long as your text editor can handle the long lines that may be present in a MySQL dump file. I ran into that problem in the past, and wound up using a script instead for this type of text conversion.

Of course, keep the original database backup.

3
carnuke
Re: Editing database as tesxt file and repacking with win-gz

  • 2004/4/10 22:10

  • carnuke

  • Home away from home

  • Posts: 1955

  • Since: 2003/11/5


Thanks for that reply. I assume I should save my edited db as a .txt then conpress to GZ?

BTW I use metapad and I think that's fairly flexible,

Richard

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

196 user(s) are online (134 user(s) are browsing Support Forums)

Members: 0

Guests: 196

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jun 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits