Jump to content
Sign in to follow this  
NewFM85User

Data export from MYSQL

Recommended Posts

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.