Hi,
Does anyone have a working start/stop script for mysql4.1.10?
The mysql.server script come with the mysql4.1.10 package does not work
with argument (start/stop).
Thanks
Sam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi Sam,
To shutdown mysql I just use mysqladmin shutdown.
http://dev.mysql.com/doc/mysql/en/server-shutdown.html
About you restart problem, have a look in mysql/data/host.err file, it
should give you a reason there.
Last time I had that problem it's because I hadn't kill all the process.
Good
Hello.
I also have a problems with MySQL Control Center, though it isn't
supported now, and another client, MySQL-Front. But the latest
MySQL Query Browser works perfectly with... Check
your queries with MySQL Query Browser 1.1.5, you can download it
from:
Hello.
Please, send us the output of the following statement:
show create table 'your table';
Hello Gleb,
Below is an extract of the SQLyog history on startup
/*[02:26:25 PM][ 0 ms]*/ show variables like '%character%'
/*[02:26:25 PM][ 0 ms]*/ Set
mel list_php wrote:
Hi Sam,
To shutdown mysql I just use mysqladmin shutdown.
http://dev.mysql.com/doc/mysql/en/server-shutdown.html
Thanks for this help. I will surely use this command next time.
About you restart problem, have a look in mysql/data/host.err file, it
should give you a reason
Yeah, I have looked at it, but not sure whether I need to repopulate the
mysql.host db file. If I do that, I may be also need to recreate all db
passwords as well.
The error is:
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050302
mel list_php wrote:
Yeah, I have looked at it, but not sure whether I need to repopulate
the mysql.host db file. If I do that, I may be also need to recreate
all db passwords as well.
The error is:
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0
Hi,
I have included show from two tables both have the same problem in two
different databases.
Enter password: **
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.10-nt
Type 'help;' or '\h' for help. Type '\c' to clear the
Hi Sergei,
I have used FT search on a collection of ~ 38'000 documents totalling 550
MB of data since 4.0.2. To my observation people have a strong tendence to
search for a few words they expect to be found close together in the text.
As far as this is technically possible it would be helpful to
Hello.
Does the problem remains with MySQL Query Browser and mysql command line client
when you are using a 'source' command?
Rob Cochrane [EMAIL PROTECTED] wrote:
Hi,
I have included show from two tables both have the same problem in two
different databases.
Enter
Hello.
Use -U --force --nodeps options.
sam wun [EMAIL PROTECTED] wrote:
Hi,
I have installed the server and started up successfully. mysql.sock file
is written to /var/lib/mysql/ directory as well.
Now I found that I also need to install mysql 4.10-1 client. However
there
Hello.
Usually it works. What error does it produce? Can you find
something in error log of MySQL server?
sam wun [EMAIL PROTECTED] wrote:
Hi,
Does anyone have a working start/stop script for mysql4.1.10?
The mysql.server script come with the mysql4.1.10 package does not work
Hi,
I have installed the query browser and it does change things but not
correctly, inserting this:
update `peterkrolltiles`.`navprompts` set `languagecode3`='afr',
`navigation`='Navigasie', `home`='Tuis', `aboutus`='Oor Ons',
`products`='Ons Produkte', `team`='Ons Span',
Hello.
seconds, but my mysql 4.1.10 takes forever to run.
Do the queries never end? Or they're finishing after the long time?
I don't know whether all indexes are rebuilt correctly in the new database
(mysql 4.1.10). How do I know all my previous indexes are in-placed with the
How internationalized is the ft_stopword_file ?
How can I create a custom ft_stopword_file ?
Is the build in one for english only ?
Gabriel PREDA
www.amr.ro
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Is there any equivalent syntax similiar to dir /w /s for all *.doc to
insert into mysql database?
--
Power to people, Linux is here.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello there,
Another Fulltext question :) Yeah, I've been working a lot on this stuff now :)
I have a request to search companies in a huge database:
SELECT CID FROM tblCompany WHERE MATCH (CompanyName) AGAINST ('Toyota
Robert' IN BOOLEAN MODE)
In boolean mode, my results are not sorted by
Is 'find' what you're looking for?
find ${path} -type f -iname '*.doc' -print
find ${path} -type f -iname '*.doc' -exec /some/import/script {} \;
Thanks,
Ryan Yagatich
,__,
/ Ryan Yagatich Pantek Incorporated |
\
I have an PHP that do application
$sql = SET AUTOCOMMIT=0;
$db-execQuery($sql);
$sql = DELETE FROM TABLE X WHERE...;
if($db-execQuery($sql)){
print ERROR ;
exit(0);
}
$sql = INSERT INTO TABLE ;
if($db-execQuery($sql)){
print ERROR ;
exit(0);
}
I have a persistent connection to
That works on Unix, not on Windows machine. I'm looking for mysql
internal utility for Windows machine.
On Wed, 2 Mar 2005 09:18:09 -0500 (EST), Ryan Yagatich [EMAIL PROTECTED]
wrote:
Is 'find' what you're looking for?
find ${path} -type f -iname '*.doc' -print
find ${path} -type f
I have a 50g CSV file that I am trying to import into an empty MyISAM
table. It appears to go fine except after 10 hours it hasn't completed. A
Show Process List shows Info=load data infile ... and State=Repair
with keycache. The table has a few hundred million rows of data. I assume
it is
shabanip [EMAIL PROTECTED] wrote on 02/25/2005 03:21:10 AM:
which version of mysql has more features?
Payam Shabanian
[EMAIL PROTECTED]
Have you had no luck understanding the information that starts here?
http://www.mysql.com/products/
If you tell us specifically which features you are
El Mar 01 Mar 2005 18:29, Heikki Tuuri escribi:
Alfredo,
I have changed my my.cnf to try and include the suggestions from the list, as
much as possible and try to run my program again. It now reads like this:
innodb_data_file_path = ibdata1:2G;ibdata2:2G:autoextend
set-variable =
I've got a customer with a mysql that is crashing on startup. MySQL is
4.0.18 with InnoDB tables on a Linux 2.4.26 system. MySQL binaries are
Linux x86 glibc static gcc from mysql.com
Can anyone divine what might have happened to cause this?
thanks,
baba
resolve_stack_dump gives:
0x8071f44
Hi,
Is it possible to use the LOAD DATA INFILE to load an XML file into a table?
Thanks for your help
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
On Mar 02, Thomas Spahni wrote:
Hi Sergei,
I have used FT search on a collection of ~ 38'000 documents totalling 550
MB of data since 4.0.2. To my observation people have a strong tendence to
search for a few words they expect to be found close together in the text.
As far as this is
Imagine a field with just two numerals, 250 and 2.8.
How would I designate that field if I want to display
them?
First, I tried decimal 3,1. It displayed numerals like
250 perfectly, but it rounded all the decimals off,
turning 2.8 into 3.
So I converted the field to char 3 and made sure the
Hello.
Just tested on Windows 2k Professional (Russian) computer - the query works
correctly.
If you can make a reproducable test case (the problem remains on other
boxes) you may report a bug. Can you create a text file with
a query and then execute it using a 'source' command (don't
Hello.
Use MySQL Query Browser instead of MySQL CC. What output does the
following statement produce:
show variables like '%char%';
Steve Quezadas [EMAIL PROTECTED] wrote:
Hey guys,
I just upgraded to mysql 4.1 and I'm trying to get damn unicode to work in
my database. I
Hello.
Other than rebuilding the slave from a backup of the master, is there
any way to get the replication backup up?
Have you tried to stop a slave and then start with SQL_SLAVE_SKIP_COUNTER = n,
as suggested at:
http://dev.mysql.com/doc/mysql/en/replication-problems.html
But if
Hi,
Using the MySQL Query browser to enter the data the correct data is in
the field and it remains correct. MySQLCC reads it incorrectly as does
SQLyog. My applications which is .asp in one case and php in the other
both read the data correctly. So at this stage the problem seems to have
been
Thanks for the response.
We can't afford to lose information, and I don't like doing dangerous
things.
I guess it's time to rebuild the slave.
David
Gleb Paharenko wrote:
Hello.
Other than rebuilding the slave from a backup of the master, is there
any way to get the replication
Coming in late on this thread. The testing on your laptop, are you just
running the one query or are you somehow emulating the typical load you
are trying to design for? As you said, you are trying to improve
concurrency, so you'll need to compare MyISAM and InnoDB setups under
load (i.e. the
Hello,
See my later post
I will continue to test and supply all my results if I find it to be DB
and not client
Once again... many thanks
Rob
Gleb Paharenko wrote:
Hello.
Just tested on Windows 2k Professional (Russian) computer - the query works
correctly.
If you can make a reproducable test
Dear List,
Is it possible to load data, for example with 2 columns in a table and add
the value of the third column using a command?
Example:
I have these data, stored in two text files:
a)species_1
182020
185020
182510
b)species_2
400030
500020
and I would like to
El Mié 02 Mar 2005 11:41, Brent Baisley escribió:
Coming in late on this thread. The testing on your laptop, are you just
running the one query or are you somehow emulating the typical load you
are trying to design for? As you said, you are trying to improve
concurrency, so you'll need to
Anyone knew how to uninstall old version of MySQL? Thanks
__
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
Netscape. Just the Net You Need.
New! Netscape Toolbar
-Original Message-
From: Tommy McNeely [mailto:[EMAIL PROTECTED]
I am building an IRC based application bot (using libmysql) .. that
will take commands from users (!mybugs, !mybugs KEY !newbugs,
etc), do
SQL queries and of course dump formatted results back to the channel.
H, sounds like you are trying to mix OLTP and OLAP in one database
structure. That's a tough one. You want your tables designed to always
accept data in real time, but once the data is in, it doesn't change
and you want to query it. Relational vs. Dimensional data models.
Your hardware is
I apologize if this is a double post, but it appears
that my first message didn't transmit for some reason.
Anyway, I'm having a weird problem with decimals.
Imagine a field with just two numerals - 450 and 24.8.
You want to display them as 450 and 24.8, not 450.05
and 24.8 or 450 and 3.
I
Bill Maidment wrote:
Hi
There doesn't appear to be any info. on the archives regarding this,
so does anyone know what character set/collation sequence to use for
EBCDIC rather than ASCII collation?
I discovered the /usr/share/mysql/charsets directory and added a
latin1_cp500_ci collation entry
El Mié 02 Mar 2005 16:04, escribió:
H, sounds like you are trying to mix OLTP and OLAP in one database
structure. That's a tough one. You want your tables designed to always
accept data in real time, but once the data is in, it doesn't change
and you want to query it. Relational vs.
Hello,
I have two tables:
Table2 (listings), columns - listingID, state, preferred, siteAddress,
siteTitle, siteDescription
Table1 (invotes), columns listingID
I want to select the listingID of the rows in Table2 where the 'state'
column equals '$st' then count the number of rows in
Hi,
I use MySQL 4.1.10, and it crashes about once a day. I posted about this
bug two days ago, but I forgot to put the stack trace result there,
sorry for that. Now I put the stack trace result below.
My kernel is 2.6.10, RAM is 4 GB. Single CPU with HT (shows up as 2 CPU
on linux). The MySQL
44 matches
Mail list logo