upgrading database

Hi,

am doing a fresh intall of V1.5 on my server and am following this article, as I would like to import the data from my live database from my old install (1.3.8a, (flexible attributes and additional sideboxes mods) from fantastico, I know, knew nothing then so am doing it properly now)

Have created a new database to install V1.5 into, and have imported the data from my live shop into this new database as advised, so now the new db has inherited the old dbs structure I need to upgrade the new db.

Everythings fine when I run the installer, I get to 'database upgrade' and when I hit the button I get the correct db info and upgrade steps.

however, there's a Database Security

Admin Username (from Zen Cart® Admin area) and Password box at the bottom.

As I don't have either, it hasn't been installed yet, how do I upgrade my database structure while retaining the data?

If I install then the old db data will be lost and can't import old database because of sructural diferences.

Can I update the structure of my old db in myphpadmin (3.4.9) to be compat with 1.5? or can I just import the bare minimum of tables I need, products, orders and customers for example

Any suggestions would be greatly appreciated, SK

skelly100:

however, there's a Database Security

Admin Username (from Zen Cart® Admin area) and Password box at the bottom.

As I don't have either
Yes, you do. It's the admin username and password from the database you imported.

Thanks for your very prompt reply DrByte!

If you mean the shop admin login name and shop admin login password from my live shop, these don't seem to work..

I found a script ```
DELETE FROM admin WHERE admin_name = 'Admin';
INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

which I ran but came back as non existant so i presumed this data wasn't in the old db..

maybe my exported database from live shop is corrupted?

SK

You do know that you posted the password for your live shop on an open forum.. Wouldn't take much to decrypt the password and get to your site.. Just sayin'..

Diva, I'm not sure what you mean. They posted the admin pwd reset script, which is already freely available to anyone.

skelly100:

If you mean the shop admin login name and shop admin login password from my live shop, these don't seem to work..
...
which I ran but came back as non existant so i presumed this data wasn't in the old db..
Your old db probably uses a different DB_PREFIX than what you're using on your new site.

YOU MUST USE THE SAME DB_PREFIX ON THE NEW SITE if you want to re-use the old database contents.

Fix the DB_PREFIX setting in your new site's configure.php files to match what's in the DB_PREFIX in your old site's configure.php files.

Thanks again Dr Byte for your time..

had adjusted the db prefix so it matches the old/live db in my new config files, though I hadn't included this prefix in the passwd reset script that I ran. (wasn't my password Diva but thank you for your input)

Will export my old/live db again and try the upgarde again, if it fails will try running the passwd reset script again with correct db tables prefix.

Thanks again,
SK

DrByte:

Diva, I'm not sure what you mean. They posted the admin pwd reset script, which is already freely available to anyone.
Sorry.. I read this after e LONG day of QA testing at work and I'm afraid I saw a username and password posted, and went into auto pilot.. LOL.. My bad.. carry on..

db upgrade successful !

will recount how i did it in case of anyone else have similar problems, and for the general knowledge base..

In old/live shop admin htaccess file found code for htpasswds, however the coresponding passwds file was empty.
This was an extra security measure. I changed my mind as didn't want to have submit 2 passwrds when logging on each time,

deleted the code for htpasswds, this didn't seem to help..

Loged in to old/live shop, reset password to the same password, exported db, imported it into new db

this didn't seem to help..

logged into old/live admin, reset password to 'password' exported db, imported it into new db

this did the trick, I would presume one of the charecters in my password was gettin 'lost in translation'

(Diva, did reset passwrd before this post!)

Thanks everyone for your help.

SK

skelly100:

db upgrade successful !

will recount how i did it in case of anyone else have similar problems, and for the general knowledge base..

In old/live shop admin htaccess file found code for htpasswds, however the coresponding passwds file was empty.
This was an extra security measure. I changed my mind as didn't want to have submit 2 passwrds when logging on each time,

deleted the code for htpasswds, this didn't seem to help..

Loged in to old/live shop, reset password to the same password, exported db, imported it into new db

this didn't seem to help..

logged into old/live admin, reset password to 'password' exported db, imported it into new db

this did the trick, I would presume one of the charecters in my password was gettin 'lost in translation'

(Diva, did reset passwrd before this post!)

Thanks everyone for your help.

SK:laugh::laugh: I've decided to not type/post anymore when I am tired..