Philippe Rousselot wrote:
Hi
I have three linked tables : store, catalogue, and sales
store : ID_store, store, date
catalogue : ID_product, product
sales : ID_sales, ID_store, ID_product, product, quantity
I would like a view giving me ALL the products in catalogue with the
quantity per store
Hi,
Jerry,
Interbase/Firebird looks good on paper. But there are a
couple of
things to watch out for.
1) Check the Borland Interbase newsgroups for corruption to see if
it is
still an issue. I know from reading their newsgroups a few years back
,
there were quite a
shiva shankar wrote:
Hi,
I USE THIS FUNCTION TO INSERT VALUES TO DIFFERENT
VALUES OF MY DATABASE..
void InsertValues(const string tableName, const
string values)
{
char ValuesToStore[255];
long datasize;
char *EncodedData;
char *query;
strcpy(ValuesToStore, values.c_str());
SQL
Hi!
Does anybody have any solution?
I change time where query run.
Each new day where query run first ones in day replication crash.
Slave start on slave server restore replication.
How can it be?
I have no any ideas.
Both servers have 4.0.16
SQL
Hi all!
Nearly very night I have this
Thanks for reply!
1. mysql -u root -e create database t; show create database t; drop
database t
2. mysql -u root -e use_mysql; create database t; show create database
t; drop database t
1.| t| CREATE DATABASE `t` /*!40100 DEFAULT CHARACTER SET
cp1251 */
2.| t| CREATE
Mofeed Shahin [EMAIL PROTECTED] wrote:
mysql CREATE TABLE foo (
- ID INT PRIMARY KEY,
- note VARCHAR(50),
- First_Name VARCHAR(50),
- Last_Name VARCHAR(50),
- FOO_ID INT,
- INDEX(FOO_ID),
-
hello,
i'm working on a java-jsp-page with mysql-connection. now i've created a
test-system with myisam-tables where the tables are just read. my plans
for next weeks are, to make the owner of the site capable of
entering/changing his data by his own - web-based and multi-user-capable.
as
I have the same problem with cp1251 and, seems, it's a bug. I have posted
correspoding message two days ago. Without any reply 8(((
I migrate 3.23.55 - 4.1.1 and I don't know about existing such problem in
4.0.
Look in your table.frm - your field is in correct charset. More of,
inserts and
It's known bug, will be fixed in 4.1.2
- Original Message -
From: Juri Shimon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Noor Dawod [EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 12:37 PM
Subject: Re: Invalid ENUM values after upgrading from 4.0 to 4.1
I have the same problem with
-Original Message-
From: Brandon Ewing [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 2:28 AM
To: [EMAIL PROTECTED]
Subject: Issues with count(), aliases, and LEFT JOINS
Greetings,
This is driving me crazy.
I'm running MySQL 4.0.15-standard.
I've got a db that
Hi,
I can create new user with following.
mysqlINSERT INTO user (Host,User,Password)
VALUES('localhost','ads11',PASSWORD('ads11'));
mysqlINSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv) VALUES
Unless i'm misunderstanding(highly possible)...if you are on the command
line, you are going to be seen by mysql as localhost and not allnet.com.
You'll only be seen as another host if you connect remotely. the webserver
running on the localmachine and the mysql client will be seen as localhost.
On Dec 17, 2003, at 7:35 AM, Matthew Stanfield wrote:
Wouldn't it be great if all mailing lists and newsgroups were as
friendly and helpful as the mysql ones are.
shameless plug
I host a couple of lists: ProLinux and ProPython, which are for
developers that are new to Linux and Python, and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.17, a new version of the popular Open Source/Free Software
Database Management System, has been released. It is now available in
source and binary form for a number of platforms from our download pages
at http://www.mysql.com/downloads/
On Wednesday 17 December 2003 12:45, ads mysql wrote:
It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p
bankaccount
Enter password: (here I enter password 'ads11')
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
Domain www.allnet.com is
Situation:
Multiple DBs with the same named table in each DB.
Needed:
Grant insert to a named login to the named table in all DBs.
Not wanted:
A grant for each db.named_table combo :)
Am I right in concluding that my not wanted solution is the only solution to
this case? Ie, I'll have to
I tried to connect as follows :
#
[EMAIL PROTECTED] root]# mysql -h www.allnet.com -u ads11 bankaccount
ERROR 1130: Host 'xxx-xx-xxx-xxx.yyy.com' is not allowed to connect to this MySQL
server
#
It gives error.
I sthere anything giving permission to connect to mysql for particular
Hello,
I am in the process of installing Mysql 4.0.17. I need to have Mysql with SSL enabled.
Does this feature come enabled with the binary download? Or do I need to download the
source and compile
it?
Any good links ot setting up MySQL with SSL enabled?
Thanks
Rob
--
MySQL General
ads mysql wrote:
I tried to connect as follows :
#
[EMAIL PROTECTED] root]# mysql -h www.allnet.com -u ads11 bankaccount
ERROR 1130: Host 'xxx-xx-xxx-xxx.yyy.com' is not allowed to connect to this MySQL server
#
Your DNS is broken.
It gives error.
I sthere anything giving
Hi!
InnoDB is a MySQL table type which is included in all GPL versions of
MySQL-4.0 that you can download from http://www.mysql.com, and is included
in the commercial MySQL license MySQL Pro, which you can buy from
https://order.mysql.com/?sub=pgpg_no=1.
You can buy technical support for InnoDB
Hi,
I tried to create user with GRANt as follows :
mysql use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO
Please reply to the list so that others can follow this
discussion. Thanks.
At 8:26 -0700 12/17/03, Knepley, Jim wrote:
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 5:44 PM
To: Knepley, Jim; [EMAIL PROTECTED]
Subject: Re: Null-safe
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 5:44 PM
To: Knepley, Jim; [EMAIL PROTECTED]
Subject: Re: Null-safe equal help, please
At 15:22 -0700 12/16/03, Knepley, Jim wrote:
I've got a WHERE clause:
WHERE possibly_null_value IS NULL
If that error is verbatim from the console, then DNS may be working, but it
is not who MySQL is acknowledging you as, is there a firewall in between
you and the MySQL server? looks like you'd need a grant for
202-63-167-192.exatt.com.
and i know its not working, but you really shouldn't post
rmck wrote:
Hello,
I am in the process of installing Mysql 4.0.17. I need to have Mysql with SSL enabled.
Does this feature come enabled with the binary download? Or do I need to download the source and compile
it?
Any good links ot setting up MySQL with SSL enabled?
Good luck. Let me
MySQL checks the IP address of the user connecting to it's server. It then
does a Reverse DNS lookup on that IP address, to get the name associated
with it (there is only one name associated with any IP, the rest are just
aliases)
The host you are connecting from does not resolve to
On Wed, 2003-12-17 at 09:39, rmck wrote:
Hello,
I am in the process of installing Mysql 4.0.17. I need to have Mysql with SSL
enabled.
Does this feature come enabled with the binary download? Or do I need to download
the source and compile
it?
Any good links ot setting up MySQL
On Wed, 2003-12-17 at 09:39, rmck wrote:
Hello,
I am in the process of installing Mysql 4.0.17. I need to have Mysql with SSL
enabled.
Does this feature come enabled with the binary download? Or do I need to download
the source and compile
it?
Any good links ot setting up MySQL
Try changing it to this:
...
- COUNT(DISTINCT switch_connect1.switch_id) AS left_port_count,
- COUNT(DISTINCT switch_connect2.switch2_id) AS right_port_count,
...
I would suggest, if that suggestion fails, that you experiment with just
switch_connect.switch_port and
Greetings!
Is it common practice to name script variables/form data in say PHP to match
the appropriate colums in the db tables?
I can see how this makes sense, however in the little work I have done I
preferred to do the opposite as it seems to be helpful to keep a
distinction.
Thanks!
--
Well, I keep my internal script variables identical to the relevant MySQL
variable , with the exception of putting the type identifier in front of the
script variable (s for string, i for int, etc...)
I do the exact opposite of form data in trying not to have a form variable
with the same name as
As advised by other member of this mailing list, Let me check whether it is reverse
DNS problem. Reverse DNS is giving 202-63-167-192.exatt.com instead
www.networkshastrihall.com.
Regarding password, this is test database not in production . I am going to change all
settings later on. From
I have run into this a few times now, and am wondering there is a
solution:
I have two queries:
(1) select query on a MERGE table
(2) 'alter table' on the same MERGE table.
As expected, the select query will lock the 'alter table'
query. The alter table query is intended to swap one of the
From: Paul Fine [mailto:[EMAIL PROTECTED]
Greetings!
Is it common practice to name script variables/form data in
say PHP to match the appropriate colums in the db tables?
I can see how this makes sense, however in the little work I
have done I preferred to do the opposite as it seems
Hi Steve and Paul,
Thanks - the comma did get me!
Paul, no the mistake isn't in the manual - I managed it all on my own.
For anyone following, the correct sequence was:
mysql CREATE TABLE geom ( g GEOMETRY );
Query OK, 0 rows affected (0.05 sec)
mysql INSERT INTO geom VALUES (
At 10:55 AM 12/17/2003, you wrote:
MySQL checks the IP address of the user connecting to it's server. It then
does a Reverse DNS lookup on that IP address, to get the name associated
with it (there is only one name associated with any IP, the rest are just
aliases)
Suppose we wanted to associate
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT * FROM mytest.
How can I make it so that the table name is still MyTest
but selects work with mytest ?
--
MySQL General
At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote:
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT * FROM mytest.
How can I make it so that the table name is still MyTest
Hi all,
We're trying to upgrade from 4.0.2 max to 4.0.16
Everything starts fine, but when querying the DB, something as simple as
SELECT count(*) FROM myTable
will return errno 138, but this works fine before the upgrade.
Its probably something minor, but we're at a loss.
Im not sure what
Dear all,
I am trying the following mysql statement (probably it will be obvious
that I am a newcomer):
select IMdirectory, IMljd, count(*) as N from Images where IMstid
= 5, N 10 group by IMdirectory order by IMljd;
ERROR 1054: Unknown column 'N' in 'where clause'
My question is: how could I
Paul DuBois wrote:
At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote:
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT * FROM mytest.
How can I make it so that the table
At 12:52 -0500 12/17/03, Gaspar Bakos wrote:
Dear all,
I am trying the following mysql statement (probably it will be obvious
that I am a newcomer):
select IMdirectory, IMljd, count(*) as N from Images where IMstid
= 5, N 10 group by IMdirectory order by IMljd;
ERROR 1054: Unknown column 'N' in
use having N 10
The having clause takes the results of the query AFTER all of the rows have
been read and aggregated by the group by clause and further reduces the set
of rows that gets returned.
- original message -
Date: Wed, 17 Dec 2003 12:52:08 -0500 (EST)
From: Gaspar Bakos [EMAIL
I upgraded to Connector/J 3.09 from 2.0.14. After some hours, the driver
looses it's connection and will not reconnect (despite setting
reconnect=true). The error starts as follows below. I rollback to 2.0.14
and everything is stable again. This is using mysql 4.0.16-standard. Is
connector/j 3.0x
At 13:00 -0500 12/17/03, Mayuran Yogarajah wrote:
Paul DuBois wrote:
At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote:
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT *
Hello,
I have a 4.5 FreeBSD server with mysql database. only 250MB
was allocated to /var/db. Our database is increasing so fast that now
i need to expand the memory for /var/db. I guess one way to do is to
install a new hard drive and then mount it to /var/db. But i would
like to know if there
At 9:03 -0800 12/17/03, Naveen Babu wrote:
Hello,
I have a 4.5 FreeBSD server with mysql database. only 250MB
was allocated to /var/db. Our database is increasing so fast that now
i need to expand the memory for /var/db. I guess one way to do is to
install a new hard drive and then mount it to
Jerry Apfelbaum wrote:
I have been tasked with evaluating open source databases for a large
upcoming project: e-commerce, B2B, high availability.
Jerry -- See what I meant when I said:
very active mailing lists where list subscribers are helpful and quick to
respond.
I think we all deserve a
Yes, Matthew, the response to my original query here has been almost overwhelming, far
surpassing what I had expected.
Yes, you certainly all deserve a pat on the back.
Thanks to everyone who took the time to respond. This has proven to be a useful short
cut to ascertaining some of strengths
On Wednesday, December 17, 2003 1:58 PM CET, Lenz Grimmer wrote:
Functionality added or changed:
* `lower_case_table_names' is now forced to 1 if the database
directory is located on a case-insensitive file system. (Bug
#1812)
Uh, _very_ bad. I know that my Windows filesystem is
Hi,
RE:
In other words, you cannot use values that are determined from
the selected rows to determine which rows to select. :-)
Sounds very logical. In fact I was not surprised that my query did not
work, I just had no idea about the workaround.
Thanks again!
Gaspar
--
MySQL General
Dmitry,
we have to consider implementing
NOWAIT
and
SKIP LOCKED
clauses to SQL statements. The latter would be useful in implementing
transactional queues.
But there are lots of items in the TODO list. Do not expect these soon.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Felix,
I assume this is a MySQLCC bug.
Can you perform the ALTER TABLE from using the mysql interactive SQL client
program?
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - hot backup tool for InnoDB
Mofeed,
if you are using a relatively recent version of 4.0, or 4.1.1, please look
with
SHOW INNODB STATUS\G
what is the latest FOREIGN KEY error.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - hot
I agree, 100%. We live in a mixed environment of UNIX and Windows and as
such, we've assumed case insensitivity in our apps. I know that this is bad
practice, but forcing this flag on us is and even worse practice. This
should always, always be an option.
I wont be able to upgrade until this is
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 8:12 AM
To: [EMAIL PROTECTED]
Subject: RE: Issues with count(), aliases, and LEFT JOINS
Try changing it to this:
...
- COUNT(DISTINCT switch_connect1.switch_id) AS
On Wed, 17 Dec 2003 07:55 pm, Victoria Reznichenko wrote:
Mofeed Shahin [EMAIL PROTECTED] wrote:
mysql CREATE TABLE foo (
- ID INT PRIMARY KEY,
- note VARCHAR(50),
- First_Name VARCHAR(50),
- Last_Name VARCHAR(50),
- FOO_ID
Hi,
Just have a couple more full-text search inquiries here. :-)
I'm not exactly clear on how matching rows are found when searching for
2 or more required words: '+word1 +word2'. I understand that it can't
currently know which word occurs less, so that it can be searched
first -- this
Hi,
Just have a couple more full-text search inquiries here. :-)
I'm not exactly clear on how matching rows are found when searching for
2 or more required words: '+word1 +word2'. I understand that it can't
currently know which word occurs less, so that it can be searched
first -- this
Hmmm, Thanks for that.
But I'm not quite sure what it means.
Mof.
LATEST FOREIGN KEY ERROR
031218 8:48:23 Error in foreign key constraint of table moftest/foo,
FOREIGN KEY (First_Name, Last_Name) REFERENCES Blah (First_Name, Last_Name))
Hi!
I would like to remind people that if you want to move an InnoDB database
between Unix and Windows, you have to consider the following:
http://www.innodb.com/ibman.php#Moving
On Windows InnoDB stores the database names and table names internally
always in lower case. To move databases in a
Mofeed,
- Original Message -
From: Mofeed Shahin [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 12:20 AM
Subject: Re: foreign keys.
Hmmm, Thanks for that.
But I'm not quite sure what it means.
Mof.
Hi,
I saw the change as soon as it was posted last week or whenever and
didn't think anything of it. But the point Yves brings up seems very
important!
Although, I'm not sure what to do then with bug #1812. Too bad MySQL's
code can't make database/table names case-sensitive like on *nix. e.g.
Hello friendly helper types,
What is the problem here. I can't find any errors. I know it's there but as a
newbie I'm as blind as a bat at the moment. Thanks for your help.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource
Warning: mysql_fetch_row(): supplied
Jonck,
sorry, there is currently no way to detect InnoDB locks, except by setting
globally
innodb_lock_wait_timeout=1
in the [mysqld] section of my.cnf. Then your failing lock requests return
with the error 'lock wait timeout'.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Hello,
Was wondering if any one on the list has or is using PremiumSoft Navicat's MySQL
Administration Tool for windows, and if so, any thoughts on it... good,
excellent, poor...etc.
Appreciate the feedback ;)
TIA
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain
try adding an error report after the query
$result = mysql_query( select * from domains ) or die (mysql_error());
the rest looks OK
Peter
-Original Message-
From: Trevor Rhodes [mailto:[EMAIL PROTECTED]
Sent: 17 December 2003 22:26
To: [EMAIL PROTECTED]
Subject: Basic error
Hello
On Thu, 18 Dec 2003 09:05 am, Heikki Tuuri wrote:
Mofeed,
- Original Message -
From: Mofeed Shahin [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 12:20 AM
Subject: Re: foreign keys.
Hmmm, Thanks for that.
But I'm not
Mofeed,
- Original Message -
From: Mofeed Shahin [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 12:47 AM
Subject: Re: foreign keys.
On Thu, 18 Dec 2003 09:05 am, Heikki Tuuri wrote:
Mofeed,
- Original Message -
Hi Trevor
You haven't the query which connection to use:
$result = mysql_query( select * from domains, $link );
HTH
Steve Davies
Trevor Rhodes wrote:
Hello friendly helper types,
What is the problem here. I can't find any errors. I know it's there but as a
newbie I'm as blind as a bat at
From: Trevor Rhodes [mailto:[EMAIL PROTECTED]
Hello friendly helper types,
What is the problem here. I can't find any errors. I know
it's there but as a
newbie I'm as blind as a bat at the moment. Thanks for your help.
Warning: mysql_num_rows(): supplied argument is not a valid
Hello friendly helper types,
Forget it people. I'm an idiot. Just forgot to change the table name. Of
course then it at least had more clue as to what it was doing that myself.
I'm going away now, but you can be sure I'll be back with more silly
questions later. Bye. :^)
What is the
Andrew,
SELECT [STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] [HIGH_PRIORITY]
[DISTINCT | DISTINCTROW | ALL]
select_expression,...
[INTO {OUTFILE | DUMPFILE} 'file_name' export_options]
hehehe, Yeah figures that it was something stupid I did!!!
Thanks for that.
Mof.
On Thu, 18 Dec 2003 09:30 am, Heikki Tuuri wrote:
Mofeed,
- Original Message -
From: Mofeed Shahin [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 18,
Chris,
- Original Message -
From: Chris Nolan [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, December 13, 2003 7:24 AM
Subject: Questions about MySQL implementation
Hi all!
I've got a few questions that I was hoping some of the fine readers of
this list could
Chris,
- Original Message -
From: Chris Nolan [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, December 13, 2003 7:54 AM
Subject: Planned transactions?
Hi again all,
Given that a transaction looks like this:
BEGIN;
SELECT useless_field FROM useless_table
Carlos,
- Original Message -
From: Carlos Proal [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, December 12, 2003 4:09 AM
Subject: Innodb multiple tablespaces benchmark
Hi all, specially to Heikki.
Its really amazing that multiple tablespaces are available
Osvaneo,
you probably forgot to move also ib_logfiles.
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 7 1021600303
InnoDB: Doing recovery: scanned up to log sequence number 7 1021600256
It cannot scan the current ib_logfiles at all!
Best regards,
Heikki Tuuri
OK, ehm, considering Heikki's post, why does MySQL take care of
case-sensitive table names at all? I'm not that familiar with the whole
thing about it, but aren't database names also case-insensitive? I know that
column names are. So why isn't this option removed and table names are
generally
Hi!
Well, I checked the code and looks like in 4.0.17 lower_case_table_names
is NOT forced to 1 on case-insensitive file system, despite the
changelog entry (that we will fix, by the way). Obviously a programming
mistake, but for now only warning that lower_case_table_names is forced to 1
is
Hi Jamie,
Yes, when tables are made smaller in MySQL, the file size isn't
actually reduced. I guess it shouldn't usually make a speed difference
unless your SELECTs are doing a table scan. Reads that use an index
shouldn't really be affected, I don't think.
If you want to reclaim the deleted
Hi,
I'm Using the Same, the Tool is very much useful to me
to export data from one server to another online, and
for much more activities.
Excellent...
-Aman.
Mike Blezien wrote:
Hello,
Was wondering if any one on the list has or is using PremiumSoft
Navicat's MySQL Administration Tool for
Hi, I am not a database person. I have a database
called members. One of the fields in this database
is user_name. There are a number of records in
this database. Under the field user_name, I would
like to make some changes manually; for example, I
want to change
John Doe
to
john_doe
Hi,
I am trying to setup network having
1) Linux main server running IPTABLES firewall, squid, dns server.
2) LAN connected to main server.
2) DMZ having apache, mysql and php, mail server connected to main server.
User will use php script from remote host to connect to mysql as follows:
I have been using it for a long time is works fine !
:)
-
syed sanya
Amanullah [EMAIL PROTECTED] wrote:
Hi,
I'm Using the Same, the Tool is very much useful to me
to export data from one server to another online, and
for much more activities.
Excellent...
-Aman.
Mike Blezien wrote:
Hey all,
I don't like the default locations that mysql tries to install into.. I
like putting stuff in user accounts, with a version directory. Easier to
maintain, yada yada.
Anyways, as per the instructions you have to change a path in
./bin/mysqlaccess
I did this but when I run the
Martijn,
I've asked this question a year ago on the Borland forums but didn't get
any replies. Do you know of any websites (non-programming related) that are
using Interbase/Firebird for their primary webserver database? I don't mean
programmer hangouts like www.mers.com or www.tamaracka.com
Hi,
I am trying to setup network having
1) Linux main server running IPTABLES firewall, squid, dns server.
2) LAN connected to main server.
2) DMZ having apache, mysql and php, mail server connected to main server.
User will use php script from remote host to connect to mysql as follows:
Caroline Jen wrote:
Hi, I am not a database person. I have a database
called members. One of the fields in this database
is user_name. There are a number of records in
this database. Under the field user_name, I would
like to make some changes manually; for example, I
want to change
John Doe
Hello,
I am using MySQL 4.0.16 on Debian GNU/Linux at the moment. In this database
there are over 4,5 Mio. entries!
The Database crashs with follow errors:
031217 19:21:06 mysqld started
/opt/lampp/sbin/mysqld: ready for connections.
Version: '4.0.16-log' socket:
you can optionally use MySQL Front to view and edit data in GUI mode
get it free of cost athttp://www.mysqlfront.de/
Enjoy
Nitin
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Caroline Jen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, December 18, 2003
91 matches
Mail list logo