Grinsewald
Mon 8th Jan '01, 11:30pm
most important of all i need to trasfer all my users accounts. I can do it manually by copying and pasting, telnet did not work so i have tried the dump that i d/l off my old account, I have gone to insert text file in the users part of the dbase, when i go to insert it it has all the seperated by, terminated by etc see below, what i want to know is what shall i put in these fields, i have tried the standard settings, i have tried changing it to anything recgnisable in the dump file, but i cant get it to work it always adds like 595 or more members with no name when my site has only 340 members and none of the members are backed up, so can anyone tell me what i should put in thses fields as the seperators etc?
thankyou.
Grinsewald
Message below
------------------
Location of the textfile
Replace table data with file Replace The contents of the file replaces the contents of the selected table for rows with identical primary or unique key.
Fields
terminated by The terminator of the fields.
Fields
enclosed by OPTIONALLY Often quotation marks. OPTIONALLY means that only char and varchar fields are enclosed by the "enclosed by"-character.
Fields
escaped by Optional. Controls how to write or read special characters.
Lines
terminated by Carriage return: \r
Linefeed: \n
Column names If you wish to load only some of a table's columns, specify a comma separated field list.
thankyou.
Grinsewald
Message below
------------------
Location of the textfile
Replace table data with file Replace The contents of the file replaces the contents of the selected table for rows with identical primary or unique key.
Fields
terminated by The terminator of the fields.
Fields
enclosed by OPTIONALLY Often quotation marks. OPTIONALLY means that only char and varchar fields are enclosed by the "enclosed by"-character.
Fields
escaped by Optional. Controls how to write or read special characters.
Lines
terminated by Carriage return: \r
Linefeed: \n
Column names If you wish to load only some of a table's columns, specify a comma separated field list.