editing multiple pages

[Trees2wood]

THANKS EVERYBODY !! I am going to learn this or die trying.

Thanks for pointing me in the right direction

[Trees2wood]

and I used to think trying to learn the banjo was hard...geezzz
But I guess I can look at this the same way , practice and sooner or later I will know how to do it

[haredo]

This thread will get you on the right track..

http://www.zen-cart.com/forum/showthread.php?t=124425

[Trees2wood]

I have had a question in my head for a few weeks now about backups , guess this is a good time to get clarification. When I do backups using phpMyAdmin I follow the directions found in the documentation here. The next time I go to do a backup of the DB most everything is checked the same as when I did my last backup with the exception of "add drop table" instead the box "add if not exists" is checked.
In the past I check the box " add drop table " anyway because thats what the directions say.
So my question is do I need to check the "add drop table" everytime or will it be ok leaving it checked at "add if not exists" ??

[kobra]

So my question is do I need to check the "add drop table" everytime or will it be ok leaving it checked at "add if not exists" ??

Basically, NO....

There are instances where one might select a different set but they must really understand what they are doing

The DB while robust is fragile to being structured correctly....

If all you want to alter is the product description....

First make a backup, place your site down for maintenance,

Tehn make a backup/export of ONLY the product description table.

Preserve a unaltered copy of this table, open another copy in a code editor like notepad++

Do a replace and enter the current text exactly in the for box

Enter the exact text you want displayed in the with box and select replace all

Save and import this table to your DB

Take off maint and check that you have not broken things

If you have....import the unaltered back of that table and you should be back to where you were

All else fails, import the full DB backup you made before starting

[Trees2wood]

I got an error message that said #1062 - Duplicate entry '23-1' for key 'PRIMARY'
I scratched my head for a while and thought it was because some of the words was in both what I had to start with and the new description I changed to. ?? So I figured I would try and change the text I didnt want anymore with the word pizza , then I could do it again and change pizza to my new description but get the same error message ?? #1062 - Duplicate entry '23-1' for key 'PRIMARY'

Looking at the database after I changed it , it looks like I want it but something is not in the right place for the import ? any ideas ? Thanks

Scratching my head some more....
Should I drop the products_description table first, then import the new one ? is that where the " duplicate is coming from ?

[Trees2wood]

Should I drop the products_description table first, then import the new one ? is that where the " duplicate is coming from ?

That did it. Thanks for the help everybody. I just changed 768 pages ( I forgot I had over 500 other pages 90% filled out thanks to the copy function )