Re: Importing Data into Mysql

Maxim, I am interested in this concept. I have some big Filemaker databases which I can export in a number of formats. What I would like to do is to be able to create the table and import the data using the first row as field names etc. This is because there are over 300 fields in one of the DBs (13000 records). Any suggestions? George P, in Edinburgh ----- Original Message ----- From: "Maxim Maletsky (PHPBeginner.com)" <php-general@phpbeginner.com> To: "'Jon Farmer'" <jonfarmer@enta.net>; "'Stephen Phillips'" <Stephen.Phillips4@btinternet.com>; <php-general@lists.php.net> Sent: Friday, September 28, 2001 12:31 PM Subject: RE: [PHP] Importing Data into Mysql Creating a dump file is the most universal and secure way. Basically, with any possible language in the world you can write into files, then, adding INSERT bla bla into each line will make you a mySQL dump file. And, with any other method you like you can send this file to mySQL server to import. That is why this method is so useful. Maxim Maletsky www.PHPBeginner.com -----Original Message----- From: Jon Farmer [mailto:jonfarmer@enta.net] Sent: venerdì 28 settembre 2001 12.39 To: Stephen Phillips; php-general@lists.php.net Subject: Re: [PHP] Importing Data into Mysql >Bit off topic this, but does any one know of an easy way to import a database in another >format into Mysql other than exporting it to text or straight to mysql via ODBC? >I'm quite new to this so I'm just trying to sus it all out :) Whats wrong with either of those two methods? -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send blank email to pgpkey@bctech.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com