Mysql newbie here, looking for some help configuring 5.0.45 master-slave
replication. Here's my scenario...
We have a heavily loaded 30gb 5.0.45 DB we need to replicate via
master-slave configuration to a new, beefier server running same mysql
5.0.45, and then cutover to the new server.
dumps are already done during the least busy
times.
Regarding snapshots, how long are snapshot locks held? These are ext4
filesystems. Assuming the lock is not held for long, what's the
recommended way to do snapshots on ext4?
Thanks,
Ed
On Thursday, August 29, 2013, Ed L. mysql
This mysql newbie is having trouble connecting to a mysqld instance,
hoping someone can offer a clue on troubleshooting.
I have 2 mysql 5.0.45 installations on one RHEL server. One live mysqld
is setup in what appears to be a relatively standard installation, port
3306, user 'mysql', etc.
What are the *.index files in the MySQL Data directory? I notice a new one is
created every time that MySQL is stopped and restarted. My Data directory is
not in the default location so does that have anything to do with it?
Thanks,
Sandra Arnold
Data Warehouse Administrator
MartinFederal
There are files beginning with 1.sequence number. The sequence number is
01 to 15. A new file is created every time MySQL is restarted. The
1.index file contains a list of these files. One thing that I have done is
when I was hardening the security we stopped MySQL and moved the
.
There are low-impact software solutions.
There are hardware solutions. (This is what I am used to at work; it is
severe overkill for most users.)
Bottom line: There is no best or perfect solution. First decide what
'keeps you up at night'.
-Original Message-
From: Joey L [mailto:mjh2
It sounds like you are all consultants.
On Mon, Jun 11, 2012 at 4:46 PM, Baron Schwartz ba...@xaprb.com wrote:
Yeah -- that was an unintentional omission. There are solo consultants
like Ronald Bradford too.
On Mon, Jun 11, 2012 at 3:14 PM, Andrew Moore eroomy...@gmail.com wrote:
Not
I am running a site with about 50gig myisam databases which are the
backend to different websites.
I can not afford any downtime and the data is realtime.
What is the best method for this setup? master-master or master-slave?
What are the best utilities to create and maintain this setup? as far
balancing.
On Mon, Jun 11, 2012 at 7:56 PM, Joey L mjh2...@gmail.com wrote:
I am running a site with about 50gig myisam databases which are the
backend to different websites.
I can not afford any downtime and the data is realtime.
What is the best method for this setup? master-master or master
You listed a lot of things - but no solution - i am looking for master
- master configuration.
Any tools you have used ?
Anything concrete you can offer?
thanks
On Mon, Jun 11, 2012 at 11:39 AM, Shawn Green shawn.l.gr...@oracle.com wrote:
On 6/11/2012 10:36 AM, Ananda Kumar wrote:
...
of 'load balancing'; it is a high availability
solution you're looking for.
On Mon, Jun 11, 2012 at 4:43 PM, Joey L mjh2...@gmail.com wrote:
I understand ..I am looking for load balancing - something that i do
not have to worry about if one server goes down - the other server
will be up
yourself
in the foot. Whilst you're trialling things, you could try 'XtraDB Cluster'
from percona.
A
On Wed, Jun 6, 2012 at 5:09 AM, Joey L mjh2...@gmail.com wrote:
My current situation arises out of testing really - i restored a db
that is out of sync with the other server (having less records
you can deploy
and support this in production yourself with out fear of shooting yourself
in the foot. Whilst you're trialling things, you could try 'XtraDB Cluster'
from percona.
A
On Wed, Jun 6, 2012 at 5:09 AM, Joey L mjh2...@gmail.com wrote:
My current situation arises out of testing
I am following or trying to follow this document:
http://www.howtoforge.com/mysql5_master_master_replication_debian_etch
I think it is running in a good state because when i query the show
slave state, I get awaiting connection from host, like :
on server1:
mysql SHOW MASTER STATUS;
Hi -
I have setup mysql mult master setup on debian squeeze.
I have realized that the databases have to be initially in sync before
multi master can operate properly.
This can require a lot of down time on the one functioning server.
Is there a way to do an automatic sync from the 1 server that
email you lack of a lot of basics and I
suggest you to read some documentation before proceeding.
Maatkit is now Percona Toolkit and contains some of the best tools for
MySQL.
Cheers
Claudio
2012/6/5 Joey L mjh2...@gmail.com
Hi -
I have setup mysql mult master setup on debian squeeze.
I
you getting your data in sync but how have you
arrived at this out-of-sync predicament you find yourself in?
A
On Tue, Jun 5, 2012 at 11:03 PM, Joey L mjh2...@gmail.com wrote:
with all do respect - I am new to this - i did read the docs and
having a hard time.
I also was asking if you
master master and that
you're not implementing it because you think it's 'nice to have'.
pt-table-sync should assist you getting your data in sync but how have you
arrived at this out-of-sync predicament you find yourself in?
A
On Tue, Jun 5, 2012 at 11:03 PM, Joey L mjh2...@gmail.com wrote
, Jun 5, 2012 at 3:53 PM, Joey L mjh2...@gmail.com wrote:
I am following or trying to follow this document:
http://www.howtoforge.com/mysql5_master_master_replication_debian_etch
I think it is running in a good state because when i query the show
slave state, I get awaiting connection from host
i am running mysqlrepair on 80G myisam table.
It is taking forever to repair - i am getting a lot of Waiting for
table messeges when i execute show full processlist
613 | p_040912 | localhost | p_040912| Query | 24 | Waiting
for table | SELECT `oldurl`, `newurl
Can anyone help for
i am getting this wierd error in the mysql log:
120604 8:31:32 [Warning] option 'table_cache': unsigned value
536870912 adjusted to 524288
I have 28G of ram in my server, can anyone tell me what this value
should be set to ?
what is the syntax - i have tried different syntax -- get the same
Can you explain this further ?
Sorry a little slow ?
table count * expected connections
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
I am running debian with mysql 5.1
I am running the backup command like this :
innobackupex --user=root --password=pass --stream=tar .^C| bzip2 -
./xtra/052912backup.tar.bz2
and doing the restore command like this in the /var/lib/mysql directory:
tar -xvif ./xtra/052912backup.tar.bz2
and then i
On 2/29/2012 5:54 PM, LUCi5R wrote:
JW,
I'm trying to understand LEFT JOIN as we go - but it's not working.
This query
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHONE
WHERE CUSTOMERS.DATE = 02/28/12 AND (CALLS.PHONE IS NULL OR CALLS.DATE =
02/28/12)
Is
Stupid wrapping helped me to make a simple mistake. I wrote
On 3/1/2012 10:40 AM, LUCi5R wrote:
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHONE AND
CUSTOMERS.DATE=CALLS.DATE = 02/28/12
But I meant it to be
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE =
-database/
and you can also use something like :
#!/bin/bash
mysql dbnaneEOFMYSQL
DROP table table_name;
CREATE TABLE table_name;
EOFMYSQL
Thanks Rg
Mohan L
I have a very large table - approx 3 or 4 gig in size.
When i initiate a process on my webpage - mysql starts to create a
temporary table in /tmp directory.
Is there a way i can create this file/table ahead of time so mysql
does not have to create it ?
thanks
mjh
--
MySQL General Mailing List
On Mon, Oct 24, 2011 at 10:52 AM, Joey L mjh2...@gmail.com wrote:
I have a very large table - approx 3 or 4 gig in size.
When i initiate a process on my webpage - mysql starts to create a
temporary table in /tmp directory.
Is there a way i can create this file/table ahead of time so mysql
You should do EXPLAINs on your slow-running queries to find out which ones
are likely... If it is generating a 30gig file, I'd expect it must be a very
slow query.
I know why the files are being created - but is there anything i can
do on the server to accomodate for large file operations ?
MySQLTuner 1.2.0 - Major Hayden ma...@mhtx.net
Bug reports, feature requests, and downloads at http://mysqltuner.com/
Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:
/
any thoughts or help would be appricated.
thanks
On Mon, Oct 3, 2011 at 1:22 PM, Eric Bergen eric.ber...@gmail.com wrote:
Can you run show processlist in another connection while the select
count(*) query is running and say what the state column is?
On Mon, Oct 3, 2011 at 7:00 AM, Joey L mjh2
is done by webcrawlers to the
site - so there is a lot of activity occuring on the 9gig tables.
thanks
mjh
On Thu, Oct 6, 2011 at 6:13 AM, Joey L mjh2...@gmail.com wrote:
guys - i am having such a hard time with this..it is killing me!!!
Sorry - had to vent.
my machine is running an tyan
AM, Joey L mjh2...@gmail.com wrote:
Just as an fyi - I have other databases and their corresponding apache
websites on the same server - performing okay.
It seems that apache/mysql server is just having a hard time dealing
with the access to those pages that deal with the 9gig table
here is mysqlreport ---
root@rider:~/tmp# ./mysqlreport --user root --password barakobomb
Use of uninitialized value $is in multiplication (*) at ./mysqlreport line 829.
Use of uninitialized value in formline at ./mysqlreport line 1227.
MySQL
be better suited to InnoDB engine (you must configure and tune for this, not
JUST change the engine).
HTH
Andy
On Thu, Oct 6, 2011 at 5:05 PM, Andrew Moore eroomy...@gmail.com wrote:
Joey, does your 'large' table get
On Thu, Oct 6, 2011 at 3:22 PM, Joey L mjh2...@gmail.com wrote:
here
another session, do a show processlist
I bet you that you will see another process updating or deleting or
inserting into the MyISAM table.
On Thu, Oct 6, 2011 at 12:35, Joey L mjh2...@gmail.com wrote:
i did google search - myisam is faster...i am not really doing any
transaction stuff
about 20 miles long.
thanks again
mjh
On Thu, Oct 6, 2011 at 7:48 PM, Jan Steinman j...@bytesmiths.com wrote:
From: Joey L mjh2...@gmail.com
i did google search - myisam is faster...i am not really doing any
transaction stuff.
That's true for read-only. But if you have a mix of reads
:
set global wait_timeout=some value
You can do the same for the interactive_timeout.
Setting these values too low will cause long running queries to abort
On 10/02/2011 07:02 PM, Joey L wrote:
Variables to adjust:
max_connections ( 100)
wait_timeout ( 28800
:58 AM, Andrés Tello mr.crip...@gmail.com wrote:
have you tried
select count(yourindex) instead of select count(*) ?
On Mon, Oct 3, 2011 at 7:53 AM, Joey L mjh2...@gmail.com wrote:
Thanks for the input -
1. I will wait 48 hours and see what happens.
2. can you tell me what are some
I have having issues with mysql db - I am doing a select count(*) from
table -- and it take 3 to 4 min.
My table has about 9,000,000 records in it.
I have noticed issues on my web pages so that is why i did this test.
I have about 4 gig of memory on the server.
Is there anything I can do to fix
?
A
On Sun, Oct 2, 2011 at 2:44 PM, Joey L mjh2...@gmail.com wrote:
I have having issues with mysql db - I am doing a select count(*) from
table -- and it take 3 to 4 min.
My table has about 9,000,000 records in it.
I have noticed issues on my web pages so that is why i did this test.
I have about 4
, Singer X.J. Wang w...@singerwang.comwrote:
Are you sure? Do a show create table and send it to us please
On Sun, Oct 2, 2011 at 10:02, Joey L mjh2...@gmail.com wrote:
thanks for the quick reply!
My table is MyISAM
further top says this:
top - 10:01:29 up 8:25, 4 users, load average
Also i did run mysqlcheck and i did optimize and repair the database/table..
thanks
On Sun, Oct 2, 2011 at 9:19 PM, Joey L mjh2...@gmail.com wrote:
The section called: Variables to adjust: --when it says -- does this
mean I have to set it higher in my.cnf file ?? and if I have a -- does
Dear All,
I have the following two system variable set in my MySQL configuration file
under mysqld section. But I am not fully understand what the two variable
internally does.
innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
Any help will be appreciated.
Thanks for Your Time
Mohan L
Yes! The illegal double error only happens if you do the select like you
did. The only error I was getting was the generic there's an error in your
sql.
Thank you!
Bob
From: Hank [mailto:hes...@gmail.com]
Sent: Monday, December 20, 2010 11:52 AM
To: Ramsey, Robert L
Cc: mysql
storage
bases on date .Here id is same. I am new to witting mysql query (learning).
I think this can be done using sub query. any help will be really
appreciated .
Thanks Rg
Mohan L
I have a query with three subselects, all referencing the same table. I'd like
to be able to combine them into one with aliases.
Here's what I have now:
select letter_codename,
(select greek from letter_otherlanguages where letter ='A') as greek,
(select french from letter_otherlanguages where
Say I have the following data:
+---+
| title
|
+---+
| ...And justice
Kris wrote:
Hello,
I am trying to produce an automated, reliable, and repeatable way of
testing mysql releases, and I am finding an error that makes this
impossible to accomplish.
I am trying to compile mysql and install it in a non-standard directory.
I do notwant mysql installed in /usr or
Hi,
I have a table of events like this:
Evtuid
Evtname
Startdate
Stopdate
Repeats enum('true', 'false')
Monday enum('true', 'false')
Tuesday enum('true', 'false')
Wednesday enum('true', 'false')
Thursday enum('true', 'false')
Friday enum('true', 'false')
Satday enum('true', 'false')
Sunday
Hi,
I'm a little rusty in my SQL statements, and I'm not all that certain
that this can be done.
IF I have a field with the contents like:
http://beta.somedomain.com/url/url/url=2;
where 2 is the record ID value. And I need to change the contents of
that field to read:
Little, Timothy wrote:
Also titled, I want this to run slow ALL the time...
I have a group of dreadful queries that I have to optimize.
Some take 20-30 seconds each -- the first time that I run them. But
then they never seem to take that long after the first time (taking less
than a second
blackwater dev wrote:
I have a hold car data such as color, model, make, year, etc. I want to
allow the user to answer some questions and I'll present them with the car
that 'best' matches their criteria. How do I do this? I still want to
return ones that don't match exactly but want the
to be there including the structureMy problem is that I run a query like this :
SELECT x.application_name, y.role_name FROM application x, role y JOIN logical_app_role_link l ON x.application_id = l.application_id AND y.role_id = l.role_id WHERE l.logical_id = 15;
It works for the old mysql version
Octavian Râºniþã wrote:
Hello,
I've tried to create these 4 test tables, but when I try to create the last
one, MySQL gives the following error:
ERROR 1005 (HY000) at line 20: Can't create table '.\z\favorite_link.frm'
(errno
: 150)
It seems that the foreign keys are not created well in
Bob wrote:
mysql.sock doesn't exist on the hard drive.
Start the server.
--
Gerald L. Clark
Sr. V.P. Development
Supplier Systems Corporation
Unix since 1982
Linux since 1992
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
off the computer without a proper shutdown.
Get a UPS.
--
Gerald L. Clark
Sr. V.P. Development
Supplier Systems Corporation
Unix since 1982
Linux since 1992
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 or 10 times in one day just that it happened at least once on that day
for a user.
Chris W
try DISTINCT.
--
Gerald L. Clark
Sr. V.P. Development
Supplier Systems Corporation
Unix since 1982
Linux since 1992
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
`,
MIN(b.id) - 1 AS `To`
FROM tbl AS a, tbl AS b
WHERE a.id b.id
GROUP BY a.id
HAVING a.id `To`
--
Gerald L. Clark
Sr. V.P. Development
Supplier Systems Corporation
Unix since 1982
Linux since 1992
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
(calories) from People
INNER JOIN Meals ON People.Name=Meals.Name
INNER JOIN Meal_Items on Meals.Meal_ID=Meal_Items.Meal_ID
WHERE Name='Brian' AND Date='2009-09-04';
--
Gerald L. Clark
Sr. V.P. Development
Supplier Systems Corporation
Unix since 1982
Linux since 1992
--
MySQL General Mailing List
attempt a
/usr/local/etc/rc.d/mysql-server.sh restart
But the server does not start until I change the address back to the LAN
address.
Any help would be appreciated. I have not found via Google anyone else
having this issue.
Does that IP address resolve to your hostname?
--
Gerald L. Clark
Sr
=latin1
Regards
Phil
With no where clause, and aggregate functions, it is faster to do a full
table read, and the sort the aggregated results.
--
Gerald L. Clark
Sr. V.P. Development
Supplier Systems Corporation
Unix since 1982
Linux since 1992
--
MySQL General Mailing List
For list
I'm running MySQL 5.0.22 on CentOS 5.1 (with all current patches
applied) and tried to define a table 'testcsv' using ENGINE = CSV. I
couldn't find a *.CSV file in the data directory. After looking it up in
MySQL Third Edition (by Paul DuBois) it turns out that I'm not running
the CSV engine. My
Folks,
Thanks for the 'help'. Oy.
I figured it out from some help on the Lasso discussion list.
All I had to do was properly address ALL the tables I wanted to touch.
So this:
UPDATE tbe_gallery
SET tbe_gsa.gsa_paperprice = tbe_gallery.gallery_gsaprice_paper
WHERE tbe_gallery.gallery_id =
Hi,
I'm wondering if the following can be done
UPDATE tbe_gallery
SET tbe_gsa.gsa_paperprice = tbe_gallery.gallery_gsaprice_paper
WHERE tbe_gallery.gallery_id = tbe_images.img_rel_id AND
tbe_images.img_orig_filename = tbe_gsa.gsa_id
Let me explain:
I have 3 tables and only 1 of them
Hi,
I'm having trouble wrapping my head around this problem. I have a list
of events for multiple computers. What I want to get is a summary of
the top 3 most common errors for each computer. So I get a result like
this:
Computername event numb_times
Comp1
Dear Users
I searched google, find alot of tips, but none of the them was
successfully.
After a db move with ibdata files, which cannot be dumped (cause of a table
failure) we made a hardcopy of the files and moved it onto the new server.
Eg. we copy ibdatafiles, the original my.cnf to the new
, Robert L [EMAIL PROTECTED] wrote:
I'm looking for a best practices way of creating tables to store
both
one time and regularly repeating events. These are classes, so for
the
most part the have a regularly recurring time, but we do have some
one
off events. (...)
The only other way I could
Hi,
I'm looking for a best practices way of creating tables to store both
one time and regularly repeating events. These are classes, so for the
most part the have a regularly recurring time, but we do have some one
off events. For example, let's say the following:
Class-A Mon,Wed,Fri 8-9 from
the data is still in cache, so no read is actually made from the
disc.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Manager
Department of Mechanical Engineering
University of Michigan
734-764-8482
Fridays: 734-355-6577
AIM/iChat/Skype ID: baiewola
mysql does not have write privilege in
/usr/local/mysql-5.0.41-osx10.4-i686/data.
Is this owned by root too?
--
Gerald L. Clark
Supplier Systems Corporation
is a permissions error. Check all directories from / to the
data directory.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the user and only leaving ‘%’ with
no difference at all. I’ve also tried the –protocol=TCP option with no luck
either.
Any pointers?
TIA
Hector S. Mendoza O
PS. mysqld Ver 5.0.27
Use a my.cnf file in the user's home directory.
--
Gerald L. Clark
Supplier Systems Corporation
| ALL | NULL | NULL |
NULL | NULL | 1351 | |
++-+---+---+---+--+-+--+--+--+
-- rich
rpt_cpc needs an index on sourceID.
--
Gerald L
Linux Administrator/MySQL DBA
IT Infrastructure
American Home Mortgage
w: 631-622-6382
c: 516-652-2475
Use explain, and find out.
MySQL may reverse the two and join A to B inorder to use A's index.
Since there is no WHERE clause, only one of the tables needs an index.
--
Gerald L. Clark
Supplier
options with no luck. All tables are MyISAM.
Can anyone shed some light on what I'm supposed to do?
Thanks,
Seth
Shut the server down and run myisamchk on users.MYI
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
, and how do i fix it. Please help
regards
anandkl
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on this subject, please point me in the right direction?
You are not looged in to mysql as a user with create privileges.
You might need to backup a few chapters.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Baron Schwartz wrote:
Gerald L. Clark wrote:
Ben Clewett wrote:
Dear MySQL,
I'm running 5.0.26 through Heartbeat. Which seems to work well, even
as a replication slave and Heartbeat continously stopping and
starting the server.
The Heartbeat moves MySQL around from server to server
PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED]
The show grants you ran shows you the proper syntax.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
, at this
point...
-untz
You have to be logged-in to mysql as a privileged user to grant
permissions to others.
Logout, and login as root.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
to be a
long list), I wondered if it is possible to just lock one table, with the
gentleman's agreement that in order to modify the database, every process
must first lock that particular table.
You could use a string lock for this.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing
, perform
your updates, and then UNLOCK TABLES.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Ananda, I don't know how to solve this, but if you have space in another
storage, try restoring your all-databases dump there and then create a new
onlyone-database dump to restore in your server.
Regards.
Pelle.-
-Mensaje original-
De: Ananda Kumar [mailto:[EMAIL PROTECTED]
limit of your filesystem,
or the default maximum MyISAM size?
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem
is I have a query that's failing and I can't figure it, I can't read the
log file.
Suggestions anyone?
Use the mysqlbinlog command.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
* FROM myTable WHERE col3 = ' '; -- a space character
If this is the case, you might consider using a different table type,
such as InnoDB.
HTH,
Kevin
MyISAM has no problem representing NULL.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http
the db)
Best luck
mysqlhotcopy does not require a database shutdown. If it did, it
would not be a hot copy.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
in the target directory.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I change the mysql home directory
to some other folder?
Neither.
Just make sure that mysql has permission to write in the directory you
want to contain the output file.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
with model or tyre_type, then no.
The index can be used down to, but not including the first column that
is compared against '%'.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
to do to stop the replication process?
Thanks,
Jesse
You have to remove the master information from the slave's my.ini file.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
up sending mail to Sy Serson.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
)
070418 8:43:57 [ERROR] Can't start server: can't create PID file: Undefined
error: 0
070418 08:43:57 mysqld ended
HOw is this fixed?
The mysql user must have execute and write privilege on /usr/contrib/var
and all subdirectories.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL
!
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
These are not the same type.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(*) from fidcid;
+---+
| count(*) |
+---+
| 100480507 |
+---+
1 row in set (0.09 sec)
If this table is InnoDB, then count(*) is
just an approximation.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
rt3
--set-variable=max_allowed_packet=256M Attachments Attachments.sql
Try adding the -q option.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-leading spam and email virus protection.
You will not be able to search on encrypted fields.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 633 matches
Mail list logo