Welcome to WebmasterWorld Guest from 54.159.44.227

Forum Moderators: open

Message Too Old, No Replies

getting dat files uploaded and.

getting dat files uploaded and...

     

KG2RG

3:04 am on Feb 19, 2006 (gmt 0)

10+ Year Member



Hi, I am very new to SQL. My servers runs phpMyAdmin.

I created a database, and a user.

I also created a few tables, and fields. I have several huge dat files and I wanna get them uploaded to the server.

I asked my server provider, and they said I may need to convert my dat files into SQL file formats. Is this true, and haw do I do it.

Here is what 1 of my dat file looks like, only this is just a snall prtion:

AM¦226081¦¦¦AE4XH¦E¦A¦4¦¦¦¦¦¦¦¦¦A¦
AM¦226603¦¦¦AF4KW¦E¦A¦4¦¦¦¦¦¦¦¦¦A¦
AM¦235651¦¦¦K1UAX¦A¦C¦1¦¦¦¦¦¦¦¦¦¦
AM¦237666¦¦¦K2ITV¦T¦C¦2¦¦¦¦¦¦¦¦¦P¦
AM¦238501¦¦¦K2OKW¦G¦C¦2¦¦¦¦¦¦¦¦¦¦
AM¦239974¦¦¦K2ZXO¦A¦C¦2¦¦¦¦¦¦¦¦¦¦
AM¦241335¦¦¦K3JIZ¦G¦C¦3¦¦¦¦¦¦¦¦¦¦
AM¦243996¦¦¦K4BHI¦T¦C¦8¦¦¦¦¦¦¦¦¦P¦
AM¦246946¦¦¦K4KQ¦E¦A¦4¦¦¦¦¦¦¦¦¦¦
AM¦247083¦¦¦K4KZS¦E¦C¦4¦¦¦¦¦¦¦¦¦A¦
AM¦249372¦¦¦K4VIR¦G¦C¦5¦¦¦¦¦¦¦¦¦¦
AM¦252609¦¦¦K5MSW¦G¦C¦5¦¦¦¦¦¦E¦¦¦P¦
AM¦256709¦¦¦K6LGU¦A¦C¦6¦¦¦¦¦¦¦¦¦¦
AM¦257380¦¦¦K6PGL¦G¦C¦6¦¦¦¦¦¦¦¦¦¦
AM¦257977¦¦¦K6SDJ¦G¦C¦7¦¦¦¦¦¦¦¦¦¦
AM¦258070¦¦¦K6SMR¦¦¦6¦KN6LA¦¦¦¦¦¦¦KF6LLR¦¦KREIDER III, GEORGE W
AM¦260898¦¦¦K7LOB¦G¦C¦7¦¦¦¦¦¦¦¦¦¦
AM¦262963¦¦¦K7ZOX¦E¦C¦7¦¦¦¦¦¦¦¦¦A¦
AM¦266353¦¦¦K8UFX¦G¦C¦8¦¦¦¦¦¦¦¦¦¦
AM¦272129¦¦¦KA0FZR¦N¦D¦10¦¦¦¦¦¦¦¦¦¦
AM¦275438¦¦¦KA0VVN¦N¦D¦10¦¦¦¦¦¦¦¦¦¦
AM¦275661¦¦¦KA0WRS¦G¦D¦4¦¦¦¦¦¦¦¦¦N¦

KG2RG

10:52 pm on Feb 20, 2006 (gmt 0)

10+ Year Member



?

maccas

11:45 pm on Feb 20, 2006 (gmt 0)

10+ Year Member



Try and do a seach and replace. Download textpad and do a regular expression replace (search > replace and check regular expression), find ^ and replace it with INSERT INTO `your_table_name` VALUES (' the do another regular expression and replace $ with ');

Then uncheck regular expression and replace all the with ',' backup first and give it a shot.

 

Featured Threads

Hot Threads This Week

Hot Threads This Month