Hello,
A few months ago I asked to have the ability to turn off autocommit at a
server level. I was told by a mySQL rep that this would not be added to the
3.23 tree but would be added to the 4 tree.
Well since 4 has been declared stable I have upgraded. Now I am trying
to find out wher
SELECT DISTINCT
table1.column1,
table1.column3,
table2.column1,
table2.column2,
table3.column3,
table3.column4
FROM
(table1LEFT JOIN table2 ON table1.column1=table2.column1)
LEFT JOIN table3 ON table1.column3=table3.column3;
you can a
At 23:36 -0500 3/21/03, Bernard Miville wrote:
Hi,
I am using MySQL 3.23.
I use SHOW TABLES to obtain a list of tables from my database and
then put this list in an HTML select form on a web page. What I need
to
know, is there a way of obtaining this table list, using SHOW TABLES,
in ascendi
Charles Kline wrote:
I am fairly new to SQL and this is a really complex query for me.
Possibly more complex than necessary. Must you have a separate column
for each of the areas? If you don't mind having them all in a single
column, the query becomes simple and efficient:
SELECT p.fname, p.lna
Hi,
I am using MySQL 3.23.
I use SHOW TABLES to obtain a list of tables from my database and
then put this list in an HTML select form on a web page. What I need
to
know, is there a way of obtaining this table list, using SHOW TABLES,
in ascending or descending order the same way you woul
At 22:28 -0600 3/21/03, Paul DuBois wrote:
At 20:04 -0800 3/21/03, Todd Cary wrote:
I
would like to avoid the necessity of specifying all of the fields -
instead use the following syntax:
INSERT INTO teachers VALUES
(1,12345,NULL,'Harry','Smith','707-773-4523',2',...
However, the first field is a
At 20:04 -0800 3/21/03, Todd Cary wrote:
I would
like to avoid the necessity of specifying all of the fields -
instead use the following syntax:
INSERT INTO teachers VALUES
(1,12345,NULL,'Harry','Smith','707-773-4523',2',...
However, the first field is an autoincrementing field. Will MySQL
ignor
Hi all,
I am fairly new to SQL and this is a really complex query for me.
Here is the setup. 3 tables. tbl_personnel, tbl_personnel_dras, tbl_dra
each person in the tbl_personnel table can have 0 - 3 records in the
tbl_personnel_dras table. The tbl_personnel_dras table is just the
person_id (fro
I would
like to avoid the necessity of specifying all of the fields -
instead use the following syntax:
INSERT INTO teachers VALUES
(1,12345,NULL,'Harry','Smith','707-773-4523',2',...
However, the first field is an autoincrementing field. Will MySQL
ignore my value and overwrite it with the "aut
At 17:11 -0800 3/21/03, Bonnie Poole wrote:
I just sent a note but here is more info. I was able to mysql_install_db
successfully. But when I run safe_mysqld -- user=mysql & this
is what appears in the err file
030321 16:00:24 InnoDB: Operating system error number 13 in a file
operation.
% p
On Fri, Mar 21, 2003 at 01:16:46PM -0700, Jeff Mathis wrote:
> great. the files are exactly as you describe.
>
> we are doing transactions when we load. auto commit is off, and the
> loader commits rows after a certain number has hit the database.
> however, if I understand you correctly, once a l
I just sent a note but here is more info. I was able to mysql_install_db
successfully. But when I run safe_mysqld -- user=mysql & this
is what appears in the err file
030321 16:00:24 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.ht
On Friday 21 March 2003 05:42 pm, Brian McCain wrote:
> Do you have two identical tables? If not, then doing a select the way you
> propose won't yield any rows. If they are identical, then you've already
> got the data, and so wouldn't need to select anything. I'm sure I'm
> misunderstanding exact
I am trying to install on a AIX box. I do not want to install into
/usr/local. I have put everything in /sybase/mysql/mysql. I am running into
alot
of problems with things expected to be in /usr/local/mysql. What do I
need to run in order to tell mysql everthing is in /sybase/mysql/mysql
T
not really for mhsql list, more for php list but,,,
select your database after connection.
use echo statement to look at you queries.
check your punctuation
Roger
-Original Message-
From: Karl James [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 6:51 PM
To: [EMAIL PROTECTED]
Subje
What's the error you're getting? What OS are you running on? If it's *nix,
make sure the file you are trying to load, and the full path to that file,
is readable by the user mysql runs as. I once had some files in a user's
home directory I was trying to load and although the file was
world-readable
sql,query
You have written the following:
My code:
http://nopaste.php-q.net/8594
My site:
http://66.12.3.67/webdb/webdb13/assignment_1a.php
My goal:
http://66.12.3.67/webdb/webdb19/assign01/index.php
==
Can anyone help me get this resolved please?
These links may help:
2.5.2 Upgrading From Version 3.23 to Version 4.0
http://www.mysql.com/doc/en/Upgrading-from-3.23.html
2.1.1 Installing MySQL on Linux
http://www.mysql.com/doc/en/Linux-RPM.html
2.6.1.1 Linux Notes for Binary Distributions
http://www.mysql.com/doc/en/Binary_notes-Linux.html
2.2
Thank you for your reply. OK, I understand that. So what are the steps to install
the file. Isn't there an RPM or something. Do I take the 4.0 binary and place it an
any folder on my box? Then go to that directory and type a lynix command to unpack
and install the files? Then, go to the co
Do you have two identical tables? If not, then doing a select the way you
propose won't yield any rows. If they are identical, then you've already got
the data, and so wouldn't need to select anything. I'm sure I'm
misunderstanding exactly what you're trying to do, so maybe you could
explain it a b
On a linux box you do not have to stop everything like on Windows. We
always leave our current version running, install the upgrade in a new
location with a new data dir (a snapshot of the live one). We run the new
install on a different port than the live install so we can test it and what
not b
I posted earlier this week about how to select from two different tables with
an OR -- selecting rows from either table and putting them into one.
That was easily accomplished with a UNION statement (AFTER upgrading to
MySQL 4.0.x).
Now I'm doing almost the opposite. I have two tables, TestCas
[EMAIL PROTECTED] wrote:
> Can someone help
> point me in the right direction? Thanks
I just finished a practice upgrade (on a back-up server) myself and will
be upgrading the real server during off-peak hours soon. We are running
win2k servers so I can't speak directly to any linux issues, but
I currently am running linux 7.1 and have MySQL 3.23.54 running on my box. I have
heard that there are some security issues with the version of mysql that I am running,
plus, phpnuke 6.5 needs the newer version of mysql.
I am a newbie to linux and mysql, and need a bit of hand holding I think.
Hello, MySQL list subscriber!
We will be performing maintenance on the servers hosting the MySQL
mailing lists this weekend, which will result in some periods of
unavailability, and possible delays in mail delivery.
Sorry about the interruption and inconvenience, and thanks for
your patience!
We
miguel solórzano wrote:
> Some program has locked C:\mysql\bin\libmySQL.dll, if you can
> delete it.
Indeed, my server didn't even want me to delete the file, until I checked the process
list and realized what was locking it: winmysqladmin. Duh... I shut that down and
everything went smoothly.
I've finally set up replication for one of the MySQL servers I
administer, and it seems to be working. I'm puzzled, however, by
what I see in the general query log.
I'm using replicate-wild-do-table to restrict the replication to only
two of the databases on the master server (since I understa
John,
> One hundred MySQL licenses still works out to $90.00 USD. Even if it
> worked out to half that would still leave me with no margin and so
> no compensation for my time. I am trying to find a way of
> using MySQL in a very low cost market and still have still have
> pocket change after each
great. the files are exactly as you describe.
we are doing transactions when we load. auto commit is off, and the
loader commits rows after a certain number has hit the database.
however, if I understand you correctly, once a load is complete and
everything has been committed, we are free to delet
John,
> Actually, I am trying to address the problem of having to buy a $200
> MySQL license for every $50 software product I sell. If you have a
> solution for this problem I would like to know what it is.
> This is a licensing issue that I haven't found a good solution for.
Try with the MySQL
Actually, I am trying to address the problem of having to buy a $200 MySQL license for
every $50 software product I sell. If you have a solution for this problem I would
like to know what it is. This is a licensing issue that I haven't found a good
solution for.
John
-Original Message
I think this works too:
Select * from Tablename where drinks <> 'pepsi';
> -Original Message-
> From: Andrew Wilson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 20, 2003 4:49 PM
> To: '[EMAIL PROTECTED]'
> Subject: "where drink is not equal to pepsi
>
>
>
> Hi guys,
> Hopefully
Gerald,
One hundred MySQL licenses still works out to $90.00 USD. Even if it worked out to
half that would still leave me with no margin and so no compensation for my time. I am
trying to find a way of using MySQL in a very low cost market and still have still
have pocket change after each sale
Buy a hundred at a time.
John Griffin wrote:
Actually, I am trying to address the problem of having to buy a $200 MySQL license for every $50 software product I sell. If you have a solution for this problem I would like to know what it is. This is a licensing issue that I haven't found a good sol
Joe,
- Original Message -
From: ""Jennifer Goodie"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, March 21, 2003 9:45 PM
Subject: RE: mysqld got signal 11; (CRASH max-3.23.51) What do I need to do
to clean up?
> I wouldn't run 3.23.51, there have been major securit
I downloaded the RPM's from the Chicago mirror site and saved the files in a
directory "/data/downloads/mysql". I then maneuvered there using the GUI
file manager and double-clicked on the file names. That caused a GUI to
open up and it displayed status as it checked things out. When it displaye
Well, then I would buy a $50.00 product using MySQL, and then
your $5000.00 product. Oh, and subtract the $500.00 license fee.
I already have a license.
I prefer to pay a flat fee for each license, not a fee based on the
price of your software.
John Griffin wrote:
Hello David,
Since you were k
Ryan McDougall wrote:
I can't seem to wrap my head around this, please see if you can help me out. I
have 2 tables. One with some basic info but they are structured as follows.
info table:
IDNum(PK)
LName
FName
Title
Deladd
City
State
Zip
codes table:
IDNum (used only so that there could be a prim
I wouldn't run 3.23.51, there have been major security patches since then.
I always mess up the byte math, but it looks to me like you have 2 gigs of
ram in your box and you are allocating 2.3 gigs to mysql. With 263
connections you would have been using about 1.4 gigs, if you have anything
else r
At 14:04 21/03/2003 -0500, Tab Alleman wrote:
> Most probably you are running a server and the setup program
> fails to rewrite the file. Before run the setup.exe stop the
> current server.
Most probably you are correct. :)
I stopped the server and ran the set-up again, and this time it got much
Jeff-
Actually, thsee sound like the binary log files used primarily for
replication. If you're on host doctorpants, they'll be
doctorpants-bin.001
doctorpants-bin.002
doctorpants-bin.index
and so forth. If you don't want a write query log and aren't doing
transactions, remove the binlog option
Hey all,
I can't seem to wrap my head around this, please see if you can help me out. I
have 2 tables. One with some basic info but they are structured as follows.
info table:
IDNum(PK)
LName
FName
Title
Deladd
City
State
Zip
codes table:
IDNum (used only so that there could be a primary key :-/
> Most probably you are running a server and the setup program
> fails to rewrite the file. Before run the setup.exe stop the
> current server.
Most probably you are correct. :)
I stopped the server and ran the set-up again, and this time it got much
further, but I then encountered a new erro
Had my first mysqld crash today after a solid 4 month uptime.The details
are below.
The DB restarted, and I haven't been able to detect any corruption. Is
there anything I should be running to ensure the integrity of the Innodb
databases?
Running: mysql-max-3.23.51, Innodb databases, Dual I
At 9:33 -0800 3/21/03, Mark wrote:
Hi,
mysql seems to log bad queries, is there any way to keep this from
happening?
thanks,
- Mark
That's impossible. Queries are written to the binary log only after
they execute. (Queries are logged to the general log before they
execute, but your message subjec
we're using mysql-max4.04 on solaris 2.8. all tables are InnoDB tables.
I see in the data directory a series of -bin files. I'm assuming
these are the index files. Is this correct? the sum total size of these
files are larger than the files I've allocated for data. How can I
manage these files? Wh
Hi everyone,
I am using MySQL 3.23.49 and have started having a problem with the "load
data infile" command.
I recently created a new user with select,insert,update,and delete on one
table only (tableA). Because I want the user to be able to use "load data
infile" to load records into tableA, I
At 13:26 21/03/2003 -0500, Tab Alleman wrote:
Hi,
Ok now I've got my database completely copied on another server, so now
I'm doing a trial run of upgrading the copy-db to 3.23.56. I unzipped
the stuff and ran the SETUP.exe and after setting the parameters, the
SetUp programs runs a little bit and
Ok now I've got my database completely copied on another server, so now
I'm doing a trial run of upgrading the copy-db to 3.23.56. I unzipped
the stuff and ran the SETUP.exe and after setting the parameters, the
SetUp programs runs a little bit and then pops up this error message:
An error occurr
At 17:50 + 3/21/03, John Poltorak wrote:
Hi,
I'm new to the list having just tried to install MySQL v4.0 onto Linux
Redhat v7.3 using an RPM distribution.
You need to install both the server *and* the client RPM files.
According to the docs I should be able to set a password for the MySQL
ro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 21 Mar 2003, Christensen, Dave wrote:
> I'm trying to install the MySQL RPM's on a newly set up RH 8.0 box.
> Things seem to go well until I try to install the "server" RPM, which
> fails stating that it can't find libmysqlclient.so.10 on the
At 05:27 AM 2/18/2003, you wrote:
Hi,
I am a MySQL admin. I like it very much. It is very quick,stable and
easy in configuration.
But I have a boss, who has been told about InterBase. He told me I should
interest in the InterBase, because it is programmed by russian, who made a
great project and
Hi,
I'm new to the list having just tried to install MySQL v4.0 onto Linux
Redhat v7.3 using an RPM distribution.
According to the docs I should be able to set a password for the MySQL
root user by running mysqladmin, but I don't see this program. Where
should I expect it to be?
This is
Hi,
mysql seems to log bad queries, is there any way to keep this from
happening?
thanks,
- Mark
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Aman Raheja wrote:
Hello friends
A friend of mine is running the current version of MySQL on a Win2k machine,
and using ODBC to connect his VB application. Thinks it is slow !
Is there some free tool available on the net to check the perforamnce of
MySQ
At 18:12 +0100 3/21/03, Stefan Hinz wrote:
David,
I would like to suggest that a third condition be included in this list. It
seems that either of the other 2 comment characters, * -- * or
* # * are
also recognized by the parser within /* ... */.
"-- " means "comment to the end of the l
David,
> I would like to suggest that a third condition be included in this list. It
> seems that either of the other 2 comment characters, * -- * or * # * are
> also recognized by the parser within /* ... */.
"-- " means "comment to the end of the line". So,
SELECT "Hello" /* This is a
Look at the HAVING clause.
c are columns, t are tables
SELECT c1, c2, c3, sum(c4)
FROM
WHERE t1.c1 = t2.c1
AND t2.c2 = t3.c2
HAVING sum(c4) > 0
-ms
-Original Message-
From: Sorin Marti [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 2:36 AM
To: [EMAIL PROTECTED]
Subject: Re:
On Tue, 2003-02-18 at 13:55, Bernhard Döbler wrote:
> Hi,
>
> the OpenSource GPL'd version of InterBase 6.01 is called Firebird and is available
> from: http://sourceforge.net/projects/firebird
>
> On Hannover CeBit'2002 I talked to a guy from MySQL AB. It was the
> time the Firebird 1 release
Hello David,
Since you were kind enough to clarify some matters on licensing I was hoping you would
also be open to suggestions. Instead of charging a flat fee for each copy of MySQL
that is resold why not charge a percentage up to a certain point. It might make it a
bit easier for developers w
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
> Why do you want to store the sum of columns? You can just sum them when
> you retrieve data.
The database has got about 1 million records, and it gorws day by day
The query I need returns lots of records, and calculating it while
retrieving data
Good Morning!
I'm trying to install the MySQL RPM's on a newly set up RH 8.0 box. Things
seem to go well until I try to install the "server" RPM, which fails stating
that it can't find libmysqlclient.so.10 on the computer. What do I have to
do to get around this problem?
Thanks!
David Christen
Hi,
I'm working for a client that has an auction application using MySQL.
We have a program to simulate the load when N users have an auction
page open. The auction page pings the server for updates every
few seconds, and that ping results in two UPDATEs and 64 SELECTs.
I have cut the statement
Hello friends
A friend of mine is running the current version of MySQL on a Win2k machine,
and using ODBC to connect his VB application. Thinks it is slow !
Is there some free tool available on the net to check the perforamnce of
MySQL on Windows platform or is there a reason why it might be slow o
On Tue, 2003-02-18 at 18:06, Ben Clewett wrote:
> This will be my last posting. I don't belive I am being constructive
> and have no wish to instantly be hated by the whole of MySQL.
>
> Michael T. Babcock wrote:
> > Ben Clewett wrote:
> >
> >> MySQL say that this is an extension of the applica
On Wed, 2003-02-19 at 08:14, Damir Dezeljin wrote:
> Firstly excuse my poor english ;)))
>
> I read the entire mail thread. I'm useing MySQL for our own data storage
> (I use it to store our oceanographic data for internal use) - I guess that
> I don't need a commercial license for this.
>
> I ha
On Thursday 20 March 2003 21:56, dleetest at kw dot com wrote:
> It seems that this error occurs only when I try to access mysql tables with
> many rows. Just wonder if anyone knows what is the cause and how to prevent
> it.
There are a lot of possible causes. Check these link, they can help you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Christian Andersson wrote:
Hi there, I have a friend that is running mysql 4.10 gamma on his
windows XP machine and he is having problem with an java application
that uses jdbc to connect to mysql..
from what I coudl see it sometimes worked and it so
On Thursday 20 March 2003 21:10, Juan Nin wrote:
> Imagine I have a table with 3 colums (column1, column2, column3), which are
> of type INT.
>
> I want the data in column3 to be generated automatically from the one in
> column1 and column2 when it is inserted
> For example a sum, that the data in
Howdy All,
The MySQL Reference Manual lists 2 limitations on the way the mysql client
parses /* ... */ comments, these being:
Single-quote and double-quote characters are taken to indicate the
beginning of a quoted string, even within a comment.
If the quote is not matched by a sec
On Thursday 20 March 2003 22:42, John Hardin wrote:
> It would be really nice if there were some way (a variable) to make
> MySQL totally ignore certain directories in the datadir - for example,
> "lost+found", "RCS", and suchlike.
>
> The listed dirs should not show up in SHOW DATABASES and you s
On Thursday 20 March 2003 23:25, Andreas wrote:
> I'm trying to get going with InnoDB.
> As for now I created several tables which relate to each other with some
> foreign key restrictions.
>
> mysqldump --all --opt writes 6++ MB stuff in a textfile that mysqld
> won't accept without SET FOREIG
Gerald R. Jensen wrote:
> I just ran your query (create and both inserts), and it
> worked like a charm on a Win32 MySQL 3.23.52.
>
> Just out of curiousity, why are putting the \r in?
>
Gerald (and all who were interested),
I didn't put the \r in, actually...mysqldump did. The solution to the
On Friday 21 March 2003 08:01, sivakumar wrote:
> Hai, am having the problem in creating CD of my project(Online
> Tutorial).While creating the CD only am having the problem. Actually am
> working in SSH(linux),right.
>
> I have to make a dump of my source code and mysql ..to copy (from server to
>
On Friday 21 March 2003 11:13, Filip Rachunek wrote:
> I have this problem with MySQL 4.0.12. When I run the following SQL query,
> I get this result:
>
> mysql> select last_move_date_time, days_per_move,
> (unix_timestamp(last_move_date
> _time) + 7 * 24 * 60 * 60 - 1048188722) as time_left from t
Hi there, I have a friend that is running mysql 4.10 gamma on his
windows XP machine and he is having problem with an java application
that uses jdbc to connect to mysql..
from what I coudl see it sometimes worked and it sometimes did not
work... why I had no idea... but after digging somewhat
Sorin,
>> Okay, here for another wild guess:
>> SELECT u.login, p.name, sp.name, SUM(t.time)
>> FROM t_user u
>> LEFT JOIN t_project p ON 1
>> LEFT JOIN t_subproject sp ON p.id = sp.project_id
>> LEFT JOIN t_time t ON ?? = ??
>> WHERE u.login = 'amg'
>> GROUP BY p.name
>> Where I'm not sure if you
Stefan Hinz wrote:
Okay, here for another wild guess:
SELECT u.login, p.name, sp.name, SUM(t.time)
FROM t_user u
LEFT JOIN t_project p ON 1
LEFT JOIN t_subproject sp ON p.id = sp.project_id
LEFT JOIN t_time t ON ?? = ??
WHERE u.login = 'amg'
GROUP BY p.name
Where I'm not sure if you will need t
Sorin,
> If there are entries which are:
> 60 / amg / 5
> 120 / amg / 5
> (in this example '5' is the id of the calculation-subproject)
> Then the result should be:
> +---+---+---+---+
> | login | name | name |
Hi,
ConnectTel is pleased to announce the release of XQX
Version 1.0-Beta.
XQX is a XML interface to relational databases. It
allows access to
Relational Databases using a XML interface.
XQX is an innovative product which enables enterprises
to make their
data accessible, in an easy and effectiv
Hi,
I am facing a problem with "net stop mysql" command to stop mysql. I waited
for 10 mins and it never stops. This happens whenever I add a new innodb
data file. Following are the versions of s/w I am using.
OS - Windows professional, with service pack 2
Mysql - 3.23.48 and 4.0.12.
Thanx i
Hi all,
I posted my question a short time ago and didn't receive any answers. So
I am trying describe it better.
I want to select For every user (from table t_user), every project (from
t_project) and from every project I want to select every subproject
which has the id of the project (t_subpr
Sorin,
> SELECT u.login, p.name, sp.name, t.minutes
> FROM t_user u
> LEFT JOIN t_project p ON 1
> LEFT JOIN t_subproject sp ON p.id = sp.project_id
> that gives me every subproject and the project where it belongs to for
> every user.
> Now I want the SUM of the time (t.hours) worked on the sub
Andrew,
> In phpMyAdmin 2.3.0 the 'Or Location of the textfile ' instead of running a sql
> statement does this have to be a txt file or can it be a .sql file?
> Or if it is a .sql can I just rename the file so it is a txt file?
The file extension doesn't matter. The .sql files PhpMyAdmin wants i
The following should do the trick
mysql> LOAD DATA file_name.ext INFILE INTO TABLE table_name
Paul
-Original Message-
From: Andrew [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 3:58 AM
To: [EMAIL PROTECTED]
Subject: RE: sql or import file
Hi Paul
Its a backup of phpbb so its
In phpMyAdmin 2.3.0 the 'Or Location of the textfile ' instead of running a sql
statement does this have to be a txt file or can it be a .sql file?
Or if it is a .sql can I just rename the file so it is a txt file?
Why is importing a large file inot MySQL so damn difficult. It would be so easy
f
Wendell,
- Original Message -
From: "Wendell Dingus" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, March 21, 2003 5:42 AM
Subject: RedHat 8 SRC RPM 4.0.12 Build
> Is the inability for 4.0.12 (and previous) SRC RPMs to build on RedHat 8
the
> fault of something in M
Hi Everybody
Could you know How can I add Connect/J Support to the MySQL
I downloaded mysql-connector-java-2.0.14.tar.gz then un-package
it after that I copied mysql-connector-java-2.0.14-bin.jar file to under the
tomcat/lib directory after that restarted tomcat for this
Benoit,
- Original Message -
From: "Benoit St-Jean" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, March 21, 2003 4:54 AM
Subject: Stopping InnoDb recovery and fixed columns
> I recently had a bad experience with a "feature" of
> InnoDb. Whenever the server crashes,
Hi all,
I tried around a long time. Has no one an idea?
my query:
-
SELECT u.login, p.name, sp.name, t.minutes
FROM t_user u
LEFT JOIN t_project p ON 1
LEFT JOIN t_subproject sp ON p.id = sp.project_id
that gives me every subproject and the project where it belongs to for
every user.
Now
sunil sharma said:
> Dear Friends
>
> I am new in this list
> I am using mysql on linux
>
> My problem is about the backup of mysql database
>
> We are having 50 Databases and each database is of
> minimum of 300 MB in size and maximum of 2 G.B size
>
> I am planning to take incremental backup of
I have been using mysqldump -a to backup my clients sites.
I have discovered a problem with this aproach. I decided to
try and restore it with mysqlimport on my local hd and it'll
restore it up to a certian point then stop. What I'm looking
for is any other recomendations to backup and restore 7
Not an issue since you don't need to edit the htaccess file for every file.
You set it for the whole directory.
The only reason for preventing ppl to access files would be theft of
bandwith. If you worry about ppl being able to get the images then you
shouldn't publish them at all. You can't pr
Jerry M. Howell II wrote:
sunil sharma said:
Dear Friends
I am new in this list
I am using mysql on linux
My problem is about the backup of mysql database
We are having 50 Databases and each database is of
minimum of 300 MB in size and maximum of 2 G.B size
I am planning to take incremental back
Tab,
>> file). Anyway, it can't help to try the following:
>> C:\mysql\bin>>mysql --max-allowed-packet=32M < \dev_hotel_data.sql
> Thanks, I'll try that... But in the meantime, is there something I can
> do to get Mysql to show me more information about the syntax error? I
> think that the diffe
sunil sharma said:
> Dear Friends
>
> I am new in this list
> I am using mysql on linux
>
> My problem is about the backup of mysql database
>
> We are having 50 Databases and each database is of
> minimum of 300 MB in size and maximum of 2 G.B size
>
> I am planning to take incremental backup of
Wynne,
- Original Message -
From: "Wynne Crisman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Sent: Friday, March 21, 2003 5:18 AM
Subject: Re: fulltext search
> Since InnoDB tables don't support fulltext searching yet, what is the
> recommended w
Hello,
I have this problem with MySQL 4.0.12. When I run the following SQL query, I
get this result:
mysql> select last_move_date_time, days_per_move,
(unix_timestamp(last_move_date
_time) + 7 * 24 * 60 * 60 - 1048188722) as time_left from two_player_game
where
id = 44970;
+
Don't forget that the images can be stored *outside* the root dir. Access
them using ../../ until you reach your img dir. There's no way to get to the
images directly then.
Paul
-Original Message-
From: lasse [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 12:14 AM
To: unlisted-rec
If I do a query on a table which has a column of the 'text' type, I get the
following error: "Positioned request cannot be performed because result
set was generated by a join condition". This is on a simple select with a
join between two tables.
I'm using a wrapper class from codeproject.com to
1 - 100 of 104 matches
Mail list logo
