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

Who's Online

242 user(s) are online (126 user(s) are browsing Support Forums)


Members: 0


Guests: 242


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