I changed all the easy stuff like below. But ALL the insert statements are FUBAR also. And they are massive insert statements, with HTML content, so not a small job to find the error in each one. And the cleint didn't want to pay for any more of my time to fix something that should have been working already. While I have lost this client now, I just want to try and avoid this problem in the future. Avoiding MySQL seems to be the best answer :-)
Russ -----Original Message----- From: dave [mailto:[EMAIL PROTECTED] Sent: 23 October 2005 23:53 To: CF-Talk Subject: RE: MySQL database export i dunno why its changing it, must be a setting he has (on purpose or not) i manually went in and search and replaced names to the right ones and ran it through navicat and it loaded up just fine. so u just might have to do some manual changing ~Dave the disruptor~ "Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time." ---------------------------------------- From: "Snake" <[EMAIL PROTECTED]> Sent: Sunday, October 23, 2005 6:38 PM To: CF-Talk <[email protected]> Subject: RE: MySQL database export Here is one simple example. As you can see every occurrence of the word weight has been generated as weigl instead. /* Table structure for tbl_shipweighls */ drop table if exists `tbl_shipweighls`; CREATE table `tbl_shipweighls` ( `ship_weighlrange_ID` int(11) NOT NULL auto_increment, `ship_weighlrange_Method_ID` int(11) default NULL, `ship_weighlrange_From` double default NULL, `ship_weighlrange_To` double default NULL, `ship_weighlrange_Amount` double default NULL, PRIMARY KEY (`ship_weighlrange_ID`), KEY `shp_weighlrange_ID` (`ship_weighlrange_ID`), KEY `shp_weighlrange_method_ID` (`ship_weighlrange_Method_ID`), KEY `tbl_ShipMethodtbl_ShipWeighlRange` (`ship_weighlrange_Method_ID`) ) TYPE=MyISAM; -- Russ -----Original Message----- From: dave [mailto:[EMAIL PROTECTED] Sent: 23 October 2005 22:59 To: CF-Talk Subject: RE: MySQL database export can you post one of the tables? i have run intotroubles where it will add a default char set that messes everything up, should be last line of each table like TYPE=MyISAM DEFAULT=LATIN=1; change to TYPE=MyISAM; (or whatever db type it is, just remove the default char setting ~Dave the disruptor~ "Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time." ---------------------------------------- From: "Snake" Sent: Sunday, October 23, 2005 5:49 PM To: CF-Talk Subject: RE: MySQL database export Unfortunately I do not have direct access to the MySQL server the original database was on. Only PHPMyAdmin access. Alas the client has decided to believe the old developer. Which is strange considering he came to me in the first place because the developer still didn't have his site up and running after several weeks, and I got it almost working in a few hours. Oh well what can you do. Russ -----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: 23 October 2005 20:14 To: CF-Talk Subject: Re: MySQL database export I'll add a 'me too' to the suggestion of directly connecting the two databases. Get yourself a gui tool like mySQLFront or SQLYog. You should be able to do a direct export/import from server to server right from your desktop. All you need is a username, password, server IP and port number. As for the client getting a line of BS from the developer, you were able to explasin the problem to us without too much technobabble. Supply your info to the client and let them decide who is full of beans. Perhaps they can apply some leverage once properly informed. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222011 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
