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:221973 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
