[plug] Advice before change to zencart MySQL database

[Chris Caston]

hello,

I'm experimenting with Zencart and looking at putting in the Aussie ABN
module for wholesalers.

(http://www.zen-cart.com/modules/mydownloads/singlefile.php?lid=439)

 I made a backup of my catalogue folder called zencart2 and used that to
make the changes to the .php files.

I now need to run the following mysql code:

INSERT INTO configuration VALUES ('', 'Minimum ABN Number Length',
'ENTRY_ABN_MIN_LENGTH', '10', 'min length of ABN number', 1, 3,
'2004-10-15 13:27:30', '0000-00-00 00:00:00', NULL, NULL);

ALTER TABLE address_book ADD COLUMN entry_abn varchar(10) NOT NULL
default '' AFTER entry_zone_id;

However this would make the changes to my zencart database that I use
for the original and not the testing one.

Is there a way I can make a copy of the database or something that would
allow a bit of change management?

I'm very wet behind the ears with MySQL and am currently using
MyPHPadmin to do most of the work.

thanks,

Chris Caston