Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Different versions and importing a text file

Posted by jill (jill), 31 October 2002
We have two web servers, one for development only, and the other is the live server.  Ideally they would have exactly the same software, but as it happens they don't.  I have been told that the development server is running mysql v 3.23.44 whereas the live server is running 3.23.32.

We update the mysql database by importing a text file.  On the dev server when we import the file and count the records there is always an extra one, a blank record right at the end.  When we import the same text file to the live server, the record count is correct and there is no blank record at the end.

The way I do the import is with an insert into command.

The later version of the software is the one which adds the blank record, so any ideas about why the difference and anything I should do to avoid adding the blank record would be very welcome.

TIA

Posted by admin (Graham Ellis), 1 November 2002
Hmm.   Is there a blank line on the start or end of the text file by any chance?  If so, any way to strip it off?  Forgive me starting at basics.

If that's not a solution, another work around might simply be to add a "delete where somefield = "" " onto the end of your import script - I really think that would be easier than looking for the difference in the versions, especially as it might turn out that the later version is the one that's technically doing the right thing for some reason.



This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2014: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho