Hi there, I must start out by saying that i am a newbie in the Mysql arena. If i can i will give a bit of background information. Where i work we currently have a MS SQL 7.0, It has a database on there of support calls (100,000 records) that i would like to take and import into Mysql. Thus far i have exported the 24 tables from the database in CSV format and transferred the files to the linux machine.
Now from reading through the online manual i see there is a LOAD DATA LOCAL INFILE function that is turned off by default, to enable i have pass mysql an option ..... somewhere ... Is this the only thing i need to do to get the data into mysql? And if i do get this done will it then take on the properties of the tables that i am importing, eg when i do a create table you have to specify the table size etc. As i said i am only new to this, and would like to thank anyone for their assistance. On another note, having gone through some tutorials online and having found some of them a little brief on information and examples, is anyone able to suggest some good references. Thankyou in advance for your assistance. Regards Sebastian --------------------------------------------------------------------- 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
