[solved]how to import the db from the backup file at 1.3.7

[cselton]

i had just try to upgrade to 1.4, but fail.

so trying to downgrade bk to 1.3.7, but coz the db is a mess, so i create a new one and want to import back the old db into the new one, but how can i do it?
there is no button to do this!!

[shokinro]

1. Create a empty DB
2 Use DB tool like PhpMyAdmin to import the backup


3. Restore your site file to the new store

This is important, because you old DB use old cookie key which is saved in your old store setting file
If you don't restore old store file, you and your customer will not bale to log in.

I think this way should be able to go back previous version.

[cselton]

it said
#1046 - No database selected
when i try to do that in phpmyadmin

and wt u mean by restore?
like use bk the file that should from 1.3.7?
i did that already, and now had reinstall and is a brand new site.

but how can i solve this no db selected problem!!

[peanut]

1. Create a empty DB
2 Use DB tool like PhpMyAdmin to import the backup


3. Restore your site file to the new store

This is important, because you old DB use old cookie key which is saved in your old store setting file
If you don't restore old store file, you and your customer will not bale to log in.

I think this way should be able to go back previous version.

I tried this but it doesn't work. I can't see any products in the back office.

[cselton]

im ok with it now,
when u import the db in it, rmb need to select the db store name first to upload, else it will said that no db selected.

[peanut]

im ok with it now,
when u import the db in it, rmb need to select the db store name first to upload, else it will said that no db selected.

Can you be more clear please. Select store name where?

[cselton]

on clipboard01
b4 u do anything, u r at the server level, which havent select any db yet

on clipboard02
then u need to click ur db name on the left column, after that u r at the db store level, and theres where ur db data start.
u can c all the table at this level.

if u c on the top, u can c the different.