NewFM85User Posted May 21, 2009 Posted May 21, 2009 Hi, I have this weird situation while exporting mysql data. I am using MYSQL 1.2.9 to store the WebData where users modify it regularly. I am running a FM program each night to import the data from MYSQL to FM.I am using FM pro advanced 8.5 version. I export all the data from mysql table to a text file first and import into FM database from text file. The situation I am facing is, when it exports data from MYSQL to text file , it does not export all the data. If there are 821000 records in mysql, it exports around 819000. The number differs everyday. The data not exported does not have any problem and data not exported differs each day. If data not exported was consistent, I would think that there was some problem with the data, but it gets exported the next day or it was exported few days back. I am not able to find out why this is happening . I have to manually find out which data was not exported and manually import the data from MYSQL to Fm now. When I do that it imports fine indicating that there is nothing wrong with the data. It is just that when I execute the export script ( I run the apple script) to execute mysql command, it does not export all the data and the data NOT exported each day is random. I would appreciate if somebody can help me analyze this problem. If somebody came across the same situation, any advice or feedback would be appreciated. Thanks
mr_vodka Posted May 21, 2009 Posted May 21, 2009 Have you tried using an ODBC import into a temp table ( using the same SQL statement) to see if you get the same results? Or have you tried a different file format?
Newbies MikeyG79 Posted July 27, 2009 Newbies Posted July 27, 2009 What if you only exported the changed data? Do all 800,000+ rows change every night? Doesn't seem too slick to have to manually do an export/import every day.
Recommended Posts
This topic is 5597 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now