« previous next »
Pages: [1]

Author Topic: mass category update  (Read 3987 times)

0 Members and 1 Guest are viewing this topic.

Offline bgnm2000

  • Jr. Member
  • **
  • Posts: 56
    • View Profile
mass category update
« on: October 27, 2002, 04:44:54 PM »
I'd like to change the setting for about 300 categories, I want them all to be the same settings, how can I do this? But I would still like to be able to keep one different from the rest.
Logged

Offline bgnm2000

  • Jr. Member
  • **
  • Posts: 56
    • View Profile
help.
« Reply #1 on: October 31, 2002, 02:40:43 AM »
nobody can help?
Logged

Offline Chris

  • 4images Moderator
  • 4images Guru
  • *****
  • Posts: 4.487
  • Did u ever stop to think and then forget to start?
    • View Profile
A solution
« Reply #2 on: October 31, 2002, 03:40:58 AM »
Okay.

    1.  Install phpMyAdmin, get it from
http://phpmyadmin.net
2.  Using phpMyAdmin, export the 4images categories table
3.  Open the exported text file in an editor.
4.  Do a search and replace on the values you want changed.
5.  Using phpMyAdmin, import the edited file back into the database.
*** KEEP A CLEAN BACKUP OF YOUR TABLE IN CASE OF A MISTAKE! ***[/list:u]
That's what I would do.

P.S.:  You could also use the admin control panel>"Backup Database" to download the table, make the edit, upload by FTP to 4images/data/database, and then restore the table.
Logged
Pages: [1]
« previous next »