Re: Post-installation config and startup questions

2015-06-23 Thread Steve Matzura
On Tue, 23 Jun 2015 14:51:48 -0400, you wrote: > > >On 6/23/2015 10:59 AM, Steve Matzura wrote: >> I'm building a mail system with Dovecot, Postfix and Mailman with >> MySQL. I have the other three products installed but not yet >> configured. I'll do that after I get MySQL running. >> >> The docu

Re: Post-installation config and startup questions

2015-06-23 Thread shawn l.green
On 6/23/2015 10:59 AM, Steve Matzura wrote: I'm building a mail system with Dovecot, Postfix and Mailman with MySQL. I have the other three products installed but not yet configured. I'll do that after I get MySQL running. The documentation at http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en

Re: Post-installation config and startup questions

2015-06-23 Thread a . smith
Hi Steve, you haven't said what OS you are installing this on or how you have installed MySQL. Normally you would use a version avaialable in your OS distribution as this avoids any overly complicated installation and will manage security and bug patches for you MySQL binaries. Ie insta

Post-installation config and startup questions

2015-06-23 Thread Steve Matzura
I'm building a mail system with Dovecot, Postfix and Mailman with MySQL. I have the other three products installed but not yet configured. I'll do that after I get MySQL running. The documentation at http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html was instrument

Re: questions about timestamps and DST

2015-03-31 Thread Mark Goodge
changed. If you want to store a specific value you should use a datetime field." http://stackoverflow.com/questions/409286/datetime-vs-timestamp As a more general rule of thumb, use DATETIME unless you have a specific application for which you know that TIMESTAMP is more appro

Re: questions about timestamps and DST

2015-03-31 Thread Larry Martell
r any time in that hour I give. This makes me >> think that I have not actually solved the problem for next year (I >> can't test this to know). >> >> So my questions are: >> >> 1) How can I actually insert a timestamp value that will not be >> affected by

Re: questions about timestamps and DST

2015-03-30 Thread Andrew Moore
ime in that hour I give. This makes me > think that I have not actually solved the problem for next year (I > can't test this to know). > > So my questions are: > > 1) How can I actually insert a timestamp value that will not be > affected by the time change and not have the missi

questions about timestamps and DST

2015-03-30 Thread Larry Martell
time in that hour I give. This makes me think that I have not actually solved the problem for next year (I can't test this to know). So my questions are: 1) How can I actually insert a timestamp value that will not be affected by the time change and not have the missing hour? 2) Why is it not

Re: Questions about building a dedicated MySQL server.

2014-03-17 Thread Carsten Pedersen
On 17-03-2014 16:21, Mister Vlad wrote: I am looking at building a dedicated MySQL server... was wondering about the downside to using SSD drives? My thoughts was going 2 servers, with 4 drives each in raid 5 (3+1) configuration. Is this a good idea? I was originally thinking about going Raid

Questions about building a dedicated MySQL server.

2014-03-17 Thread Mister Vlad
I am looking at building a dedicated MySQL server... was wondering about the downside to using SSD drives? My thoughts was going 2 servers, with 4 drives each in raid 5 (3+1) configuration. Is this a good idea? I was originally thinking about going Raid5(3+1) and Raid 1 (Mirrored) but that mig

re: replication newbie questions

2013-08-29 Thread Michael Widenius
Hi! > "Ed" == Ed L writes: Ed> Mysql newbie here, looking for some help configuring 5.0.45 master-slave Ed> replication. Here's my scenario... Ed> We have a heavily loaded 30gb 5.0.45 DB we need to replicate via Ed> master-slave configuration to a new, beefier server running same mysql

Re: replication newbie questions

2013-08-28 Thread Ananda Kumar
if i u have LVM's then lock is held only for the duration of taking snapshot, which would be few min, if there is very less activity on the db. On Wed, Aug 28, 2013 at 3:08 PM, Ed L. wrote: > On 8/28/13 2:00 PM, Ananda Kumar wrote: > > > Why don't u try snapshot backups, where the lock held fo

Re: replication newbie questions

2013-08-28 Thread Ed L.
On 8/28/13 2:00 PM, Ananda Kumar wrote: Why don't u try snapshot backups, where the lock held for less duration. Or can't u take mysql dumps during Night time when there is less bd activity I neglected to mention these systems are both CentOS linux systems. Unfortunately, the 5.5 hour dumps

Re: replication newbie questions

2013-08-28 Thread Ananda Kumar
Why don't u try snapshot backups, where the lock held for less duration. Or can't u take mysql dumps during Night time when there is less bd activity On Thursday, August 29, 2013, Ed L. wrote: > > Mysql newbie here, looking for some help configuring 5.0.45 master-slave replication. Here's my sce

replication newbie questions

2013-08-28 Thread Ed L.
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. Du

RE: questions about group_concat_max_len

2013-01-07 Thread Rick James
, then pay whatever the price is. "If you hit a MySQL limit, you are probably mis-using MySQL." > -Original Message- > From: Paul Halliday [mailto:paul.halli...@gmail.com] > Sent: Friday, January 04, 2013 5:12 AM > To: mysql mailing list > Subject: questions a

Re: Questions about mysql-proxy...

2012-04-16 Thread Kristian Davies
On Fri, Apr 6, 2012 at 2:46 PM, shawn green wrote: > On 4/5/2012 3:14 PM, Wes Modes wrote: >> >> No one here has any experience with it? We use the proxy between master/slaves for the last 3 years. I didn't implement it, but I look after it. I'm just about to switch to 0.8.2, but the only real

Re: Questions about mysql-proxy...

2012-04-06 Thread shawn green
On 4/5/2012 3:14 PM, Wes Modes wrote: No one here has any experience with it? ... Probably not. If you notice the version number for MySQL Proxy still starts with a "0." which the universally accepted indicator that it is of pre-production quality. Thanks to the corporate changes of the las

Re: Questions about mysql-proxy...

2012-04-05 Thread Wes Modes
No one here has any experience with it? W. On 4/4/2012 2:17 PM, Claudio Nanni wrote: > Wes, > Thanks for these questions about this 'ghost' of the MySQL world, it > seems more a legend than a real thing! > I am sorry I do not have the answers but I would love to hear some

Re: Questions about mysql-proxy...

2012-04-04 Thread Claudio Nanni
Wes, Thanks for these questions about this 'ghost' of the MySQL world, it seems more a legend than a real thing! I am sorry I do not have the answers but I would love to hear some. All I can say is that MySQL Proxy is currently (still) in Alpha http://dev.mysql.com/downloads/mysql-pr

Re: Questions about Mysqldump

2011-09-15 Thread Ananda Kumar
or u can use "for loop", have only the database to be exported and use that variable in --database and do mysqldump of each database. On Thu, Sep 15, 2011 at 6:27 PM, Carsten Pedersen wrote: > On 15-09-2011 10:31, Chris Tate-Davies wrote: > >> Adarsh, >> >> 1) >> >> When restoring a mysqldump you

Re: Questions about Mysqldump

2011-09-15 Thread Carsten Pedersen
On 15-09-2011 10:31, Chris Tate-Davies wrote: Adarsh, 1) When restoring a mysqldump you have the option of which database to restore. mysql database1 < backup.sql Admittedly, it's been a few years since I last used mysqldump, but I suspect that it will contain USE commands - as such, it wil

Re: Questions about Mysqldump

2011-09-15 Thread Chris Tate-Davies
Adarsh, 1) When restoring a mysqldump you have the option of which database to restore. mysql database1 < backup.sql 2) You might be able to use the --ignore-table command. I'm not sure if this would work mysqldump --all-databases -q --single-transaction --ignore-table=databasetoignore.*

Questions about Mysqldump

2011-09-14 Thread Adarsh Sharma
Dear all, Today i backup my all databases (25) by using the below command :- mysqldump --all-databases -q --single-transaction | gzip > /media/disk-1/Server11_MysqlBackup_15September2011/mysql_15sep2011backup.sql.gz Now I have some doubts or problems that I need to handle in future : 1. Is

Re: Innodb table space questions

2011-01-17 Thread Angela liu
n, 1/17/11, Eric Bergen wrote: From: Eric Bergen Subject: Re: Innodb table space questions To: "Angela liu" Cc: mysql@lists.mysql.com Date: Monday, January 17, 2011, 10:09 PM reply inline On Mon, Jan 17, 2011 at 9:30 PM, Angela liu wrote: > Folks : > > two questions: > >

Re: Innodb table space questions

2011-01-17 Thread Eric Bergen
reply inline On Mon, Jan 17, 2011 at 9:30 PM, Angela liu wrote: > Folks : > > two questions: > > 1. can Innodb create per database table space , not per table table space? No. The only available options are creating a global tablespace which can be many files or a file per tabl

Innodb table space questions

2011-01-17 Thread Angela liu
Folks : two questions: 1. can Innodb create per database table space , not per table table space? 2. can we store table on specific tablespace like Oracle or DB2 when creating table? Many thanks.

Re: Questions regarding Query cache usage

2010-06-09 Thread Kyong Kim
Absolutely. You don't want to obscure the cause by just throwing more hardware at things. That approach just buys you time until a bigger pile hits the fan if the underlying issue remains unresolved. At the same time, though, 8 MB production innodb buffer pool allocation should be fairly high on th

Re: Questions regarding Query cache usage

2010-06-09 Thread Johan De Meersman
On Wed, Jun 9, 2010 at 8:04 PM, Kyong Kim wrote: > If the memory is available, why not use it? It seems like the default > buffer pool size out of the box was just never changed. Agreed, of course, but if something happens on a system that is out of the ordinary, it's very good practice to hunt t

Re: Questions regarding Query cache usage

2010-06-09 Thread Kyong Kim
On Tue, Jun 8, 2010 at 10:57 PM, Machiel Richards wrote: > Good morning all > > > >        I would like to try and find out how you can see what is using the > query cache. > > > >                My reason for asking is the following: > > > >                On one of our client databases, the quer

Questions regarding Query cache usage

2010-06-08 Thread Machiel Richards
Good morning all I would like to try and find out how you can see what is using the query cache. My reason for asking is the following: On one of our client databases, the query cache is set to 128Mb and the usage always varied between 5% and 53%

RE: DBA questions to ask WAS: How to corrupt a database please???

2010-04-22 Thread Daevid Vincent
-8388608 to 8388607 # SMALLINT SIGNED = -32768 to 32767 # TINYINT SIGNED = -128 to 127 # TINYTEXT = 255 # TEXT = 65535 # MEDIUMTEXT = 16777215 # LONGTEXT = 4294967295 # TEXT fields are NOT case sensitive, whereas BLOB fields are. # Always try to use UNSIGNED integers whenever possible. Anyways

RE: timezone questions

2010-03-29 Thread Daevid Vincent
> -Original Message- > From: Elim PDT [mailto:e...@pdtnetworks.net] > Sent: Monday, March 29, 2010 5:57 PM > To: mysql@lists.mysql.com > Subject: timezone questions > > data from one server in timezone A ported to another server > in timezone B, what will hap

timezone questions

2010-03-29 Thread Elim PDT
data from one server in timezone A ported to another server in timezone B, what will happen for the records with datetime columns? What is the recommended way of handling this kind of issues? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: [PHP] Instll php on Window 2003 64Bit questions

2010-01-04 Thread Richard Quadling
2010/1/3 Ashley Sheridan : > On Sun, 2010-01-03 at 15:10 +0800, Edward S.P. Leong wrote: > >> Dear All, >> >> If the OS is Windows 2003 64Bit (IIS)... >> So, which php package must download and how to config it for running >> with IIS ? >> Due to I don't quite the online manual: >> http://www.php.n

Re: [PHP] Instll php on Window 2003 64Bit questions

2010-01-03 Thread Daniel Egeberg
On Sun, Jan 3, 2010 at 08:10, Edward S.P. Leong wrote: > Dear All, > > If the OS is Windows 2003 64Bit (IIS)... > So, which php package must download and how to config it for running > with IIS ? > Due to I don't quite the online manual: > http://www.php.net/manual/en/install.windows.iis.php > Whi

Re: [PHP] Instll php on Window 2003 64Bit questions

2010-01-03 Thread Bilal Akhtar
There are instructions on the Microsoft IIS site on installing php as well. http://php.iis.net/ Bilal On Sun, 2010-01-03 at 14:15 +, Ashley Sheridan wrote: > On Sun, 2010-01-03 at 15:10 +0800, Edward S.P. Leong wrote: > > > Dear All, > > > > If the OS is Windows 2003 64Bit (IIS)... > > So, w

Instll php on Window 2003 64Bit questions

2010-01-02 Thread Edward S.P. Leong
Dear All, If the OS is Windows 2003 64Bit (IIS)... So, which php package must download and how to config it for running with IIS ? Due to I don't quite the online manual: http://www.php.net/manual/en/install.windows.iis.php Which installation mode is suitable of it ? Thanks ! Edward. -- MySQL

Re: ssl questions

2009-10-12 Thread Neil Tompkins
We are looking to install on windows. Sent from my iPod On 11 Oct 2009, at 18:02, muhammad subair wrote: Hi, Maybe, first you can check MySQL documentation [0], [1] [0] http://dev.mysql.com/doc/refman/5.0/en/secure-using-ssl.html [1] http://dev.mysql.com/doc/refman/5.0/en/secure-basics.htm

Re: ssl questions

2009-10-11 Thread muhammad subair
Hi, Maybe, first you can check MySQL documentation [0], [1] [0] http://dev.mysql.com/doc/refman/5.0/en/secure-using-ssl.html [1] http://dev.mysql.com/doc/refman/5.0/en/secure-basics.html -- Muhammad Subair On Thu, Oct 8, 2009 at 6:03 PM, Tompkins Neil wrote: > Hi > > I wondered how you are ge

RE: Some MySQL questions

2009-10-08 Thread Gavin Towey
Try the tutorial: http://dev.mysql.com/doc/refman/5.0/en/tutorial.html Regards, Gavin Towey -Original Message- From: John Oliver [mailto:joli...@john-oliver.net] Sent: Thursday, October 08, 2009 2:19 PM To: mysql@lists.mysql.com Subject: Some MySQL questions 1) When I select * from

Re: Some MySQL questions

2009-10-08 Thread Nathan Sullivan
On Thu, Oct 08, 2009 at 02:33:34PM -0700, Carlos Proal wrote: > On 10/8/2009 4:19 PM, John Oliver wrote: > > 1) When I select * from whatever; is there a way to have the results go > > by one screen at a time? > > > > You can limit output by delimiting your search ie > > select * from users li

Re: Some MySQL questions

2009-10-08 Thread Carlos Proal
On 10/8/2009 4:19 PM, John Oliver wrote: 1) When I select * from whatever; is there a way to have the results go by one screen at a time? You can limit output by delimiting your search ie select * from users limit x,y; x=offset y=rows after the ofset 2) In reference to the above, is ther

Some MySQL questions

2009-10-08 Thread John Oliver
1) When I select * from whatever; is there a way to have the results go by one screen at a time? 2) In reference to the above, is there a way to just display the row that shows the names of each column? I need to drop one row from a table with a few thousand rows. I guessing I want to: delete f

Re: ssl questions

2009-10-08 Thread Tompkins Neil
Hi I wondered how you are getting on with installing SSL for mysql 5.1 server. We are looking to install it too. Do you have any pointers/recommendations ? Regards Neil On Tue, Sep 8, 2009 at 11:36 PM, qt4x11 wrote: > I'm trying to set up my mysql 5.1 server to work over ssl, I'm following >

Re: Questions on un-index searches and slow-query-log

2009-10-05 Thread Walter Heck - OlinData.com
And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html On Tue, Oct 6, 2009 at 02:59, Brown, Charles wrote: > Questions Folks: > (1) What do you about un-index searches. How can one report and monitor them? > (2) What do you do with the slow-query log. Are there any uti

RE: Questions on un-index searches and slow-query-log

2009-10-05 Thread Gavin Towey
Meyer; Mark Phillips Subject: Questions on un-index searches and slow-query-log Questions Folks: (1) What do you about un-index searches. How can one report and monitor them? (2) What do you do with the slow-query log. Are there any utilities or scripts out there to filter and manage this log

Questions on un-index searches and slow-query-log

2009-10-05 Thread Brown, Charles
Questions Folks: (1) What do you about un-index searches. How can one report and monitor them? (2) What do you do with the slow-query log. Are there any utilities or scripts out there to filter and manage this log? Thanks This message is

Re: Questions on Database Design

2009-10-04 Thread Mark Phillips
donné que les email > peuvent facilement être sujets à la manipulation, nous ne pouvons accepter > aucune responsabilité pour le contenu fourni. > > > > > > > > Date: Sat, 3 Oct 2009 18:11:59 -0600 > > From: john.l.me...@gmail.com > > To: m...@phillipsmarketi

Re: Questions on Database Design

2009-10-03 Thread John Meyer
Mark Phillips wrote: On Sat, Oct 3, 2009 at 3:06 PM, Martin Gainty wrote: depends on the relationship of the Data Tables and the Users that use them for instance if I was to setup a table of outgoing calls from 2 distinct individuals : Me> calls to HarvardMedicalSchoo

Re: Questions on Database Design

2009-10-03 Thread Mark Phillips
On Sat, Oct 3, 2009 at 4:02 PM, John Meyer wrote: > > John, >> Thanks. The data is private to each user; there is no sharing of data. I >> am not sure what you mean by "are the actions related" Each user is >> reading/writing independently of each other. Would that argue for separate >> database

Re: Questions on Database Design

2009-10-03 Thread Mark Phillips
t that user a cannot get to user b's data. Can't I achieve the same level of security if each row has a userID, and all queries use a "where userID=xxx" clause? Mark > > > > Date: Sat, 3 Oct 2009 14:38:25 -0700 > > Subject: Questions on Database Design &g

Re: Questions on Database Design

2009-10-03 Thread John Meyer
John, Thanks. The data is private to each user; there is no sharing of data. I am not sure what you mean by "are the actions related" Each user is reading/writing independently of each other. Would that argue for separate databases? Mark Are the actions of a similar nature (i.e. they're

Re: Questions on Database Design

2009-10-03 Thread Mark Phillips
On Sat, Oct 3, 2009 at 2:47 PM, John Meyer wrote: > Mark Phillips wrote: > >> I am new at database design, and my question relates to the trade-offs >> between putting all data in one database or several for mysql. For >> example, >> say I have an application where a users login from their mobile

Re: Questions on Database Design

2009-10-03 Thread John Meyer
Mark Phillips wrote: I am new at database design, and my question relates to the trade-offs between putting all data in one database or several for mysql. For example, say I have an application where a users login from their mobile phones and read/write data to a database. Say there are roughly 1

Questions on Database Design

2009-10-03 Thread Mark Phillips
I am new at database design, and my question relates to the trade-offs between putting all data in one database or several for mysql. For example, say I have an application where a users login from their mobile phones and read/write data to a database. Say there are roughly 10-15 tables in the data

ssl questions

2009-09-08 Thread qt4x11
I'm trying to set up my mysql 5.1 server to work over ssl, I'm following the directions at http://dev.mysql.com/doc/refman/5.0/en/secure-connections.html. I've confirmed that my server supports ssl mysql> SHOW VARIABLES LIKE 'have_ssl'; +---+---+ | Variable_name | Value | +---

binlog questions

2009-06-02 Thread Joshua Gordon
We outputted the bin log using the following command: mysqlbinlog -v --base64-output=DECODE-ROWS oo-mysql1-bin.87 We then looked in this file and found some odd things. For example there is the below insert statement: ### INSERT INTO panel.history ### SET ### @1=-182667600 (4112299696) ##

Re: Replica questions

2009-03-12 Thread Claudio Nanni
> > > If you are finding replication stops after a reboot then I think you have a > serious problem, but don't know what that might be. Post some more info and > someone on the list can probably help, > > just a 'skip-slave-start' in my.cnf does the trick. 2> Is there a way to get a slave to auto

Re: Replica questions

2009-03-12 Thread Andy Smith
BTW there is a list specially dedicated to replication configurations: http://lists.mysql.com/replication -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Replica questions

2009-03-12 Thread Andy Smith
:S Hi Bryan Actually changing the slave setup after a reboot is a very bad idea, you will have inconsistent data on your slave because every transaction made from when you rebooted the server to when you reset the position will not be copied from the master. Thats the point of the posi

Re: Replica questions

2009-03-12 Thread Bryan Irvine
The information is there and the replica can connect on a reboot but only if that information has not changed correct? e.g. I reboot the slave, and on the master just run "reset master;" the bin.01 could change to bin.02 and the pos change from 98 to 15443 or some such. If I do that do I

Re: Replica questions

2009-03-12 Thread Rob Wultsch
When you start up replication the data should be recorded in the master.info in your data dir. [r...@someserver ~]# cat /var/lib/mysqldata/master.info 14 MASTERHOST-bin.01 MASTERPOS 192.168.0.2 REPLICATION_USER REPLICATION_PASSWORD 3306 60 0 I am not familiar with any setups where the master.

Re: Replica questions

2009-03-12 Thread Bryan Irvine
Do I jsut need to monitor better and manually add it should the log and pos change? -Bryan On Wed, Mar 11, 2009 at 7:05 PM, Baron Schwartz wrote: > That's deprecated too :-) > > On Wed, Mar 11, 2009 at 9:17 PM, Cui Shijun wrote: >> hi, >>  #2.  try adding the information of master into my.cnf t

Re: Replica questions

2009-03-11 Thread Baron Schwartz
That's deprecated too :-) On Wed, Mar 11, 2009 at 9:17 PM, Cui Shijun wrote: > hi, >  #2.  try adding the information of master into my.cnf then restart the > server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?un

Re: Replica questions

2009-03-11 Thread Cui Shijun
hi, #2. try adding the information of master into my.cnf then restart the server. thanks 2009/3/12 Bryan Irvine : > I've got 2 questions about my newly set up master->slave replica. > > 1> When I run "load data from master;" I get an error that I do not > h

Re: Replica questions

2009-03-11 Thread Rob Wultsch
On Wed, Mar 11, 2009 at 4:03 PM, Bryan Irvine wrote: > > I've got 2 questions about my newly set up master->slave replica. > > 1> When I run "load data from master;" I get an error that I do not > have RELOAD privileges and then it boots the slave offline. &g

Replica questions

2009-03-11 Thread Bryan Irvine
I've got 2 questions about my newly set up master->slave replica. 1> When I run "load data from master;" I get an error that I do not have RELOAD privileges and then it boots the slave offline. I've run GRANT SELECT, PROCESS, FILE, SUPER, REPLICATION CLIENT, REPLICATI

Re: questions about merging

2009-02-01 Thread Steve Holmes
Robert, I know you have had other answers, but as to the database name, yes, you can remove the CREATE DATABASE statement and change the USE statement to the right database name. N.B. In our environment the students have only one database each, and will install blogs and wiki's etc. using that one

Re: questions about merging

2009-02-01 Thread Walter Heck
then: dump, import locally, rename and dump again. Still feels a bit safer then parsing though it might be a bit more work. OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Sun, Feb 1, 2009 at 9:42 PM, Robert D. Crawford wrote: > Walter

Re: questions about merging

2009-02-01 Thread Robert D. Crawford
Walter Heck writes: > Might be a bit late, Better late than never. > but on the naming issue: why not rename the tables on the old database > before doing the dump? that would save you from potentially messing > with your data due to parsing problems. A good idea, but it wouldn't have worked

Re: questions about merging

2009-02-01 Thread Walter Heck
Might be a bit late, but on the naming issue: why not rename the tables on the old database before doing the dump? that would save you from potentially messing with your data due to parsing problems. Just a thought :) Walter OlinData: Professional services for MySQL Support * Consulting * Admini

Re: questions about merging

2009-01-30 Thread Robert D. Crawford
Olaf Stein writes: > I think he only has one DB, I guess that is a provider restriction... True. I would create a separate db for each application if I could. rdc -- Robert D. Crawford rd...@comcast.net -- MySQL General Mailing List For list archives:

Re: questions about merging

2009-01-30 Thread Olaf Stein
I think he only has one DB, I guess that is a provider restriction... On 1/30/09 8:52 AM, "Claudio Nanni" wrote: > Robert, > > keep the two databases separated, > > that is on different mysql database (or schema as they are also called). > > If the wordpress blog is on a database named 'wpbl

Re: questions about merging

2009-01-30 Thread Claudio Nanni
Robert, keep the two databases separated, that is on different mysql database (or schema as they are also called). If the wordpress blog is on a database named 'wpblog' for example import your dump in another newly created database. Could just use those statement in the dump file CREATE DATAB

Re: questions about merging

2009-01-28 Thread Robert D. Crawford
Hello, Olaf, "Stein, Olaf" writes: > the import of the dump will not remove your other tables unless there > is a naming conflict, then the table will be overwritten. As far as > the prefix goes you can edit the dump file, find the create table > statement for each table and add the prefix. If y

RE: questions about merging

2009-01-28 Thread Stein, Olaf
: mysql@lists.mysql.com Subject: questions about merging Hello all, I hope I get the terminology right. I am not sure merge is what I want, so let me describe what I need. I have a sql dump from a db that is a mediawiki. I cannot upgrade the software on the old server and need to move it to a

questions about merging

2009-01-28 Thread Robert D. Crawford
Hello all, I hope I get the terminology right. I am not sure merge is what I want, so let me describe what I need. I have a sql dump from a db that is a mediawiki. I cannot upgrade the software on the old server and need to move it to a new server. I have only one db available to me on the new

RE : MediumBlob / phpMyAdmin / hex dumps Questions

2008-12-14 Thread Jacques Brignon
command line level -- Jacques Brignon > -Message d'origine- > De : mik...@qualityadvantages.com [mailto:mik...@qualityadvantages.com] > Envoyé : samedi 13 décembre 2008 15:13 > À : mysql@lists.mysql.com > Objet : MediumBlob / phpMyAdmin / hex dumps Questions > >

MediumBlob / phpMyAdmin / hex dumps Questions

2008-12-13 Thread mikesz
Hello and Greetings mysql list, A few weeks ago, I posted a question here about importing a database to my local XP pro system and getting loads of MySQL server went away errors during the import. I got suggestions about increasing max packet size and a few other parameters which I followed but st

Re: Query Cache questions

2008-09-17 Thread Ananda Kumar
query. > > > > > > On 9/17/08, Bard Aase <[EMAIL PROTECTED]> wrote: > >> > >> On Wed, Sep 17, 2008 at 11:54 AM, Uwe Kiewel <[EMAIL PROTECTED]> > wrote: > >> > Bard Aase schrieb: > >> >> On Wed, Sep 17, 2008 at

Re: Query Cache questions

2008-09-17 Thread Bard Aase
rd Aase schrieb: >> >> On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> >> >> wrote: >> >>> Hi, >> >>> >> >>> I have two questions regarding the query cache: >> >>> >> >>> 1. What is the d

Re: Query Cache questions

2008-09-17 Thread Ananda Kumar
e <[EMAIL PROTECTED]> wrote: > > On Wed, Sep 17, 2008 at 11:54 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote: > > Bard Aase schrieb: > >> On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> > wrote: > >>> Hi, > >>> >

Re: Query Cache questions

2008-09-17 Thread Bard Aase
On Wed, Sep 17, 2008 at 11:54 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote: > Bard Aase schrieb: >> On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote: >>> Hi, >>> >>> I have two questions regarding the query cache: >>> &g

Re: Query Cache questions

2008-09-17 Thread Uwe Kiewel
Bard Aase schrieb: > On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote: >> Hi, >> >> I have two questions regarding the query cache: >> >> 1. What is the difference between query_cache_limit and query_cache_size? > > query_cache_li

Re: Query Cache questions

2008-09-17 Thread Bard Aase
On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote: > Hi, > > I have two questions regarding the query cache: > > 1. What is the difference between query_cache_limit and query_cache_size? query_cache_limit is the maximum size of a single resultset in the

Query Cache questions

2008-09-17 Thread Uwe Kiewel
Hi, I have two questions regarding the query cache: 1. What is the difference between query_cache_limit and query_cache_size? mysql> show variables like '%query_cache%'; have_query_cache | YES | query_cache_limit| 1048576 | query_cache_min_res_un

Re: MyIsam Locking Questions

2008-08-28 Thread Perrin Harkins
On Thu, Aug 28, 2008 at 1:14 PM, Jose Estuardo Avila <[EMAIL PROTECTED]> wrote: > My point is that on my process lists there are no writes being done at that > time only reads and actually only one read all other reads are locked as > well as writes. Sure, that's because the reads are in line behi

Re: MyIsam Locking Questions

2008-08-28 Thread Jose Estuardo Avila
My point is that on my process lists there are no writes being done at that time only reads and actually only one read all other reads are locked as well as writes. I've gone through every single one of the queries in my processlist at any given time when more than 500 process pile up and i

Re: MyIsam Locking Questions

2008-08-28 Thread Perrin Harkins
On Thu, Aug 28, 2008 at 10:59 AM, Jose Estuardo Avila <[EMAIL PROTECTED]> wrote: > I understand that reads are locked by writes but nowhere does of mention > that reads also block reads. How could they not? You can't simultaneously read and write the same data -- the read would get half-written g

Re: MyIsam Locking Questions

2008-08-28 Thread Dan Nelson
In the last episode (Aug 28), Jose Estuardo Avila said: > On Aug 28, 2008, at 5:48 AM, "Perrin Harkins" wrote: > > On Wed, Aug 27, 2008 at 8:21 PM, Jose Estuardo Avila wrote: > >> Hi, I've been trying to find information on how myisam handles > >> locks. I though myisam had locking only on writes a

Re: MyIsam Locking Questions

2008-08-28 Thread Jose Estuardo Avila
I understand that reads are locked by writes but nowhere does of mention that reads also block reads. Boy queries y posted to the list are selects. Jose E. Avila(tachu) Yuku/Kickapps Sent from mobile device. On Aug 28, 2008, at 5:48 AM, "Perrin Harkins" <[EMAIL PROTECTED]> wrote: On Wed,

Re: MyIsam Locking Questions

2008-08-28 Thread Perrin Harkins
On Wed, Aug 27, 2008 at 8:21 PM, Jose Estuardo Avila <[EMAIL PROTECTED]> wrote: > Hi, I've been trying to find information on how myisam handles locks. I > though myisam had locking only on writes and not on reads. No, readers block writers. This true of any system that only has read and write lo

MyIsam Locking Questions

2008-08-27 Thread Jose Estuardo Avila
Hi, I've been trying to find information on how myisam handles locks. I though myisam had locking only on writes and not on reads. For some reason and after a lot of digging i've been seeing that some queries(albeit bad queries) cause other queries to hang even though they are selects is th

בעניין: Re: mysqldump questions

2008-08-23 Thread Nanu Kalmanovitz
Thanks! Nanu >>> <[EMAIL PROTECTED]> 23/08/2008 09:50:13 >>> Whatever you name it Wherever you place it Mysqldump (options) > filename -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump questions

2008-08-22 Thread chaim . rieger
Whatever you name it Wherever you place it Mysqldump (options) > filename --Original Message-- From: Nanu Kalmanovitz Sender: To: mysql@lists.mysql.com Sent: Aug 22, 2008 23:48 Subject: mysqldump questions Hi! What is the name dumped file and where it is created? System is :Nov

mysqldump questions

2008-08-22 Thread Nanu Kalmanovitz
Hi! What is the name dumped file and where it is created? System is :Novell 6.5 sp6 - Apache 2, MySQL ver. 4.0.26, PHP 5.2.3. TIA Nanu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: PHP, MySQL questions

2008-07-23 Thread Ken Menzel
VeeJay wrote: Hi there I am going to make 2 Webserver at my work going to handle 50 mil hits per month... They are using Linux already. But being a FreeBSD fan, I have proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD is more Fast and Secure solution for his needs... An

Re: PHP, MySQL questions

2008-07-23 Thread VeeJay
Hi Chaim Contents are going to be dynamic... I will go with Apache 2.2.9 and also PHP with ACP (accelator) Any suggestions? Regards VJ On Tue, Jul 22, 2008 at 10:18 PM, Chaim Rieger <[EMAIL PROTECTED]> wrote: > VeeJay wrote: > >> Hi there >> >> I am going to make 2 Webserver at my work going

PHP, MySQL questions

2008-07-22 Thread VeeJay
Hi there I am going to make 2 Webserver at my work going to handle 50 mil hits per month... They are using Linux already. But being a FreeBSD fan, I have proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD is more Fast and Secure solution for his needs... And now I want to

  1   2   3   4   5   6   7   8   9   10   >