Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error on transfering database to prod server with myphpadmin


Guest

Recommended Posts

I am trying to transfer my database to the production server using myphpadmin.

 

Heres what i have done. Used the database backup facility provided under oscommerce admin section - this creates a .txt dump file. Then uploaded this to my webspace.

 

Now, the myphpadmin section under sql tab...i press browse for the location of the text file....but i only can browse my local system for the file?? Am i going astray here? shouldnt i be locating the file in my webspace..and if so how???

Anyways, i tried to locate the txt file on the local system and press go ..then get the following error:

Database oscomm-633172 running on 217.114.xxx.xxx

Error

 

SQL-query :

 

DROP TABLE IF EXISTS address_book

 

MySQL said:

 

 

drop command denied to user: '[email protected]' for table 'address_book'

Back

 

 

 

Any ideas anyone??

Link to comment
Share on other sites

Ok,...i got this squared away..i wastn using a user with the proper permissions...once i used the dba user, i could transfer it no problem.

 

Thread closed.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...