Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Error on transfering database to prod server with myphpadmin


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



SQL-query :




MySQL said:



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





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


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

  • Create New...