On Mon, 13 Oct 2003 21:01:37 -0700
Matt Young [EMAIL PROTECTED] wrote:
The manual says:
For example, if the library is installed in `/usr/local/mysql/lib', use
-L/usr/local/mysql/lib -lmysqlclient -lz on the link command.
But I found no z library?
you need libz.
run these commands to
Hi Andy
What you can do is make a copy of your genre_titles table through
aliasing, this will allow you to only return the results that have both
genres and should reduce the need for programmatical sorting - aliasing also
makes for less typing :).
SELECT a.name, b.titleid
FROM titles a,
How can I find the way to import a text file with fixed width fields:
for example:
Import file content:
375120031010143902KABBOURIMOHAMMED
Imported in:
Field 1: 3 char : 375
Field 2: 5 char : 1
Field 3: 8 char : 20031010
Field 4: 6 char : 143902
Field 5: 20
Hi,
Will it be possible in mysql-5.0 to create packages and global session variables?
or will this be possible in the near future?
I can't find any documentation on this subject, does someone have some documentation
on MySQL 5.0 or knows where to find more?
greetings, Bob
Hi,
Are there any tools to migrate db schema as well as data from sybase
to mysql?
Thanks,
Prasad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Kabbouri
Please see below, an excerpt from the MySQL manual, that answers your
question.
If the FIELDS TERMINATED BY and FIELDS ENCLOSED BY values are both empty
(''), a
fixed-row (non-delimited) format is used. With fixed-row format, no
delimiters are used
between fields (but you can still
Des articles de Mike Hillyer peuvent t'aider.
Son site est http://www.vbmysql.com
Vous aurez besoin d'un Connecteur ODBC pour utiliser Visual Basic. MyODBC est tres
simple a utiliser. Il peut se telecharger depuis le site de MySQL
(http://www.mysql.com)
Mais le site est en Anglais.
I can ask
if you can export the same from sybase, then undoubtedly you can import
those iinto mysql
Nitin
- Original Message -
From: Prasad Budim Ram [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 1:57 PM
Subject: Migration tools for sybase to MySQL
Hi,
Are there any
I think the question is not very clear.
Do you want to delete from all the tables or you just want to delete from
one of the tables?
Does your MySQL version support sub-queries? (Is it Ver 4.1.x ?)
I saw some replies to your question, did they solve your problem?
I am asking this because a DELETE
Hi,
Sql Porter Might Be Of Some Help, But Alas Its Not Free...
P
Prasad Budim Ram wrote:
Hi,
Are there any tools to migrate db schema as well as data from sybase
to mysql?
Thanks,
Prasad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
yes, sorry.
my intention is to delete repeated rows from TABLE1.
and since its a bit difficult with mysql the way that i take is create a
new table TABLE2 with the repeated rows (but not repeated in TABLE2), and
then i want to delete from TABLE1 all the rows which also are in TABLE2.
later on, i
When restoring tables from a backup, get:
Op: repair // - this should always be restore according to manual
Msg_type: info
Msg_text: Delete link points outside datafile at 0
The datafiles seem to restore ok.
Have rtfm'd, googled and mysql forumed, but to no avail.
Is this something to worry
In the docs, search for CREATE TABLE syntax.
There is something like
CREATE TABLE tbl_name SELECT some_fields FROM some_table WHERE
where_condition
I don't remember exactly but you should find useful information in the docs
of the MySQL website.
Thanks
Emery
- Original Message
On Tue, 14 Oct 2003 11:55:18 +0200 (CEST)
[EMAIL PROTECTED] wrote:
i have mysql version 3.22
perhaps you mean 3.23 ?
but no matter, it's time to upgrade definitely.
---
WBR,
Antony Dovgal aka tony2001
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives:
Hello
I'm work in the Gdynia Maritime Academy, Poland. I use Mysql database
since 5 years. Now We are using Mysql database in the our education course
Databases technology.
This course needed SQL subselect implementation.
We compiled and installed Mysql 4.1 alpha version with openssl support on
create table tablename as select
Enjoy
Nitin
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 2:49 PM
Subject: creating a new table from a SELECT
how can i create a new table from a SELECT...WHERE... ?
thanks
--
MySQL
Does anyone know any way to be able to group by day/week/month for an
adjusted date (GMT - EDT).
I store dates as GMT in the db, but sometimes I want to count the
number of rows per EDT day instead of GMT day. I can't figure out how
to do this.
Ideas?
Thanks,
Graeme
- Original Message
Hi,
If I understand you correctly the this query should help you:
select
date_format(date_add(DateTime, interval 7 hour), %Y%m%d) as Date,
count(1)
from Table1
group by Date
order by Date
Best regards,
Mikhail.
- Original Message -
From: Graeme B. Davis [EMAIL PROTECTED]
To:
Hello,
I'm after some advice on database design:
I've got an object - for an example a hotel - and I want to keep information
about this hotel, criteria that it either has or hasn't (TV, swimming pool
etc).
I want to search on criteria and return the most appropriate match.
Bearing in mind
Hi,
I would create one field (char(200) or char(255)) for all criteria.
After that I will store:
in the first byte of that string Y if hotel has swimming pool, N - doesn't
have, Q - no idea
in the second byte of that string Y if hotel has TV, N - doesn't have, Q -
no idea
in the third byte of
I use both kinds of tables in my softawares, MyISAM and InnoDB, but since
I started trying using InnoDb, some problems with that kind of thable has
been occured.
Sometimes when I try to connect to an InnoDB, the server answers that the
table does not exist, but it's there, I can see it in my
Hi people,
I have mysql 4.0.7-gamma/linuxthreads running under FreeBSD 4.6.2 (server
has 4G phisical memory), and occasionally mysql traps with the message:
InnoDB: Fatal error: cannot allocate 1064960 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 513951016 bytes.
I'm not sure I'm posting this to the correct list. If I'm not, please
reply and let me know which list to post this to. Thanks.
We have a php-mysql web-based e-mail system that has a problem that has
happened twice in a 2 month period. This morning, somebody logged into
it and all of his
Hellow,
I'm trying to do a replication using MASTER Linux (mysql 4.1) and SLAVE Windows XP
(mysql 4.1).
I attached the show slave status, but i think that's OK.
The problem is: when I run load data from master returns:
Error running query on master: Access denied. You need the SUPER privilege
We're currently running mysql ver 3.23 with plans to upgrade to 4.x soon
but we're not ready yet.
I have two tables that are identical, table1 and table1_old. Table1_old
contains all data writen to table1 prior to july of 2003.
I need to do a single query that pulls the same fields from both
Hellow,
I'm trying to do a replication using MASTER Linux
(mysql 4.1) and SLAVE Windows XP (mysql 4.1).
I attachedthe "show slave status", but i think that's
OK.
The problem is: when I run "load data from master"
returns:
"Error running query on master:
Access denied. You need the SUPER
Lee.
Maybe others would disagree but they way I would handle this would be to
forget about storing the data in separate fields (or binary fields) and use
three tables.
Table1 - Facilities
A complete list of all criteria you want to record about the hotels
Table2 - Hotels
Table containing the
Lee,
I get the feeling there is a more efficient method using
binary operations
(only one field populated with zeros and ones) but I can't
find anything to
help in the manuals.
i think you should try to avoid such thing as much as you can.
Storing more than one piece of data in a column
Hi Jeff
Have you looked at UNIONS? An example would be something as follows:
SELECT field_1, field_2, field_3
FROM table 1
WHERE blah blah blah
UNION
SELECT field_1, field_2, field_3
FROM table 1_old
WHERE blah blah blah
ORDER BY field_1
This should do the trick...
Rory McKinley
Nebula
I am using 1 master (4.0.13 named PISSARRO ) and 3 slaves (4.0.15); of
course the my.ini are different in the master and slaves.
Today for an error (I thinked to be on my slave) I executed in sequence
these commands:
change master to
Two points about the messages below:
- With respect to the suggestion to use UNION: Original poster is using
3.23, so UNION cannot be used (it's implemented in MySQL 4.0)
- Original poster suggests that MERGE tables are not implemented until
4.0, but this is incorrect. MERGE tables are
Manual for MyISAM table types says: 'Maximum number of keys/table is 32 as
default. This can be enlarged to 64 without having to recompile myisamchk.'
Is possible to enlarge this number for windows binary distribution? How?
Thanks
Jaroslav
--
MySQL General Mailing List
For list archives:
Manual for MyISAM table types says: 'Maximum number of keys/table is 32 as
default. This can be enlarged to 64 without having to recompile myisamchk.'
Is possible to enlarge this number for windows binary distribution? How?
It's not possible for any binary distribution, because changing the
limit
Paul,
- Original poster suggests that MERGE tables are not implemented until
4.0, but this is incorrect. MERGE tables are available as
of MySQL 3.23.25.
Very true, I must have misread. Now my question is, when I create a
merge table, do I have to include every field from the two tables
At 11:14 -0400 10/14/03, Jeff McKeon wrote:
Paul,
- Original poster suggests that MERGE tables are not implemented until
4.0, but this is incorrect. MERGE tables are available as
of MySQL 3.23.25.
Very true, I must have misread. Now my question is, when I create a
merge table, do I have
The /var/lib/mysql directory is collecting server name-bin.### files.
What are these? Should I be saving them?
union isnt available with 3.23 either
Nitin
- Original Message -
From: Rory McKinley [EMAIL PROTECTED]
To: Jeff McKeon [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 8:01 PM
Subject: Re: Data from two tables in one query
Hi Jeff
Have you looked at UNIONS? An
Hi !
Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just
crached, I had to recover on another hardware, a Mac OS X 10.2, wih
mysql-max 4.0.15.
The restore went well, but I have some problems :
1. All tables/database are now lower case.
This not a major issue, as the dbs are
Are you running Replication?
- Original Message -
From: jon yeargers [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 10:12 AM
Subject: .bin.### files in /var/lib/mysql
The /var/lib/mysql directory is collecting server name-bin.### files.
What are these? Should I
jon yeargers [EMAIL PROTECTED] wrote:
The /var/lib/mysql directory is collecting server name-bin.### files.
What are these? Should I be saving them?
They are binary log files:
http://www.mysql.com/doc/en/Binary_log.html
If you don't need binary logging you can start mysqld without
At 11:30 -0400 10/14/03, Nicolas Ross wrote:
Hi !
Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just
crached, I had to recover on another hardware, a Mac OS X 10.2, wih
mysql-max 4.0.15.
The restore went well, but I have some problems :
1. All tables/database are now lower
Ok, created the merge table, now I get this error when I log into the
mysql server
[snip]
Didn't find any fields in table 'SuperMailbox'
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3903 to server version: 3.23.56
Type 'help;' or '\h' for help. Type
I have two tables, a PROJECTS table and a COMMENTS table linked by
seq in a one to many relationship. In other words, there might be
several comment rows for the same project, with different dates.
PROJECTS
seq name startdate enddate
1 p1 02032002 12202003
2 p2 04012003
At 11:50 -0400 10/14/03, Jeff McKeon wrote:
Ok, created the merge table, now I get this error when I log into the
mysql server
[snip]
Didn't find any fields in table 'SuperMailbox'
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3903 to server version:
2. Grants aren't working.
Almost for each db we have the grant I did is something like :
grant all on db.* to 'user'@'%.domain.com' identified by 'password';
So, I end up with a user with no global privilege in the user table, and
a
entry in the db table with all privs.
User table :
But MySQL even doesn't ask me for a password but returns immediately this
error.
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Stephan Wölfel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 10:14 PM
Subject: Re: Error 1045
You are not entering the
Hi -
You didn't mention which version of Sybase you are migrating from. I
just migrated our db from Sybase SQLAnywhere to MySQL v4.1 and there
were a couple things I found that didn't I had to change:
1) SQLAnywhere allows some words as column names that MySQL doesn't: I
had some a couple tables
* Dusty Kleyboecker
I have two tables, a PROJECTS table and a COMMENTS table linked by
seq in a one to many relationship. In other words, there might be
several comment rows for the same project, with different dates.
PROJECTS
seq name startdate enddate
1 p1 02032002
% perror 143
Error code 143: Unknown error: 143
143 = Conflicting table definitions in sub-tables of MERGE table
Can you post the results for SHOW CREATE TABLE for the tables
you're trying to merge?
MAILBOX
[snip]
| Mailbox |CREATE TABLE `Mailbox` (
`ID` int(11) NOT NULL
Never mind,
I used the show create table Mailbox results as my create table
supermailbox query and it worked.
Thanks
Jeff
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 11:59 AM
To: Jeff McKeon; [EMAIL PROTECTED]
Subject: RE:
I have just installed MySql 4.0.15 from package [mysql-4.0.15-win.zip] onto my Win2000
box.
After doing the binary install, I got a 'cmd' prompt and followed the install
directions.
http://www.mysql.com/documentation/mysql/bychapter/index.html
I followed the 2.1.1.1 Installing the Binaries
I've just finished reading through most of the MySQL Enterprise
Solutions book by Alexander Pachev and I think you might want to take
a look at it. There is a section that deals with testing and MySQL
benchmarking tools.
These tools are available in the mysql/sql-bench (if your MySQL was
I wrote a quick PERL script to give me the status of a table of a
particular database or queries in general on a db server.
71 | 2958 | System lock | e115 | messages |
REPLACE INTO antispam (code) values ('521.25624894_50628.1066152283')
For 71 seconds show full
Splain this to me: I use my laptop to connect to the test-bed MySQL
server residing on my desktop. Using this connection, I can do
anything: load 200K lines, do complex (for me) queries, whatever.
But,
open a MySQL console connection _on the desktop_ where the MySQL
server lives, I can't do a
Hi,
Does anyone know of a perl module or other code that can look at a text file
(CSV, tab-delim etc..) of data and determine a MySQL table definition from
it?
The data may or may not have a set of column headers as the first line.
I would appreciate it greatly if anyone could give me any
Dear All,
Hi!
Installed RH8 included it mysql (RPM-version) with
it, looks like it didnt install in the /usr/local/
directory.
I'd love to uninstall it however, everything I do an
rpm -e mysql it gives this:
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed)
1) After I did the above is the server running or not? I believe I need to do a NET
START MySql
And if so, is there a way to make this a service that starts up when my box comes up?
You do need to do a NET START MYSQL, but since you are using NET commands mysql IS
installed as a service and
Look at your wait_timeout and interactive_timeout settings. They may be
set to a low value. If your connection sleeps for these 2 vars mysql
will disconnect you.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
At 19:05 +0100 10/14/03, Andrew Braithwaite wrote:
Hi,
Does anyone know of a perl module or other code that can look at a text file
(CSV, tab-delim etc..) of data and determine a MySQL table definition from
it?
The data may or may not have a set of column headers as the first line.
You can use
Hello,
I would like get the last 10 distinct (i'm not interested in all
columns) rows in a table which meet a condition. My first try was to
use the following query:
SELECT DISTINCT frobnitz.Field1, frobnitz.Field2, frobnitz.Field3,
frobnitz.Field4
FROM frobnitz, user WHERE user.username = 'foo'
Thanks, that was extremely useful especially the date format detection.
However as it's usually quite scientific data, I need to detect FLOATs,
DOUBLEs and DECIMALs and the structure is not conducive to being integrated
into my current framework.
Is it OK if I pilfer parts of the code and extend
Is anyone aware of an open source project that provides a graphical
representation of tables that can then generate a database schema in sql
statements. Something like Posiedon auto generating java beans.
Perhaps one should be started? ;-)
dan
I have written a .NET class library (fully scriptable via java script and
vbscript too) that serves up all of the meta data for MySql, Sql, Oracle,
Access, DB2 and a few others. Not just the normal meta data but all kinds
of custom meta data that's hard to get to. So, if you're running on a
Dear all
When I use
Insert into table tabl1 (col1)
select ...
to insert about 2 mio. rows into tabl1 I get the error message 2013
connection lost.
When I just run the query, pipe the output into a text file, and use the
load data local infile into table tbl1, it works. How can I
At 19:53 +0100 10/14/03, Andrew Braithwaite wrote:
Thanks, that was extremely useful especially the date format detection.
However as it's usually quite scientific data, I need to detect FLOATs,
DOUBLEs and DECIMALs and the structure is not conducive to being integrated
into my current framework.
Does thread_concurrency work for x86 Linux systems? If so, if a thread
is waiting for a table (locked, etc.) does that mean the thread in
question could use up a one of the thread_concurrency pooled values?
For Instance you have 20 active threads. Thread_concurrency is set to 8
and 8+ threads
InnoDB uses some log files that are placed in the directory 'MySQL / data'.
What are those files ? Why and when InnoDB needs to save those logs ?
I had a problem whith those files and now all my InnoDB stopped working,
only the MyISAM tables are working, how can I recovery data from them ?
--
At 17:22 -0300 10/14/03, Daniel Franco wrote:
InnoDB uses some log files that are placed in the directory 'MySQL / data'.
What are those files ? Why and when InnoDB needs to save those logs ?
InnoDB uses them to record ongoing changes being made by transactions,
and for auto-recovery after a
Description:
Mysql 4.0.15 from ports on FreeBSD 4.7 has this repeated many times in
the logs while under heavier loads:
Warning: thr_alarm queue is full
Threads get disconnected when this happens. I assume it is the thread
that has this problem:
(...=removed sensitive data)
MySQL, Second Edition, is now available in Czech.
Information is available at:
http://www.kitebird.com/mysql-book/
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
Uberdumb question - but I'm still enough of a newbie that this is giving
me fits...
I have four tables, with relevant columns as follows:
++ ++
group zip
-- --
name varchar city_id int
zip mediumint zip
Hi
We have just release Rekall V2.1.0 beta4. There have been no new features
added but we have fixed many bugs both large and small. You can download the
demo from either http://www.totalrekall.co.uk or from
http://www.rygannon.com
If all goes well this will be the final beta release
Regards
John
I have both the standard and source mysql, and I am attempting a link with a
simple program that calles mysql_server_init and mysql_server_end.
I have tried various library call outs to find these two calls in both the
standard and source mysql directories.
I have not located these in any of
Dathan Vance Pattishall wrote:
Look at your wait_timeout and interactive_timeout settings. They may be
set to a low value. If your connection sleeps for these 2 vars mysql
will disconnect you.
- Dathan Vance Pattishall
--Subject: Connection Time Out
--
--
--Splain this to me: I use my laptop
I want to speed up a large query and I noticed if I do an:
Explain select * from LargeTable order by IndexCol1
it always has Extra Using FileSort, which means it is physically sorting
the result set.
I've tried different tables and sorted on different index columns, and it
is always using
75 matches
Mail list logo