csv database-HELP-URGENT

Ginger · #1 07-22-2005, 06:47 PM

How do I upload/dump/or import a large csv database containing pictures and text into mysql; I presume its through phpmyadmin but I can't figure out
what do.

VodaHost · #2 07-28-2005, 10:49 AM

have you created the tables in mysql ?

VodaHost · #3 08-10-2005, 09:57 AM

Hi Ginger,

You have made close to 15 database related posts in this forum and open just
as many database related support tickets.

Please understand...constructing back end database with a front end user
interface is not a easy matter and definitely can NOT be explained or outlined in a couple of paragraphs in a support ticket.

People study for months and take courses on this topic. Your best bet is to hire a professional. This is what most people do. You can find a cheap one at...

www.scriptlance.com

I hope this is helpful.

*****

sburner · #4 08-13-2005, 11:20 AM

You cannot create a mysql database using a csv file, you have to first create the database manually.

Once you did this, you can use phpmyadmin's "Insert data from a text file into the table" function. I don't know about the pictures part but this should do the trick. Excell databases are tricky.

try this:

Quote:

phpMyAdmin easily allows you to import whole tables of data in comma-separated or tab-separated format. Just look for the "Insert textfiles into table" link when you are viewing a table's properties.

This of course means that you have to create the table first, before you import the data to fit into the columns.

So it goes in this order:

1) create table with exactly the same number of fields as your Excel sheet.

2) make sure those fields have the right datatype to accept the data in the related columns in the spreadsheet.

3) Save as comma-separated .CSV or tab-separated .TXT file in Excel (I recommend tab-separated, because excel is a little weird sometimes about what it surrounds with quotes and what it doesn't. Be careful about having tabs inside your data, though)

4) View your table properties in phpMyAdmin, click on "Insert textfiles into table",
a. Set "Fields terminated by" to \t (for tab-delimited) or , (for comma-separated)
b. Set "Lines terminated by" to \r\n
c. click on "Browse" and upload your file.

I'm sure you noticed the "Fields enclosed by" and "Optionally" choices. The only caveat with Excel-to-MySQL is that Excel will only enclose cells with quotes IF the field separator (comma or tab) occurs within that cell's data, so it's kind of willy-nilly. MySQL either expects ALL fields to have quotes, or (Optionally) all Text fields to have quotes. If your data is too complex, you might have an easier time copying it into an Access table, because Access gives you more control over output to text/CSV.

good luck

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Uploading MySQL Database	charlwillia6	mySQL & PHP	3	09-23-2005 11:08 AM
creating database	sufian	General Support Issues	1	09-20-2005 08:38 PM
database	csypher	mySQL & PHP	1	08-24-2005 10:58 AM
Database Setup	Patti Johnson	CPanel - Control Panel	6	08-19-2005 05:18 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)