Lantica User Forum - Export data for mySQL

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Export data for mySQL

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Normal Topic

Export data for mySQL (Read 549 times)

Amor Full Member Members Offline No personal text Posts: 366 Location: Germany Joined: Feb 7^th, 2004	Export data for mySQL Mar 19^th, 2006 at 9:55pm	Print Post
	Hello! How can i export Sesame Data for MySQL ? I need that for my Homepage.

	Dr. med. Amor Belhareth&&Medizin Labor &&Germany
	IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: Export data for mySQL Reply #1 - Mar 19^th, 2006 at 10:06pm	Print Post
	Your best bet would probably be to export as CSV (the default), and use any of the available PHP scripts to import the data into MySQL. A quick Google search turned up: http://www.onling.com/vbportal/forum/showthread.php?p=211 for "import csv into mysql". If you wish to eschew scripts you can embed the SQL commands right in the exported ASCII and then pipe the file right into mysql. The details of this approach are better discussed with SQL folks.

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: Export data for mySQL Reply #2 - Mar 19^th, 2006 at 10:17pm	Print Post
	Found SQL statement for importing CSV while digging around. Completely untested, and I am no SQL expert: Code LOAD DATA LOCAL INFILE '/importfile.csv' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3);

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

Page Index Toggle

Pages: 1

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge