If you want to set the root password you can do the next thing
1. kill the mysqld
2. start mysqld with --skip-grant-tables option
3. set the new password with
mysqladmin -u root password 'RogerTheRabbit'
command
4. and finally - mysqladmin -h hostname flush-privileges
instead of 3 and 4 you
I am having problems with mySQL in windows. I have a query that when ran
causes the server to die. I have selected to debug the program and it tells
me of an unhandled exception wiring to a file. The specifics I can provide
on more detail if it's actually a bug.
I have the following query gener
thank u lovatt!
cant i create an application that runs like a
Oracle trigger using 'C' so that i can get the queries
and the time they took to execute dynamically rather
than using a synthetic model.
--- Peter Lovatt <[EMAIL PROTECTED]> wrote: > Hi
>
> if you are using php
>
> http://uk.php
I'm researching a specific network design and have some questions that may
involve 2-way replication.
I have one master mysql server doing 1 way replication to a large number of
remotely located slaves. Each slave
serves a number of proprietary software clients running inside a private
network.
Hi, I tried to install MySQL source distribution, to be concrete
"mysql-standard-4.0.13-pc-linux-i686".
after running ./configure, it gives no error message, but when running "make" it says
make: *** No targets specified and no makefile found. Stop.
In manual i read it is important to have new
"Me" <[EMAIL PROTECTED]> wrote:
>
> I would like to know how to create a table within MySQL at the command
> prompt where the table name will be something like:
>
>
> MyTableName_TodaysDate
>
>
> Is this possible while at the command prompt? I am trying to create a batch
> file that will creat
"MaFai" <[EMAIL PROTECTED]> wrote:
>
> I'm just wondering is there a function instead of update to overwrite data
> that has expired??
> Or can mysql automatically deletes records or rows that has expires just
> like cookies delete themselves after expiring.
Nope. Write a script that deletes rows
"Shawn Zernik" <[EMAIL PROTECTED]> wrote:
> I am having problems with mySQL in windows. I have a query that when ran
> causes the server to die. I have selected to debug the program and it tells
> me of an unhandled exception wiring to a file. The specifics I can provide
> on more detail if it's
"Ellen Cain" <[EMAIL PROTECTED]> wrote:
>
> I downloaded MyODBC-3.51.06.zip , unzipped it, and there isn't a setup.exe file -
> only 'setup.c'
> Should MyODBC-3.51.06.exe be downloaded?
Did you download MyODBC from MySQL site?
Please, download MyODBC-3.51.06.exe from one of the mirrors:
"Nils Valentin" <[EMAIL PROTECTED]> wrote:
>
> I saw in the online manual
>
> http://www.mysql.com/doc/en/SET_OPTION.html
> http://www.mysql.com/doc/en/Privileges.html
>
>
> A SUPER PRIVILEGE mentioned. How does it differ from the GRANT privilege ?
GRANT option allows you to give your privile
"Fandango del Morro" <[EMAIL PROTECTED]> wrote:
>
> Hello,
> I'm new in this list and I also a newbie with MySql. I have a big problem
> with autoincrementing with an initial value. For example:
>
> use Database Business;
> create Table Clients(Client_ID int not null primary key auto_increment=1
On Thu, 2003-06-19 at 14:13, [EMAIL PROTECTED]
wrote:
> binlog-do-db= test mysql
Hi,
There should only be one database per line:
binlog-do-db= test
binlog-do-db= mysql
regards,
Martin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
# [EMAIL PROTECTED] / 2003-06-21 12:35:04 -0700:
> I'm trying to load a couple tons of data into a shopping cart system
> and for some reason it keeps kicking back with an error. I'm too dumb
> to figure out why. Can anyone tell me what's wrong with this code and
> why it doesn't work?
I can
Martin Waite writes:
> On Thu, 2003-06-19 at 14:13, [EMAIL PROTECTED]
> wrote:
>
> > binlog-do-db= test mysql
>
> Hi,
>
> There should only be one database per line:
>
> binlog-do-db= test
> binlog-do-db= mysql
How stupid of me not to have thought about
Dear all,
Can someone please help me???
I'm getting errors compiling MySQL++ libs on Solaris 2.7 using Sun Workshop 5.0
compiler.
I've built the C client libs/api successfully using the following configure command (
& then done make, make install )
configure CC="/opt/SUNWspro/bin/cc" CFLAGS="
Hi,
I'm looking for information on testing MySQL server with Open SSL
using any client(JDBC/ODBC). Please let me know how to test using a
MySQL client for SSL. I was able to compile mysql with using open SSL
Thanks
Ram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
Hello,
After some moderately heavy usage, MySQL crashed on me.
The problem seems to relate to the size of the innodb log file,
alhtough I'm not currently using innodb files. [Still trying to
debug client before exploring innodb vs myisam ]
I've gathered up all the evidence in a "tar
> > Why isn't the key being used in the "c" (certificate) table?
> > SELECT DISTINCT a.uid, a.company, a.firstname, a.lastname
> > FROM master_info a, logins lsl, logins lc, certificate c WHERE
> > a.uid = lsl.uid AND lc.parent = lsl.uid AND lc.uid = c.uid AND
> > c.void <> 1 AND c.status IN
>
Write a quick perl program.
O.S. Bos wrote:
Hi there,
I have a textfile that I want to get inserted into a database. The
textfile consists of Questions and Answers. 1st line is a question. 2nd
line of the textfile is the answer. And so on...
What is the best way to import these lines into the
mtop (MySQL top) monitors a MySQL server showing the queries which are
taking the most amount of time to complete. Features include 'zooming' in
on a process to show the complete query, 'explaining' the query optimizer
information for a query and 'killing' queries. In addition, server
performance s
OR, if you are good at vi,
you can insert a ' at the begining and end of every line (if you dont have
any 's in the file)
then put a , at the end of every odd line
then join every other line
the put a "insert into blah (question, answer) values ( " at the
begin of every line
and then
Unless, of course, you have quotes in your data.
With perl you can use the quote() function to ensure the whole line gets in.
Christopher Knight wrote:
OR, if you are good at vi,
you can insert a ' at the begining and end of every line (if you dont have
any 's in the file)
then put a , at the end
For automated setup under windows, the MyODBC-3.51.06.exe file should be
downloaded.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Ellen Cain [mailto:[EMAIL PROTECTED]
> Sent: Saturday, June 21, 2003 4:37 PM
> To: [EMAIL PROTECTED]
> Subject: Driver 3.51 Not Found 2
gerald_clark wrote:
Unless, of course, you have quotes in your data.
With perl you can use the quote() function to ensure the whole line
gets in.
Or placeholders.
- Cs.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
That would be because you have not installed it. MyODBC does not install
by default, and you may not need it. If you are going to be accessing
your new database through ODBC, then go to
http://www.mysql.com/downloads/api-myodbc-3.51.html where you can
download the latest driver. If you will not be
Sheni R. Meledath wrote:
> Can any body provide me some details regarding migrating MySQL
> databases to MS SQL databases.
I recently got to do this. I built DTS packages on the MS-SQL database
to import my data from MySQL. I found it worked better to create the
tables manually and then import
Hi MySQL gurus
If I chnage a varchar in one table will it effect another related column in
another table?
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: "Jon Haugsand" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 23, 2003 2:57 AM
Subject: Re: XML in MySQL
> * [EMAIL PROTECTED]
> > geez mysql is an open source product you cannot expect so much too soon
over
> > a very expensive commercial prod
Hi List
Probably a stupid question, but I want to know if there is a quick way
to reset all the id's on my tables to 0?
I ran a whole bunch of "tests" on the app; writing and deleting to the
tables, and would like to "reset" all tables to start at 0 when I make
the app "live".
Thanks
--
MySQL
It will not. If such a change is desirable, you will have to make the
change in the related table as well.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Andrew [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 23, 2003 7:57 AM
> To: MySQL-Lista
> Subject: varchar restr
Nevermind, found it:
truncate table;
On Mon, 2003-06-23 at 15:59, Petre Agenbag wrote:
> Hi List
>
> Probably a stupid question, but I want to know if there is a quick way
> to reset all the id's on my tables to 0?
> I ran a whole bunch of "tests" on the app; writing and deleting to the
> tables
To pinpoint the solution here it is an one liner ;-)
perl -n -e 'chomp; print "INSERT INTO YourTable (question,answer) VALUES
(\"$tmp\",\"$_\");\n" if ($|--); $tmp=$_' test.txt > test.sql
It's a "hybrid" perl solution which requires feeding in MySQL afterwards and
it disregards special characters
Thanks to everybody for the nice discussion.
Just to let you know about my (not necessary final) decisions:
We will upgrade our SCSI -II controller to an Ultra SCSI 160 controller
(always a good idea).
Next we are looking into buying a RAID-5 system from RAIDking.
While we do this we hope for the
My costomers are using Excel, so I am looking into connecting Excel with MySql.
Does anyone know how to do this?
Do you have a small example?
Thank you very much for your help
Bernd
=
Please note that this e-m
You can use MS Query and MyODBC to allow your customers to access the MySQL
database.
-Original Message-
From: Bernd Jagla [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 9:12 AM
To: mysql
Subject: Excel(2002) and mysql4
My costomers are using Excel, so I am looking into con
I have a SQL query that needs to reference three different tables. I'm
creating an online buddy list of members who are online. I have all of this
functioning but am trying to also reference another table where the user is
being blocked, in which case I do not what the user's name to be shown in
Thanks Nils,
(B
(B I had been having an terrible experience starting up MySQL. I used to
(Bget this error Can't connect to local MySQL server through socket
(B'/tmp/mysql.sock' (2)
(B
(BI have tried the following:
(B
(B1. Manually start the server using sudo ./bin/mysqld_safe &
(B
(B
What you need is a LEFT JOIN. When you use a LEFT JOIN, you get all rows
from your main table, with either the data from the
penpals_privmsgs_block table if there is corresponding data, or NULL if
there is no related row. Take a look here:
http://www.mysql.com/doc/en/JOIN.html for more information.
Your grant tables are either corrupted or damaged. Error 145 indicates this.
(B
(B-Original Message-
(BFrom: Pushpinder Singh Garcha [mailto:[EMAIL PROTECTED]
(BSent: Monday, June 23, 2003 9:43 AM
(BTo: Nils Valentin
(BCc: [EMAIL PROTECTED]
(BSubject: Re: mysql ended error
(B
(B
(
Thanks Victor,
(B
(BWhat can I do now ?... I do not care about the data because this is
(Bjust on the testing server and the development server is unaffected.
(BHowever I need to have the MySQL Server up and running.
(B
(BThanks in advance
(B--Pushpinder
(B
(B
(B
(Bkindly suggest wha
If I have table A with a varchar and table B with a varchar, any
modification I make to A will have NO EFFECT WHATSOEVER on table B, and
vice-versa. If I want to change the varchar in table A and in table B, I
will have to make the change to each one separately and explicitly.
Does that make it mo
If this is on a development machine I would suggest completely removing what
(Byou have installed so far, downloading the latest version for your OS, you
(Bshould probably stick with the rpm and or binary, and reinstall MySQL.
(B
(B-Original Message-
(BFrom: Pushpinder Singh Garcha [ma
Hello all. I was wandering if it was possible to do a general
replacement of text on a query. What I want to do is for any fields that
equal 'false' to be replaced with 0 and any fields that equal 'true' be
replaced with 1.
Now I know you can do if statements, but I have a whole bunch of fields
an
Jeremy Zawodny wrote:
SOAP is one thing. But what about storing XML documents in the DB
(with validation on the way in) and querying them using XPath? Oracle
does that. MySQL does not.
And off-topic from the original question but to repeat myself from
before, using XML and MySQL together is
Your grant tables in their current state are unusable. You need to either
(Bimport or download a `fresh` copy of the mysql database directory
(B
(B-Original Message-
(BFrom: Pushpinder Singh Garcha [mailto:[EMAIL PROTECTED]
(BSent: Monday, June 23, 2003 9:59 AM
(BTo: Victor Pendleton
Take a look at the REPLACE() function:
http://www.mysql.com/doc/en/String_functions.html#IDX1202
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Nick Stuart [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 23, 2003 8:58 AM
> To: MySQL List
> Subject: Replacing text on q
Did you run myisamchk on user.MYI as I suggested last week?
(B
(BPushpinder Singh Garcha wrote:
(B
(B> Thanks Nils,
(B>
(B> I had been having an terrible experience starting up MySQL. I used to
(B> get this error Can't connect to local MySQL server through socket
(B> '/tmp/mysql.sock' (2)
I have updated mySQL to the 4.0.13-standard and had no problems UNTIL I
attempted to run mysql_fix_privileges. This is the error I get:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
/tmp is:
drwxrwxrwt6 root root 4096 Jun 23 1
ok ok I get it what you are saying if I change a tables attributes from varchar
on one table it wont chnage another tables varchars attributes AND WHY THE FUCK
WOULD I EXPECT IT TO!,
what I am asking is it necessary to make chnages to the other table.
>-Original Message-
>From: Mike Hilly
OK so now I have something like this:
SELECT distinct useronline.uname, penpals_fav.fav_user_id, penpals_fav.ID,
penpals_privmsgs_block.user_id, penpals_privmsgs_block.blocked_id
FROM useronline, penpals_privmsgs_block left join penpals_fav on
penpals_privmsgs_block.user_id
WHERE penpals_fav.f
Perhaps you better watch your language and better explain your question
because if I did not answer your question than I do not know what you
are asking.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Andrew [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 23, 2003 9:2
Well, the following line does not join the
penpals_privmsgs_block.user_id to anything:
penpals_privmsgs_block left join penpals_fav on
penpals_privmsgs_block.user_id
Anyhow, by LEFT JOINing the block table to the penpals_fav table you are
saying you want one row for every row in the block table,
Thanks for pointing that one out. Unfortunately relplace(table.*, ...)
does not work (syntax error) so I'll stil have to go through each field
individually. This will be two statements per-field which kinda stinks,
but oh well.
Thanks again!
-Nick
On Mon, 2003-06-23 at 11:10, Mike Hillyer wrote:
OK so now I have:
SELECT distinct useronline.uname, penpals_fav.fav_user_id, penpals_fav.ID,
penpals_privmsgs_block.user_id, penpals_privmsgs_block.blocked_id
FROM useronline, penpals_fav LEFT JOIN penpals_privmsgs_block ON
penpals_fav.user_id = penpals_privmsgs_block.user_id
WHERE penpals_fa
And what happens if you leave off the 'distinct' ?
vernon wrote:
OK so now I have:
SELECT distinct useronline.uname, penpals_fav.fav_user_id, penpals_fav.ID,
penpals_privmsgs_block.user_id, penpals_privmsgs_block.blocked_id
FROM useronline, penpals_fav LEFT JOIN penpals_privmsgs_block ON
pen
"Andrew" <[EMAIL PROTECTED]> wrote:
>
> If I chnage a varchar in one table will it effect another related column in
> another table?
Nope.
Take a look at FOREIGN KEY with ON UPDATE CASCADE:
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
--
For technical support contra
Pushpinder Singh Garcha <[EMAIL PROTECTED]> wrote:
>
> What can I do now ?... I do not care about the data because this is
> just on the testing server and the development server is unaffected.
> However I need to have the MySQL Server up and running.
>
Repair tables using myisamchk:
You guys are great! Thanks! :)
We compile from source, under Debian, and the transition from 3.23.xx
to 4.0.13 was perfectly seamless. I've never had an upgrade go more
smoothly.
There are so many messages about bumps on the road when people upgrade
from a vendor's packaged version to another p
The distinct is needed for usersonline as it holds multiple instanses of the
user's name, which I only want once.
To answer your question the user name comes up many times and the 1 still
exist in ever record of the returned results, which of course is not true.
-- Original Message ---
Andrew,
> ok ok I get it what you are saying if I change a tables attributes from
> varchar on one table it wont chnage another tables varchars attributes AND
> WHY THE F**K WOULD I EXPECT IT TO!,
>
> what I am asking is it necessary to make chnages to the other table.
The answer to your questio
Hello,
I'm looking for informations about the Embedded Server DLL. There's not
a lot of in the manuel (libmysqld section). Where can I Find the
available functions? Are they the same as in the C API?
I'm planning to use the dll from C#. Does anyone already try to
"interop" with the mysql server
Is there an mysql directory in /usr/local/mysql/data?
[psg:/usr/local/mysql] psgarcha% sudo ls data
127.0.0.1.errib_logfile1
psg.local..err
ShwetaParekh-Computer.local..err ibdata1
psg.local..err.save
ShwetaParekh-C
Hello All,
I am installing MySQL on my Mac OS Jaguar system. I was having some
trouble with the starting up my MySQL Server. I kpt getting "mysqld
ended" error and my logs showed that file "user.MYI" was corrupted. So
I decided to uninstall MySQl and re-install it.
I installed MySQL (mysql
The function are in chapter 8.4.5 of the manual.
I tried using the embedded library in C, then calling it from VB through a
DLL without any luck. The libmysql.dll seems to work better.
Eric
From: Wavyx <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Infos about the embedded server dll
Date: Mo
Hi,
Any ideas why I get an error when i use ORDER BY in an UPDATE statement?
Also is there anywhere i can lookup the error codes?
UPDATE `Subscriptions` SET picks=picks+1 WHERE (username = 'webmaster' AND
picksdatabasename = 'BetaTestService') ORDER BY subscriptionid ASC
ADODB.Connection.1 er
At 23:09 +0100 6/23/03, [EMAIL PROTECTED] wrote:
Hi,
Any ideas why I get an error when i use ORDER BY in an UPDATE statement?
Also is there anywhere i can lookup the error codes?
UPDATE `Subscriptions` SET picks=picks+1 WHERE (username = 'webmaster' AND
picksdatabasename = 'BetaTestService') ORDER
Have you tried it without it? I cannot seen a reason for using it...
With out it all records in subscriptions will be updated with pick+1
where username='webmaster' and dbname.
Wayne
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 23 June 2003 23:09
To: [E
Hi, I left out the LIMIT 1 in the example I copied... I only want the
first occurance updated.
"wayne" <[EMAIL PROTECTED]>
23/06/2003 23:22
To: <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
Subject:RE: UPDATE and ORDER BY
Have you tried it without i
this has prob been bought up many of times but how would it be possible to
setup different mysql source instances for each individual virtualhost on a
machine ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE
Then you do need it, but like Paul said, you need MySQL 4.x, or you need
to run two queries, one to retrieve the row you want to update, and one
to do the update.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monda
Thanks for all your replies. I'll have to use the 2 query approach.
Regards
Martin
"Mike Hillyer" <[EMAIL PROTECTED]>
23/06/2003 23:22
To: <[EMAIL PROTECTED]>, "wayne" <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
Subject:RE: UPDATE and ORDER BY
Then
It is definitely possible, see
http://www.mysql.com/doc/en/Multiple_servers.html
Of course, you could save yourself some trouble and just setup a
separate database on the same instance.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: electroteque [mailto:[EMAIL PROTEC
At 8:22 +1000 6/24/03, electroteque wrote:
this has prob been bought up many of times but how would it be possible to
setup different mysql source instances for each individual virtualhost on a
machine ?
What do you mean by "virtual host" here?
--
MySQL General Mailing List
For list archives: ht
On Mon, Jun 23, 2003 at 03:19:05AM -0400, M Lists wrote:
>
> I'm researching a specific network design and have some questions that may
> involve 2-way replication.
Ok...
> I have one master mysql server doing 1 way replication to a large
> number of remotely located slaves. Each slave serves a
I'm new to mysql but not databases or programming. I followed Julie
Meloni's PHP fast &easy to learn the basics. However, now that I am going
back through the material and trying to make changes, problems are rising
that I can't solve.
I am changing a database and changing the user and passwor
On Sat, Jun 28, 2003 at 10:53:48PM -0400, chad pratt wrote:
>
> What are the gotchas with respect to scaling?
Come to OSCON and find out!
http://conferences.oreillynet.com/cs/os2003/view/e_sess/4502
Sorry. They ask that speakers promote their talks on a relevant
mailling list if they get a c
I'm new to mysql but not databases or programming. I followed Julie
Meloni's PHP fast &easy to learn the basics. However, now that I am going
back through the material and trying to make changes, problems are rising
that I can't solve.
I am changing a database and changing the user and passwor
Passing mysql commands through mysqldump or BACKUP TABLE ?
We would like to perform backups on selective data within selective tables
and then purge the matching data in those tables. Is it possible to pass
mysql commands through either util above ? Which is better ?
Example: sql statement...
se
oh dear apologies , i meant virtualhosts in an apache server environment,
as in different sites on the same machine
> At 8:22 +1000 6/24/03, electroteque wrote:
>>this has prob been bought up many of times but how would it be possible
>>to setup different mysql source instances for each individual
> I am changing a database and changing the user and password of an
> existing
> database. when I enter the line.
>
> mysql> insert into user (host, user, password) values ('localhost',
> 'newuser', password ('newpswrd'));
>
> the error 1062: Duplicate entry 'localhost-newuser' for key 1
> mysql>
I am writing a shell script using Born Shell. I am trying to get the result of a SQL
statement into a variable.
For example:
/usr/bin/mysql -uroot -prootpass BOB << EOF
SELECT * FROM Bobstable WHERE Name=1
EOF
How do I get the result into a variable?
Thanks in advance!
Hi Everyone,
I am using LOAD DATA INFILE to import some data to MySQL. I would like to
leave some fields blank and use the default value set in the tables. I have
spent many hours trying to find the problem, but no luck so far. According
to the manual, it should work. I am hoping some one on th
On Mon, Jun 23, 2003 at 04:16:51PM -0700, Hubbard, Dan wrote:
> Passing mysql commands through mysqldump or BACKUP TABLE ?
>
> We would like to perform backups on selective data within selective tables
> and then purge the matching data in those tables. Is it possible to pass
> mysql commands thro
Hi, I have a question about the memory that mysql uses,
Here is the info that top command displays:
7:39pm up 55 days, 2:51, 1 user, load average: 0.18, 0.08, 0.02
54 processes: 53 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 0.1% user, 10.1% system, 0.0% nice, 89.3% idle
CPU1 states
On Mon, Jun 23, 2003 at 07:21:25PM -0500, Miguel Perez wrote:
>
> Hi, I have a question about the memory that mysql uses,
> Here is the info that top command displays:
>
> 7:39pm up 55 days, 2:51, 1 user, load average: 0.18, 0.08, 0.02
> 54 processes: 53 sleeping, 1 running, 0 zombie, 0 stopp
thanks for the invite. I am too poor to attend.
-C
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "chad pratt" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, June 23, 2003 6:58 PM
Subject: Re: scaling
> On Sat, Jun 28, 2003 at 10:53:48PM -0400, chad pra
On Mon, Jun 30, 2003 at 11:44:30PM -0400, chad pratt wrote:
> thanks for the invite. I am too poor to attend.
The slides will all be on-line within a day of the talk, if that's of
any help.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy
awesome yes I will be an eager consumer.
-C
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "chad pratt" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, June 23, 2003 9:01 PM
Subject: Re: scaling
> On Mon, Jun 30, 2003 at 11:44:30PM -0400, chad pratt
Hello..
I am attempting to insert into my table a huge block of text (talking
almost a megabyte). It seems like maybe a quarter of the way through it
just cuts off with no errors to my import script.
I've changed my max_allowed_packet to 20M as well as my
net_buffer_length to 8M in my my.cnf
I am fairly new to MySql, I have a product that is offered from the company
I work for that uses db2, oracle, and SQL Server. Recently I had a customer
ask if we could run on MySQL. I decided to test it out with my mac powerbook
using tomcat and MySQL. The app is loading and some tables are getting
Hi Singh,
I followed the threat carefully, and the more I read the more I believe we are
looking in the wrong place.
I believe that this is an OS Issue. Uninstall mysql once more. Take whichever
install method you are most comfortable with (but stick to it :-). check the
datadir and used linux
Hi Folks, needs a little advice.
I have a table that contains a unique auto-incrementing primary key
called 'id' (eg 1,2,3,4...). When inserting data, I let mySQL allocate
the value that goes into this field.
Now I want to insert a new row into this table and get the 'id' value
that mySQL has
Hi Sigh,
I just double and tripple read the threat once more.
>>Installing all prepared tables
>>./bin/mysqld: Can't change dir to '/usr/local/mysql/./data/' (Errcode:
>>13)
This tells me that your user account you are currently logged in with
(username) does not have rights to write to /usr/
No, no yu are welcome ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 24日 火曜日 02:29、あなたは書きました:
> Ahh thank you for the clarification. It is most appreciated!
>
>
> Cheers,
>
> Chris
>
> -Original Message-
> From: Nils Valentin [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 20, 200
On 23-Jun-2003 Hubbard, Dan wrote:
> Passing mysql commands through mysqldump or BACKUP TABLE ?
>
> We would like to perform backups on selective data within selective
> tables
> and then purge the matching data in those tables. Is it possible to pass
> mysql commands through either util above ?
Andrew E Filipowski wrote:
I am fairly new to MySql, I have a product that is offered from the company
I work for that uses db2, oracle, and SQL Server. Recently I had a customer
ask if we could run on MySQL. I decided to test it out with my mac powerbook
using tomcat and MySQL. The app is loading
I use version 4.0.12-max-debug.
mysql> returns the following error code when I use the load data command.
mysql> load data local infile "foo.txt" into table pet;
ERROR 1148: The used command is not allowed with this MySQL version
Do I need to upgrade to a new version?
On Mon, Jun 23, 2003 at 04:49:00PM -0700, Jeremy Zawodny wrote:
> On Mon, Jun 23, 2003 at 04:16:51PM -0700, Hubbard, Dan wrote:
> > Passing mysql commands through mysqldump or BACKUP TABLE ?
> >
> > We would like to perform backups on selective data within selective tables
> > and then purge the m
I ran into this too. I assume it is a limitation on the free version of MySQL, and
that
you have to pay to use "load data" in an SQL script. To import my data files, I use
the "mysqlimport" function from the command line or batch file. It seems to support
most of the "load data" options.
-
By default, "LOAD DATA INFILE ..." is disabled (I am not sure from which
version). You may need to compile MySQL with -enable-local-infile". You
may find details on www.mysql.com .
Ruth
- Original Message -
From: "mysql" <[EMAIL PROTECTED]>
To: "mySQL List" <[EMAIL PROTECTED]>
Sent: Tue
1 - 100 of 106 matches
Mail list logo
