database edit restore

[CleoK]

I backed up our database to my hard drive...

 

opened it with a text editor (notetab) .. corrected the prices in

 

insert into products (products_id, products_quantity, products_model, products_image, products_price, products_date_added, products_last_modified, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_ordered) values

 

using search/replace

 

saved it.. then first.. tried, via the script to restore the corrected database

 

... it reverted back to the old prices :(

 

then uploaded it to the backups directory..

 

same thing.. all changes were "un changed"

 

IS there an easy way to do this.. for dialup especially... to change the prices on close to 3000 products?

 

HELP!!!!!!!!!!!!!!!!!!

[ozcsys]

I backed up our database to my hard drive...

 

opened it with a text editor (notetab) .. corrected the prices in

 

insert into products (products_id, products_quantity, products_model, products_image, products_price, products_date_added, products_last_modified, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_ordered) values

 

using search/replace

 

saved it.. then first.. tried, via the script to restore the corrected database

 

... it reverted back to the old prices :(

 

then uploaded it to the backups directory..

 

same thing.. all changes were "un changed"

 

IS there an easy way to do this.. for dialup especially... to change the prices on close to 3000 products?

 

HELP!!!!!!!!!!!!!!!!!!

 

Go to phpmy admin or whatever program your hosting company uses to admin your database and use the sql file with the new prices to update your database from there.