Can't get this to work, but i would like to specify LOAD DATA to use an INFILE
from an URL.
For example
LOAD DATA LOCAL INFILE 'http://www.testserver.com/data.csv'
But i get an error message saying file not found.
Anyone know if this is even possible ?
I have never seen this. Mysql would have to do a wget of the file then dump it.
Last I knew it wasn't a web browser. There may be a way to do the wget inline
though, or at least write something in shell or perl to do it. Is this cron'd
or something, or a one time thing?
-
Hi thanks for your answer!
I would like this to be done via cron 3-4 times a day.
Quoting Peter J Milanese [EMAIL PROTECTED]:
I have never seen this. Mysql would have to do a wget of the file then
dump it. Last I knew it wasn't a web browser. There may be a way to do
the wget inline though,
Test USER wrote:
Can't get this to work, but i would like to specify LOAD DATA to use an INFILE
from an URL.
For example
LOAD DATA LOCAL INFILE 'http://www.testserver.com/data.csv'
But i get an error message saying file not found.
Anyone know if this is even possible ?
Which component, Spider?
with TSQLQuery try setting: ParamCheck property to false. Look in help
for your specific component...
To Leo's :
Delphi/dbExpress uses ':' character to specify SQL Parameters much alike
mysql uses '@' for variables :)
e.g.:
q.sql := 'select * from tbl where
Hi,
I have a table with consumer products. I have a row product name
and brand.
If I do a full-text search in boolean mode for a term like apple
ipod I get results like:
Apple iPod (brand: Apple)
TuneDock for Apple iPod (brand: Belkin)
Since both of these terms match
Hello.
mysqldump has --compress option, which can help in case
the network is the main bottleneck.
I'm using the typical --opt with mysqldump, over the internet.
the problem I'm having is the dump takes 30 mins or so, and during that
time, every table in the db is locked (so as not to
Hello.
Use backslashes to escape double quotes. See:
http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html
LMS wrote:
Hi,
I can't save this:
UPDATE [table] SET [filed]='
textarea name={ID_CAMPO} cols=45 rows=4 class=txts
id={ID_CAMPO}{ID_VALOR}
--
For
Hello.
Some tips from the manual could be helpful. See:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
untz wrote:
Hello there,
I just downloaded the MySQL 5 Community Edition for OS X Tiger...
Which component, Spider?
with TSQLQuery try setting: ParamCheck property to false. Look in help
for your specific component...
Mind you, setting ParamCheck only has effect for run-time assignments
to the SQL strings property.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird,
All,
I'm actually looking for a RTFM reply here. I need to simulate SQLSetPos and
SQLBulkOperations in my application which is written with the MySQL C API. I
thought MySQL 5.0 was supposed to have cursor support, but the only thing I can
find in the documentation is regarding server side
Barbara,
Are cursors supported outside of stored procedures,
My understanding is that cursors are supported in sprocs only.
PB
-
Barbara Deaton wrote:
All,
I'm actually looking for a RTFM reply here. I need to simulate SQLSetPos and
SQLBulkOperations in my application which is
Barbara Deaton [EMAIL PROTECTED] wrote on 12/01/2005 09:56:44 AM:
All,
I'm actually looking for a RTFM reply here. I need to simulate
SQLSetPos and SQLBulkOperations in my application which is written
with the MySQL C API. I thought MySQL 5.0 was supposed to have
cursor support, but
Hi list
I have a data set that is composed of many fields (30+). The final app will
allow the users to search records on each field.
What is the best thing to index in this situation? Make an index for *all*
fields?
With kind regards
Andy
--
Now listening to Phase - Morning Light on
On Thu, Dec 01, 2005 at 05:33:01PM +0100, Andy Pieters wrote:
Hi list
I have a data set that is composed of many fields (30+). The final app will
allow the users to search records on each field.
What is the best thing to index in this situation? Make an index for *all*
fields?
You
At 9:56 -0500 12/1/05, Barbara Deaton wrote:
All,
I'm actually looking for a RTFM reply here. I need to simulate
SQLSetPos and SQLBulkOperations in my application which is written
with the MySQL C API. I thought MySQL 5.0 was supposed to have
cursor support, but the only thing I can find
Hi,
Usually, 'ps -ef|grep mysqld' shows:
root 1932 1 ...
mysql 1962 1932 ...
mysql 1963 1932 ...
mysql 1964 1932 ...
...
But today I noticed it's like this:
root 1932 1
mysql 1962 1932 ...
mysql 1963 1962 ...
mysql 1964 1963 ...
mysql 1965 1963 ...
mysql
I tried -C (--compress), but it still took awhile, since the resulting .sql
file is 218Megs.
I am thinking I will have to write a function which logs into an ssh server
inside the local area network that the db server is on, and hopefully the
bottleneck of the internet will disappear, only
Hi everyone,
I just installed mysql50-server, -client, and -scripts from Freebsd ports.
Everything seemed to go well, no errors that I noticed anyway.
So, after installing I tried to start the mysql server.
/usr/local/etc/rc.d/mysql-server.sh start
Nothing happens. No error messages, no starting,
Hello,
Is MySQL 5.0's Index merge optimization is also available to multiple
table joins? When I do explain on 3 table joins, only one key per table
is used :
SELECT R.* FROM L, M, R
WHERE
L.key1 = 1
ANDL.key2 = M.key2
ANDM.key1 = R.key1
R table has 10 rows
M table has 24 million rows
In the last episode (Dec 01), Kayra Otaner said:
Is MySQL 5.0's Index merge optimization is also available to multiple
table joins? When I do explain on 3 table joins, only one key per
table is used :
SELECT R.* FROM L, M, R
WHERE
L.key1 = 1
ANDL.key2 = M.key2
ANDM.key1 =
Hi,
Is it possible to install 2 versions of MySQL on the same computer?
I want to have MySQL 4.1 and 5.0 installed, and use only one of them at a
time.
I have installed MySQL 5.0 over MySQL 4.1 and now MySQL 5 works fine,
however, I cannot start MySQL 4.1 although I have stopped MySQL 5 first.
Hello.
Have you add mysql_enable=YES and others to /etc/rc.conf?
See the contents of /usr/local/etc/rc.d/mysql-server.sh
Tim DeBoer [EMAIL PROTECTED] wrote:
Hi everyone,
I just installed mysql50-server, -client, and -scripts from Freebsd ports.
Everything seemed to go well, no errors
Hello.
If you make composite index on all fields you'll be able
to use it in searchings only on left-most prefixes of the key.
You should make a separate index for each field if you
want to search on each field, however, many indexes will slow
down inserts to the table.
Andy Pieters
Hello,
5.0.11-beta-standard is already running. Now I need to install php-mysql
which requires mysql-3.23.58-15.RHEL3.1.i3.
Here is what I did and the errors I got:
$ sudo up2date -i php-mysql
Password:
Fetching Obsoletes list for
I have read the suggestions for optimization for innodb however I'm
curious if anyone can help me understand which buffers are common (thus
used by innodb action) and which are specific to myiasm. The server has
2GB of ram but runs multiple services. I have a number of different
types of
Hello.
Basic instructions are available at:
http://lists.mysql.com/mysql/115620
Search in archives at http://lists.mysql.com/mysql for more examples.
Octavian Rasnita wrote:
Hi,
Is it possible to install 2 versions of MySQL on the same computer?
I want to have MySQL 4.1
Please see my comments below :
On Thu, 2005-12-01 at 14:06 -0600, Ross Anderson wrote:
I have read the suggestions for optimization for innodb however I'm
curious if anyone can help me understand which buffers are common (thus
used by innodb action) and which are specific to myiasm. The
I have installed Apache PHP and MySQL over a year ago on a WINXP machine
and suddenly a file, presumably there all that time is found to be
infected by an upto date Norton anti virus program.
Norton does not say what trojan horse. It cannot quarantine nor delete
the file so I stopped the MySQL
hmmm...google is null on that one too.
I'd suspect that it's just a false positive, in other words, better to be
safe than sorry from Norton's point of view.
On 12/1/05, Gary [EMAIL PROTECTED] wrote:
I have installed Apache PHP and MySQL over a year ago on a WINXP machine
and suddenly a file,
Anthony Ettinger wrote:
hmmm...google is null on that one too.
I'd suspect that it's just a false positive, in other words, better to be
safe than sorry from Norton's point of view.
On 12/1/05, Gary [EMAIL PROTECTED] wrote:
I have installed Apache PHP and MySQL over a year ago on a WINXP
Hello again,
I am using OS X Tiger and MySQL 5...
Set a password, yesterday, and wish to change it
How would I go about doing this?
I tried do this:
untz$ mysqladmin -u root password dolphin
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user
Nestor,
When I tried this... This is what I got:
mysql use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql delete from user where id='root';
ERROR 1054 (42S22): Unknown column 'id'
Ok, this worked... My question is that is the password for 'root'
supposed to
match the sudo password used to grant super priveleges to the bash user?
I purposely wanted this different and changed my root password on
mysqladmin
to something else... Is it supposed to be the same as the root's
Hi,
The two passwords are totally separate. The MySQL root users password
controls access only to the MySQL databases and tables. sudo password
will allow you access to bash scripts/programs etc.
You could test this by logging in as a user other than root having run
mysql client as a sudo
I am having similar issues. I moved a copy of mysqld_safe to init.d and
removed the old startup script, this had the effect of lowering the number
of processes from about 30 something to 7 or 8. However mysqld_safe now
appears as a subprocess of rc and under mysqld_safe is mysqld and under
_using mysql5
_I have a table points with (atleast) following fields
points_id (int, primary key), logged (datetime), sale_points(float),
available_points(float)
When a new row is inserted available_points is set to the value of
sale_points
I need to update the available points for each
37 matches
Mail list logo