Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
table problems after reinstall of mysql
copy the ibdat1 file with the data file before uninstalling? so it is too late since it was not copied. so will try to use msysqldump. thanks -
A tuff one=create a table to import a txt file with spaces
interesting karver. Create table with the trim, concat and space atributes cannot accomplish this? The format is described, it is in a txt file, and the rows are consistent.Something like this? create file cpt, (code char(5) primaryy key not null, SeqNum char(2)auto-increment, not null... -
A tuff one=create a table to import a txt file with spaces
Here is the txt file layout: In the Fixed-Feld formats, all records are 80 characters in length. When long CPT code descriptions exceed 72 characters in the fixed-field format, the CPT code is repeated and the sequence number (2-digit counter) is increased by one (eg, 01, 02, 03, etc). Blank... -
table problems after reinstall of mysql
I copied a mysql XXdb with several usable yytables from the mysql server 5.0/data/xxdb folder to an outside folder in W2k and re installed mysql. I then moved the xxdb folder back into the reinstalled mysql server5.0/data/xxdb. the mysql>describe yytable: returns error 1146 (42S02): table...
