hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : phpMyAdmin: Insert data from textfile error!!!
Reply

Forum Jump

phpMyAdmin: Insert data from textfile error!!!

Reply Post New Thread In Programming Discussion Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 09-06-2002, 04:11 AM
mioi mioi is offline
Junior Guru Wannabe
 
Join Date: Jan 2001
Location: Daly City, CA USA
Posts: 53

phpMyAdmin: Insert data from textfile error!!!


after attemping to insert data from a textfile into the table, i get this error message:

Quote:
Error

SQL-query :

LOAD DATA LOCAL INFILE '/var/tmp/phpiDnVUE' REPLACE INTO TABLE `lyrics` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'

MySQL said:


File '/var/tmp/phpiDnVUE' not found (Errcode: 0)
i think it is a phpmyadmin problem, a problem writing the temp file into the temp directory, but i'm not sure. can someone help me out on this? the techs at my webhosting company say that this directory has write permission by all.



Sponsored Links
  #2  
Old 09-07-2002, 01:15 AM
wmac wmac is offline
Web Hosting Master
 
Join Date: May 2001
Posts: 937
Sometimes phpMyAdmin fails to restore dum files specially when it contains binary data.

If you have SSH access try restoring it using shell commands:

mysql -u username -p databasename < ./dumpfilename

(you will need to ftp your dumpfile).

This works on 99% of cases which phpMyAdmin does not work.


Mac

__________________
Free Web Programming eLearning Courses at:
Learnem Educational and Course Farm

Reply

Related posts from TheWhir.com
Title Type Date Posted
Unusual DNS Error Leads to Internet Outage in China Web Hosting News 2014-01-21 12:16:24
Lengthy Outages for Hacker News, FastHosts Web Hosting News 2014-01-06 09:56:36
Network Issues Cause Amazon Cloud Outage Web Hosting News 2013-09-16 12:18:53
Rackspace Adds Redis as a Service with Exceptional Cloud Services Acquisition Web Hosting News 2013-04-01 10:55:48
Expired SSL Certificate Brings Down Windows Azure Cloud Web Hosting News 2013-02-25 10:38:00


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?