Ady,
the assertion failure means that a transaction object to be freed was not in
a committed or rolled back state.
Please try running your test as single-threaded, so that we see if this is
something repeatable. In the ideal case you could point out the transaction
which fails to do a commit
Hello!
I've set up replication with a master and two slaves, all running
3.23.43, and it works like a charm. Except for...
When the master goes down, the slave tries to reconnect after 60
seconds, but just once. I expected it to retry until it can connect,
because when the master comes up
Hi there...
I'm a very beginner in using mysql and i have a problem...
So i have a database in mySql, I connected myself to it through java, and if
I use as the host the localhost then everything goes well.
In the moment I try to connect myself remotely, i encounter problems. So on
the
screenshots at:
http://jfontain.free.fr/moodss3.gif
http://jfontain.free.fr/moodss4.gif
### CHANGES ###
--- version 15.2 ---
moomps first stable release 1.0
added importance level (emergency, alert, critical, error, warning,
notice, informational, debug) to thresholds in moodss interface
Hi Thomas
In VC++, go to project file, right clik there, select
setting then choose C/C++ then preprocessor. Here type
the path c:/mysql/include at include path options.
Also you have to add mysqlclient.lib for linker. To do
so you should go to Linker tab and explicitly type the
file in lib
hi,
I have been using mysql isam tables for a while.
Today i installed mysql3.23.44 and created the example table customer in the
test database.
But when i do a select or insert for this table i am getting the following
error.
Can't open file: 'customer.InnoDB'
Any ideas?
Kishor
Hi,
I had one question. I would like to set permission for remotely backup using
mysqldump. Let's assume I want to use B(10.0.0.2) server to remotely backup
A(10.0.0.1) server.
The command I run at B server are:
mysqldump --opt -h10.0.0.1 -uadmin -pXXX comers comers.txt
(p/s : I want to dump
After converting the data in my project from text files to MySQL tables,
things are certainly working more smoothly than they were before, but since
I use objects (in Perl, which barely supports objects, but that's another
story) I have to write a lot of annoyingly repetitive code to create
Alex writes:
Yea, but even doesn't check grant tables I think,
It just hangs up, waits about 30-40 seconds, and then says something
like 'Error 3303: failed to connect (110)'
(not sure about numbers, is there any way to find more detailed desription for
3303 error somewhere?)
CT
Hi,
The problem here is that you need to specify a user for this database, try
doing this on your server
%mysql -u root -p
Enter password: ***
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19 to server version: 3.22.32
Type 'help' for help.
mysql
Please let me know, how to handle huge numbers.
The problem is that I need to store numbers with lot more
than 16 decimal digits - e.g. 1234567890123456789012345.12
I already tried a decimal type but it caused errors (I mean
MySQL simply cutted the end of the numbers and stored only
the first 16
Thanks for the response,
but doing this results in :
ERROR 1093: INSERT TABLE 'myTable' isn't allowed in FROM table list
marc
-Ursprüngliche Nachricht-
Von: Nathan [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 14. November 2001 19:05
An: Votteler Marc
Betreff: Re: INSERT with SELECT
Thanks for the response,
you are right I would get an Exception describing that the record
already exists, but because I do not know which DBMS is being used
(one of Oracle, MS SQL and mySQL), I can not discern if it was a
'real' error or just the fact that the record already exists.
marc
Gyulay Gabor writes:
Please let me know, how to handle huge numbers.
I'll give you a suggestion or two, but first of all
I must ask you to set your time to something more
correct. If you're in the UK (or Portugal), your time
is off by about 7 hours. If you're elsewhere, I guess
your time zone
Bauer, Rich writes:
I am building mysql 3.22.26a with gnu cc 2.95.3 and gnu make under solaris 8
and get the following error. How do I fix this ?
# make
make all-recursive
make[1]: Entering directory `/opt/ftp/mysql-3.22.26a'
Making all in Docs
make[2]: Entering directory
At 10:37 AM 11/15/2001 +, [EMAIL PROTECTED] wrote:
Dear Bennett,
On Thu, 15 Nov 2001, Bennett Haselton wrote:
After converting the data in my project from text files to MySQL
tables,
things are certainly working more smoothly than they were before, but
since
I use objects (in Perl,
Alex Kirk writes:
I'm sure this question has been answered a million times, so please pardon
it again. If there's an appropriate FAQ, please point me to it.
My problem is fairly simple: I've set up a couple of users of the form
username@localhost. When I run a 'SELECT * FROM USER;' in
Garry Madrone writes:
I've downloaded the static binary mysqlgui-solaris-2.7-sparc-static-1.6. Although
this appears to be a gzip file, it did not have a .gz extention. It also seems
to be only a single file. I gunzipped the file and tried to execute it on
Solaris 7. The result is:
Hi,
We are trying to implement row level locking in our appln.
we have a table Order
we are locking the table using
SELECT * FROM Order FOR UPDATE;
but still another user is able to update this table. why?
we have autocommit set to zero.
Our requirement is
1. user selects a order for
What version of MySQL are you using and is it our binary ??
It's 3.23.37. I built it from source on my OpenBSD-2.9 box (i386
architecture). It didn't appear to have any trouble when I built it.
Also check the integrity in mysql database with CHECK TABLE.
mysql check table user;
Alex Kirk writes:
What version of MySQL are you using and is it our binary ??
It's 3.23.37. I built it from source on my OpenBSD-2.9 box (i386
architecture). It didn't appear to have any trouble when I built it.
Also check the integrity in mysql database with CHECK TABLE.
mysql
Does anyone know where to get a dictionary that would be for sql. I was
attempting to write up a few scripts for password stuff and thought it
would be easy if someone knew where to obtain a dictionary in sql
format. Any ideas would be helpful.
Thanks
On Wed, 14 Nov 2001, Aaron Williams wrote:
At 3:54 PM + 11/14/01, M. A. Alves wrote:
On Wed, 14 Nov 2001, Aaron Williams wrote:
. . .
I am not expert on innodb, or mysql either. I started playing with
those values after reading the performance guide on Innodb.com.
What is this
Description:
Requests are much longer when using IN instead of =, even
if the list specified after IN has only one element.
How-To-Repeat:
create table tmp (a integer, b integer, c integer);
create index tmp_id on tmp (a,b,c);
insert into tmp values
| One more question is how to transfer these values through
| the MySQL C api ?
try this site...
http://www.mathtools.net/C++/Extra_precision_computation/
ati
-
Before posting, please check:
Hi,
Is it possible to drop an auto_increment column index or primary key to
boost performance for bulk inserts? It seems mysql requires auto_increment
columns to be a key at all times.
Here is the error message:
Incorrect table definition; There can only be one auto column and it must
Paul DuBois wrote:
Am I making wrong?, is there some function just to retrieve qty records
selected in a query?
mysql_num_rows() is intended for SELECT queries. Its argument should be the
result set identifier.
Thanks , I checked again, and problem was exporting scripts from Windows to
If you consider JSP, then JSP, Servlets, and MySQL by David Harms is
excellent.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 14, 2001 4:11 PM
To: Webmaster
Cc: [EMAIL PROTECTED]
Subject: Re: Need A book for dynamic website
On Wed, Nov 14,
Kishor,
Hi,
We are trying to implement row level locking in our appln.
we have a table Orderwe are locking the table using
SELECT * FROM Order FOR UPDATE;
but still another user is able to update this table. why?
check with
mysqlSHOW TABLE STATUS FROM yourdatabasename;
that your
Bennet MySQL documentation says that CHAR and VARCHAR types are case-insensitive:
Bennet http://www.mysql.com/doc/C/H/CHAR.html
Bennet But I have a table with a column of type VARCHAR(255), and if I do a query
Bennet like
Bennet select * from user where LOCATE('Bennett',
Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Grzegorz Paszka writes:
On Mon, Nov 12, 2001 at 07:21:07PM +0200, Sinisa Milivojevic wrote:
cut
Another is as I wrote above. New database with content from
data source is also broken. I know that is sounds strange but it's
After investigating my system, MySQL database server and application, i found
that something wrong with my configuration, Thanks a lot for Mr. Heikki
Tuuri for helping me.
Now, i do really believe that innodb is faster that myISAM, and more
reliable, just remember that you have to
Hello, I use BLOB fields to store pictures, it works nice, but problem
arises when trying to backup/restore data, or else export BLOB fields to
another database.
I tried to use MysqlFront to export / import data, but it appears can't
deal with BLOB, so it writes null character on TXT file for
Hi guys, I get the module Msql-Mysql-modules-1.2217 to install DBD, but
when
is execute this command perl Makefile.PL i have a message that some
library no found.
The message
-
Which drivers do you want to
From: Bennett Haselton
My databases textbook from college says that specifying an
attribute as an
index means that the data will be stored in such a way that
lookups on
that attribute are faster, and specifying an attribute as a
key means
that its values have to be unique.
If you are
FYI: im using mysql 3.23.44
auto_increment doesn't seem to work with InnoDB. i've tried to create a
table with:
create table some_table (
uid INT UNSIGNED AUTO_INCREMENT NOT NULL DEFAULT 1500,
user VARCHAR(100) NOT NULL,
PRIMARY KEY (uid),
UNIQUE KEY (uid)
) TYPE=INNODB;
i've
MySQL 3.23.41 on Solaris
Alright, I have a system where data comes in once... or maybe
a few times a day. I use this data to recreate a table, and then
I need to safely and quickly replace the old table. I was thinking
lock original table, drop it, and then rename the new table, but
I
Hi guys, I get the module Msql-Mysql-modules-1.2217 to install DBD, but
when
is execute this command perl Makefile.PL i have a message that some
library no found.
The message
-
Which drivers do you want to
From: Bennett Haselton
My databases textbook from college says that specifying an
When I read my post I saw that I had made at least one obvious error.
Please change:
An index is conceptually a container of keys arranged in such a way that
each key in the index refers to a unique record.
HI,
does anyone have a clue on how to manage japanese characters in a textfield
in MySQL PHP
it works on varchar type fields , defining it as binary; but no way to make
it work in a text or blob field
thanx
-
Before
Thank you, Carl and Chris, for helping me with this problem. Something else must be
happening, as I still can't log in:
www:~ # mysql -u zope -p
Enter password:
ERROR 1045: Access denied for user: 'zope@localhost' (Using password: YES)
www:~ #
Mysqlaccess shows:
www:~ # mysqlaccess -u zope -d
At 10:06 AM -0500 11/15/01, Anthony R. J. Ball wrote:
MySQL 3.23.41 on Solaris
Alright, I have a system where data comes in once... or maybe
a few times a day. I use this data to recreate a table, and then
I need to safely and quickly replace the old table. I was thinking
lock original
Ahhh! Excellent. I didn't think my idea was quite right.
Thanks.
On Thu, Nov 15, 2001 at 09:32:38AM -0600, Paul DuBois wrote:
At 10:06 AM -0500 11/15/01, Anthony R. J. Ball wrote:
MySQL 3.23.41 on Solaris
Alright, I have a system where data comes in once... or maybe
a few times a
hi all,
can anyone explain me if mysql support view???
if yes what is the syntax?
thanks to all
alessio
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
There is no support for views -- just hard-code your queries.
On Thursday 15 November 2001 09:38 am, Alessio Torino wrote:
hi all,
can anyone explain me if mysql support view???
if yes what is the syntax?
thanks to all
alessio
insert-select on the same table is not allowed in MySQL. If I remember
right it isn't allowed in ANSI SQL either, supposedly because it could lead
to infinite loops if implemented poorly.
Jon Gardiner.
-Original Message-
From: Votteler Marc [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
Hi,
I installed Debian 2.2 to findout that MySQL 3.23 is not available (it's
still in the testing section) so I went and got it from the download section
on www.mysql.com and installed it, but where is the client (not GUI) part.
I need the mysql, mysqladmin files, I can't even set a password
There is no support for views -- just hard-code your queries.
It is olso possible to use temporary tables.
But still the support for views in mysql will be great :)
On Thursday 15 November 2001 09:38 am, Alessio Torino wrote:
hi all,
can anyone explain me if mysql support view???
if yes
I would advice against using temporary tables as views for performance
reasons.
On Thursday 15 November 2001 10:21 am, Alexei V. Alexandrov wrote:
There is no support for views -- just hard-code your queries.
It is olso possible to use temporary tables.
But still the support for views in
Hello
Can I make a query in mySQL like this?
DELETE FROM table1
WHERE id NOT EXIST IN (SELECT id FROM table2)
--
WBR
Lyubomir mailto:[EMAIL PROTECTED]
-
Before posting, please
no
-Original Message-
From: Lyubomir Simich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 15, 2001 12:04 PM
To: [EMAIL PROTECTED]
Subject: SUB-SELECT
Importance: High
Hello
Can I make a query in mySQL like this?
DELETE FROM table1
WHERE id NOT EXIST IN (SELECT
Hi, I have a mysql table I am searching using the FULLTEXT INDEX feature.
However, the legacy database that I am working from had 90 different fields
holding a keyword in each of them. Since the FULLTEXT INDEX only holds 15
different fields, I would much rather have the fields concatenated into
On Thu, Nov 15, 2001 at 12:21:19PM -0300, Walter D. Funk wrote:
does anyone have a clue on how to manage japanese characters in a textfield
in MySQL PHP
it works on varchar type fields , defining it as binary; but no way to make
it work in a text or blob field
You have to think in
Hi,
I am using 4.0 and switching from MyISAM to InnoDB,
so quite newbie on this:
I have a couple of questions:
1) First, I read in the docs that the minimal thing to
do is to add to /etc/my.cnf
innodb_data_file_path=ibdata/ibdata1:2000M
(although the ibdata file is some 67M in
You can'd use sub-selects... you have to do it with a join.
Chris
Can I make a query in mySQL like this? DELETE FROM table1 WHERE id NOT
EXIST IN (SELECT id FROM table2)
-
Before posting, please check:
On Thu, Nov 15, 2001 at 01:49:31AM -0800, Bennett Haselton wrote:
my $user = user.CreateFromTableRow(bennett);
$user.sendReminderEmails();
$user.emailaddress = '[EMAIL PROTECTED]';
You would lose some indexing features, etc., but you could easily use a
language like Python that allows for
HI!
I set the LD_LIBRARY_PATH variable in my safe_mysqld file
but I still get error 1124 (no paths allowed for shared library)
message while trying add new user function (by CREATE FUNCTION
command).
What do I do wrong? This is a part of my safe_mysqld file:
trap '' 1 2
Gyulay Gabor wrote:
The problem is that I need to store numbers with lot more
than 16 decimal digits - e.g. 1234567890123456789012345.12
[...]
The reason is why we need this that there're several
currencies (like italian lire) which requires this kind of
precision.
Excellent answer from
they will be in mysql 4.1
-Original Message-
From: Rosyna [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 15, 2001 2:11 PM
To: Christopher Book; '[EMAIL PROTECTED]'
Subject: Re: SUB-SELECT
Anyone know if subselects will be available in the future?
Ack, at 11/15/01, Christopher
Description:
Whenever you create a database with an underscore in it and give
a user rights to it, he is able to create other databases with
whatever charater in place of the underscore.
How-To-Repeat:
create database aa_bb;
grant all privileges on aa_bb.*
Joe,
sorry, I did not know AUTO_INCREMENT=... clause does not work with InnoDB. I
will look if it is easy to fix.
A workaround is that you insert the first row which the auto-inc column
value explicitly specified:
INSERT INTO some_table VALUES (1500, 'joe');
Then InnoDB starts to increment
Hi,
Is there any mySQL forums ( discussion boards) where I
can post my mySQL queries ?
Thanks
Jason
__
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
El Jueves 15 Noviembre 2001 13:15, escribiste:
Gyulay Gabor wrote:
The problem is that I need to store numbers with lot more
than 16 decimal digits - e.g. 1234567890123456789012345.12
[...]
The reason is why we need this that there're
I'm having a problem with Distrib 3.23.42 with the following query:
select x1.*,x2.* from x1 left join x2 on x1.d1=x2.d2 where x2.d2 is null;
I'm finding that a left join on datetime fields that do not allow nulls is not
working when I'm trying to emulate a subselect to find non-matching values
select max(storyID), storyCategoryID
from newsStories where storyCategoryID 0
group by storyCategoryID
- Original Message -
From: Christopher Oson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 15, 2001 6:31 AM
Subject: Easy SQL query??
Good Day, All,
Given:
insert-select on the same table is not allowed in MySQL. If I remember
right it isn't allowed in ANSI SQL either, supposedly because it
could lead
to infinite loops if implemented poorly.
Jon Gardiner.
Core SQL support does not require the DBMS to support it; enhanced
SQL support allows
Hi, load your dict file with LOAD DATA INFILE
very easy; pretty quick ;-)
If you don't want to mess with that, I just dumped my dictionary
database. Here is the link to where you can download that dump file:
http://brimstone.fpsn.net/~cfaber/mysql/dict.sql.gz
Michael wrote:
Does anyone
From: Bennett Haselton
My databases textbook from college says that specifying an
attribute as an
index means that the data will be stored in such a way that
lookups on
that attribute are faster, and specifying an attribute as a
key means
that its values have to be unique.
If
At 12:57 PM -0700 11/15/01, Mark A Ohrenschall wrote:
I'm having a problem with Distrib 3.23.42 with the following query:
select x1.*,x2.* from x1 left join x2 on x1.d1=x2.d2 where x2.d2 is null;
I'm finding that a left join on datetime fields that do not allow nulls is not
working when I'm
I'm trying to keep a table of summary statistics for another table,
because I expected that generating the counts would take a while.
But I never expected the query to take hours, as it does. On
examination, I see that the query is not using an index, even
though the table has an index on the
I am trying to calculate an approximate age from a birth month field
(birthMonthVal TINYINT(3) UNSIGNED NOT NULL) and birth year field
(birthYearVal SMALLINT(4) UNSIGNED NOT NULL). I do not have the day so an
approximate age is OK (the results will be grouped in an aggregate format
anyway).
How
I'm trying to keep a table of summary statistics for another table,
because I expected that generating the counts would take a while.
But I never expected the query to take hours, as it does. On
examination, I see that the query is not using an index, even
though the table has an index on
On 15 Nov 2001, at 21:59, Carsten H. Pedersen wrote:
PRIMARY KEY
(`collection_id`,`document_id`,`tcml_field_id`,`order_number`),
KEY `collection_field_value`
(`collection_id`,`tcml_field_id`,`value`(12)),
KEY `value` (`value`(12)),
KEY `resource_id` (`resource_id`)
)
thanks.
i'll start it with the value i need. it increments after that ;)
Heikki Tuuri wrote:
Joe,
sorry, I did not know AUTO_INCREMENT=... clause does not work with InnoDB. I
will look if it is easy to fix.
A workaround is that you insert the first row which the auto-inc column
value
I have a database that is names and addresses. I want to make a web page
that will display those
names and addresses in a table with 4 columns per row, as many rows as necessary. The
little
if statement below works to make 2 columns, but when I change the number to 3 or
higher it no longer
Try:
$i++;
if( $i % 3 == 0 ){
echo /tr\ntr\n;
}
b.
mysql
[EMAIL PROTECTED] wrote:
I have a database that is names and addresses. I want to make a web page
that will display those
names and addresses in a table with 4 columns per row, as many rows as necessary.
The little
if statement
On 15 Nov 2001, at 21:59, Carsten H. Pedersen wrote:
PRIMARY KEY
(`collection_id`,`document_id`,`tcml_field_id`,`order_number`),
KEY `collection_field_value`
(`collection_id`,`tcml_field_id`,`value`(12)),
KEY `value` (`value`(12)),
KEY `resource_id` (`resource_id`)
I was just reading DOCS for MERGE tables... and they
look like exactly what I want.
I have a large lookup table that I use to track down
where I want to find my data, which gets loaded into
different tables at different times of the day
(financial data). Now I am loading all the data into
Has anyone ran any benchmarks as to what affect
different number of RAID_CHUNKS has on speed?
Also, what affect does the RAID_CHUNKSIZE have?
Here are a few results I've gotten all with the default
CHUCKSIZE.
-
No RAID Tables (yes, fewer rows.. hit the 2G limit)
There's no way to know that without knowing the schema of the table you're inserting
into. How you index it is going to be the biggest factor there.
--jfarr
- Original Message -
From: Gabor Penoff [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 15, 2001 2:23 PM
Ok, so to follow... Paul Dubois told me the little
RENAME TABLE trick to swap out a table... Will that work
on a table in a MERGE, or are there different hoops to
jump through?
On Thu, Nov 15, 2001 at 02:01:44PM -0800, Bill Adams wrote:
Anthony R. J. Ball wrote:
I was just reading
Anthony R. J. Ball wrote:
Ok, so to follow... Paul Dubois told me the little
RENAME TABLE trick to swap out a table... Will that work
on a table in a MERGE, or are there different hoops to
jump through?
Your table names need to be unique. Then it should work just fine.
o If you do
The mysql-perl had something called the Perl DBI. Go to this url:
http://www.mysql.com/downloads/api-dbi.html
Get the DBI and the Mysql-Perl tarballs. They are funny to install, but
basicly you untar them:
tar zxvf file
then, in the directory created by that:
perl Makefile.PL
make
Thanks Bill,
That works great.
Much appreciative,
Chip
Bill Adams [EMAIL PROTECTED]@tqs.com on 11/15/2001 10:31:45 PM
Internet mail from:
Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject: Re: getting multiple columns per row from databse query
Try:
In Message-ID: [EMAIL PROTECTED] Jason
Rowski wrote:
Hi,
Is there any mySQL forums ( discussion boards) where I
can post my mySQL queries ?
Thanks
Jason
Jason,
I hope this isn't seen as spam... but http://dbforums.com has a forum for
most mainstream databases, including web access to most
The date addition and subtraction functions in mysql don't seem to quiet do
this. I was wondering if anyone know a way I could do this in the query:
Say you have two fields, start_time, and end_time, representing the start and
end of a period of time. Both are datetime datatypes. What I want
Jason
The forums at http://forums.devshed.com aren't half bad either... Apache, PHP, MySQL,
HTML/Javascript...
# Nathan
- Original Message -
From: Paul [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 15, 2001 4:28 PM
Subject: Re: Is there any mySQL forums ?
In
On Thu, 15 Nov 2001 [EMAIL PROTECTED] wrote:
I am using 4.0 and switching from MyISAM to InnoDB,
so quite newbie on this:
I'm still using 3.23.4X (differs depending on which machine I'm on), but
I'm pretty sure that none of the questions have answers that change too
much between those
Here is the same data in a little easy format.
Raid Chunks count like %like % %
10.00 sec 0.33 sec 2 min 3.70 sec
30.00 sec 0.39 sec 14 min 59.83 sec
50.00 sec 0.38 sec 6 min 44.92 sec
15 0.00 sec 0.39 sec 6 min 33.72 sec
Hrm... so it is going to need to rebuild all the indexes, not just the
table I am adding... doh... oh well, should still be faster, I'd guess.
Probably my best bet in this case is to create a new merged table with the
new table and all the other old ones, then replace the old merged table
I'm having a problem sorting records that are used in a left join statement.
Basically what happens is that any record that is not in table1 doesn't get
sorted correctly. It first sorts all the records that have valid 'c2'
records in both table1 and table2, then moves on to all the records that
Description:
I am using russian values(cp1251 charset) for ENUM items.
Here is an example how to damage ID field by query to change
F_Category Enum.
How-To-Repeat:
# Create tableA with ID field.
CREATE TABLE tableA (
ID int(11) NOT NULL auto_increment,
F_ReportID
mysqlHow to install mysql on unix?
ÖÂ
Àñ£¡
Peter.Liu
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hi,
- Original Message -
From: Brent Simpson [EMAIL PROTECTED]
I've been reading up on this most of the day and still can't get it!
You'll say DOH! later ;-)
I need to use PHP to make connections to MySQL. When I use my actual
host name to make the connection I get this:
Warning:
Hi,
I'm building an application which uses Innodb. It is very imperative
that all data is processed as quickly as it possibly can and so the problem
I have is quite a concern. My perl script executes the queries however if if
make an error in the code and the script crashes half way through
Hi,
I resubmited again for anyone with solution to assist me.
I had one question. I would like to set permission for remotely backup using
mysqldump. Let's assume I want to use B(10.0.0.2) server to remotely backup
A(10.0.0.1) server.
The command I run at B server are:
mysqldump --opt
Hi:
I telnet to the server. But I can not get into MySql
database. What's the problem?
% mysql
ERROR 2002: Can't connect to local MySQL server
through socket '/tmp/mysql.sock'
(2)
% mysql -p linksdb
Enter password:
Then I type in password, and got the following:
ERROR 2002:
Sounds like you have a TCP socket problem. Is the database on a local
machine or a hosting provider? What platform is it on wintel or *nix?
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Georgina Fang [mailto:[EMAIL PROTECTED]]
I am extremely new to mySQL (and the Linux environment all together). I have
been building/maintaining a mySQL/PHP site. Today, the site began giving me
errno 145 (cannot open file) errors. I found that meant I had at least one
corrupt table, so I went into mySQL, found I had two corrupt
Jennifer Slis wrote:
I am extremely new to mySQL (and the Linux environment all together). I have
been building/maintaining a mySQL/PHP site. Today, the site began giving me
errno 145 (cannot open file) errors. I found that meant I had at least one
corrupt table, so I went into mySQL, found
1 - 100 of 110 matches
Mail list logo