Did you try to make an .csv file and then import it with Mysql-Front? I believe that both tables have the same structure. > --- Ian Zabel <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > I already > have my table structure in place in MySQL, > > and I just want to > > import the data from my Access 2000 database. (the > > .mdb is about 50 megs) > > > > The MySQL server is on a Linux system. > > > > I've been using DBTools to do the import, because > it > > allows me to import > > just the data, and not create the tables. (I don't > > want it to create the > > tables, because it's creates them inccorectly. I > > used another tool to create > > the schema, and and fixed all the problems with > it.) > > > > My problem is that when the import is done, all my > > varchar (text in access) > > and text (memo in access) field data leaves behind > > escape switches. All > > quotes look like this \' or \" and all linefeeds > > look like this \r\n. I also > > have other weird characters in the data. > > > > If I export the data using MySQL-Front, I get > stuff > > like this: \\\" \\\' > > \\r\\n > > > > > > Also, some of my data has special characters like > > the ellipses characer, ., > > and when I view access the data through my code, > it > > comes out like this ?. > > > > What is the best way to import data to a MySQL > > server on Linux and preserve > > the correct escaping? > > > > Ian. > > > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list > > archive) > > > > To request this thread, e-mail > > <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > > http://lists.mysql.com/php/unsubscribe.php > > > > ____________________________________________________________ > Do You Yahoo!? > &Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&thgr;&ugr;&ngr;&sgr;&eegr; &sgr;&agr;&sfgr; &sgr;&tgr;&ogr; > http://www.otenet.gr >
____________________________________________________________ Do You Yahoo!? &Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&thgr;&ugr;&ngr;&sgr;&eegr; &sgr;&agr;&sfgr; &sgr;&tgr;&ogr; http://www.otenet.gr --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
