MySQL

[TunaBoo]

Hi everyone, another newb yay!

Anyways, I have a website hosted for me. I have a webstore deal set up that uses a | delimited database. It has grown too slow (because it is big) so I want to convert it over to MySQL. Now my provider gave me a MySQL database, and I have a web interface deal to enter data... but there is no way I am typing in thousands of lines of database info by hand.

Does anyone have an idea on how exactly to turn a | delimited database into a MySQL database? I can read guides, but I haven't found an applicable one yet.

[matbennett]

Tools like phpMyAdmin let you import data from delimited form. You may well find that your provider has installed this (the majority seem to).

If not, then you can always install it yourself (and it is a VERY useful thing to have available anyway). You can get it from http://www.phpmyadmin.net/

[mystrymaster]

LOAD data INFILE is the sql command that you want to use

[TunaBoo]

I dont have telnet access because they are security nazis or something.

Through the web interface I do have Php my admin. What do I have to do to name the "columns" what they are supposed to be etc?

And I assume I import as tab delimited not pipe delimited?