I ran into a problem doing this! I took the list of usernames and passwords from a .txt (or .cfg, but that's still plain text) file and converted it to excel then made a CSV out of it. When I did that, the data got corrupted for some reason. Whenever I looked at the tables in MySQLCC they were fine, but in command line based MySQL they were corrupted
My only guess was that since Windows uses a different end-line character, MySQL did not import correctly and imported that end-line character which corrupted the data. I didn't know how to convert the CSV to a linux document (I thought all you had to do was make a change then save it). Anyway, I ended up copying the data from the Windows CSV, in gvim, into a new file. I don't know if you'll run into this error at all. When you have your CSV, all you should have to do is LOAD DATA LOCAL INFILE '/path/data.csv' INTO TABLE radcheck; I'm assuming you already know what to put into the CSV files. if not, check the frontios website (www.frontios.com/freeradius.html) to help out Evan Stenmark On Thu, 22 Jul 2004 15:45:32 +0300, Edgars <[EMAIL PROTECTED]> wrote: > test > > > > issa rabba' wrote: > > >You can use one of these descktop programs > > > >SQLyog http://www.webyog.com/index.php > >EMS mysql manager http://ems-hitech.com/mymanager/ > > > >If you don't need to use any of them tell me, I have php script to do some > >thing like this > > > >Regards > > > >-----Original Message----- > >From: [EMAIL PROTECTED] > >[mailto:[EMAIL PROTECTED] On Behalf Of sarky > >Sent: Wednesday, July 21, 2004 9:09 AM > >To: [EMAIL PROTECTED] > >Subject: username's and password > > > >Hello all > > > >I have an excel sheet with 10,000 username's and password and i am trying to > >import them into mysql databse, does anyone out there know of a way to do > >it.. > > > >Thank you > >Sarky > > > > > >- > >List info/subscribe/unsubscribe? See > >http://www.freeradius.org/list/users.html > > > > > >- > >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > > > > > > > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
