, 2011 at 12:46 PM, Frank Chang wrote:
> Good afternoon, We developed a C++ class algorithm and code together with
> sqlite3.c and the sqlite C/C++ UDFs. Everything is combined into a single
> Windows DLL/UNIX-LINUX SO
>
> Now we would like to change from SQLite to MySQL to ta
Good afternoon, We developed a C++ class algorithm and code together with
sqlite3.c and the sqlite C/C++ UDFs. Everything is combined into a single
Windows DLL/UNIX-LINUX SO
Now we would like to change from SQLite to MySQL to take advantage of
MySQL's ability to do parallel writes on separate thre
used for spam purposes nor I offered products.
Please, how can I use the list so that I can response to posts?
I read the list via gmane.org
Best regards
Frank Becker
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
I'm looking to engage a developer with php / mysql experience in
Adelaide, Australia for full time employment or contract basis.
Please email me if you are interested.
Regards,
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
interessting to, how I will have
to import the data. Does this work once, or will I have to divide the data in
several parts for import?
Best Greetings,
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub
ask. I don't want a master of desaster.
You asked for arrows. Here are they:
Master3 (virtual) <--> Master1 <--> Master2 (virtual)
^
|
v
Master4 (virtual)
Thank you for your help.
Frank Bec
regards
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
rticles where
'peter' and 'mary' are among the authors;
or find all articles where 'peter' is an author but 'tom' not;
etc.
If there would be no possibility to do that, how could I redesign my tables?
Best regards,
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Varuna Seneviratna schrieb:
I added a line to the [mysqld) group
As --defaults-file="C:\WINDOWS\my.ini" and then I restarted the
service.Everything was fine.Then I took out the my.ini file in the MySQL
instalation directory the result was an error message AS
Could Not start the MySQL Service on
s there a way to find out why MySQL crashed?
Regards,
Frank
--
View this message in context:
http://www.nabble.com/MySQL-crash-on-Debian-Etch-system-tf4857583.html#a13900443
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: htt
ecame more effort than it was worth, so the
systems might be slightly out of sync. Perhaps I can just ignore the
checksum differences for that particular table...
I'll let you know the results.
Thanks,
Frank
Baron Schwartz wrote:
Frank,
Frank Bottone wrote:
I've been having tr
Fix the problem, and restart the slave SQL thread with "SLAVE START". We
stopped
at log 'mysql-bin.000105' position 893425700
Any help or ideas tracking this down would be appreciated - I think we
are going to have to take down the production database to resync the two
a
a changes during the dump.
o you can set up more slaves to spread the workload even more
From what you told about the completion time of your dump it seems you
should re-design your whole MySQL setup.
Regards,
Frank.
--
Dr. Frank Ullrich, DBA Netzwerkadministration
Heise Zeitschriften Verlag
Thank you to everyone who replied. It turned out I had index corruption and
after running an OPTIMIZE TABLE I was able to convert all the records to
InnoDB.
Thanks,
Frank
be posting output from my latest conversion attempt in some time.
--Frank
Jim Winstead wrote:
> On Thu, Jul 20, 2006 at 08:41:23AM +1200, Frank wrote:
>> Dear all,
>>
>> is it a desired feature that the embedded version of the client library
>> still tries to create a network connection when I pass a hostname into
>> connect?
>
&
to the embedded
server?
Regards,
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
in order to size the innodb buffer cache optimally it would really be
beneficial to see what it is composed of and how much memory each of the
components (also internal structures!) consumes.
Is there any chance to get this information?
Regards,
Frank.
--
Dr. Frank Ullrich, DBA
ement
for each and parse the output.
Cheers
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Nico Rittner wrote:
> Hi Frank
>
>> what I meant was: are you sure that the tables which are in your database
>> are defined correctly, i.e. have the actions?
> Yes, if i try to delete or update a record which is referenced by another
> i get mysql error #1217 ,
innodb files/tables (*.ibd).
Regards,
Frank.
--
Dr. Frank Ullrich, DBA Netzwerkadministration
Heise Zeitschriften Verlag GmbH & Co KG, Helstorfer Str. 7, D-30625 Hannover
E-Mail: [EMAIL PROTECTED]
Phone: +49 511 5352 587; FAX: +49 511 5352 538
--
MySQL General Mailing List
;
> Thanks,
>
> Nico
Hi Nico,
what I meant was: are you sure that the tables which are in your database
are defined correctly, i.e. have the actions?
The fact that "show create table" does not display them, implies that they
might have been "lost" somewhere. Can yo
e (without the
references to other tables) and added and "on delete" clause, which was
dumped fine. Could be a bug in 4.1.14 of course.
Sorry to ask this questions, but are you confident that the action clauses
work properly, i.e. the tables were created correctly?
What do you see
#x27; when altering
> the table with forein keys.
>
> Thanks,
>
> Nico
Hi Nico,
are you using the InnoDB storage engine for your tables?
If not, the clauses will not be included in the dump, as only InnoDB
supports foreign keys.
When you create a non-InnoDB table which has a foreign key spec
by a manager
written in QT - which can provide the required portability.
If portability is not such a concern for you, check out dwebpro, it's quite
good.
Another project, I've tried but with which I was not very happy is WAMPonCD
(http://www.x-author.de/en/tools/amp/x-author.html).
e values appended to the
> end.
>
> is there switch that puts it back to the old way of separate inserts
> for each row?
>
> Thanks
> Randy
Hi Randy,
since 4.something extended-inserts are used by default.
Use
mysqldump --extended-insert=false
to get the old behaviour.
Chee
can either bind to one or all addresses.
Cheers
Frank
see sql/mysqld.cc:
case (int) OPT_BIND_ADDRESS:
if ((my_bind_addr= (ulong) inet_addr(argument)) == INADDR_NONE)
{
struct hostent *ent;
if (argument[0])
ent=gethostbyname(argument);
else
{
sheeri kritzer wrote:
> Frank,
>
> 1) Check out the FEDERATED storage engine, that might help.
>
> 2) You cannot specify a different location for a read database and a
> write database.
>
> 3) Another solution is to use multiple databases -- each database is
> jus
Id
If your version does not support sub-queries, have at look at
http://dev.mysql.com/doc/refman/4.1/en/rewriting-subqueries.html
Cheers
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
omething very wrong.
>
> Maybe someone can point me in the right direction?
>
Hi Adrian
you can check whether a trigger exists by querying the information schema
database:
http://dev.mysql.com/doc/refman/5.0/en/triggers-table.html
Hope that helps.
Cheers
Frank
--
MySQL General Mailing
e.
Cheers,
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> mysql mysql <
zm_create.sql.in ERROR 1045 (28000): Access denied for user
'frank'@'localhost' (using password: NO)
It wants to default to the OS user who is logged in and that user is NOT in
the mysql database and does not need to be. I tried to insert the -u r
d recipient or a person responsible for delivering
> the
> information to the named recipient, you are notified that any use,
> distribution, transmission, printing, copying or dissemination of this
> information in any way or in any manner is strictly prohibited. If you
> have
> received this communication in error, please delete this mail & notify us
> immediately at [EMAIL PROTECTED]
>
> www.sify.com - your homepage on the internet for news, sports, finance,
> astrology, movies, entertainment, food, languages etc
>
--
Frank DeLaTorre
408.390.0415
no clue what reason it
could be. In fact i'm a little bit confused right now.... so any help is
very welcome.
Greetings
Frank
From: Gleb PaharenkoDate: December 28 2005 4:01pm
Subject: Re: Replication A->B->C - changes on B are not replicated to C
Hello.
>So now my questio
his or doesn't mysql
replication mechanism support this setup? If it is possible: Any idea where
the problem could be? If it's not possible: any idea for a different setup
that would allow to this?
Thanks a lot for your help.
Kind regards
Frank
?
--
Frank Rust, Technische Universität, Institut für Theoretische Informatik
Tel.: +49 531 391 9525 Postfach 3329, D-38023 Braunschweig
Fax.: +49 531 391 9529 Mühlenpfordtstr. 22-23, D-38106 Braunschweig
--
MySQL General Mailing List
For
Hi all
I got it - just found another posting that briefly explains how it's done. I
gave it a quick try on my workstation and i works (nevertheless i dunno what
i shall do with 3 instances of mysql on my workstation lol).
http://lists.mysql.com/mysql/115628
Cheers
-Frank
> -
ifferent service names and refering to different
my.cnf files?
Thanks a lot for your help!
- Frank
ot an error.
I know, that I'm able to use creation=now() in the insert statement, but
parts of the code are encrypted and I can't change them. So I need a way to
handle that without modifying the statements.
Got any ideas?
Frank Busch
At 07:03 PM 7/22/05, Siegfried Heintze wrote:
I'm having trouble getting the like clause to work. It seems to work fine in
the MySQL Control Center 9.4.beta. I'm using MySQL 4.0.23-debug.
use DBH;
my $sth = DBH->prepare("SELECT 'David!' LIKE '%D%v%'");
$sth->execute();
my $row;
print join(@$row
At 09:39 AM 7/21/05, Scott Hamm wrote:
M$ SQL executed and brought up result in 2 seconds
where MySQL took 801 seconds and where
Batch datalength is around 18.5 MB,
QAErrors is around 464KB and
QA is around 3.5MB
Did you create an index?
--
MySQL General Mailing List
For list archives: http
data will
be _much_ easier to work with. If you want a history then you need to
insert a new record for each datapoint that you get, with, as Frank
suggested, a date/time column. How large your table will get will depend
on the number of monitors and how often you retrieve data. Depending on
At 01:49 PM 7/2/05, nephish wrote:
i am writing a database to track what a bunch of electric monitors are doing.
the status of the monitor changes almost daily. i need access to each
monitor, when it changed, and i also need to track its history. Easy
enough. but if i update a row in a table,
ocation.
See: http://www.mysqluc.com/pub/w/35/sessions.html "New InnoDB Features"
David
Regards,
Frank.
--
Dr. Frank Ullrich, DBA Netzwerkadministration
Heise Zeitschriften Verlag GmbH & Co KG, Helstorfer Str. 7, D-30625 Hannover
E-Mail: [EMAIL PROTECTED]
Phone: +49 511 5352 587
At 09:01 AM 6/18/05, madderla sreedhar wrote:
> Isn't MySql supports large amounts of data to be stored in
> databases. What is the maximum number of records that
> can be handled or stored in Mysql. Is there any limit. If i
> want to store large amounts of data then is it necessary
> to migrate
At 03:09 AM 6/16/05, Cory Robin wrote:
I need to speed up a search, big time.
I have an application that searches for records on a date field. If it
doesn't find an exact date match, it keeps searching adjacent days until it
finds a certain amount of records.
The problem now is, I'm using my
At 10:36 AM 6/13/05, Brian Dunning wrote:
On Jun 13, 2005, at 7:18 AM, Berman, Mikhail wrote:
How about an FTP service on your remote server?
No - I actually don't have any remote access directly to the MySQL
server. My ISP has separate machines for the database servers and the
web servers -
At 10:00 AM 6/13/05, Brian Dunning wrote:
I have to load my remote MySQL db's with about a gig of data -
phpMyAdmin only allows me to upload a 15MB CSV file, so I have to
painstakingly separate my data into 15MB chunks and upload them one
at a time. It's a huge pain and takes about two entire da
Wrong path, you are referring to an uri, not a path. Way off topic to
starting explaining basic file system stuff here.
You should be the same path you used when your uploaded the
file. Something like:
/home/chris/datafile.txt
Frank
At 10:06 PM 6/7/05, Chris wrote:
Well, in
At 03:59 PM 6/7/05, Chris wrote:
I have a simple php script which runs the following query:
LOAD DATA INFILE 'datafile.txt' INTO TABLE LocationTEMPSR12 FIELDS
TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
which generates the error:
File './mydabasename/datafile.txt' not found (E
call?
--
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Frank Schröder <[EMAIL PROTECTED]> wrote on 05/31/2005 03:18:11 AM:
Hello,
I have an InnoDB table running on MySQL 4.1.11 with multiple FK
constraints. I'm accessing it via JDBC from Java.
When an FK constraint fails with error 1216 I need to know w
At 05:23 AM 5/31/05, James M. Gonzalez wrote:
Im loading rows from a txt tab separated fields file into a MySQL table.
It mostly works, but the date format in one field is not the type that
MySQL likes. So right now Im loading it as a char field. Yes, it is ugly
and a pain to work with. I would l
RAINT `u_registration_ibfk_1` FOREIGN KEY (`DEVICE_ID`)
REFERENCES `u_device` (`DEVICE_ID`)
...
Is there a way of getting to the name of the last failed FK constraint
without using SHOW INNODB STATUS? What I need is the
'u_registration_ibfk_1' from the above example.
Any help is highly apprec
At 02:46 PM 5/27/05, zzapper wrote:
Today I designed a fairly cute error404.php page, which I'd like to reuse
in future.
Currently I rely on remembering that I created such a page for say ACME
Carpets.
Now and again my memory fails to remember which site I developed a piece
of HTML,PHP,Perl,J
My understanding is that RESTRICT and NO ACTION share the same behavior.
http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html
*
|NO ACTION|: In |ANSI SQL-92| standard, |NO ACTION| means /no
action/ in the sense that an attempt to delete or update a primary
key
hly appreciated
--
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 12:54 PM 5/13/05, Brian Dunning wrote:
I have a db of about 300,000 records and when I try to find one
random record like this:
select * from table order by rand() limit 1;
it can take several minutes. My Sherlock Holmes instincts tell me
that what I'm doing is somehow inefficient. What is the p
At 02:22 PM 5/10/05, Paul Halliday wrote:
Now, as time progresses the queires are getting slower and slower.
I know this is expected,
I don't think so. I thought that if the number of rows returned does not
change and an index is properly used, then query time should not change
significantly as
eady decided on MySQL and
Linux. This platform is not the answer to every environment; like those
that require features only available in beta releases.
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 11:07 AM 4/27/05, Jigal van Hemert wrote:
So, if we would define that the key entry "0-NULL-Whatever" equals
"0-NULL-Whatever" (which MySQL is capable of if you look at the definition
of UNIQUE indexes with BDB tables) then allowing NULLs as part of a key
entry would not permit duplicate entries
At 08:49 AM 4/26/05, Jay Blanchard wrote:
[snip]
http://dev.mysql.com/doc/mysql/en/silent-column-changes.html
mentions that "Columns that are part of a PRIMARY KEY are made NOT NULL
even
if not declared that way. "
And http://dev.mysql.com/doc/mysql/en/create-table.html tells me that "A
PRIMARY KEY
At 02:07 PM 4/25/05, Scott Gifford wrote:
[EMAIL PROTECTED] writes:
> Frank Bax <[EMAIL PROTECTED]> wrote on 04/25/2005 11:47:12 AM:
>> Or simply use "split", default is 1000 lines, but can be changed via
>> command line.
That's a start, but the files each
At 10:44 AM 4/25/05, Art.M (Wikki) wrote:
I have a large .sql file to upload which is about 9 mb and I was
wondering if anyone knew of a program that could break it up into
chunks of 2 mb or under? So I can upload it to a shared web server.
You can't upload a 9M file to webserver? But you can upl
At 03:12 PM 4/22/05, Jay Blanchard wrote:
[snip]
Thank you for your reply. Can you provide more details on how to write
to a MySQL table from Excel? I am a newbie to MySQL. Thanks.
[/snip]
You must be new to mailing lists too...
http://catb.org/~esr/faqs/smart-questions.html
You can save the excel
At 03:20 PM 4/21/05, Scott Hamm wrote:
However when I used left join (trying to learn it) I issued this command:
SELECT
QA.OperatorID,
QA.QAID,
QA.BrandID,
QA.Batch,
QA.KeyDate,
Batch.[Order],
Batch.Errors,
Batch.Comments
FROM
At 11:22 AM 4/21/05, Darryl Hoar wrote:
I am running Mysql 3.23. Is there an sql statment that will allow me
programmatically to retrieve the names of the tables in a database ?
show tables;
Yes, this is an SQL statement!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
At 11:21 AM 4/15/05, Ian Gibbons wrote:
On 15 Apr 2005 at 9:47, mos wrote:
> I'm running MySQL 4.1.10 on XP and I was doing a 2 table equi join join on
> a date field that was indexed. There are It was taking quite a long
time so
> I let it run overnight. There are 200 million rows in the first t
At 09:22 AM 4/15/05, DebugasRu wrote:
taken from the manual 3.6.2 The Row Holding the Maximum of a Certain Column
which of the two queries will in general be faster:
1)
SELECT article, dealer, price
FROM shop
WHERE price=(SELECT MAX(price) FROM shop);
2)
SELECT article, dealer, price
FROM shop
ivity to a table" - does MySQL ever
close a file? If I create a table and run a select on it, then there is no
access to that table for months (and MySQL is not shutdown or restarted),
does MySQL still have the file open?
Yes, I ran myisamchk and there are no problems with database.
Frank
At 10:07 AM 4/5/05, Frank Bax wrote:
At 04:27 PM 4/4/05, Frank Bax wrote:
Cannot execute query.
Can't find file: './donor/list_lst.frm' (errno: 9)
- -
I got the same error last week on a different table. Today I notice that
there is a table in another database
At 04:27 PM 4/4/05, Frank Bax wrote:
Cannot execute query.
Can't find file: './donor/list_lst.frm' (errno: 9)
- -
I got the same error last week on a different table. Today I notice that
there is a table in another database on same system producing the same
error.
it just locked up after
entering password. Start/stop mysql and mysql cli at least started but
issued errors about some tables even before I entered a command. I decided
to reboot and the problem goes away (for a while).
MySQL 4.0.20 - OpenBSD 3.6
Frank
--
MySQL General Mailing List
For list
guages on
different databases when you try to make things easy of trust on automatism.
This always works.
Put all the checks and escapes into a function and call it instead of
mysql_real_escape_string... Then everything will be fine.
Frank Busch
...
leegold wrote:
> I'm rippin
recommend the first way and
never(!) trust on any automatic escaping PHP would do for you.
By the way... you might get more probs when you have backslashes in you
strings. You should double them, too.
Frank
> I fixed it. But I'm not clear on why. The following code ie. taking
> th
m t;
And you will get
+--+
| Species |
+--+
| Sample A1: 5 species_b |
| Sample A2: 3 species_c |
| Sample A3: 1 spec
On Fri, Jan 28, 2005 at 04:00:24PM +, Mat wrote:
> What Operating System are you running this on?
Linux 2.6, 64 bits.
MySQL 4.1.9.
> Also, is there anything in the errorlog?
Nothing, but as soon as I restart the server, it enters a strange state
where all slots are full with unauthenti
data
and to keep the server working?
Best regards,
-Frank.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
state. They weren't doing anything, just as
if they were waiting for a dead lock.
It didn't happen with MySQL 4.0 on the same hardware.
Bumping up the thread stack to 256 K seems to fix the issue, both with and
without NPTL.
Best regards,
-Frank.
--
MySQL General M
ata is not getting replicated. Need to
figure that out now.
thanks again.
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
One thing I left out is that we are running 4.1.8-Max-log not
4.1.8-standard-log
Could that have anything to do with it?
Thanks for any insight,
Frank
On Mon, 17 Jan 2005 15:55:06 -0500, Frank Febbraro
<[EMAIL PROTECTED]> wrote:
> Hey all,
>
> I have setup replication in th
never starts. There are no error
messages in any logs, or the show slave status screen. Below are my
relevant configurations. I am very sorry if I have left anything
significant out.
Thank you for any help,
Frank
MASTER CONFIG
~~
[EMAIL PROTECTED] cat /etc/my.cnf
[mysqld
You obviously do not understand auto-increment capability. You wouldn't
"get that value" of the sequence, because you would always retrieve the
same value. You would have to add a row to the 'extra' table for the
auto-increment field to work as designed, then use the highest value of
auto-inc
comment_base and
id_commentaire (primary key) from comment_content.
My obvious question is: why 3187 rows were examined since everything is
indexed and there's only one matching entry of the comment_content table for
every comment_base entry?
Best regards,
--
Frank - my stupid blog:
the field starts XXX, I want it
replaced with XXX with only the new text following.
TIA
--
Robin Lynn Frank - Director of Operations - Paradigm-Omega, LLC
Website: http://www.paradigm-omega.com/
RSS: http://paradigm-omega.blogspot.com/atom.xml
Spamtraps: http://paradigm-omega.n
At 12:15 PM 1/8/05, Tom Crimmins wrote:
[snip]
datetime is "displayed" as -MM-DD HH:MM:SS - it is *not* stored that
way. It is stored as a *nix timestamp - an integer number of seconds since
1970-01-01 00:00:00.
[/snip]
Actually datetime is not stored as epoch time. It has a range from
1000-01
At 06:00 AM 1/8/05, Ehud Shapira wrote:
I don't understand why DATETIME takes 8 bytes. It's just a waste, since
DATE+TIME take 6 bytes. And in fact, while DATE and TIME are each rounded
up to bytes on its own, a combined DATETIME should only take 5 bytes:
14 bits for year
04 bits for month
05
further test I would suggest that you take the data table (.myd
file?) from the 4.1.8 db and copy it into a __test__ 3.23 db replacing
the data table there (it's myisam isn't it?). See if the avatars are ok
when you read them from the 3.23 db.
Regards,
Frank.
I'm not too sure w
I'm using OpenBSD 3.6 (latest version) which comes with binary packages for
MySQL 4.0.20 - More recent binary packages are not yet available for this
platform and installation from source is not an option.
I have a table with datetime field and I would like to select all data
older than "X" wee
S
section becomes long.
What causes that behaviour and can you work around the problem?
Regards,
Frank.
--
Dr. Frank Ullrich, DBA Netzwerkadministration
Heise Zeitschriften Verlag GmbH & Co KG, Helstorfer Str. 7, D-30625 Hannover
E-Mail: [EMAIL PROTECTED]
Phone: +49 511 5352 587; FAX: +49 511 5352
I am aware of that.
But from my experience MySQL returns the the rows in the order that you
inserted them.
Assuming this is the case, I was wondering if the result I have seen means
that the order of autoincrement values does not correspond to the order in
which inserts are done.
Frank
On
table.
The inserts corresponding to ids (10, 11, 12, 13) are done inside one
transaction, the insert that generates id = 5, in another (concurrent) one.
Cheers
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Michael, Gleb,
thanks a lot for your hints!
Now I know that "default database" means "current database".
And I did not find Section 13.3.2 in the fine manual because I searched
for "default database" and we find the string "default (current)
database" t
p set just once
upon creation time without any changes later on.
How could this be done?
Thanks a lot for your help
Frank
a while but could not find an explanation.
So the question remains:
what is the "default database"?
Regards,
Frank.
--
Dr. Frank Ullrich, DBA Netzwerkadministration
Heise Zeitschriften Verlag GmbH & Co KG, Helstorfer Str. 7, D-30625 Hannover
E-Mail: [EMAIL PROTECTED]
Phone: +49 511 5352
Just curious...
While running SHOW INNODB STATUS, the "list of transactions for each
sessions" part shows queries that are only related to MyISAM tables.
Is it the expected behavior?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
I'm obviously missing something. I can use mysqlcc to change data in a
row of a table and save it. But, if I try to insert a row, add data and
save it, it never gets saved. What am I overlooking?
--
/"\ ASCII RIBBON Robin Lynn Frank
\ / CAMPAIGN Director of Operations
On Wed, Dec 08, 2004 at 11:25:55AM +0100, Bogdan TARU wrote:
> Everything went
> ok, up until the point when I tried linking PHP-4.3.9 against
> MySQL-4.1.7. After starting the new Apache/PHP (ldd httpd shows
> '/usr/local/mysql-4.1.7/lib/mysql/libmysqlclient.so.14'), I get a
> whole lot of Se
, just from somewhere that responded really slow, or it
tried, got some timeout, then gave up?
Thanks again...so happy.
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
best way to figure this out, not knowing this
could have been the case?
I truly apprecuate the help.
Regards,
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 278 matches
Mail list logo
