Just to be complete, linux does have limitations depending upon
limitations of the file-system, and the kernel. All modern filesystems
(XFS, EXT3, ...) all allow files over a terabyte is size.
On Tue, 2004-04-06 at 13:39, Ronan Lucio wrote:
Uhm,
what are you talking about?!?
When I put
When I use multi-byte code (especially UTF-8) with data including
Kanji (Japanese kanji character) and execute SELECT from mysql
client command, the vertical lines(|) of output table aren't aligned
as straight lines and the output doesn't look like a table.
When I use SJIS code, the problem of
Hello all,
I would like to run diverent MySQL-Daemons on the same Linux machine, so
I use mysqld_multi to start the different processes.
The Config looks right to me, I have different Database Directorys,
Pid-Files, Ports, IDs usw. and different Socket-Files and all over it
seems to work.
But!
Hello,
I have the following structure:
people
-
| id | name |
-
| 1 | John |
| 2 | Mary |
-
cities
| id | city|
| 1 | Glasgow |
| 2 | Madrid |
| 3 | Berlin |
travel_expenditures
Hi List,
Can this be done in one sql statment (without the use of sub-queries):
SELECT count(*) as total, status
FROM table
GROUP BY status
---
Absent | 40
Present|60
and get this result:
Absent: 40%
something like:
SELECT ((count(total) OF status=Absent) /
Terence [EMAIL PROTECTED] wrote:
Can this be done in one sql statment (without the use of sub-queries):
Without subqueries - no.
SELECT count(*) as total, status
FROM table
GROUP BY status
---
Absent | 40
Present|60
and get this result:
Absent:
Hello,
i have a table that contains datetime entries which are stored in GMT. Now I
would like to convert these datetime values in a select statement to local
time. I first thought of someting like this (in germany DST starts at
2004-03-29 02:00:00 and ends 2004-10-31 03:00:00 this year. The
Hi,
MySQL 4.0.14
Are there any known issues on windows 2000 advance
server?
After installation, on running the WinMySQLAdmin the
green light comes on for a second or two and then
disconnected. We tried running MySQLd-nt on its own,
it simply cannot establish connection.
What could be wrong
Lou Olsten [EMAIL PROTECTED] wrote:
I'm in the process of trying to move some of our systems to MySQL from SQL Server and
Oracle. At this point I'm learning and testing MySQL.
One immediate question I have is regarding getting aggregate information. For
example,
the SHOW DATABASES
A Z [EMAIL PROTECTED] wrote:
Hi,
MySQL 4.0.14
Are there any known issues on windows 2000 advance
server?
After installation, on running the WinMySQLAdmin the
green light comes on for a second or two and then
disconnected. We tried running MySQLd-nt on its own,
it simply cannot establish
Hi,
I'm using mySQL 4.1.18 on Windows XP pro. I tried this syntax and I received error.
mysql -u root -p databasename scriptfile.sql
What is the right syntax for this.
I managed to unpack my table structure from the same script into another machine on
Win2000 Server. However, I remember
Thursday, April 08, 2004, 1:07:27 PM, b wrote:
hi,
Error 1064: You have an error in your SQL syntax. Check the manual that corresponds
to your mySQL for the right syntax to use near 'mysql -u root -p databasename
scriptfile.sql' at line 1
however, I tried this.
\u database name;
\.
Is there any way to fix a corrupted relay log on a slave?
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've experienced more corruption lately on my main site since I moved to my
own server running 4.0.17max. The site is very busy (60GB a month) and the
tables are large. I didn't have this level of problems on the rental server.
What are the variables to look into regarding why my tables are
Hi
I recently began to work through the Book entitled PHP MySQL For Dummies
and i am currently stuck towards the end of the forth chapter ive done
everything as said so in the book but i keep getting an error message. Here
is an outline of the problem:
i have 2 tables one pet containing
I seem to have encountered a corrupt database file,
and was wondering if anyone could shed some light onto
how this occurred. I was able to restore from a
backup, so I'm OK now, but I'd like to know how to
avoid this in the future. I'm running MySql-max
4.0.18, using InnoDB tables. It looks like
On 4/8/04 9:18 AM, Barry . [EMAIL PROTECTED] wrote:
Hi
I recently began to work through the Book entitled PHP MySQL For Dummies
and i am currently stuck towards the end of the forth chapter ive done
everything as said so in the book but i keep getting an error message. Here
is an outline
For starters look at pet.petName=petcolor.petName
Try changing it to.
pet.petName=color.petName
You are referencing the color table as petcolor.
Thanks,
Andrew
From: Barry . [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Learner Here Getting Frustraighted
Date: Thu, 08 Apr 2004 14:18:10 +
Hi
Barry Smith writes:
i have 2 tables one pet containing petName and petType other table is color
containgin petName and petColor. The code which i keep getting errors on is:
Select * from pet outer join color using (pet.petName=petcolor.petName) ;
Unfortunately petcolor is not a table. Based
Hi,
I tried to load a table's indexes into cache, however
I noticed that full-text indexes have a different
block-size than others (2048 vs. 1024), which caused
load index command to fail. Any idea on how to solve
this?
Thanks a lot
__
Do you Yahoo!?
Yahoo! Small
At 8:29 -0600 4/8/04, Kevin Jaques wrote:
Thanks for the reply. I feel it is getting me somewhere, but I'm not
there yet.
The log said, regarding the most recent attempt:
040407 09:55:24 mysqld started
040407 9:55:25 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See
Hi,
I would like to make a connection between 2 databases in
MySQL that are on the same server. The purpose is that a
class X in database A uses a class Y in database B by a
foreign key. Thus, the table in B can be re-used by other
databases which will make my databases more efficient.
I've
Hi, MySQL Gurus,
Version of mysql is Distrib 3.23.54, for redhat-linux-gnu (i386). I
started mysql server with 'safe_mysqld --user=root ' . Then I found some
variables needs to be optimized. SO I shut it down with 'mysqladmin -p
shutdown' using root. But I was connected to the mysql server at
Please look in your data directory and post the contents of the host
name.ERR file that you find there. That will give folks the information
they need to help solve your problem.
-Original Message-
From: Ginger Cheng [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 10:21 AM
To:
What information is being logged in *.err?
-Original Message-
From: Ginger Cheng
To: [EMAIL PROTECTED]
Sent: 4/8/04 10:20 AM
Subject: Please HELP !!! Can not restart server
Hi, MySQL Gurus,
Version of mysql is Distrib 3.23.54, for redhat-linux-gnu
(i386). I
started mysql server
I don't have such files. Unfortunately. Am I hopeless?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I can't seem to get a FULLTEXT search in the form of MATCH...AGAINST to
work. I even copied verbatim the example listed on mysql.com at
(http://www.mysql.com/doc/en/Fulltext_Search.html). When I use...
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database')
it works as expected.
Hello Robb,
Thursday, April 8, 2004, 4:30:46 PM, you wrote:
RK I've got several tables with FULLTEXT indexes and on none of them can I get
RK this syntax to work. What's up?
Your version of MySQL perhaps?
--
Best regards,
Richard Davey
http://www.phpcommunity.org/wiki/296.html
--
MySQL
Here is the error msg:
040408 08:47:14 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB
I got it fixed with the msg from --err-log. THank you so much for all your
help. I couldn't have made it without your hints.
ALl the best
ginger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Robb Kerr [EMAIL PROTECTED] wrote:
I can't seem to get a FULLTEXT search in the form of MATCH...AGAINST to
work. I even copied verbatim the example listed on mysql.com at
(http://www.mysql.com/doc/en/Fulltext_Search.html). When I use...
SELECT * FROM articles WHERE MATCH (title,body) AGAINST
Ginger Cheng [EMAIL PROTECTED] wrote:
Here is the error msg:
040408 08:47:14 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your
* Steijn, B.S.
I would like to make a connection between 2 databases in
MySQL that are on the same server.
If you by connection mean to join tables from the two databases on the
same server, you can do that.
The purpose is that a
class X in database A uses a class Y in database B by a
Is there an easy way to create an HTML page that will copy selected tables
to backup copies on the same server? I want to create an administration
page for my client to be able to backup their database whenever they see
fit. But, I can't give them direct access to the MySQL server and don't
want
Sound like a great idea!
Is there an easy way to create an HTML page that will copy selected tables
to backup copies on the same server? I want to create an administration
page for my client to be able to backup their database whenever they see
fit. But, I can't give them direct access to
Try using such command from PHP...
system($MYSQLDUMP --opt --user=$USER --password=$PASSWORD $DATABASE_NAME
$GZIP - $BKDIR/$newfile.gz,$status);
where
$MYSQLDUMP is the mysqldump path
$GZIP is the path to gzip
$BKDIR is the path to the backup folder
Is there an easy way to create an HTML page that will copy selected tables
to backup copies on the same server? I want to create an administration
page for my client to be able to backup their database whenever they see
fit. But, I can't give them direct access to the MySQL server and don't
Is there an easy way to create an HTML page that will copy selected tables
to backup copies on the same server? I want to create an administration
page for my client to be able to backup their database whenever they see
fit. But, I can't give them direct access to the MySQL server and don't
Typo petColor is meant to be color
From: James McConnell [EMAIL PROTECTED]
To: Barry . [EMAIL PROTECTED],MySQL Mailing List
[EMAIL PROTECTED]
Subject: Re: Learner Here Getting Frustraighted
Date: Thu, 08 Apr 2004 09:34:36 -0500
On 4/8/04 9:18 AM, Barry . [EMAIL PROTECTED] wrote:
Hi
I'm new to mysql, so I thought I'd use the command
center utility, which requires an X server to be
running.
Is there a way to start the xterm and mysqlcc all at
once? I would like a shell script that starts xterm
and then runs mysqlcc.
Any ideas?
TIA.
=
Thanks.
Kevin
-- Enjoy Life,
James McConnell wrote:
On 4/8/04 9:18 AM, Barry . [EMAIL PROTECTED] wrote:
Hi
I recently began to work through the Book entitled PHP MySQL For Dummies
and i am currently stuck towards the end of the forth chapter ive done
everything as said so in the book but i keep getting an error message.
We have been looking and looking for some guidance for installing MySQL with
SSL on a SuSE 9.0 box. By searching the archives, the net using Google,
etc., we keep finding pieces of the puzzle, but no single piece that covers
all of the ground.
The problem is that we seem to complete the
First a big thanks to Mark, BAO, Beacker, Matthais, Rich Ken for their
response.
My problem was that I thought that I needed to download tar file to start
the installation. Rich's response somewhat cleared that. I ran the following
commands, and got the following errors:
% perl -MCPAN -e
I upgraded from MySQL 4.0.12 to MySQL 4.0.18 last night and found some
oddities this morning. Apparently some of the varchar data being input into
certain tables had carriage returns: \n in the data. This was an
accidental thing, but on 4.0.12, the \n was ignored when matching on that
record.
iH
is mysql installed and running?
- hcir
On Apr 8, 2004, at 9:53 AM, Kirti S. Bajwa wrote:
cpan install DBD::mysql
Errors returned:
Can't exec mysql_config: No such file or directory at Makefile.PL
line 174
readline() on closed filehandle PIPE at Makefile.PL line 176
... (there are 10 such
Before switching to version 4.0.18 of MySQL the command delete from table
was also reseting the autonincrement column value... It seems that this is
not happening anymore after we have installed this version...
Any idee about this problem? Is there any other way to reset this?
Arthur
--
Here's what I did to fix it... Excert from MySql Manual...
When you back up your slave's data, you should back up these two small
files as well, along with the relay log files. They are needed to resume
replication after you restore the slave's data. If you lose the relay
logs but still have the
Good point. I was focused on the question of using the alias to restrict
results, so I left the function in the SELECT part. As you say, in this
query, that would just give a useless column of '1's, so you might as well
leave it out. In that case, though, the alias question is moot. That
On 4/8/04 1:05 PM, Michael Stassen [EMAIL PROTECTED] wrote:
James McConnell wrote:
On 4/8/04 9:18 AM, Barry . [EMAIL PROTECTED] wrote:
Hi
I recently began to work through the Book entitled PHP MySQL For Dummies
and i am currently stuck towards the end of the forth chapter ive done
Hi Kirti,
mysql_config tell the perl build module how to link with the
driver. The easiest way to fix this is make sure the bin driectory of
MySQL is in your path. If you can type 'mysql_config' at the command
line and get an answer like:
Usage: /usr/local/bin/mysql_config [OPTIONS]
Options:
Try truncate table. It essentially drops the table and recreates it.
--
DVP
-Original Message-
From: Arthur Radulescu [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 10:36 AM
To: [EMAIL PROTECTED]
Subject: autoincrement column
Before switching to version 4.0.18 of MySQL
All you had to do what
CHANGE MASTER TO MASTER_LOG_POS=Exec_master_log_pos,
MASTER_HOST=Master_host, MASTER_USER=Master_user,
MASTER_LOG_FILE=Relay_Master_Log_File
This essentially forces mySQL to redownload the relay logs and stay in sync.
Its call rewinding the replication thread.
--
DVP
Keep in mind you can't use truncate in a transaction though. I experienced
this problem
recently when wanting to delete an entire table and reset my auto increment
values. While
keeping it in a transaction.
From: Dathan Vance Pattishall [EMAIL PROTECTED]
To: 'Arthur Radulescu' [EMAIL
I've experienced more corruption lately on my main site since I moved to my
own server running 4.0.17max. The site is very busy (60GB a month) and the
tables are large. I didn't have this level of problems on the rental server.
What are the variables to look into regarding why my tables are
Ken:
Thank you for your response. I tried the 'mysql_config' command and got an
errot message. I will add 'mysql_config' to the path (if I figure out
how!!!).
I noticed that on my installation the 'mysql_config' is in
'/usr/local/mysql/bin' directory whereas you have indicated that it should
be
Is there a way to disable the use of the backslash as an escape
character in strings? I need to use an application that's designed to
work on any database server supporting ANSI SQL. When it generates SQL
insert/update queries, it doesn't escape backslashes in strings, because
the ANSI SQL
Why Mysql load index ... into cache require the same
size index block when it creates indexes in different
block sizes (1k or 2k)? I don't understand.
Please help!
__
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
Are you using a high level library such as Perl::DBI? If so, you should run
all your strings the quote method. That will quote it properly for each
database you connect to. If you are connecting to all the databases yourself
using custom code, I would recommend you find some database neutral
Kirti S. Bajwa wrote:
Ken:
Thank you for your response. I tried the 'mysql_config' command and got an
error message. I will add 'mysql_config' to the path (if I figure out
how!!!).
You need to add the directory which contains mysql_config to your path.
Adding to your PATH isn't difficult, but
When I use multi-byte code (especially UTF-8) with data including
Kanji (Japanese kanji character) and execute SELECT from mysql
client command, the vertical lines(|) of output table aren't aligned
as straight lines and the output doesn't look like a table.
When I use SJIS code, the
INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as category_id,
'' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1 + g.Desc2 +
g.Desc3 as description, g.Desc4 as price,0 as quantity, '' as
comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type, now()
as created, now()
dan orlic wrote:
INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as
category_id, '' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1
+ g.Desc2 + g.Desc3 as description, g.Desc4 as price,0 as quantity, ''
as comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type,
now()
My final issue is inserting a currency, $500.00 for example into a field
that is a BigDecimal(10,2).
Anyone have any thoughts on how to do that within a SQL statement?
dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
63 matches
Mail list logo