Hi Bob hall,
I do apologize for being unclear in my previous message.
To answer your question:
>Does the MySQL server run on your FreeBSD system?
Yes MySQL runs prefectly with my FreeBSD 4.6 system.
> How are you trying to export your Jet tables? I assume that's
what you mean when you refer
Christensen, Dave
There doesnt seem to be any error when performed exports,
however i still cant see the tables in mysql.
- Original Message -
From: "Christensen, Dave" <[EMAIL PROTECTED]>
Date: Fri, 17 Jan 2003 07:51:28 -0600
To: "'mc 02'" <[EMAIL PROTECTED]>
Subject: RE: Connection ms
On Fri, Jan 17, 2003 at 03:15:05AM -0500, mc 02 wrote:
> I've downloaded the necessary application MySQL 3.51 and myODBC for
> freeBSD. On the XP side i only downloaded myODBC. I played around the
> configuration but i still cant seem to export the files to my FreeBSD
> box.
>
> What am i doing w
Hey everyone. I figured it out.
Packed tables are read only.
Thanks!
Paul
-Original Message-
From: Paul Borghese [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 9:26 PM
To: [EMAIL PROTECTED]
Subject: Upgrade from ISAM to MyISAM fails with "read only" error
Any ideas why t
Any ideas why the following upgrade from ISAM to MyISAM fails:
mysql> alter table users type = MYISAM;
ERROR 1036: Table 'users' is read only
This only occurs for about half the tables I tried to upgrade.
Thanks!
Paul
-
Bef
On Fri, Jan 17, 2003 at 06:46:09PM +0530, Shripal Shah wrote:
> Dear Sir/Madam
>
> I want to know that which is more faster in terms of loading data into table
> from file
>
> 1> MYSQL --quick -f -s -u root DBNAME < FILE.TXT
>
> 2> LOAD DATA INFILE.
Try both and you'll know. :-)
Seriously,
Hi, all
I have two tables with full of data. Their structure is same.
Tables1
id type name
1
2
3
...
Tables2
id type name
1
2
3
4
I want to merge them into one table.
id typename
1
2
3
4
5
6
7
...
How can I do it?
thanks in advance.
luoya
sql,query,queries,sm
on 01/17/2003 9:25 AM, gerald_clark at [EMAIL PROTECTED]
wrote:
>> I tried installing mySql on OS X 10.2.3, following the instructions at
>> http://www.entropy.ch/software/macosx/mysql/ . I wanted to set a
>> password for the MySQL root user , so I typed:
There apparently is a problem with the e
At 16:27 -0700 1/17/03, Zak Greant wrote:
On Fri, Jan 17, 2003 at 04:24:37PM -0700, Mark Stringham wrote:
I'm not sure what you mean but the file gets created and when I open
it - there is nothing in it.
Do I need the path to mysql at the beginning ? IE
c:\apache\mysql\bin>mysqldump ?
Hi
On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote:
> sql, query
>
> I'm trying to utilize the mysqldump utility to backup my db on a WIN2k
> advanced server. I'm running a BAT file with the following syntax
>
> c:\apache\mysql\bin>mysqldump -u uipcontent -p test >
> c:\testdum
On Fri, Jan 17, 2003 at 04:24:37PM -0700, Mark Stringham wrote:
> I'm not sure what you mean but the file gets created and when I open
> it - there is nothing in it.
>
> Do I need the path to mysql at the beginning ? IE
> c:\apache\mysql\bin>mysqldump ?
Hi Mark,
To rephrase: If you run the
Hi!
Installing the latest MySQL 4 build on Mac OS X, I got a couple of
errors when running the mysql_install_db script (sudo
./scripts/mysql_install_db) from the mysql directory:
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
Th
I'm not sure what you mean but the file gets created and when I open
it - there is nothing in it.
Do I need the path to mysql at the beginning ? IE
c:\apache\mysql\bin>mysqldump ?
thanks
MS
> On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote:
> > sql, query
> >
> > I'm trying
I'm not sure what you mean but the file gets created and when I open
it - there is nothing in it.
Do I need the path to mysql at the beginning ? IE
c:\apache\mysql\bin>mysqldump ?
thanks
MS
> On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote:
> > sql, query
> >
> > I'm trying
sql, query
I'm trying to utilize the mysqldump utility to backup my db on a WIN2k
advanced server. I'm running a BAT file with the following syntax
c:\apache\mysql\bin>mysqldump -u uipcontent -p test >
c:\testdump.sql
the file testdump.sql gets created in the appropriate place but the
fi
sql, query
I'm trying to utilize the mysqldump utility to backup my db on a WIN2k
advanced server. I'm running a BAT file with the following syntax
c:\apache\mysql\bin>mysqldump -u uipcontent -p test >
c:\testdump.sql
the file testdump.sql gets created in the appropriate place but the
fi
Problem: I am migrating servers, from a dual PIII-866 Mhz with 384 MB of
RAM running Linux to the following server configuration:
Dual Athlon 1.5 Ghz
1 GB RAM
2 x 18 GIG SCSI drives.
FreeBSD 4.7-Stable
MySQL-Max-3.23.54a (ELF) i.e. without linuxthreads - runs on only 1 process.
I am trying to i
Hi,
- Original Message -
From: "Hoffman, Geoffrey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 7:01 PM
Subject: Whats the best way to manage 'generic two-way relationships'?
> I couldn't think of a better term for what I want to do...
>
> I am building a CMS
On Fri, Jan 17, 2003 at 04:29:36PM -0500, Poon, Kelvin (Infomart) wrote:
>
> Thanks a lot that's very clear...but you help me clear up some more?
>
> The reason I asked is because I got this new project that requires me to
> make a webpage with PHP that collects information from the dbs of ths ne
Thanks a lot that's very clear...but you help me clear up some more?
The reason I asked is because I got this new project that requires me to
make a webpage with PHP that collects information from the dbs of ths new
server we brought...SQL 2000 server. Like it is a SQL server so I thought I
woul
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Will, et al --
...and then Will Standley said...
%
% I'm looking for an ISP to host a couple of MySQL db's...
Well, you could drop me a note :-) I live here, I work here, and I host
here. You'd fit right in.
HTH & HAND
mysql query,
:-D
- --
Da
Marcos Henke Wrote:
> SELECT a.* FROM company a, employee b
> WHERE a.id=b.cid AND
> (b.name='joe' OR
> b.name='bill');
This will pull out all companies which have a Joe or a Bill. We want only the
company in which Joe and Bill are working.
A working solution was offered by Adolfo Bello earl
Quoting Jeff Kilbride ([EMAIL PROTECTED]):
> What about just issuing a PURGE MASTER LOGS TO master-bin.007 on the master
> and then starting the slave without a master.info file? I think that will
> recreate it for you -- but you should research this before trying...
Works perfectly.
James
(sql
Hi:
I am newbie in this email list.
I would like to convert rows from a table into columns in a new table, which
is simliar to maxtrix transposition. What tools do you recommend to do it?
In Oracle, we could use PL/SQL. In MySql, we certainly do not have such
tools.
Is MySQL ++ (http://www.my
Hi !!!
I'm new with mysql database.
I have to migrate the data from access to mysql, is it posible? How can I
do it?
Thanks for your help
La información contenida en este correo es para uso exclusivo de
los destinatarios del mismo. Está prohibido a las personas o entidades
que
MySQL is a relational database managament system (DBMS) that uses the SQL
language for doing queries to get the inforamtion stored in it. MySQL is
the equivalent as saying Oracel, or DB2.
HTH
JFernando
* sql *
-Original Message-
From: Poon, Kelvin (Infomart) [mailto:[EMAIL PROTECTED]]
S
On Fri, Jan 17, 2003 at 03:53:52PM +, Diana Soares wrote:
> Hi,
> I coudn't compile the my-mysql-utils.cc file..
> I'm not going to ask you for help on this (you have more interesting
> things to do :-) and also i didn't used the same version of gcc as you
> did). I've done an UDF sometime ago
Hi I am new to mySQL,
Can someone explain to me the difference between SQL and mySQL?
I know a little bit of SQL, select statments, insert statments and such, but
I ahve no idea what is mySQL?
-
Before posting, please check:
oops small mistake in my prev post..
I meant to say (f -> b b-> c,d,e, Kk-> l,m) in my example
NOT f->b,k b->c,d,e
lol.. got a little confused with all those insert examples ;)
Friday, January 17, 2003, 2:01:22 PM, you wrote:
> Geoffrey,
> Friday, January 17, 2003, 12:01:20 PM
Hello,
I've read documentation and looked in the list archives but
haven't found anything that specifically addresses the idea
of writing out fields in a fixed-field format.
I'd like to do something like "SELECT id,date INTO OUTFILE
'data.txt' id = column 1, date = column 10;" to get a file
th
Geoffrey,
Friday, January 17, 2003, 12:01:20 PM, you wrote:
> I couldn't think of a better term for what I want to do...
> I am building a CMS for news stories. Often news stories are related to each
> other, or need to be grouped by content. I need a simple way to manage
> storyId relationships
On 17 Jan 2003, at 16:40, Octavian Rasnita wrote:
> In MySQL I know that I need to put the column names between `` in some
> cases if they contain a % or an _ sign in it. Please tell me what sign
> can I use to link 2 words in a column without needing to include that
> column name between ``.
>
>
Hi Chavvon,
we are running a high volume site with
currenty 1.3 Million Page Views daily.
mysql query average is at 300. We are using the
latest stable versions of mysql, apache and php.
the server has 2 GB of RAM and 4 XEON 2.4 GZ
processors and the load varies between 1 and 2 at
peek times. alt
Are you creating new tables or importing from an old application? If you
are building something from scratch it is a really really bad idea to use
spaces in the names or start putting in special characters, you're just
making more work for yourself, and anyone that works on the application
after y
We have a site with a similar architecture:
- 6 load balanced front-ends
- 1 dedicated database server (Dual P3 1.4GHz, 2GbRAM, RH7.2)
we serve around 3 million pages/day (all pages are dynamiquely generated,
each page needs an average of 15 SQL queries).
What we have done:
- audit ALL SQL queries
Jeff Spivack wrote:
Description:
I tried installing mySql on OS X 10.2.3, following the instructions at
http://www.entropy.ch/software/macosx/mysql/ . I wanted to set a
password for the MySQL root user , so I typed:
./bin/mysqladmin -u root password 'new-password' (with, of course, a
pas
I couldn't think of a better term for what I want to do...
I am building a CMS for news stories. Often news stories are related to each
other, or need to be grouped by content. I need a simple way to manage
storyId relationships - in both directions.
Thinking about the business logic to implemen
I've had great luck with both:
http://linuxwebhost.com and
http://onsmart.net
WS> From: Will Standley [mailto:[EMAIL PROTECTED]]
WS> Sent: Friday, January 17, 2003 7:45 AM
WS> Subject: --- Best ISP for MySQL & PHP ???
WS> I'm looking for an ISP to host a couple of MySQL db's...
WS> Will be usin
* Stefan Hinz
> * Sergei:
> > It's because of NULLs.
> > Extra byte is used to mark, if the column is NULL or not.
>
> Thanks alot for the explanation. Thanks to Gerald Clark, too, who told
> me the same.
>
> > (in fact it's a bitmap, that is it would be one byte for up to 8
> > columns, then it'll
Hi all,
In MySQL I know that I need to put the column names between `` in some cases
if they contain a % or an _ sign in it.
Please tell me what sign can I use to link 2 words in a column without
needing to include that column name between ``.
Can I use a - (dash) sign, or it might be considered
Description:
I tried installing mySql on OS X 10.2.3, following the instructions
at http://www.entropy.ch/software/macosx/mysql/ . I wanted to set a
password for the MySQL root user , so I typed:
./bin/mysqladmin -u root password 'new-password' (with, of course, a
password in place of 'new p
Gerald,
> >>(in fact it's a bitmap, that is it would be one byte for up to 8
> >>columns, then it'll be 2 bytes, etc.)
> >If so, this table should have an average row length of 92, not 91,
> It does on mine.
Alright, I take this as a Windows goodie (my MySQL 4.0.7 runs on Win2K
;-)
Regards,
--
I saw a message in November that said they would be out any time now.
Any news on if they are available and in what forms are they available
(tar.gz RPM, etc).
Thanks,
(mysql, sql, database)
--
Michael Eklund <[EMAIL PROTECTED]>
Netmechanic, Inc
---
We are hosting a high volume site that gets about 1 million page views a day
on RedHat 7.3. We currently have 3 load balanced servers on the front end
accessing a MySQL server on the back end. The MySQL servers is dual P3 1ghz
with 1 GB of RAM and when the MySQL queries hit about 50 per second, t
Gang,
I'm looking for an ISP to host a couple of MySQL db's...
Will be using PHP as the scripting language...
Want to use PhpMyAdmin to administer the db.
Are there certain ISP's who specialize in hosting such sites?
Thanks for any info.
Will
Hi!
On Jan 16, Stefan Hinz wrote:
> Sergei,
>
> >> any other guru who can explain why 10 = 11?
>
> > It's because of NULLs.
> > Extra byte is used to mark, if the column is NULL or not.
>
> Thanks alot for the explanation. Thanks to Gerald Clark, too, who told
> me the same.
>
> > (in fact it'
Why don't you add all the indecies in one alter table command?
Brent Baisley wrote:
You can probably monitor the database directory to see when the
temporary file disappears or the index file size stops changing. Then
it won't matter if the script dies again or not, you just need to keep
trac
Hi,
I didn't notice in the other e-mail, but the syntax of mysqlimport says
everything.. :-)
mysqlimport is like "LOAD DATA INFILE" and imports data to ONE table.
To use your UM.txt you may use:
# mysql test < UM.txt
For further explanation of mysqlimport:
# mysqlimport --help
Loads tables
Stefan Hinz wrote:
Sergei,
any other guru who can explain why 10 = 11?
It's because of NULLs.
Extra byte is used to mark, if the column is NULL or not.
Thanks alot for the explanation. Thanks to Gerald Clark, too, who told
me the same.
(in fact it's a bitmap, that is it
Hi Tyler,
Most probably there is a problem in PHP configuration if you are sure
MySQL is working properly. You didn't get any errors, did you? If not and
you have acces to php.ini change the error reporting level to E_ALL. If you
don't have acces to php.ini, call the error_reporting (E_
You can probably monitor the database directory to see when the
temporary file disappears or the index file size stops changing. Then it
won't matter if the script dies again or not, you just need to keep
track of which indexes have already been built.
On Friday, January 17, 2003, at 08:30 AM,
Do not use mysqlimport.
That is for flat file import.
mysql test < UM.txt
Shripal Shah wrote:
Dear Sir/Madam,
I've one data file which is built with the help of mysqldump. This file
contains structure & data of 2 tables of test database. Like this..
mysqldump -C --add-drop-table -e test patie
Hi!
After a very successful Alpha period, MySQL Control Center goes Beta !
All the critical features are already coded in this release and from now on,
the next releases of the 0.8.X branch will only be minor-enhancements /
features and bug-fix releases type releases.
Apart from several bug-fixe
Hey.. I've got a promblem. I use PHP, and I cant seem to be able to change
anything in the MySQL db via the webpage. I know the scripts are correct,
but nothing happens when I change somethign via web. I've even installed
PhpMyAdmin to moniter the DB via the web, and that doesn't work either.
> Hi,
>
> I need some guidance to the following problem.
>
> We have a really big table that crashed. We decided to rebuild the
> indexes so we stripped all the indexes and started a perl script that
> issued commands to build one index at a time. No the problem is that the
> shell where we star
Dear Sir/Madam
I want to know that which is more faster in terms of loading data into table
from file
1> MYSQL --quick -f -s -u root DBNAME < FILE.TXT
2> LOAD DATA INFILE.
Thanks & Regards,
Shripal.
-
Before posting, ple
* Paul DuBois
> At 17:00 -0700 1/16/03, Matthew Phillips wrote:
> >I am running 3.23 and am new to mysql
> >
> >I would like to do something like this:
> >
> >delete t1
> >from t1, t2
> >where t1.col = t2.col
> >and ...
> >
> >basically deleting every row in t1 that has a matching row in t2.
> >
>
Dear Sir/Madam,
I've one data file which is built with the help of mysqldump. This file
contains structure & data of 2 tables of test database. Like this..
mysqldump -C --add-drop-table -e test patient hospital > UM.txt
then I am trying to import data using this statement..
mysqlimport test UM
SELECT a.* FROM company a, employee b
WHERE a.id=b.cid AND
(b.name='joe' OR
b.name='bill');
_
Marcos Henke
_
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Blaster" <[EMAIL PROTECTED]>
Sent: Friday, Janua
* Blaster
[...]
> "main" company table
> id (int) | company name (varchar) | phone (varchar) | .. more fields that
> doesn't really matter
>
> "employee" table (company.id = employee.cid)
> id (int) | cid (int) | name (varchar) | age (int) | email (varchar)
>
> Now, I want to make a search which ca
Hi Roger,
you are so right about the query you mentioned.
i was using two other tables for the storage of column and row names since
each aij uses common names for rows and columns, that mixed my mind, but i
will use 1 select query, and make two joins from column-row name tables to
the main table
Hi,
Start the mysqld with --skip-grant-tables. This way the server will not
use the privilege tables... Then alter the data as you want and do a
mysqladmin flush-privileges (or reload) to restart using them.
More info:
http://www.mysql.com/doc/en/Privileges_options.html
On Fri, 2003-01-17 at 03:
> >>>
> >>
> >>equipID is a PRIMARY KEY ;)
> >>
But you don't have index in which ifName is on the first place - and you yave
to have it.
> > Well!!! ifname also a Primary key!!
> >
> >ysql> CREATE TABLE equipment_interfaces (
> >> -> equipID CHAR(20) NOT NULL,
> >> ->
While Csongor Fagyal (I belive) is correct about current behavior, the DBI
documentation explicitly says that this will break:
Currently, a new hash reference is returned for each
row. This will change in the future to return the
same hash ref each time, so don't rel
* Tarik Kutluca
> 1. I need to store dynamic sized tables with different row and
> column sizes, but all small tables ( like 2*5, 3*1,5*3)
> 2. For this purpose i created a table to store each value of the dynamic
> sized table, also with the row and the column number, so this is something
> like
>
Hello!
Is it feasible to enable storing multiple values into one variable?
(that would then be an array)
For example:
@a := (SELECT idref FROM tableB);
(... some commands ...)
SELECT id FROM tableA WHERE id IN @a;
Or will mysql support something like cursors?
--
Christian Kohlschütter
[EMAIL PR
Hi,
>Was found problems with some glibc system, please use temporally the
>work around of the start the server with the option:
> --thread_stack=196KB >>
Ok i'll have a look to that.
For the glibc, i used binary tar.gz, so even if my glibc is buggy this'll
not affect me ...
>The access denied i
Hi,
I am using windows 2000 server and MySql 4.07gamma.
I have a merge table, combining 2 tables.
The tables both have only one index (non unique) which consist of 2 fields
(both these fields are defined as char but in reality they only have
integer values in them. Index Field 1 is char(1) and i
At 09:19 17/01/2003 +0100, David Bordas wrote:
Hi,
Hi list and thanks to read me.
Since december, I've got aborted_clients and aborted_connects to my mysql
server ...
Clients that connected to this server have errors like :
Failed to connect to database:
Error: Access denied for user: '[EMAIL PR
On Fri, 2003-01-17 at 08:51, Ivan Hoo wrote:
> is there any way you can implement a secure replication via ssh or sth else?
Who can implement?
As user you can use SSH tunnel with it. There are many tutorial about
making SSH tunneling in the internet. I believe if MySQL will have some
kind of tra
I have never tried to compile sources on openbsd. So I don't know if it is possible or
not. Generally I prefer the standart openbsd packages. You can download and use
mysql-server3.23.49 package from openbsd: http://www.openbsd.org/3.2_packages/
Also if you have problems installing openbsd packa
Hi list and thanks to read me.
Since december, I've got aborted_clients and aborted_connects to my mysql
server ...
Clients that connected to this server have errors like :
Failed to connect to database:
Error: Access denied for user: '[EMAIL PROTECTED]' to database 'mydb'
MySQL server has gone
Hi,
I'm New to the networking world so bare with me. Now i know im
suppose to look through the manual in the mysql website but i still
cant make it work. So i need all the help i can get.
What i want to do:
===
I want to export my MS Access (2000) files (.mdb)in my WinXP Box to
M
73 matches
Mail list logo