Jonathan Hilgeman wrote:
Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm
considering moving to a P4 2 Ghz with the same amount of RAM. I have a
few specific tables with several million rows of data, and it takes
quite a long time to process that data on my current server. Does
On Tuesday, August 12, 2003, at 09:59 PM, otherguy wrote:
On Tuesday, August 12, 2003, at 09:46 PM, Andrew Rothwell wrote:
Hello List,
I have a movies database, that I had an autoincrementing field for
counting purposes.What I did though was remove some of the rows out of
the table, now my
hi all!
can we enable and disable log files (update log, slow
query log) dynamically. Please let me know.
what should i do to enable it without restarting the
server. I am using MySQL 2.23.52
advance thanx!
Want to chat
Then you need to be even more explicit
INSERT INTO nye_opskrifter (foo,bar) SELECT foo, bar FROM opskrifter where
id
in($numbers)
-Original Message-
From: Lars Rasmussen [mailto:[EMAIL PROTECTED]
Sent: 13 August 2003 19:22
To: 'Jay Blanchard'; [EMAIL PROTECTED]
Subject: INSERT
Hi,
I'm doing some web development and have mysql (3.23.x) installed
to test with (win2k, but I don't think this question is particularly
platform specific).
I have a reasonably complex query which I am trying to optimise.
When I first startup mysql, and perform the query, it can take
10 or so
The comma after Gerlad R was a typo.
As for the 500 actors issue, I'm merely using the movie db as an example.
People always post the strangest db's to this list (I have one table for
monkeys and one for fishes who speak Urdu, and I need...), so I thought I'd
spare everyone the particulars of
Does the FIND_IN_SET() function mentioned in the manual have any
performance bonuses over doing a LIKE search for a SET fields? I'm
trying to decide between using a SET or a separate lookup table at the moment,
but data needs to be searchable and could have a lot of values, so it
needs to be
Susan,
you had posted your message to the newsgroup mailing.database.mysql. That is
only a mirror of the mailing list [EMAIL PROTECTED], where you should
send your postings for them to be readable for all.
InnoDB has a data structure which is equivalent to the 'rollback segment' of
Oracle. But,
* m n
I have the following table with just one record! And when I do a select
statement, mysql returns no hits!!!
Would you explain to me what is wrong??
You have only one row.
URL: http://www.mysql.com/doc/en/Fulltext_Search.html
For very small tables, word distribution does not reflect
Hello All,
Redhat 9.0
Mysql 3.23.56 == Running
I want to upgarde to 4.0.13 but this is the error it says:
[EMAIL PROTECTED] downloads]# rpm -Uvh MySQL-server-4.0.13-0.i386.rpm
warning: MySQL-server-4.0.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID
5072e1f5
error: Failed dependencies:
mysql USE company;
Database changed
mysql
mysql DROP TABLE IF EXISTS EMPLOYEE;
--
DROP TABLE IF EXISTS EMPLOYEE
--
Query OK, 0 rows affected (0.00 sec)
mysql
mysql CREATE TABLE EMPLOYEE
- (
- FNAMEVARCHAR(15) NOT NULL,
- MINITCHAR,
Hi Mathan.
i am totally confused . Actually same problem occurred when install the
mysql 2-3 months back. but then i solved the problem , how , i didnt know .
but this time when i again start the mysql and did the installation the same
problem is unable to resolve after all tries.
i would like
Can someone tell me why the columns ssl_cipher, x509_issuer, x509_subject in
the user table are REQUIRED? If they are required what is the default
value?
I am having a heck of a time working with the mysql gui's and adding records
to this table
Thanks
---
Keith
On Wed, Aug 06, 2003 at 12:16:40PM -0400, walt wrote:
On Wednesday 06 August 2003 11:50 am, Andy Smith wrote:
$ cat mysql/master.info
angora-bin.001
20102800
127.0.0.1
repl
removed
3306
60
Looks fine to me. :(
Looks fine to me as well
Are you still getting the 1200
uhhh.there are only two fields in the table, but I'll give it a whirl.
:)
As for Donald's advice: it gave me access denied for user. :\
-Mike
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 4:08 PM
To: Mike At Spy; Donald Tyler;
Bennett Haselton [EMAIL PROTECTED] wrote:
While logged in to my Linux server as root, I went in to MySQL and (with no
databases selected, so that the GRANT statement would apply globally),
ran the command:
mysql grant all privileges on * to bhaselto identified by 'password';
where
Is there something about 3.23 that makes this illegal? It is fine on 4.012.
SELECT [lots of columns]
FROM new_people p LEFT JOIN new_address ad ON p.address_id = ad.id
JOIN list_states ls ON ad.state = ls.id
WHERE p.company_id = 1
Will some minor rewording help it run on both versions OK?
--
Hello,
mysqld_multi doesn't start the two groups if I gave this command imediately
after stopping them. It will start only one group.
I'm working on Linux RedHat 9 MySQL 4.0.14.
How can I solve this problem, please?
Thanks Anticipated,
Iulian
--
MySQL General Mailing List
For list
Hey folks -
While contemplating the design of a secure web database, an idea struck me.
I'm thinking of submitting it as a feature request, so please critique it.
I'm having php handle user logon with it's .htaccess emulation. I'm storing
usernames and password hashes in a table. The problem is
Hi,
I have some trouble since i've upgradet from 3.23.49 to 4.0.13.
I used this command:
INSERT INTO nye_opskrifter SELECT * FROM opskrifter where id
in($numbers)
But now it gives this error:
Column count doesn't match value count at row 1
I tried IGNORE, but it's just not working.
I hope
I don't know if mySQL caches results, but your system almost surely caches
disk sectors read. I've noticed in another database app that I'm working on
(not mySQL) that executing the same query twice runs noticably faster the
second time, and I know the DBMS isn't caching results because I'm
I want to get the most out of my Dedicated Red-Hat Linux 6 drive (3
RAID-1 / 3 RAID-10 ) mysql servers using Reiser-fs.
Currently I have this in my fstab
/dev/sda6 /var/lib/mysql reiserfsdefaults
1 2
I would like to turn off/on some options to get the most out of my
On Thu, 14 Aug 2003 15:19:46 +0300, Victoria Reznichenko wrote:
Mark Healey [EMAIL PROTECTED] wrote:
I'm trying to learn to use mysql. I don't want to mess with the
system databases so I decided create a database and user to play
with but I can't seem to do it right.
I logged in as root and
First of all, thank you Jeremy for your answer.
You said:
It's the amount of time that thread has been in its current state.
Is it the current state column value (which is in fact nothing or the text of the
running SQL request)
or the current command column value (sleeping, opening table,
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: moyc
To: [EMAIL PROTECTED]
Subject: Installation challenges - mysqld
Description:
I've never installed MySql before and I am
[snip]
I used this command:
INSERT INTO nye_opskrifter SELECT * FROM opskrifter where id
in($numbers)
But now it gives this error:
Column count doesn't match value count at row 1
[/snip]
* does not return a specific number of columns, the work around is to
specify the columns explicitly
INSERT
I am hitting a problem compiling mysql on aix 4.3
configure works ok and picks the CC compiler. However the compile fails
as shown in the attachment.
Even following the advise under the IBM - AIX section of the
doccumentation and setting the following
enviromental variables gives the same
Thanks very much.
Marc.
-Message d'origine-
De : Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 13 août 2003 17:01
À : Mechain Marc
Cc : [EMAIL PROTECTED]
Objet : Re: Meaning of Column time in Show Processlist
On Wed, Aug 13, 2003 at 03:26:24PM +0200, Mechain Marc wrote:
I tried that, but i dont work either.
I need to insert a way that mysql doese'nt complain when i copy some
records that have the same id (or that it just gives it an id according
to the AUTO_INCREMENT)
Thanks again
//Lars Rasmussen
-Oprindelig meddelelse-
Fra: Jay Blanchard
[snip]
ID | Name
1 | Author\'s
As you can see, the name value has been escaped. Now, the question is,
how do you match on a value that has escaped charaters? I've tried the
following
SELECT * FROM table WHERE Name = 'Author\'s'
SELECT * FROM table
On Wed, Aug 13, 2003 at 09:54:51PM +, Michael Welsh wrote:
On Wednesday 13 August 2003 02:11 pm, Matthew McNicol wrote:
see section '4.8.2 mysql, The Command-line Tool' in the manual
Thank you Matthew, but, the prompt feature is not available until v4.02.
From the docs:
From MySQL
Hi!
On Aug 14, Henry Hank wrote:
Sergei wrote:
How big is your table?
The MYD file is 2,406,292,556 bytes.
oops :(
I actually thought about asking for a copy of your data - it will
definitely help to fix the bug, but 2GB is big enough to try everything
else first.
But if you don't
I can certainly wait. This system has been working ok for almost a year. I'm
very happy!
I've been doing a review of all aspects of the system, and many of the
maintenance tasks, and internal DB operations have suffered in speed to get
the external parts optimal. But when this fix comes, i'll
At 10:19 am 14/08/03, Jim Smith wrote:
I repeat. Why do you need the parentheses? Union queries don't require them.
Sorry, missed this.
They do need them if you want to use ORDER BY on the result of the UNION.
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General
Hello All:
I would like to rename a table if it exists.
The following query
IF EXISTS ALTER TABLE gwcc_members RENAME gwcc_members_bak;
fails.
also
ALTER TABLE IF EXISTS gwcc_members RENAME gwcc_members_bak;
fails.
1)What is the correct syntax?
2)Where is documentation.
I'm using ver.
m n [EMAIL PROTECTED] wrote:
How fulltext is working!!?
From the MySQL manual:
The search for the word MySQL produces no results in the above example, because that
word is present in more than half the rows. As such, it is effectively treated as a
stopword (that is, a word with zero semantic
I have heard Apache croaks after 130 connections..
-M
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
To: Andrew Rothwell [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 6:34 PM
Subject: Re: A final Windows MySQL PHP plea
Hi Andrew,
I guess your reply
Hi Andy,
Thanks for your comments and my apologies on the late reply.
To optimize my queries I restructured the tables - adding another table
into the mix.
Here is my table structure:
CREATE TABLE kcs_thread_types (
id int(11) NOT NULL auto_increment,
typeName varchar(255),
PRIMARY
At 10:42 AM 8/14/2003, you wrote:
I'm sure this is an easy process, but I'm at a total loss on the command to
use. I want to send the contents of table x to a file x.csv. I've
looked at the mysql_dump but that has way more info than I need. Just the
table contents separated by commas, thanks
To take it one step firther
I do
mysqluse database
This way all the consequent commands are directed at the specified DB
Regards,
Martin
- Original Message -
From: Murad Nayal [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 5:44 PM
Subject: Re: Cant login as a user
On 13 Aug 2003 at 16:17, Rob wrote:
ID| Name
1 | Author\'s
As you can see, the name value has been escaped. Now, the question
is, how do you match on a value that has escaped charaters? I've
tried the following
SELECT * FROM table WHERE Name =
Hi!
On Aug 13, Henry Hank wrote:
Environment:
I'm setting up a database server on a Dell Poweredge 2650, dual 1.8GHZ pentium
with 1GB of memory and RAID5 drives. I've installed RedHat 9, and updated the
kernel to 2.4.20-19.9smp. I've installed the RPM binary distribution of MySQL
4.0.14
Hi Roger,
2003 8 14 19:33Roger Baklund :
* Nils Valentin
I have problems understanding why the below two commands would
return the same result.
[...]
mysql select * from sensei where link like
'/var/www/html/xoops/2003\'s sum';
[...]
mysql select * from sensei where last_name
While I understand the concern, it shouldn't be any easier for a hacker to
see the raw text of your PHP files than to get directly to your database
files. Neither is normally permitted by the web server. So if he somehow can
get in and get one, why not the other?
That said, if it makes you
Hi,
Is ssl support provided in the MAX mysql binary distribution. The
website lists some of the features provided in MAX that are not provided in
the Standard binary. However, the website does not list the full list of
features that are supported in the MAX but not in the Standard.
Ren
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 13 Aug 2003, Annie Xie wrote:
Any one could help?
1 anyone has a compiled tarball for mysql new version (-4.0 up) for
solaris 2.6 can be shared? The OS was patched latest.
2 I'm trying build it, configure w/o any problem.
Please notice that
INDEX (DNO, DNUMBER),
is changed to be
INDEX (DNO),
And I managed to get another error message,
But it still woun't compile.
Also manually typing the code gave another result as
Piping the company_01.sql file through an input operator
Please tell me what could
Thats a good quote on your site, I agree.
To sum things up I've changed my design and basically am going to implement
the last Q of http://www.mysql.com/doc/en/Replication_FAQ.html.
Thanks for the info everyone.
PS. Jeremy hows your book coming? I just bought a bunch of MySQL books, and
can't
Morten Gulbrandsen [EMAIL PROTECTED] wrote:
USE company;
# SHOW INNODB STATUS;
DROP TABLE IF EXISTS DEPARTMENT;
CREATE TABLE DEPARTMENT
(
DNAME VARCHAR(15) NOT NULL,
DNUMBER INT NOT NULL,
MGRSSN CHAR(9) NOT NULL,
MGRSTARTDATE
Fatt Shin wrote:
Yes, found the problem, you are right. Thanks.
But this is something caused by powerbuilder, in my code I never put
any space between count(*), but when it goes to odbc, an space is
added. Any idea how to solve this?
Wouldn't sum(1) return the same count -theoratically
Could you deascribe it more detailed? Which version of MySQL do you
use?
If you're talking about my original question, the database is 4.0.13.
-- Jason
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Susan,
- Original Message -
From: Susan Lam [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, August 11, 2003 8:37 AM
Subject: no foreign key and view?
I was told that mysql doesn't has foreign key and views. Is it ture?
Or is it different across different version
I am trying to use a function as a default value for a column but do not
seem to get the desired result. I want to use the NOW() function for a
last_updated column, here is my code...
CREATE TABLE test_table (
last_updated datetime NOT NULL default `NOW()`
) TYPE=MyISAM;
This gives an error;
On Wed, Aug 06, 2003 at 07:00:33PM -0700, Steven Roussey wrote:
So does anyone else have any ideas what is going on here? Shall I
report this as a bug?
Did you post how you setup the servers to load the different my.cnf
files? Hopefully you don't have one at a default location.
I don't
I am using cold fusion to make a small custom website using
mysql to store the information a user inputs. I want it to
be able to save japanese and unicode text, but whenever I
enter any it comes back as garbage. Is there anything
special I need to do to configure mysql to use unicode?
Steven Roussey wrote:
ORing on two different fields is what I have been asking about :).
This is not optimized, and I don't think it is set to be optimized
until 5.1 (as per someone else's comment).
Using a composite index was suggested
This is bad information. It works for AND, not for OR.
On Thu, Aug 07, 2003 at 09:07:41PM -0500, Dan Nelson wrote:
In the last episode (Aug 07), Jeremy Zawodny said:
I've been on the box at the mysql prompt quite a few times when it
has happened and there was always a large amount of threads waiting
for a lock to clear, and as soon as they
On Thu, Jul 31, 2003 at 10:33:21AM -0700, Richard Sumilang wrote:
Anyone know when it will be considered production stable?
When it's stable.
http://www.mysql.com/doc/en/Release_philosophy.html
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] |
Or do not delete them at all, simply flag them as deleted then proceed
otherwise. Develop some routine to purge/backup the deleted records after
a given period of time.
on 8/8/03 2:08 PM, Chris Boget at [EMAIL PROTECTED] wrote:
How can I see if a record was deleted from a database?
You can
I don't believe Windows services can be started with any priority types.
MySQL is on it's own box with the ASP version, which works like a dream.
It's simply that whenever the PHP version is used (either as a solitary
website on another box or as another website on the same box), that's
when
Dear Sir/Madam
i am trying to run mysql_install_db but my windows xp command prompt give me the
following error:
'mysql_install_db' is not recognized as an internal or external command, operable
program or batch file.
How can i run this line?
please help
thank you very much
Sandeep Sodhi
Hi everyone,
I got apache 2.0 + MySql 3.23.52 + PHP 4.3.1 on a Redhat 8.0 server.
Somehow MySQL automatically shuts down overnight, anyone has a reason
for this? Might because of cron?
Thanks in advance!
Hi all
I continue to have problems with the CPU usage with MySQL and PHP under
IIS 5 (Win2000). I recently rewrote our messageboards in PHP (from
ASP). I now have both online separately, and if I look at the
processlist, the times on the ASP version rarely hit double figures, but
those on
All,
I'm building a member signup form. Fields that contain more than one word
are being truncated when being inserted into the MySQL table.
I'm using this code that I got from one of my PHP books.
$as_addr1 = addslashes($_POST['addr1']);$tr_addr1 = trim($as_addr1);
So, if I post 1122 Boogie
I think I see the problem. Mysql really needs to be on it's own box.
It's designed to just use as much power as it can find. This is a good
thing for those with dedicated machines. I don't know if there's a
configuration setup that tell mysql that it's not the head honcho. Does
Windows have a
Hi Andrew,
I guess your reply was meant for Gary (the original poster of this e-mail).
I will foward your request to the mailing list.
Best regards
Nils Valentin
Tokyo/Japan
WOW!!!
That kind of System Power and you are wasting it on Windows and IIS
E!
Sorry - but Dual
Rafal Kedziorski [EMAIL PROTECTED] wrote:
we have problems with import our dumped InnoDB tables.
We get this error message:
Can't create table '.\mmcms_test\media_lock.frm' (errno: 150)
My tables which will be referenced by foreign keys will be dumped in the
inncorect order.
if I
/* Copyright (c) 2003 Aftab Jahan Subedar
mysql_last_value() Version 3.2
--
Replaces NULL column(s) with value from last available column value.
Scenario
Table to be operated on.
table_a
---
record
I have a stand alone database server. It is a RAID5 running mySQL 3.23.55
on FreeBSD 4.1 and has 768MB of RAM, I'm not sure on the processor speed,
but I think it's a P3 1GHz. It has several tables with 20-40 million rows
and a ton of smaller tables with less than 1 million rows. All tables are
I think I figured it out. I had the gallery_id field zero filled... It
works now, thank you very much!
-m
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 3:49 PM
To: mysql
Cc: motorpsychkill
Subject: Re: order by question
*
Brian Austin says:
Have you read the following page in the Manual on their site?
http://www.mysql.com/doc/en/Linux.html
This gives you some tips to increase thread allocation. Especially
interesting is the part about the LinuxThreads hack.
That's where I started, and it's why I compiled my
[snip]
70050;451
70322;451
LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
TERMINATED BY ';' LINES TERMINATED BY '\r\n'
[/snip]
[/snip]
I am going to recommend that you specify which columns the data goes
into
LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE
Try changing JOIN list_states to INNER JOIN list_states
Looks like the earlier version didn't like your (synonymous) wording.
-Original Message-
From: Jack Dare [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 8:35 AM
To: [EMAIL PROTECTED]
Subject: Join syntax diff 3.23
I'm using some default table names and such here...my actual code has the
appropriate table, server, un, pw etc...
Hi there,
I am trying to understand the logic of full text search in mysql. I'm not using mysql
4. The search work OK, be it thast I get hits on certain words, whilst other words are
discarded for some reason or other. Why is that. An example: I search in a text field
for the word organisation.
On Thu, Aug 07, 2003 at 01:00:12PM -0700, Ian Neubert wrote:
I was trying to design it so that the slaves wouldn't know they had
connected to a different master, as they both masters would have the same IP
address that gets failed over based on the Linux Virtual Server software and
VRRP (like
Joshua,
Joshua Spoerri wrote:
Forgive me, that example is no good.
Oddly, it works, but the following does not:
mysql create temporary table x (y int, z int, q int, index (y, z)); insert into x
values (1,2,3), (3,4,5), (5,6,7); explain select * from x where y = 1 or z = 1;
MySQL will never use
Hi,
I know that Mysql handles large database very well, but there is a project
that requires more than 2000 small databases(about 20 talbes with a few
rows) to be created within a Mysql server. Could somebody tell me does it
make sense?
Thanks for your consideration.
likai
Sometimes, movies have more than one director, so the
association between movies and directors needs to be in its
own table, instead of the movies table. (Otherwise, you're
limited to some fixed number of directors per
film.)
Directors may not be the best example. Think about producers,
Is the workload I/O bound, CPU bound, or memory bound?
On Linux, you can get a sense of this as follows:
Run top and vmstat 5 on your MySQL box, and with them running have
your system perform whatever slow operations you are concerned about.
The key numbers here are the swap used % iowait and
Fraser,
- Original Message -
From: Fraser Hanson [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, August 06, 2003 5:46 AM
Subject: ON UPDATE CASCADE fails
Hello,
I have a table which has a foreign key relationship with itself. I
want and expect my updates to
Testing ..Please ignore this email
Jeff,
- Original Message -
From: Jeff Mathis [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, August 07, 2003 9:01 PM
Subject: Re: reindexing
what is the command to update InnoDB table indexes?
if you mean update index cardinality statistics, then starting from
Hi :)
I'm not even sure if I'm naming the question correctly. I hope I can
ask/explain it clearly enough to get a hint ;)
Essentially...
1) I have a table of portfolio 'pieces', each row of which has a unique ID
2) I have a table of 'projects', which are comprised of a number of
'pieces'.
Shut down my Linux PC running MySqld and rebooted this morning and cannot get mysqld
up. In services when I click on mysqld I get the message Mysqld dead subsys locked
when i restart the server it says mysql succesfully restarted, but it isnt. When I
try to stop the server it comes back with
See http://www.connectionstrings.com/
Regards,
Ulises
-Mensaje original-
De: Ratmil Torres [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles 6 de Agosto de 2003 07:11 AM
Para: [EMAIL PROTECTED]
Asunto: Connecting to MySQL from ASP
Hi. I am developing a web site using ASP. I need to
Dear administrator,
Now I have a quesion and want to get your help.
When I insert an image file data (data size 64KB) to a BLOB field of MySQL database
by com.mysql.jdbc.driber,there is error. Error message as follows:
aq.executeQuery:Communication link
On Fri, Aug 01, 2003 at 01:00:13PM -0400, Jack Coxen wrote:
Since starting up RTG not quite 3 months ago, my database has grown to over
10GB in size. If I can get the drive space to keep the 2 years worth of
data I want to, my database will be edging upward toward 100GB. There are
It's a perl DBI question not a MySQL one but anyways...
$sth is just a statement handle and if you print it it gives you a hash ref,
so is not an error.
After preparing you should do an execute on the statement than fetch the
results. Better, use a prepare-execute-fetch all-in-one command like:
On Wed, Aug 06, 2003 at 11:23:31AM -0400, walt wrote:
On Wednesday 06 August 2003 11:13 am, Andy Smith wrote:
On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote:
On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote:
Andy,
I don't see
log-slave-updates
in your master
mailing [EMAIL PROTECTED] wrote:
it's possible in mysql set the db folder into home user?
You use symbolic links:
http://www.mysql.com/doc/en/Symbolic_links_to_databases.html
example:
user fred, home is /home/fred i want store db data in /home/fred/db.
it's possible?
i've tested
Good question :)
I got a message from a person off the list that suggested I use network disk
mirroring or a NAS/SAN/NFS system to handle that. I'm not sure if the
mirroring would be 100% perfect, but the NAS/SAN solution should as either
server would be reading and writing to the same physical
Hi Dan, all,
I don't know PERL, just coming back to speed on PHP after 3+ years with
ColdFusion.
Trim() is a function listed in my PHP Functions book, not something I wrote.
It's supposed to: removes all whitespace characters from both the left and
right ends of a string... A space (ASCII 32)
Greetings all.
I have a bit of a problem here, a database i'm administering was somehow =
corrupted, and i'm unable to recover it in any way.
what happened? A power outage? You deleted the ib_logfiles? Modified my.cnf?
Hard disk broke?
Thats the weird thing, nothing abnormal happened, i just
Chris,
What version of MySQL are you using and what table type (InnoDB, MyISAM,
etc.)? I followed your procedure and was unable to replicate the problem
with MySQL 4.0.14 on a MyISAM table.
-Rob
-Original Message-
From: Chris Edwards [mailto:[EMAIL PROTECTED]
Sent: Wednesday,
On Tue, Aug 05, 2003 at 02:14:11PM +0100, [EMAIL PROTECTED] wrote:
See the command LOAD DATA FROM MASTER (
http://www.mysql.com/doc/en/LOAD_DATA_FROM_MASTER.html ). This should do
what you want - it does it for me.
As I understand it, this puts a read lock on each table as it copies it.
On Thu, Aug 07, 2003 at 03:58:37PM -0700, Jennifer Goodie wrote:
One of my coworkers insists that this is due to corrupt indexes, stating
that if an index points to a location outside of the record set
mysql gets
confused and hangs.
Does he have any evidence whatsoever for that?
At 12:54 -0400 8/8/03, Jeff McKeon wrote:
How can I see if a record was deleted from a database?
Jeff
You can attempt to SELECT it, and if you get no result, it's not there.
But that doesn't necesarily mean that it was once there and has now been
deleted. If you want to determine that, you'll
have you looked at the file permissions of the directory itself?
looks only maciej:staff may access this one, but no mysql user.
-yves
-Ursprüngliche Nachricht-
Von: Maciej Wiznerowicz [EMAIL PROTECTED]
An: [EMAIL PROTECTED]
Gesendet: Donnerstag, 7. August 2003 14:56
Betreff: mysqld
Setting skip-name-resolve will avoid this code path and the bug. It
looks like some DNS funkyness...
I've implented this and so far I can't get the box to hang in authentication
no matter how mean I am to it. I feel so dumb, for not thinking of this
before, I swore I had already done it
1 - 100 of 562 matches
Mail list logo