Uploading database - access denied?!ASAP

[Becki]

Hi,

 

I've taken a backup of my database using phpmyadmin from my offline shop at home. I have tried to import it to my live site through phpmyadmin. It comes back to say access denied because of the user name and password.

 

Do I need to change my username and password of my offline database to the username and password I have on the live database.

 

I have tried to change the username and password before for the offline database and it has always gone wrong and ends up in uninstalling and installing again.

 

Any help really appreciated!

 

 

Thanks

Becki

 

Can I import a backup from my offline database using the sites admin backup as this isn't password protected - or does it have to be from phpmyadmin

[spax]

Can I import a backup from my offline database using the sites admin backup as this isn't password protected - or does it have to be from phpmyadmin

 

Yes, just upload it to your backups directory and then restore it from your admin. Be sure to upload in ASCII mode.

[Becki]

Yes, just upload it to your backups directory and then restore it from your admin. Be sure to upload in ASCII mode.

 

 

even if I have added sql tables as part of adding contributions to my offline database - so will be different the orignal stock one?

 

Thanks

Becki

[spax]

That's not a problem as the file drops every table before re-creating it. So every table starts with something like:

 

drop table if exists new_table;

create table new_table (

field_1

field_2

field_3

PRIMARY KEY

);

 

Then after that, you get:

 

insert into new_table (field_1, field_2, field_3) values ('data_1', 'data_2', 'data_3');

 

 

Open the backup in a text editor and take a look.

 

Obviously, you will also need to upload your, contribution changed files, for the new tables to be used.

[Becki]

That's not a problem as the file drops every table before re-creating it. So every table starts with something like:

 

drop table if exists new_table;

create table new_table (

field_1

field_2

field_3

PRIMARY KEY

);

 

Then after that, you get:

 

insert into new_table (field_1, field_2, field_3) values ('data_1', 'data_2', 'data_3');

Open the backup in a text editor and take a look.

 

Obviously, you will also need to upload your, contribution changed files, for the new tables to be used.

 

 

My host has said I need to update the database using phpmyadmin?!

 

I remember trying to change the username and password before and it all went very wrong, whats the best way to do it? I suppose I can't get into the backup and change it in there I'll have to change it in phpmyadmin?

 

Thanks

Becki

[crash3903]

My host has said I need to update the database using phpmyadmin?!

 

I remember trying to change the username and password before and it all went very wrong, whats the best way to do it? I suppose I can't get into the backup and change it in there I'll have to change it in phpmyadmin?

 

Thanks

Becki

 

Becki

 

Does your host know anything about OS Commerce - Normally they don't which is why that have said to do it through PhPMyadmin

 

Do as Spax has suggested and you will have no problems

 

Regards

[Becki]

Becki

 

Does your host know anything about OS Commerce - Normally they don't which is why that have said to do it through PhPMyadmin

 

Do as Spax has suggested and you will have no problems

 

Regards

 

Yes they do, I have asked again though incase there was any confusion.

 

Thanks

 

Becki