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 Modules Support forums / 
  3. Module usage questions 
  4.  / Moving images on XCGal
Register
1
evylrat
Moving images on XCGal

  • 2005/7/27 16:20

  • evylrat

  • Not too shy to talk

  • Posts: 164

  • Since: 2004/2/25


All this time I've been putting albums in the user albums directory. I want to have a good clear out and move the public albums up a directory. This means that the database will have to reflect the new locations.

In phpmyadmin, is there a quick way to search and replace text in the fields?

(I'm a newbie with SQL)
CheshAIR - Chester and surrounding areas air and water cooled VW club
2
adrock
Re: Moving images on XCGal

  • 2005/7/27 17:09

  • adrock

  • Quite a regular

  • Posts: 291

  • Since: 2004/12/7


use phpMyAdmin to download the xcgal tables from the database as a text file, and then alter the entries using a text editor. (easier find and replace functionality)

I say this because if you are new to it, it will take you longer to find what you are looking for than phpmyadmin's session will allow for changes.

Good Luck!
Affordable Web Hosting - Family - Fun!...and not always in that order!
3
evylrat
Re: Moving images on XCGal

  • 2005/7/27 17:56

  • evylrat

  • Not too shy to talk

  • Posts: 164

  • Since: 2004/2/25


And just reimport the tables back in (after making a backup of course)?
CheshAIR - Chester and surrounding areas air and water cooled VW club
4
adrock
Re: Moving images on XCGal

  • 2005/7/27 18:10

  • adrock

  • Quite a regular

  • Posts: 291

  • Since: 2004/12/7


yep

Be sure that when you 'export' from phpmyadmin that you check the 'drop table' option, and use 'insert' as the overall method.

This will cause the database to drop all of the tables and then re-insert them with the updated info. If you don't drop the tables first, you'll get insert errors telling you that the entries are already there.

(SAVE THE ORIGINAL...if things get whacked out oo bad, you'll at least want to get back to the way it was)

>>example image here<<
Affordable Web Hosting - Family - Fun!...and not always in that order!
5
evylrat
Re: Moving images on XCGal

  • 2005/7/27 18:39

  • evylrat

  • Not too shy to talk

  • Posts: 164

  • Since: 2004/2/25


Thanks! Will have to shift the photos around the server first... What a pain. Thanks for the help
CheshAIR - Chester and surrounding areas air and water cooled VW club

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

182 user(s) are online (140 user(s) are browsing Support Forums)

Members: 0

Guests: 182

more...

Donat-O-Meter

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

Latest GitHub Commits