I have searched the archives for a solution to my problem and also the FAQ
and the mysql documentation but can't seem to resolve it.
I am exporting a tab delimited file from FileMaker Pro 5.5 using Mac OS
10.3.
I am uploading the file to my hosted server running RedHat
Linux 7.2. I am then import
dear mysql team,
i was trying to save a file in mysql
now can u please help me with an alternative that i save the file name in the database
and how to retrieve back
prathima rao
- Original Message -
From: Prathima Rao
To: [EMAIL PROTECTED]
Sent: 06/12/2003 9:23 AM
Sub
hello,
I am using mysql++ API and it is giving an error -
"The procedure entry point mysql_connect could not be located in the dynamic link
library LIBMYSQL.dll"
any solutions,
Best Regards
- Pawan
Have A Nice Day
dear mysq team,
i have myodbc 3.51.01 version now how do i upgrade to latest version 3.51.06
please help
regards
prathima rao
I have a problem using mysqlhotcopy. Everything was fine until I recently
moved to a different server. Old one was running mysql 4.0.15 on FreeBSD
4.8, new is mysql 4.0.16 on FreeBSD 4.9.
The error returned is "No tables to hot-copy at
/usr/local/bin/mysqlhotcopy line 379."
I ran w/ --debug and h
Mysqlians,
I am getting the following errors in an application log for
4.0.16 mysql and 3.51 myODBC
SQL Error: SQLSTATE=S0002 Native error=1146 '[unixODBC][MySQL][ODBC 3.51
Driver][mysqld-4.0.16-Max-log]Table 'TRIBE.NETWORK_VECTOR' doesn't exist'
SQL Error: SQLSTATE=S1000 Na
Hi!
On Dec 05, tk wrote:
> Hello Sergei, Gunnar, and others,
>
> thank you for your quick responses.
> One little mystery remains:
>
> Why does one need to read all the row data (with
> SQL_CALC_FOUND_ROWS) to get the total number of
> results when using a limit?
>
> When the index is used to
I've read a lot of tips (even if I'm not up and running yet) about
telling people to setup the correct way to their mysql directory.
So, what I wanna know (when I get there) is if there is any
command that I can write to make the computer tell where
this files actually are?
I've read a lot of tips (even if I'm not up and running yet) about
telling people to setup the correct way to their mysql directory.
So, what I wanna know (when I get there) is if there is any
command that I can write to make the computer tell where
this files actually are?
I have been reading and following the instructions from:
http://www.mysql.com/doc/en/Resetting_permissions.html
But, if I do:
./bin/mysqld_safe --skip-grant-tables
And then I:
mysqladmin -u root password 'mypassword'
I get:
mysqladmin: unable to change password; error: 'You must have privileges t
Swedish should not be a problem ... the chief software architect behind
MySQL is a Swedish-speaking Finn.
If you want the password to be bubba, then the syntax is:
/usr/local/mysql/bin/mysqladmin -u root password bubba
If the computer (host) name is snickers, it would be written as:
/usr/local/
I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
variables with mysqladmin, "has_openssl" is set to "NO". What could
have happened to cause this? I've got OpenSSL 0.9.7c installed. I'm
seeing this on both Solaris and Debian hosts. I'm not seeing any errors
during th
I found a script on this help page, that should be used when
giving the root user a password, but I really don't understand
what of this is words and what is just an example.
/usr/local/mysql/bin/mysqladmin -u root password
/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password
Where in t
A newbie here, with a simple question (I guess).
I just installed MySQL on my OS X 10.2
But failed pretty quick. Please help me... I wanna get started.
This it what it looks like after following the description in the ReadMe
file.
Last login: Fri Dec 5 22:41:28 on ttyp1
Welcome to Darwin!
[COVE
Didn't have the list cc-ed.
-Forwarded Message-
> From: Andrew Hall <[EMAIL PROTECTED]>
> To: Mike Johnson <[EMAIL PROTECTED]>
> Subject: RE: replication question
> Date: Fri, 05 Dec 2003 16:17:14 -0500
>
> Ok, at this point it appears my replication is working, but I have two
> quest
Hi,
I have a password to a database with all the databse privileges, except
reload, shutdown, process, file and with Grant options.
This is the administrator or super user password, with most of the
privileges. Someone else has created the data base. Now I'll maintain it. I
need to add a new user
I came across the following errors after install
I am not able to start server from terminal
(only progress i made was running as root NOT user)
1.
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
2.
WARNING: The host 'localhost' could
DUH!! I should have tried that...
Thank you!
Drew
On Fri, 2003-12-05 at 15:49, Victor Pendleton wrote:
> Try slave start
>
> -Original Message-
> From: Andrew Hall [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 05, 2003 2:46 PM
> To: [EMAIL PROTECTED]
> Subject: replication questio
Try slave start
-Original Message-
From: Andrew Hall [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 2:46 PM
To: [EMAIL PROTECTED]
Subject: replication question
Greetings,
Firstly I have searched the archives and received exactly 0 results
returned for 'START SLAVE 1064' so...
Greetings,
Firstly I have searched the archives and received exactly 0 results
returned for 'START SLAVE 1064' so...
I have a mysql server I wish to replicate, its running 3.23.54. I have
two test FreeBSD 5.1 servers I installed and from ports version
3.23.58. I completed the following steps to
Do you only have the Microsoft DBF and ldf files?
-Original Message-
From: Mark Graves [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 1:24 PM
To: [EMAIL PROTECTED]
Subject: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?
I run a website using MySQL, PHP, and CFMX. S
Ask the person who gave you the file to do the work. Give them a list of formats you
can read (i.e. SQL, csv, etc.) and let them decide which of those formats they want to
export into.
John
-Original Message-
From: Mark Graves [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 2:
..I don't have MSSQL
>>> Zenzo <[EMAIL PROTECTED]> 12/5/2003 2:30:44 PM >>>
there is a command but i didnt found it in the
documentation. Try dump MS SQL database into a text
file and then try mysqlimport.
--- Mark Graves <[EMAIL PROTECTED]> wrote:
> I run a website using MySQL, PHP, and CFMX. So
there is a command but i didnt found it in the
documentation. Try dump MS SQL database into a text
file and then try mysqlimport.
--- Mark Graves <[EMAIL PROTECTED]> wrote:
> I run a website using MySQL, PHP, and CFMX. Someone
> recently gave a
> data file to me that they'd like to access. The
>
I run a website using MySQL, PHP, and CFMX. Someone recently gave a
data file to me that they'd like to access. The problem is that it
appears to be from MS SQL. How can I convert/import this into MySQL?
I did some searching and found MSSQL-to-MySQL, but this program
requires that I have MSSQL
Alex Brown wrote:
Hi.
Thanks for the prompt reply.
It seems strange that the installation procedure should include an
instruction that requires a password with no indication that one is
required (i.e. there is no -p in the command sequence). Reading through
Mark Liyanage's installation instruc
Stefan:
Thank you very much, I got the point. I'll make some tests with the
'log-slave-updates' parameter, I think if the master can log the updates
made from any slave, then it can propagate the changes to the others.
Regards
From: Stefan Kuhn <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECT
At 19:04 4/12/2003 -0600, Matt W wrote:
Hi,
Named Pipe crashes on MySQL (4.1.1 alpha) WinXPI have been unable to get
named pipes to work on mysqld-nt 4.1.1
Alpha(including today's official release). As soon as I attempt a
connect the server crashes. I can't create a debug trace because named
pipes
At 10:44 -0600 12/5/03, Jay Blanchard wrote:
[snip]
Please upgrade you MySQL Windows client to 4.0.16 there is a bug
with net_read_timeout and net_write_timeout on 4.0.15 that
disconnect when the query takes more than 30 secons.
[/snip]
Can you elaborate on this, we have not seen this problem
See t
Outstanding opportunity for someone in the San Diego area.
Database Internals Engineer
Successful candidate will be responsible for the architecture, design and
implementation of a database engine and its interface with a variety of commercial
databases. Responsibilities include authoring o
"Kiky" <[EMAIL PROTECTED]> wrote:
> I have a problem with
> "Error 2013 - Lost connection to MySQL server during query"
>
> I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro.
> They turn out to have the same error.
>
> My problem is:
> I have a Java program which is
[snip]
Please upgrade you MySQL Windows client to 4.0.16 there is a bug
with net_read_timeout and net_write_timeout on 4.0.15 that
disconnect when the query takes more than 30 secons.
[/snip]
Can you elaborate on this, we have not seen this problem
--
MySQL General Mailing List
For list archives:
That worked perfectly!!! Thanks so much :-)
-Original Message-
From: Diana Soares [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 10:31 AM
To: Robert Hughes
Cc: [EMAIL PROTECTED]
Subject: Re: Need help with query. Please!
Try:
SELECT C.company_id, C.company_name
FROM compani
Hello Matthew,
Friday, December 5, 2003, 2:12:08 AM, you wrote:
thanks, but some more see below.
[skipped]
>> I have some table:
>> /* BEGIN DUMP */
>> CREATE TABLE `sp_tovar_vid` (
>> `id` int(11) NOT NULL auto_increment,
>> `id_tovar_vid` int
Try:
SELECT C.company_id, C.company_name
FROM companies C
LEFT JOIN company_group_intersect CG
ON (C.company_id=CG.company_id AND CG.group_id='1')
WHERE C.status='1' AND CG.company_id IS NULL
--
Diana Soares
On Fri, 2003-12-05 at 15:08, Robert Hughes wrote:
> I have the following 3 tables:
Hallo Lenz,
> From: Lenz Grimmer [mailto:[EMAIL PROTECTED]
> > Any chance to offer binaries for PowerPC Linux as well ? (Preferable
> > tgz)
>
> Yes, we plan to offer Linux/PPC binaries in the near future - we're
> currently working on purchasing a system for that.
If you have some harddisk sp
At 14:14 5/12/2003 +0800, Kiky wrote:
Hi Guys,
I have a problem with
"Error 2013 - Lost connection to MySQL server during query"
I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win
XP Pro.
They turn out to have the same error.
Please upgrade you MySQL Windows client to 4.0.16
Jacob Friis Larsen <[EMAIL PROTECTED]> wrote:
> I have upgraded from MySQL (rpm) 4.1.0 to 4.1.1 and now I see lots of
> lines in the error log with:
>
> Unknown character set: 'latin1_swedish_ci'
>
> How can I fix this?
Does 'latin1_swedish_ci' present in the output of SHOW COLLATION LIKE 'lati
Hello Sergei, Gunnar, and others,
thank you for your quick responses.
One little mystery remains:
Why does one need to read all the row data (with
SQL_CALC_FOUND_ROWS) to get the total number of
results when using a limit?
When the index is used to find relevant rows and sort
the results, the c
I am trying to untar the .gz but this is what I get.
#tar xzvf mysql-standard-4.0.16-pc-linux-i686.tar.gz
mysql-standard-4.0.16-pc-linux-i686/
mysql-standard-4.0.16-pc-linux-i686/bin/
mysql-standard-4.0.16-pc-linux-i686/bin/comp_err
mysql-standard-4.0.16-pc-linux-i686/bin/replace
mysql-standard-
How do I create relationships between tables?
I have tried but have no way of being sure that I am successful just by
looking at the db. I am not sure how to relate one record in one table
to it corresponding record in another.
Mat
--
MySQL General Mailing List
For list archives: http://lists.
I have the following 3 tables:
table 1: companies
fields 1: company_id, company name, status
Sample data:
1 , company 1 , 0
2 , company 2 , 1
3 , company 3 , 1
4 , company 4 , 0
5 , company 5 , 1
table 2: groups
fields 2: group_id, group_name
Sample data:
1 , Group 1
2 , Group 2
3 , Group 3
4 ,
Hi TK,
There was an optimizer bug in MySQL 4.0
This bug is fixed in 4.0.17 (not yet released)
# Fixed bug when the optimiser did not
# take SQL_CALC_FOUND_ROWS into account
# if LIMIT clause was present. (Bug #1274)
Kind regards
Gunnar
> -Original Message-
> From: [EMAIL PROTECTED]
Hi!
On Dec 04, tk wrote:
> Hello,
>
> Thanks for the response.
> There is one thing that is not clear however.
>
> Regardless of whether or not I perform the fulltext
> search with or without the SQL_CALC_FOUND_ROWS
> keyword, the results that I get are exactly the same.
>
> Also, the notion
We have a database that supports our customers and runs pretty much
24/7/365. Obviously we need to keep this database healthy and
optimized. I've read the official documentation and third party books
on MySQL and they all are very good at explaining what should be done
and how to do it but none t
Furthermore, Microsoft will *not* email you about real critical
updates either. The only way to get an email from Microsoft is to
request support or to sign up for a mailing list. That's something they
bring up at just about every Microsoft seminar these days.
Thanks,
Rob Brahier
Web A
Hi,
You can do it in several smaller and faster deletes using the LIMIT option -
for example
DELETE QUICK from table WHERE indexed_row < UNIX_TIMESTAMP()-86400 limit
1;
HTH
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: "Chris Elsworth" <[EMAIL PROTECTED]>
To: <[EMAI
Look at http://www.mysql.com/downloads/mysql-4.0.html for Dynamic client libraries for
your platform.
Enjoy
Nitin
- Original Message -
From: "Franz Edler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 05, 2003 6:25 PM
Subject: Where to find MySQL-shared-compat-VERS
how about recreating the table w/o the autoincrement, then reload the data, then alter
table to reimplement the autoincrement?
> -Original Message-
> From: Matthew [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 04, 2003 7:12 PM
> To: Alex E.Wintermann; [EMAIL PROTECTED]
> Subject: R
Hello,
Please forgive me my newbee-question:
Where can I find MySQL-shared-compat-VERSION.i386.rpm ?
I have just installed MySQL 4.0 and an application requests
libmysqlclient.so.10
Franz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
Teemu Kuulasmaa <[EMAIL PROTECTED]> wrote:
>
> I was wondering is it possible to use "SHOW COLUMNS FROM tbl_name" as a
> subquery.
>
> I tried something like this ( w/o success ):
>
> SELECT * FROM tbl1 INNER JOIN (SHOW COLUMNS FROM tbl2) AS t2 WHERE t1.ID
> =t2.field;
>
> or
>
> SELECT fiel
[snip]
How can i import table structure and data which is there in a text file
to database say test_database using phpmyadmin. I m asking using
phpMyadmin as i don have shell access and hence can't use mysql
commands.
[/snip]
What format is the table structure in?
As for the data it should be fai
For those who are interested like me:
MySQL 4.1.1 is released.
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax: +250-50 15 19
Mobile: +250-08517768
Email: [EMAIL PROTECTED]
http://www.nef
Hello,
On Fri, Dec 05, 2003 at 12:02:05PM +0100, Martin Gillstr?m wrote:
>
> The table can look something like this:
> row_id INT PRIMARY KEY
> where_column SET('a','b','c')
> groupby_column VARCHAR(255)
> orderby_column DATE
> .. more rows that I need to fetch with the select.
> This is what I
Hi,
I have a table with about 500 000 rows and need to execute a query with
first a WHERE then a GROUP BY and then ORDER BY all on different columns
is their any way to optimize this?
The table can look something like this:
row_id INT PRIMARY KEY
where_column SET('a','b','c')
groupby_column VAR
Hi all,
I was wondering is it possible to use "SHOW COLUMNS FROM tbl_name" as a
subquery.
I tried something like this ( w/o success ):
SELECT * FROM tbl1 INNER JOIN (SHOW COLUMNS FROM tbl2) AS t2 WHERE t1.ID
=t2.field;
or
SELECT field FROM (show columns from Research.idefix);
Teemu
--
My
Hello,
I have quite a large table, 45 million rows, which has 3 indexes on
it. The rows are evenly distributed across one particular index, which
records the time the row was inserted. At any given time there's
between 20 and 21 days worth of rows, and every night I delete
anything over 20 days. S
hi
i'm trying to get musql to insert the default values
into a table. from the insert section in the manual:
Warnings can occur under any of the following
conditions:
* Inserting NULL into a column that has been
declared NOT NULL. The column is set to the default
value appropriate for the colu
I have upgraded from MySQL (rpm) 4.1.0 to 4.1.1 and now I see lots of
lines in the error log with:
Unknown character set: 'latin1_swedish_ci'
How can I fix this?
Regards Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.co
Hi.
Thanks for the prompt reply.
It seems strange that the installation procedure should include an
instruction that requires a password with no indication that one is
required (i.e. there is no -p in the command sequence). Reading through
Mark Liyanage's installation instructions, I notice th
Hi all,
How can i import table structure and data which is there in a text file to database
say test_database using phpmyadmin. I m asking using phpMyadmin as i don have shell
access and hence can't use mysql commands.
Plz help me ... its very urgent ..
Thanks in advance
Binay
Binay wrote:
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
use mysql;
select User from user;
Ivan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ivan Cukic wrote:
1. Free use for those who are 100% GPL
2. Free use for those who never copy, modify or distribute
3. Commercial use for everyone else
Strange thing: How can SUSE redistribute mySQL when it is not 100% GPL?
(It has MPL, ... also, beside commercial programs)
Ivan
--
MySQL Gener
[EMAIL PROTECTED] wrote:
Thanks for the heads up on this. Unfortunately the only
varchar is the gbl_locus field, so I'm not sure how much this
would by me for the space.
Thanks again,
Brad Eacker ([EMAIL PROTECTED])
No, it wouldn't save you any space. I
Hi Binay,
Use the mysql client to open the "mysql" database. For example, enter the
following at the "mysql>" prompt:
use mysql
Then type:
select * from user;
Bob
-Original Message-
From: Binay [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 12:26 AM
To: mysql users
Subje
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
67 matches
Mail list logo
