473,320 Members | 1,910 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

another way to mass-upload than LOAD ??

Hi
My ISP gives me phpMyAdmin to get in contact with my MySQL-db
but sadly enough the "IMPORT TEXTFILE TO TABLE" do not work
(gives errormessage "#1045 access denied" and I do not know if it will be fixed,
everything else seems to work allright)
so I'm looking for an other (easy) way to upload 3000 + more records.

--
Erik RN
Denmark
Jul 19 '05 #1
2 1895


erik wrote:
Hi
My ISP gives me phpMyAdmin to get in contact with my MySQL-db
but sadly enough the "IMPORT TEXTFILE TO TABLE" do not work
(gives errormessage "#1045 access denied" and I do not know if it will be fixed,
everything else seems to work allright)
so I'm looking for an other (easy) way to upload 3000 + more records.
If your ISP has PHP I'd just write a load.php script. Not knowing what
your data looks like (1 col... 10 cols) hard to say. Anyway if you dont
have PHP theres bash. Do a script that outputs:
"insert into mytable values ("v1", "v2", n1, n2);"
then run the script:myscript > load.sql
mysql mydb < load.sql


even in PHP you'd need a line $insq = "inser.... ("$val1", "$val2",...

cal

Jul 19 '05 #2


erik wrote:
Hi
My ISP gives me phpMyAdmin to get in contact with my MySQL-db
but sadly enough the "IMPORT TEXTFILE TO TABLE" do not work
(gives errormessage "#1045 access denied" and I do not know if it will be fixed,
everything else seems to work allright)
so I'm looking for an other (easy) way to upload 3000 + more records.
If your ISP has PHP I'd just write a load.php script. Not knowing what
your data looks like (1 col... 10 cols) hard to say. Anyway if you dont
have PHP theres bash. Do a script that outputs:
"insert into mytable values ("v1", "v2", n1, n2);"
then run the script:myscript > load.sql
mysql mydb < load.sql


even in PHP you'd need a line $insq = "inser.... ("$val1", "$val2",...

cal

Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Jeffrey Silverman | last post by:
Hi, all. Sorry, first off, for the kidna weird selection of crossposted groups, but this question touches on aspects of discussion in each of the groups. So I have a group of around 500 email...
1
by: John Rauhe | last post by:
Hello, Does anybody know how to detect if an mass-storage device has been added to the system ? I am making a program that will (should) detect when a CompactFlash memory card has been inserted...
1
by: kartik | last post by:
Hi , I am in need to find a way, to mass copy the data from db2 table running in mainframe to universal database db2 on NT. I know that DB2 connect gives the flexiblity of connecting and...
3
by: Strasser | last post by:
In Access2000 mass emailing worked perfectly (very powerful tool!). Doesn't work when using XP version of both Access and Outlook, even though I checked the box to ensure that I was sending the...
0
by: Ivan | last post by:
Hi, all, How to get BusRelations of a USB Mass Storage Device in C#? Or, do we have any function to get BusRelations of a USB Mass Storage Device, even not in C#? Any information is...
3
by: Gil \(Asp.net Developer\) | last post by:
3
by: Vjay77 | last post by:
As a result from who is I am getting this: > > NOTICE AND TERMS OF USE: You are not authorized to access or query our WHOIS database through the use of high-volume, automated, electronic...
3
by: colleen1980 | last post by:
Hi: Can any one please help me when user select 2 dates from DDLDate1 10/09/2006 and DDLDate2 10/12/06 and the name and it close the form. I need to create multiple records in the another table on...
1
by: teo | last post by:
Hallo, I'm performing a mass insertion from a text file to a db table with AdoNet commands, like this: myCommand.CommandText = "BULK INSERT ..." from a Win form no problem
4
by: wrldruler | last post by:
Hello, First, I know it's against "Access Law" to save calculations in a table, but....I want/need to. I currently have sub-totals being calculated inside a form, using DMax, DCount, and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.