Programming :: Upload Zip With Textfiles Via Http --> Import Into MYSQL?
Jun 13, 2011
I want the LAMP server to present an upload page to the user The user uploads a zip file containing txt files which are tables in clear-text format The server : opens the zip validates the text files (going to skip this for now, but will try to make later) converts the files as here imports them to MYSQL tables All this is supposed to happen automatically, then the user can immediately use the website with the updated data How to implement this (esp. the first part with the zip file)
View 1 Replies
ADVERTISEMENT
Nov 18, 2009
I have a server (fedora 11 , LAMP). I want to know if I can upload something to my server via http (I mean from WAN),and this data stream can directly run into MySQL database . Do I need to write some special codes on my web page , or just change apache's configure file
View 7 Replies
View Related
Feb 24, 2011
However, configured a website on a dedicated server using WHM/cPanel. The site was uploaded using the master account for the website.
The security issue is public users are able to upload files on to my server via the website. They could even access the root and execute whatever they want on the server.
I have consulted with 2-3 Linux experts. According to them, the PHP user has rights to execute anything on the server or upload & store files in whichever folder they want.
Can I protect my folders to avoid file uploads via the website. The application has security vulnerabilites. However, I want to prevent hackers to enter my site until the vulnerabilities are fixed.
View 2 Replies
View Related
Nov 6, 2010
What I am trying to do is to convert a mass of files from standard Windows text encoding to UNIX encoding(462 .txt files). After a bit of searching, I found this bit of code, changed the necessary parts, put in "Sleep" so I could see the output and ran it:
Code: #!/bin/bash
FROM=iso-8859-1
TO=UTF-8
[code]...
View 6 Replies
View Related
Nov 16, 2010
I'm quite a newbie when it comes to MySQL but i heard that its possible to import data from a CSV into a mysql table.
Can anyone enlighten me on how to do it please? Im running CentOS and usiong MySQL Workbench to connect and run queries.
I have my CSV formatted so that the first row has the names of my columns on the table that I want to import it to and the following rows are the data that needs importing.
View 6 Replies
View Related
May 14, 2010
It took a while but I got my home webserver setup and running with mysql. Now I want to import a 70MB MSSQL backup file from my hosting company. I noticed phpMyAdmin can import up to 2MB. Any suggestions on how to do this for a larger file. I do have access to the server running SSH so I'm not opposed to using the command line if I need to.
View 2 Replies
View Related
Jun 8, 2011
I am trying to install some program: rosinfo: - Create mysql database for rosinfo - Create table hosts, locks. Use file docs/rosinfo.sqlAnd I need to create table hosts, locks, using file rosinfo.sql. I have that file, but dont know what to do with it.
View 1 Replies
View Related
May 6, 2010
I want to import data from MySQL to MSSQL. I've been searching in the web, and I can't find a good and straight answer. How can I do it?
View 2 Replies
View Related
Nov 1, 2010
i am having a problem while hosting a website on rhel apache server.when i write the url on browser than its doesnt show any page ,neither it displays any error.However when i am hosting a simple php webpage apart from that website its works fine.i also want to know how can i import a databe file in mysql which is a part of that website.
View 3 Replies
View Related
Feb 8, 2011
I'm looking to import hundreds of email messages stored in mbox format into a MySQL database. Is there a tool out there to do this already? I'd rather not reinvent the wheel if at all possible. I've been using HyperMail to archive my email in HTML format, but the results aren't searchable. I figure that once it's all in MySQL I can write some simple queries to accomplish this.
View 1 Replies
View Related
Oct 10, 2010
I am migrating SugarCRM from windows server to a linux server. But the main problem is the database. How will I import the data from MSSQL of windows to MYSQL of Linux ?
View 5 Replies
View Related
Sep 29, 2010
I have 2 CPU 8 GB RAM server running MySQL & HTTP server with apps using LAMP architecture. Since last few days we are having some performance problems.While looking at the problem i came to know both mysql and http are almost taking 100% cpu time of a single processor and the second processor is free. redirecting the mysql load to one cpu and http load to the second one? Is it possible? If so how to do it?
View 1 Replies
View Related
Feb 7, 2010
I am trying to use regex or pcre to find out the matched from multiple textfiles. how to write a relative program on linux C?
View 3 Replies
View Related
Jan 17, 2011
I am new to pygame and Linux and I am using Red Hat Linux and I cannot import pygame. I thought I installed it but when I open up Python IDLE It says "No module named pygame". Does anyone know what is wrong?? I downloaded pygame1.9.1.release.tar.gz from URL...I might not have installed it or maybe I need something else too, I don't know.
View 6 Replies
View Related
Jul 12, 2011
i am trying to upload a file with cgi. I have an html code like below :
<table class=upload>
<form method='POST' enctype='multipart/form-data' action='upload.cgi'>
<input name=upfile type=file ><br>
<br> <input type=submit value=Press> to upload the file!</form>
</table><br>
I am trying to get the file with upload.cgi and execute a linux command in linux but i do not know how to. I use C code for that. Can you help me,please? How can i know the file from html in cgi C code?
View 2 Replies
View Related
Apr 1, 2010
I work on two hosts, [1] with online ftp access, and [2] without ncftp installed, but with ssh access.
Now I need to recursively upload a folder from [2] to [1]. So I can't use hardfeed - which is for downloading
I think I can use a
find ./orig -exec curl ftp://pinshosting.net
But I'm not so so known with the params of find and curl to get it working recursively.
View 4 Replies
View Related
Apr 10, 2010
I have generated a deb package with the python module stdeb and now I am looking to upload it to the Ubuntu PPA. I have a directory listing of:
[Code]...
View 1 Replies
View Related
Apr 12, 2011
About php upload. I want a php upload script that renames and overwrite every uploaded file as onscreen.jpg I googled it but only found random number rename. Not working for me I want file name change and overwriting file on server.
View 8 Replies
View Related
Jun 1, 2011
I want to know what is the best way/practice to let users upload and download files? I want to be able to let the user upload a file, list all the files uploaded, and allow him to download any file from that list, also delete a file. To my understanding I can make a php script to let them do this and the uploaded files are in a specific folder in the server or I can insert the files into a SQL table. Which direction should I go, let them directly upload the files to a specific folder (no SQL involve), or upload the files into a SQL table?
View 1 Replies
View Related
Apr 21, 2011
The software Nagios uses .cgi files to show a lot of things.. services, hosts, etc etc. Is there any way to pick up those .cgi files and import them to other web page? how to do it?
View 2 Replies
View Related
Sep 3, 2010
I'm at the bottom of the bash learning curve, looking up, hoping someone can toss me a line. I need to update tracker on my system but this will erase the metatag database I've been building up over the course of months for the purpose of indexing a news archive. So the solution seems to be, 1) save the output of tracker-tag to a text file for all relevant files within a directory, 2) upgrade tracker (since the version in the Ubuntu repositories is very much out of date) and then 3) use a script to parse the text file and pass appropriate arguments back to tracker-tag to rebuild the database. It sounds as though it ought to be simple enough, but I need a push in the right direction, which hopefully will not be off the cliff. Before I confuse my metaphors any further, here's what the text file looks like.
[Code]....
View 3 Replies
View Related
Mar 29, 2011
I have this simple code written in python:
Code:
import os
os.system("xterm -e 'ls /usr/lib'")
Is there anyway I can hide the xterm window that is opening ?
View 7 Replies
View Related
Feb 16, 2010
Well, the title says it all. I have a form like this in my document:
<form enctype="multipart/form-data" name="profile" method="post" action="?">
<input type="hidden" name="MAX_FILE_SIZE" value="250000">
Select image:<input type="file" name="image" />
<br />
[code]...
I even printed the $_FILES array and it looks like this:
Array ( [image] => Array ( [name] => bojan.jpg [type] => image/jpeg [tmp_name] => /var/upload/phpjarPwZ [error] => 0 [size] => 10096 ) )
But the problem is that this file never gets saved to /var/upload directory (I changed php.ini file, so that uploaded files should be saved into /var/upload. I tried /var/tmp as well, but it's the same). Here are also the permissions of this dir:
drwxr-xr-x 2 apache apache 48 2010-02-17 00:30 upload
BTW, I use Mandriva 2010 64 bit distribution. I spent last two days searching for solution on internet forums, asking people and made absolutely no progress. is it possible to debug what is happening with the supposedly uploaded file? I mean any logs, where I could find trace, what's going wrong? I tried to check /var/log/httpd and files in there, but no success either...
View 7 Replies
View Related
Oct 15, 2010
I want a script that will send me an email when a file is created on a directory. The script will be monitored by cron. It should actually monitor an FTP directory for any uploads to the FTP directory
View 4 Replies
View Related
Jun 13, 2010
have setup a LAMP server with ubuntu 10.04 server edition x86 for my study in VMware Workstation 7.1 For a assignment I had to make a php script that would load a file up to the server and set the name in a mysql database. According to the book the server should set the image in a cryptic folder in the /tmp/ folder.
This isn't working and i also try'd locate and find to find the image i uploaded. I checked the php.ini and file uploads were on but no folder so i set that one to /tmp/ but still no images. Can anyone help me with enabling this function?
View 3 Replies
View Related
Feb 19, 2010
Exist an equivalent on eclipselink 2.0?
View 2 Replies
View Related
Nov 24, 2010
i'm trying to create simple form that will also upload only xml data. first, the user will need to upload an xml document only by clicking submit, the data will be posted to the server and the user will be redirected to uploader.php. This PHP file is going
to process the form data and do all the work.
PHP Code:
[code]....
View 1 Replies
View Related
Dec 10, 2013
I have installled eyeD3. It works on the commandline (bash). But I want use it in python3.
I did get this error:
Code: Select all>>> import eyed3
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: No module named eyed3
Why cant I use this module for reading and writing tag information to mp3 files?
View 4 Replies
View Related
Oct 7, 2010
upload a file to a business partner of ours in another country. Currently they have an SFTP server set up for us that I am using to download a daily generated file from a previous requirement. I use a bash script to download it since its fairly simple.
Quote:
sftp username@address/filename_filedate.zip /home/user/filedirectory > /var/log/joblog
(removed private info) To satisfy the new requirement I have been trying to write something similar to this;
Quote:
sftp /home/user/filedirectory/filename_filedate.zip username@address:/remotedirectory/
sftps manual page only gives a hint about using a batchfile, however i still cannot get it to work. Does anyone know another way? Or if you can even suggest another method or application? It seems like a bit of a cop out you can EASILY download using the sftp command but can't upload.
EDIT - forgot to mention I have already got keyless entry set up using ssh keys.
View 1 Replies
View Related
Sep 14, 2009
Dear all,
My application has to listen to http request and it must be able to read the http header and then forward the request from proxy. All these things must be done on C/C++. please help me. Awaiting for your reply.
Thank in advance
View 4 Replies
View Related
