Copying database from one server to another
 

In developing customized software for different development sites, I copied the mySQL database from original server to my development server using mysqldump to creat a copy, then mysqladmin to creat it to the development server. The web page I am testing is the same for both development sites, but an error regarding UPDATE on my development server occured. The error message is as below:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Query-based update failed because the row to update could not be found.
/CSG/RMO_portal/user_profiles/userUpdate_submit.asp, line 151


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322)

Page:
POST 257 bytes to /CSG/RMO_portal/user_profiles/userUpdate_submit.asp

Any suggestion on what the error is?

Re: Copying database from one server to another
 

post a couple of lines that include line 151 from userUpdate_submit.asp and we'll see if that will help us help you.