I did ask the developer to get a copy of the databaase directly from the host, and what I got back was another script. It said at the top it was created by SQLyog. It also had errors.
Russ -----Original Message----- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: 23 October 2005 17:25 To: CF-Talk Subject: Re: MySQL database export Try SQLyog at http://www.webyog.com/sqlyog/buysqlyog.html. They have a free version you can try. It is easy to move a db between host with SQLyog. You just right click on the db to move/copy and select "Copy Database to Differenct Host/DB...". It works wonderfully! >I have a client who wanted to mmove their MySQL driven web site to our >servers. >But moving the database has proved to be a pain. >All the original developer could send me was a script he created from >PHPMyAdmin, which is supposed to generate all the tables and data. >Alas the script doesn't work as it is full of errors. He even gave me >access to PHPMyAdmin myself, and I generated the script myself, and it >generated the same errors. > > >table, column, index names have spelling mistakes. >E.G. what should be >Create Table 'sku_options' >is coming out as >Create Table 'sku_ophcla' >and stuff like that > >data types are being mis-spelt. >E.G. tinyint is coming out as tizyint. > >and INSERT statements just cause errors. This appears to in cases where >the table contained large amounts of HTML data. So probably unescaped >quotes and stuff in there I expect. > >Unfortunately the original developer wont admit to the client that >there is a problem with the scripts, and is claiming that it's a >problem with our servers why the database wont work and claiming that >he can move the database to other servers just fine. Which he obviously >cannot if he is using the same errornous script he gave me. > >I can't get a backup of the actual database as the developer says he >doesn't have access to this, and when I asked him to ask the host for >it, I just got back another script with the same problems. Altho this >one wasn't generated with PHPMyAdmin. > >I have actually had this problem in the past when people have sent me >MySQL scripts, but never knew how they had been generated. >Does anyone know if this is a common problem, is it MySQL specific, or >a problem with the programs that are generating the scripts? > >Oh and this is a windows server BTW. > >-- > >Russ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221976 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54