Hosting Service's SQL Command
I have been having trouble getting the following statement to work to populate my databse with data from a text file.
LOAD DATA INFILE 'Listings-Residential.txt'
INTO TABLE `RESIDENTIAL`
According to my hosting company's support, cPanel configures databases in such a way that this statement will not work.
My question is, I also have access to a co-worker's hosts - one that runs Plesk and one that runs Verio's control panel. Do either of these panels disallow this statement? Is this a common thing, that control panels configure databases in such a way that certain commands cannot run on them?
View Complete Forum Thread with Replies
Related Forum Messages:
Data Transfer Services
Does anyone did DTS using MYSQL before? thinking to migrate from MSSQL to MYSQL.. If MYSQL can do DTS, then I don't need to do scripting to transfer data.
View Replies !
Mysql Services Windows 2003
------=_NextPart_000_0001_01C34BC2.26B3C4C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Why can't I start the service in windows 2003 server have any one a solution?
View Replies !
Windows SQL Services And Removing MySQL
I had installed mySQL when a programmer wanted to use it for a project. Then i uninstalled it. Now the MS SQL services (SQLserver, sql server activation directory helper, sql server browser, and sql server vss writer), cannot be started. The error messages seem to indicate that there are some files missing in order to run the services. I tried to re-install MySQL, but not it is giving me error zero when i run the configurator.
View Replies !
Remote Conn Via ODBC Or Web Services?
I need your help, I've developed an application succesfully using PHP and MySQL But in order to mantain the MySQL database I need to make constant connections from either Progress or Delphi It's been working just fine using the MySQL ODBC 3.51 connector, but only in the SAME machine (localhost) any other machine atmysqlting to connect remotely gets an error This implementation works if my customer has a dedicated server posted on the web, but other customers need to hire external hostings In that case, how can I connect progress or delphi to a REMOTE MySQL DB on a external SERVER?
View Replies !
Mysql Stock In Services Forgot To Remove
i have uninstalled mysql to put it on a different drive soon The old mysql stayd in Services and I dunno how to remove it from administrative services? Mysql is not installed atm i will install it soon in other words how do I remove from administartive services once i uninstall the whole thing.
View Replies !
DB Hosting
I Was looking for a bit of advice, I am new to mySQL and the whole idea of building DB's and websites. There are a few things I would like advice on. If I wanted to put a database that I have made on mySQL onto a webserver how can I do this? Also if I built a website with a db for say a small business would it be a good idea to place the DB on a webserver? I.e. would the db information be safe? Is there a better way to do this?
View Replies !
Hosting MySQL
Any good tutorials on setting up the MySQL server for hosting? is this even possible in the community version?
View Replies !
Web Hosting Databases
Many times we want to be able to manage our databases stored in the web hosting but these only can be manipulated with the PhpMyAdmin.PhpMyAdmin is a simple but useful tool. To people that use MySQL Clients a very good alternative it is the SSH Tunneling, throught this one we can carry out connections to web hosting that supports SSH. SSH can be used to encrypt communications between MySQL Client and your remote MySQL server in your Web Hosting.The prime benefit of SSH tunneling is that it allows us to connect to a MySQL server from behind a firewall when the MySQL server port is blocked.
View Replies !
MySQL Hosting
does anyone know a stand-alone MySQL host... i need to be able to access a MySQL database from anothersite... seperate from the host of the MySQL database...
View Replies !
NySQL Hosting Provider
would be interested in any advice since this is new territory for me -- my experience has only been with Access so far, and for situations where only I could modify the database. But now I have a web application where lots of users need to have password access and be able to modify their own data etc, and where I need to be able to administer the whole thing.
View Replies !
Yahoo's GeoCities Pro Hosting
I am using Yahoo's GeoCities Pro Hosting and when I get into "MyPHPadmin" to view my databases I get the following message. Warning: Your privilege table structure seem to be older than this MySQL version! Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem! How can I get to the script?? Can't find it.
View Replies !
MySQL Virtual Hosting
When you create a new user, let's call him "userJohn", is it possible to set a different data foler for that user? I was thinking it would be great if you could keep user databases seperate from each other, kind of like every user has thier own folder on a virtual database folder, and access can be restricted for that user to the databases in their folder. So if user1 creates a database named "Database1", and later user2 creates a database with the same exact name, it will not give an error, and when user1 alters his "Database1," it will not effect any other users "Database1". Similair to webhosting, where every user has their own folder they keep thier data in.
View Replies !
Hosting Photo Album
I am writing a database for an online photo album website which will allow people to sign in, upload photos, and have an online photo album. I am trying to figure out the best design for this type of application, and I am not sure how to best set up each persons picture database. I suppose there can be a table with a list of all of the people, and then a table with all of their information that is linked to the list of people..does that sound right? Also, does a primary key need to be the same for each table that is related to each other? (Silly question, I know.)
View Replies !
Pull Hosting Plans
I am currently creating a web hosting website for a client of mine, for the packages and the order process we are using a script called "Auto-Host (http://www.idevspot.com/AutoHost.php)", which stores all the hosting plans into a mysql database. This is a great script and it does exactly what we want it too, the only thing missing is it doesnt create a page where people can view the hosting plans and click a sign-up button. Can someone please give me guidance on how i can get a page with all the hosting plans on please?, alternatively i am willing to pay somebody for doing this on my behalf
View Replies !
Demon Hosting How To Use It (odbc/MySQL)
My customer wants a PHP web page; very basic one which I can do for him but I have no idea how to set up ODBC connection (I want to use Access format database) on his account. I can do that with fasthosts quite easily but I cannot find anywhere this option on his demon account. p.s. How do I use MySQL with demon? do I need to install anything on my pc to connect to their server?
View Replies !
Client App Connecting To A Hosting Database
I have installed this webapp http://www.webhelpdesk.com/ on my 2 computers. I want to setup both computer to pull data from my hosting database. I'm with dreamhost.com and when I created my database with the name webhelpdesk. When I checked the database its show as webhelpdesk.domain.com. When I try to change the database on the webapp I get the following: Could not connect to MySQL database 'webhelpdesk' on host 'webhelpdesk.domain.com'. Please confirm the connection settings.
View Replies !
How To Control Mysql In Hosting Server
I am a ASP programmer. I use MS Access for quite some time, and I am to switch to MySQL. The way I use Access is create tables in my computer and upload it. When I want to do backup, I will download it and make another copy locally. 1. How to create a MySQL DB and Upload it? 2. How to modify the DB structure? For example, create index for certain field? do I have to download it and change it locally? 2. How to download and make backup?
View Replies !
Odbc Problem While Hosting Mysql In Ubuntu
I am new comer in mysql, i have a code that is running well when i am using vb6 to accessing mysql database which is hosted in windows. But the odbc facing problem ( table "ttt" does'nt exist ) when i am trying to host the mysql database in ubuntu. I have trying to looking for the solution from google, but until the time of writing this thread, i got no solution.
View Replies !
MySQL Version - Hosting Problem/Question
I was wondering if any of you ever had experiences with different MySQL version with your hosting providers? I used MSSQL with PHP last month in a project and I liked the clean and easy code after using STORED PROCEDURES. So, How can I go about using MySQL 5 or so if hosting provider doesn't support it??
View Replies !
Can I Upload A MYSQL Database To My Free Web Hosting Space?
I have a domain with awardspace.com which has php and MYSQL enabled. I am a newbie and not quite sure how to set it all up or if it's even possible with the Database I've created on my desktop. When I go to the Database Manager in the administrator section it has a spot to create a database,and confirm a password. From there I take it you would use the PHPMyAdmin to alter the database. Can I just upload a database using an FTP manager like Dreamweaver, or do I need to start from scratch and create the database on this server. If so is there a way to eventually download it so I don't lose any of the information in it.
View Replies !
How Often Is Best To Create New Database, Migrate Data With Shared Hosting?
I have got a web site that I have ben working on since March, 2007. It is a news reporting web site. It is replacing an older web site. I created a new database (it uses the MySQL database) last March when I started working on the new web site. I have migrated all of the news content from the old web site database to the new web site database. I have a shared web hosting. It's my understanding that the hosting service provider fills up one server with databases then starts a new server with databases. For example, the IP for the server that is hosting the current database for the new web site is 10.6.166.5 I just created a new database (the hosting allows you to have ten databases per shared hosting). The IP for the server for the recently created database for the new web site hosting is 10.6.166.92 If the servers are ordered sequentially there have been 87 new servers filled up with databases since last March (i.e. 10.6.166.92 recently created IP minus 10.6.166.5 March, 2007 IP equals 87 servers). The problem with migrating the nine-month old database to the new database is that I have got over a thousand news stories and two thousand pictures stored in the database with the 10.6.166.5 IP address. I would have to copy and paste all of the data into the phpMyAdmin program or write a PHP script that would automate the process. Is there any benefit to migrating the 10.6.166.5 March, 2007 IP database over to the more recently created 10.6.166.92 IP database? Would it be reasonable to expect the more recently created database to perform better over the next 12 to 18 months than the one created nine months ago?
View Replies !
Why Dont Shared Hosting Accounts Provide Stored Procedures And Triggers?
i am searching for 3 days now for a reliable, fast hosting company, which supports stored procedures and triggers on mysql5. most of them dont support this, because mysql5 has a design-flaw in which it stores procedures and triggers on a root level-area (tables mysql information_schema). due this logic, most of the hosting companies wont allow you to create/run procedures and triggers. funny, that hosting companies forbid you to use new technologies and methods to build faster.
View Replies !
Best Command
i would like to know the best command to do backuping of the tables in the databases....... i'm using MySQL 4.0 on a solaris 9 OS .....
View Replies !
++ Command In SQL
I am developing a website in MySQL and PHP at www.zakirium.com. The site is supposed be a listing of the best freeware on the web. I'd like to be able to keep track of how many times each piece of software is downloaded. Is there a type of ++ command that could be used with an UPDATE command in PHP that would increase the number in the database column by one, so every time there was a download, the number would increase by one.
View Replies !
Where Command
If I want to update multiple rows and set the same column in each to the same thing, how would I go about doing that? UPDATE gfx SET creator = 202 WHERE id='1,2,3,4,5' Obviously that doesnt work, can I make an array somehow? Or do I have to use a bunch of or s?
View Replies !
SQL Command
If in my data I have for title the values Marketing Manager, Manager, Database Manager and I use LIKE 'Manager' I would want to return all titles with the word Manager or Managers etc. My code only returns an exact match. Can this be easy to do? Code: SELECT * FROM jobtitles j WHERE `title` LIKE 'Marketing Manager';
View Replies !
Sum Command
This may be a silly question but my knowledge is very very limited. If I have 6 columns, say a,b,c,d,e,f and i have a entry where values were a=1 b=2 c=3 d=1 e=2 f=3 If I wanted a sum of cells a,b,c and output a new column called abc and then a sum of cell d,e,f and output a new column called d.e.f how do I go about it ? select sum('a,b,c') $abc sum('d,e'f) $def from detailsas said, knowledge is very limited,
View Replies !
Command To Use
Is there a command that I can use to select a row that contains a particular word in a series of words? For eg. how do I select the row that contains "I am Neo and I hate Smith" in a column if I just search with "Neo"?
View Replies !
Using Command --help
I wonder if ther is any way to get help while using mysql clinet etc. In Linux one can type man command or command --help. If I have forgotten the syntax, for example of grant or update command, how can I get help?
View Replies !
Sql-command
why doesn't work this sql-command? it gives me a syntax-error: SELECT *, IF((SELECT COUNT(*) FROM A, B WHERE A.pk = B.fk) > 0, 'true', 'false') FROM A; the inner sub-selection itself works fine: (SELECT COUNT(*) FROM A, B WHERE A.pk = B.fk; also this would work: SELECT *, IF(1 == 1, 'true', 'false') FROM A; I'm using 4.0.21 - might it be too old for this command? if yes, how could I get it otherwise?
View Replies !
Command
I moved my forum to another folder and now all the references in the database still point to the old folder. What command can I use to update all the URL's in the database to the new folder? EDIT: Nevermind, I figured it out.
View Replies !
SLEEP Command
Is there a 'sleep' command in mysql? I'm trying to take a backup of MySQL instance from a ksh script, and I want to lock all the tables before I take a back of all datafiles. So, once I issue the lock tables command and exit the session to take backup of the OS files, the session (and there by the lock) is lost. So, I'm trying to issue a lock command from one script and let it sleep till my backup is completed.
View Replies !
GROUP BY Command
I've got a table with following fields and data: int int double article,userid,price 1 1 10 1 2 15 1 1 20 2 1 10 2 2 20 3 2 100 3 1 200 What I want to know is, which user pays the highes price for every article. And this in one sql-command. The Result have to look like this: int int double article,userid,price 1 1 20 2 2 20 3 1 200 Any ideas?
View Replies !
Connect Command
I'm new to MySql and I'm having a problem figuring out how to configure my Connect command so I can test on my PC and upload scripts to my ISP without constantly changing the Connect command to reflect the applicable host. I use LocalHost on my machine and then change it to my ISP's IP on their network before uploading the scripts. I'm sure there's something I'm missing in the manual about setting up Grants.
View Replies !
Command Editing
I'm running mysql 4.1 on a Mandrake 10.1 machine. When I try to edit commands using the arrow keys, many keys don't work properly, most notably the delete key. That is, if I make a typo at eh beginning of a long command, I have to way to correct it. Entering the delete key just echos tilde characters in the console. The bash prompt itself recognizes all these keys correctly. This sort of command editing seem to work fine under Win2K at the command prompt.
View Replies !
Mysql BETWEEN Command
i just want to know on how can i query certain part of data using the date.what i mean is, i want to query for example the data from 2005-04-25 till 2005-04-30.i've try the sql code below,but it does'nt work.can anyone give me an example on how can i query using mysql??plz help.tq rsLetterDate.Open " select * from letter BETWEEN letter.letterdate = '2005-04-01' AND '2005-05-31'", "DSN=Data", adOpenStatic, adLockOptimistic
View Replies !
|
TRACKER
