Re: Can I Develop using Community Edition and Deploy onto Enterprise Edition??

Partitioning is available in the community edition and has been for a while now. Support is the only real difference and since Oracle took over the support available in the community is usually faster and better than you get from Oracle. John On Wed, 2011-09-21 at 16:23 +0200, Claudio Nanni wro

Re: Allowing all users to access a specified database

t the access they need and security is a little tighter :) You should also find Stored Procedures execute a little faster :) On 3 June 2011 11:47, Mark Goodge wrote: > On 03/06/2011 11:24, John Daisley wrote: > >> The reason >> >> *GRANT SELECT, INSER

Re: timezone

> > I strongly suggest you read the manual section relating to time zone > support which you can find here > > http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html > > > > On 3 June 2011 10:27, Rocio Gomez Escribano < > r.go...@ingenia-soluciones.c

Re: Allowing all users to access a specified database

r each site > which can be accessed by the server admins without needing to have access to > each site's own database. > > Clues, anyone? > > Mark > -- > Sent from my Babbage Difference Engine > http://mark.goodge.co.uk > http://www.ratemyairport.com > > -- &g

Re: timezone

; *Rocío Gómez Escribano* > > r.go...@ingenia-soluciones.com > > > > [image: Descripción: cid:image002.jpg@01CB8CB6.ADEBA830] > > Polígono Campollano C/F, nº21T > > 02007 Albacete (España) > > Tlf:967-504-513 Fax: 967-504-513 > > www.ingenia-soluciones.com &

Re: timezone

nes.com > > > > [image: Descripción: cid:image002.jpg@01CB8CB6.ADEBA830] > > Polígono Campollano C/F, nº21T > > 02007 Albacete (España) > > Tlf:967-504-513 Fax: 967-504-513 > > www.ingenia-soluciones.com > > > -- John Daisley Certified MySQL 5

Re: Not finding my.cnf file

ysql picks its configuration > or it go for its default. > > > Thanks & best Regards, > Adarsh Sharma > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=john.dais...@butte

Re: Deleting of records older than a specific date & time

s respect as I am fairly new to the dba > scene. > > > I would really appreciate it if someone can assist me in this > regard please. > > Regards > Machiel > > PS someone already suggested me using MySQL scheduled events , > however I was not able to fig

Re: Another replication question

greatly appreciated. > > > > Regards > > Machiel > > > > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI Developer Telephone: +44 (0)7918 621621 Email: john.dais...@butterflysystems.co.uk

Re: Mysql server full with idle connections

e ordinary. > > I can think of only two causes: bug in the app code, or bug in MySQL. This > is 5.0.32-Debian_7etch3-log (Debian package) on Debian Etch, running on > x86_64. > > Does anyone know of similar things happening ? > > -- > Bier met grenadyn > Is als most

Re: MMM setup and requirements

system failure > it is rather quick and easy enough to get the slave running as the > master. > >I do not have as much experience on this yet so I would > really appreciate assistance. > > Regards > Machiel > -- John Daisley Certified MySQL

Re: MySQL replication server

ou dont specifically set readonly on the slave you > have to be very careful in order to maintain data integrity on the slave and > also not to break repliacton. Tools like Maatkit are designed to check data > integrity on the slave due to exactly this issue, > > thanks Andy. >

Re: MySQL replication server

ell (even though it may not be replicated) ? > > Kind Regards > > Machiel > -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI Developer Telephone: +44 (0)7918 621621 Email: john.dais...@butterflysystems.co.uk

Re: Changing database tables to different storage engine.

1. this is a production system and can't afford any > downtime or as little performance degration as possible. > > What is the best way to do this in order to > have the least amount of effect on the database and it's performance? &

Re: Failover on master/slave replication

very large DBs, Ive not personally used it tho). > > > > Thats about it I think, unless anyone wants to correct me on that... > > > > thanks Andy. > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.

Re: Performance problems on MySQL

- > INSERT BUFFER AND ADAPTIVE HASH INDEX > --------- > Ibuf: size 1, free list len 0, seg size 2, > 0 inserts, 0 merged recs, 0 merges > Hash table size 1452727, used cells 496505, node heap has 597 buffer(s) > 31.26 hash searches/s, 15.31 non-hash searches/s > --- > LOG > --- > Log sequence number 61 3783563525 > Log flushed up to 61 3783563173 > Last checkpoint at 61 3778869606 > 1 pending log writes, 0 pending chkp writes > 4297652 log i/o's done, 40.63 log i/o's/second > -- > BUFFER POOL AND MEMORY > -- > Total memory allocated 419047082; in additional pool allocated 2578048 > Buffer pool size 22400 > Free buffers 15784 > Database pages 6019 > Modified db pages 1895 > Pending reads 0 > Pending writes: LRU 0, flush list 0, single page 0 > Pages read 3543, created 2476, written 594057 > 0.00 reads/s, 0.00 creates/s, 6.47 writes/s > Buffer pool hit rate 1000 / 1000 > -- > ROW OPERATIONS > -- > 8 queries inside InnoDB, 29 queries in queue > 1 read views open inside InnoDB > Main thread id 11, state: sleeping > Number of rows inserted 530873, updated 2100423, deleted 31904, read > 7886015 > 0.21 inserts/s, 19.95 updates/s, 0.00 deletes/s, 40.05 reads/s > > END OF INNODB MONITOR OUTPUT > > > ### > -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI Developer Telephone: +44 (0)7918 621621 Email: john.dais...@butterflysystems.co.uk

Re: MySQL SUM on two columns

les.products_id = products.products_id > WHERE products.enabled = 1 > AND products_sales.language = 'EN' > > This works fine, however I also want to SUM the ES language within the same > query. Is this possible to do, or should I just query the table twice, > replacing the language

Re: Mysql BestPractices

p; Regards, > > > > Kranthi kiran > > > > > > > > > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI Developer Telephone: +44 (0)7918 621621 Email: john.dais...@butterflysystems.co.uk

RE: Migration

CURRENT_TIMESTAMP as the default for a TIMESTAMP column. The way around this is to have a trigger set the column value to UUID() Regards John Daisley -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI

Re: Why Does This Drop Fail?

KEY (`idx`) REFERENCES `second_table` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | So, first you remove the key: ALTER TABLE table_name DROP KEY `idx`; then the foreign key: ALTER TABLE table_name DROP FOREIGN KEY `table_name_ibfk_1`; Then that should do it! Regards Jo

Re: Why Does This Drop Fail?

Most likely a foreign key constraint would be violated if the table were dropped. Check those index definitions on `Store` and `User` columns. Regards John Daisley Microsoft SQL Server 2005/2008 Database Administrator Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos

Re: Which tool to use for developing Pl/Sql on MySQL?

used wordwide? So I make practice with the most > used one. > > Thanks in advance! > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk

Re: How to become a DBA on MySQL

> >> worked only as developer and not as DBA. > > >> Thanks! > > >> > > >> > > >> -- > > >> MySQL General Mailing List > > >> For list archives: http://lists.mysql.com/mysql > > >> To unsubscribe: > > >> http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com > > >> > > >> > > > > > > > > >-- > > >Claudio > > > > > > > > > > Keith J. Clark > > > Business ManagerOwner > The BookwormWaterloo Hosting > Quality Used Books Complete Web Hosting Provider > www.k-wbookworm.com www.waterloohosting.com > sa...@k-wbookworm.com sa...@waterloohosting.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk > > -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI Developer Telephone: +44 (0)7918 621621 Email: john.dais...@butterflysystems.co.uk

Re: How to become a DBA on MySQL

eneral Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk > > -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI Developer Telephone: +44 (0)7918 621621 Email: john.dais...@butterflysystems.co.uk

Re: finding exact query being run

file but the best way to control these is ensure your app closes its connections when it is finished with them and do not use persistent connections unless absolutely necessary Regards John John Daisley SQL Server 2005/2008 Database Administrator Certified My

Re: Differences between 2 MySQL instances

Linux I have MySQL 5.0 and under Windows MySQL 5.1 and I definitely > need to upgrade? > > There are some differences between the global variables that start with > innodb_ under Windows and Linux, but I don't know if those differences make > InnoDB to choose another index. > > Tha

Re: Master - master replication

sing >> master - master replication on remote sites? (The data contains the >> information of children, credit cards and bank accounts.) >> >> Thanks, >> >> Carl >> - Original Message - >> From: John Daisley >> To: Carl >>

Re: Master - master replication

formation of children, credit cards and bank accounts.) > > Thanks, > > Carl > > - Original Message - > *From:* John Daisley > *To:* Carl > *Cc:* Walter Heck ; mysql@lists.mysql.com > *Sent:* Monday, May 24, 2010 6:47 AM > *Subject:* Re: Master - master rep

Re: Master - master replication

/doc/refman/5.1/en/replication-solutions-ssl.html > > cheers, > > Walter Heck > Engineer @ Open Query (http://openquery.com) > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=john.dai

Query Help!

system was free between 16:45:57 and 16:47:01 on 26th February 2010 and this is what I would need the query to return only working with a lot more data. Any ideas? Thank you in advance for any help, suggestions. This is currently on a MySQL 5.1 system. Regards -- John Daisley Certified M

Re: Secure Install Removed Root Accounts

If you only want root to be able to log in locally then you only need 'root'@'localhost' unless you are using tcp connections. regards John On Tue, Mar 30, 2010 at 11:25 PM, Carlos Mennens wrote: > Today I installed MySQL 5.1.45-1 on my production server and it > recommended that I run the follo

Re: MySQL Encryption

On Sun, Mar 21, 2010 at 9:49 PM, mos wrote: > At 03:21 PM 3/21/2010, John Daisley wrote: > >> Mike, >> >> Encrypted filesystems can seriously impact performance of MySQL. >> >> Its an entirely different issue to MySQL encryption but one would hope >&g

RE: MySQL Encryption

much care of your hardware by ensuring that it is kept secure and not left in the hands of an untrustworthy isp, disposed of in an insecure manner or kept in an insecure office. John Daisley Certified MySQL 5 DBA / Developer Cognos BI Developer Tel: +44 (0)1283 537111 Mobile: +44 (0)7918

RE: MySQL Encryption

-Original Message- From: Jim Sent: Friday, March 19, 2010 4:22 PM To: John Daisley ; mysql@lists.mysql.com Subject: Re: MySQL Encryption Thanks for the reply, John. What you are describing seems to be the approach I've seen on the few places I've seen this topic discusse

Re: MySQL Encryption

` AS CHAR)) I then store the logic in a database stored procedure and use database security to prevent unauthorised access. At no point do I have this logic outside the database in any external application or script! That would be silly :) Regards John Daisley On Thu, Mar 18, 2010 at 7:26 PM, Ji

Re: Need help with query optimization

It may only be returning 51 rows but its having to read significantly more. Get rid of the derived table join if possible. Something like SELECT TAP.ID , M.UID, TAP.FirstName, TAP.MI, TAP.LastName, TAP.State, TAP.SchoolName, TAP.StateApproved, TAP.DiplomatApproved, C.ChapterType,

Re: mysql & RAID

What are your plans for OS as this can have an impact on hardware choice especially if you are considering Solaris or Open Solaris. Regards John On Tue, Mar 16, 2010 at 3:22 PM, Евгений Килимчук wrote: > > http://assets.en.oreilly.com/1/event/27/Linux%20Filesystem%20Performance%20for%20Databases

Re: Innodb buffer pool usage

There will be an increase in IO and a noticeable decrease in performance if the buffer pool is too small. Give it all the memory which is not needed elsewhere. If you can set it a little larger than the size of all your innodb tablespaces that would be good. Oracle is a very different animal to My

Re: mysql proxy in production?

Has MySQL Proxy been improved since that article was released? I ask because although I have no personal experience with it I do know of a big UK based online payment processing company who use MySQL Proxy with MySQL 5.1 in production very successfully. On Thu, Mar 11, 2010 at 3:34 PM, Johan De

RE: Partitioning

overcome this issue so please do let me know what you decide. Regards John Daisley == John Daisley Certified MySQL DBA / Developer IBM Cognos BI Developer Tel: +44(0)1283 537111 Mobile: +44 (0)7819 621621 Email: j...@butterflysystems.co.uk == Sent via HP IPAQ mobile

RE: slow queries not being logged

> From: machi...@rdc.co.za > To: mysql@lists.mysql.com > Subject: slow queries not being logged > Date: Tue, 23 Feb 2010 09:59:13 +0200 > > Good day all > > > > I hope you can assist me with this one... > > > > We have a client where the slow query log wa

RE: hi help to take backup-mysql-windows-xp

What error are you getting? === John Daisley MySQL 5.0 Certified Database Administrator (CMDBA) MySQL 5.0 Certified Developer Cognos BI Developer Telephone: +44(0)1283 537111 Mobile: +44(0)7812 451238 Email: john.dais...@butterflysystems.co.uk === Sent via HP

RE: Event feature already working in Server 5.1.37

General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk ======= John Daisley MySQL 5.0 Certified Database Administrator (CMDBA) MySQL 5.0 Certified Developer Cognos BI Developer

RE: Help Save MySQL

rice unless a regulator demands it (unlikely). John === John Daisley MySQL 5.0 Certified Database Administrator (CMDBA) MySQL 5.0 Certified Developer Cognos BI Developer Telephone: +44(0)1283 537111 Mobile: +44(0)7812 451238 Email: john.dais...@butterflysystems.co.uk =

RE: sql file system + optimization

Yes, you can symlink it. How much performance benefit you get will depend on hardware and traffic. === John Daisley MySQL 5.0 Certified Database Administrator (CMDBA) MySQL 5.0 Certified Developer Cognos BI Developer Telephone: +44(0)1283 537111 Mobile: +44(0)7812 451238 Email

RE: mysql server optimization

your box) try increasing the values for tmp_table_size and max_heap_size, these control how large an in-memory temp table can grow before it is converted to an on disk temp table. Regards John === John Daisley MySQL 5.0 Certified Database Administrator (CMDBA) MySQL 5.0

RE: Help saving MySQL

if we don't support it. ======= John Daisley MySQL 5.0 Certified Database Administrator (CMDBA) MySQL 5.0 Certified Developer Cognos BI Developer Telephone: +44(0)1283 537111 Mobile: +44(0)7812 451238 Email: john.dais...@butterflysystems.co.uk === Sent via HP I

RE: Help saving MySQL

ed 27 years of his life to MySQL I think he earned every last penny! ======= John Daisley MySQL 5.0 Certified Database Administrator (CMDBA) MySQL 5.0 Certified Developer Cognos BI Developer Telephone: +44(0)1283 537111 Mobile: +44(0)7812 451238 Email: john.dais...@butt

RE: Missing Entries

passwords for root first you will delete all the initial root accounts too! You really should read the installation section of the manual. Your issue is simple because the installation has not been secured. It removes those accounts.     Neil ===

RE: Missing Entries

I'm on my mobile so can't give you a link but you should read the reference manual section on 'post-installation setup and testing'. Regards John Daisley. -Original Message- From: Carlos Williams Sent: 09 December 2009 21:16 To: mysql@lists.mysql.com Subject: Mi

Re: How to change root password?

Make sure your mysql server is not accessible to anyone else, its a good idea to disconnect all network connections because the server will be totally insecure for a short period of time! Start your MySQL server with the --SKIP-GRANT-TABLES option. At a shell prompt type mysql -uroot

Re: log sql queries?

t the manual(http://dev.mysql.com/doc/refman/5.1/en/)! You can get answers to questions like this so much quicker from there. Regards John Daisley On Fri, 2009-11-13 at 16:43 +, Sydney Puente wrote: > OK thanks to some help from this list I now have a blank my.cnf file in /etc > And I wan

Re: Fw: cannot find my.cnf file

H I wouldn't use that my-huge.cnf file unless that machine is a dedicated mysql server with plenty of ram and even then I wouldn't use it without modification. Are you sure you have the password correct? A % under host is a synonym for 'any host'. Regards John > Guys, > That's a great respo

Re: cannot find my.cnf file

should be in /etc/my.cnf or try the following at the command line locate my.cnf That should give you the location On Thu, 2009-11-12 at 18:10 +, Sydney Puente wrote: > Hello, > I want to log all sql queries made against a mysql db. > Googled and found I should add a line to my.cnf. > >

Re: Oracle, Sun and MySQL

> On Nov 11, 2009, at 9:34 AM, John Daisley wrote: >> On Tue, 2009-11-10 at 23:50 -0600, Peter Brawley wrote: >>> European regulators agree with Monty that the Oracle-Sun deal threatens >>> database competition. Apparently Oracle means to play hardball. >>> M

Re: Oracle, Sun and MySQL

What I am more concerned about at the moment is how much the uncertainty over the deal is hurting MySQL? I was recently in a project planning meeting where MySQL was dismissed completely because nobody could give guarantees about where MySQL was going. There were a lot of concerns over where futur

Re: Best way to purge a table

Just truncate the table, this will get rid of data whilst preserving the table structure. eg: truncate tablename; regards John On Mon, 2009-11-09 at 11:20 -0500, Jones, Keven wrote: > Hi, > > I need to get rid of all data in one table of my database. The table just has > old > Data that I no

RE: Inserting csv

E' command to put the data into your database fairly quickly. Regards John Daisley Mobile +44(0)7812 451238 Email j...@butterflysystems.co.uk Certified MySQL 5 Database Administrator (CMDBA) Certified MySQL 5 Developer Cognos BI Developer --- Sent from HP IPAQ mobile d

RE: Unable to Login to MySQL 5

You have set the root password on your mysql server to root with this command GRANT ALL PRIVILEGES ON petclinic.* TO r...@localhost IDENTIFIED BY 'root'; The IDENTIFIED BY clause of a grant sets the password. You shouldn't run a system without a root password anyway. Regard

RE: MYSQL slow query log in table.

. Regards John Daisley Mobile +44(0)7812 451238 Email j...@butterflysystems.co.uk Certified MySQL 5 Database Administrator (CMDBA) Certified MySQL 5 Developer Cognos BI Developer --- Sent from HP IPAQ mobile device. -Original Message- From: Brown, Charles Sent: Thursday

RE: mysql odbc connection problem

Make sure you have granted permissions in the db for root to connect from the host you are trying to connect from. Something like GRANT priv ON db.table TO 'root'@'hostname' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; regards Regards John Daisley Mo

Re: Another Join Problem

Qualify the column names. EG SELECT categories.ID, products.Item FROM products JOIN categories ON categories.ID = products.Category LIMIT 0 , 30; Regards John Daisley > Hi; > I get the following error: > > *SQL query:* > > SELECT ID, Item > FROM products > JOIN cat

RE: Unable To Remove User

What version of mysql a you using? Drop user works differently for versions before 5.0.2. You could just remove the user from the mysql.user table with a delete statement. Regards John Daisley Mobile +44(0)7812 451238 Email j...@butterflysystems.co.uk Certified MySQL 5 Database Administrator

RE: iam new bee to mysql

Basic answers under each of your questions below -Original Message- From: F.A.I.Z.A.L Sent: Wednesday, September 30, 2009 11:11 AM To: John Daisley Cc: mysql@lists.mysql.com Subject: Re: iam new bee to mysql Hi 1. can you please explain me about mysql 5 architecture and background

RE: iam new bee to mysql

. Regards John Daisley Mobile +44(0)7812 451238 Email j...@butterflysystems.co.uk Certified MySQL 5 Database Administrator (CMDBA) Certified MySQL 5 Developer Cognos BI Developer --- Sent from HP IPAQ mobile device. -Original Message- From: F.A.I.Z.A.L Sent: Wednesday,

Thread Stack Overrun

We have a master slave replication setup with 3 slaves running off one master. The master and one slave run on the same physical box running Centos 5 (We use this slave instance for backup purposes only). One of the other slaves is on a seperate Centos 5 box and the final slave is on a windows xp m

RE: how to query this

SELECT MAX(value), id FROM table GROUP BY id; Regards John Daisley Mobile +44(0)7812 451238 Email j...@butterflysystems.co.uk Certified MySQL 5 Database Administrator (CMDBA) Certified MySQL 5 Developer Cognos BI Developer --- Sent from HP IPAQ mobile device

RE: Prevent execution of queries without a WHERE clause

Add the option 'safe-updates' to the mysql section of your 'my.cnf' / 'my.ini' file and restart the mysqld service. [mysql] Safe-updates Regards John Daisley Mobile +44(0)7812 451238 Email j...@butterflysystems.co.uk Certified MySQL 5 Database Administrator (CMDB

RE: Fwd: Help with Timestamp invalid value error

Is your table innodb? If so i think the 'STRICT_TRANS_TABLES' sql_mode 'may' be causing the problem. Try inserting the value as '2008-03-09 02:56:34.737' Do you get the same error? What mysql version is your server? Regards John Daisley Mo

RE: Help with Timestamp invalid value error

What is your sql_mode set to? I tried inserting that value into a timestamp column on our test server and it works fine. Regards John Daisley Mobile +44(0)7812 451238 Email j...@butterflysystems.co.uk Certified MySQL 5 Database Administrator (CMDBA) Certified MySQL 5 Developer Cognos BI

Re: Query for rolling totals

s_id ,a.tran_date,b.cat_type,a.payee,a.amnt, > @runningTotal := @runningTotal+a.amnt AS rollingTotal from > transactions a join categories b on a.cat_id = b.cat_id where > a.user_id=1 and a.acc_id=3 order by a.tran_date ASC > > Brent Baisley > > On Thu, Sep 3, 2009 at 1:56

Query for rolling totals

Hi, Hoping someone can help me with this little issue! It seems really simple but my brain is refusing to work. We have a transactions tables like so... mysql> desc transactions; +---+--+--+-+-++ | Field | Type | Nul

Re: How do you show ALL grants for a username?

Use information_schema! select * from information_schema.user_privileges where grantee like "'madc'@%"; Should get you what you need. John Daisley Email: john.dais...@butterflysystems.co.uk Mobile: +44 (0)7812 451238 MySQL Certified Database Administrator (CMDBA) MySQL

Re: Index selection problem

being picky: these two kinds of > index accesses perform differently. The range condition makes MySQL > ignore any further columns in the index, but the multiple equality > condition doesn’t have that limitation." > > > > > John Daisley Email: john.dais...@but

Re: How can we stock the query result into a text file

SELECT INTO OUTFILE does almost the same thing as spool in SQL*Plus SELECT columnname from tablename into outfile '/path/and/filename.txt' Regards John > Hi > > In mysql , how can we stock the query result into a text file > > the table is too large , i don't want to dump it , but select a par

Re: how to fetch and calculate data from remote database and insert into local database

Depending on what you mean by 'Calculate the data', you could try using a tool like Talend (www.talend.com). > What exactly do you want to calculate? > > Generally, export (mysqldump cmd) and import (mysql cmd) of data is done > as > below: > > Supposing "japan" is the source db and "usa" is your

RE: AW: creating databases in different folders

> > >>-Original Message----- >>From: John Daisley [mailto:john.dais...@mypostoffice.co.uk] >>Sent: Tuesday, June 02, 2009 6:30 AM >>To: Foo JH >>Cc: schackenb...@termindoc.de; mysql@lists.mysql.com >>Subject: Re: AW: creating databases in different f

Re: AW: creating databases in different folders

load but I have never tried it on Windows. Regards John Daisley MySQL 5 Certified Database Administrator (CMDBA) MySQL 5 Certified Developer (CMDEV) MySQL Certified Associate (CMA) Telephone +44 (0)1283 537111 Mobile +44 (0)7812 451238 Email john.dais

Re: Partition of Mysql

Hello Lin What tools are you using to model your data and build your OLAP cube? If I were building a cube which required data from 15 fact tables which only differed in that they contained a different years data, I would model the 15 tables so they appeared as one using something like Cognos Frame

RE: Information Schema

---+ > | information_schema | > | hgallery | > ++ > 2 rows in set (0.00 sec) > > mysql> > > Ok, so how do I disable that? > > - Mark > > > -Original Message- > From: John Daisley [mailto:john.dais...@my

Re: Start MySQL with --intit-file?

To me the update seems fairly pointless, unless there are other users with the name 'root' in addition to the the two specifiied in the grant commands. Specifiy the full path in the '--init-file=' option. Issue the Flush Privileges command after the two GRANT statements not in between them. This

Re: Information Schema

Scott Information_schema is a virtual database only. I think it was added in MySQL 5.0.2 to comply with SQL:2003 specifications. information_schema provides the same info as you can get from 'SHOW' commands. Every user automatically has select privs for information_schema and its not possible to

RE: Oracle , what else ?

> On Thu, 2009-04-23 at 17:58 +0100, Gabriel - IP Guys wrote: >> > The real question is whether they will let MySQL >> > wither >> > and die by not providing updates for it? >> >> Well, MySQL is open source, right? And the source is available? I'm >> sure >> a team of devs will come to the rescue.

Re: Oracle , what else ?

MySQL will live on regardless of who owns the brand. First and foremost MySQL is a community and that community will continue to develop MySQL and take it in the direction they want it to go. Sure Oracle could try and force some 'features' or changes through but if the community didn't like them th

SOLVED: Re: Foreign Key Issue

cubes` > -- - > DROP TABLE IF EXISTS `cubedoc`.`cubes` ; > > SHOW WARNINGS; > CREATE TABLE IF NOT EXISTS `cubedoc`.`cubes` ( > `idcubes` SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT , > `cube_name` CHAR(30) NOT NULL , >

Foreign Key Issue

`cube_name` CHAR(30) NOT NULL , `cube_kit_location` VARCHAR(100) NOT NULL DEFAULT 'On Development Pc' , `Developer` ENUM('John Daisley','Daxa Everitt','Dave Hartley','Rob Dando','Will Morley') NOT NULL ,

Re: IBM could buy Sun?

Seems a very low valuation despite Sun's problems! If this goes through what do you think the future holds for MySQL and DB2? In the long term maybe this would mean some much needed decent MySQL support in the IBM Cognos BI suite ;) Regards John > Yeah! No kidding. If IBM doesn't pick it up

Re: MySQL versus PostgreSQL for GPS Data

Juan I don't think it really matters, doesn't look like you'll need any features which are only available in one or the other! The main issue you will have is supporting the application and the RDBMS so go for the one you are most comfortable with and can support/configure best. Regards John >

Re: JOB: linux sysadmin with good mysql skills [think really "mysql dba] - LOCATION: reading, berkshire, england, uk - SALARY: £40k-£55k at least!

ge is beneficial then its not spam! I also do not see that messages I have sent are spam, they were replies to messages on the list! Regards John Daisley Email: john.dais...@butterflysystems.co.uk Mobile: 07812 451238 MySQL Certified Database Administrator (CMDBA) MySQL Certified Developer (

Re: JOB: linux sysadmin with good mysql skills [think really "mysql dba] - LOCATION: reading, berkshire, england, uk - SALARY: £40k-£55k at least!

On Tue, 2009-03-17 at 12:56 -0400, Jujitsu Lizard wrote: > On Tue, Mar 17, 2009 at 12:25 PM, j...@camalyn.org wrote: > > > On Tue, 2009-03-17 at 17:10 +0100, Jon Stephens wrote: > > > Please don't post off-topic mails to the MySQL Cluster list. > > > > Jon hi, I couldn't see anything that rea

Re: JOB: linux sysadmin with good mysql skills [think really'mysql dba] - LOCATION: reading , berkshire, england, uk - SALARY:£40k-£55k at l east!

James, I'm guessing this is the same position you sent me direct, sorry for not getting back to you, it slipped my mind. Sadly the location is not suitable for me. Can I suggest you post this on the MySQL website in the Jobs Forum? You should get a good response from there as its a good oportunit

Re: && vs AND

Never seen && used with MySQL, does it really work??? As for other RDBMS, I reckon its likely to cause problems in Oracle as && is used for session substitution variables in SQL*Plus. John Daisley Email: john.dais...@butterflysystems.co.uk Mobile: 07812 451238 MySQL Ce

Re: Resend: enabling storage engine with RPM install

Jim, Where did you get your RPM from? Regards John > Sorry, but I'm resending because I made a mistake in terminology and want > to > be clear. The problem isn't that innodb is "DISABLED" on the database. > The > innodb engine is not supported by the database. > > We have 5.0.22 installed on a

Re: Newbie First Use Connection Question - Mac OSX 10.5.6

The root Password will be blank after initial install. You can set it at a shell prompt with commands something like this... shell> mysql -u root mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd'); mysql> FLUSH PRIVILEGES; mysql> EXIT; Where newpwd is your desired password. Best to

Re: Instance scale-out

ace' as being a port, socket, pipe etc. Thats what it says in the study guide and the reference manual and thats what they are going to test you on. John > Quoting John Daisley : > > >> I would say in terms of the MySQL server the interface is either a >> TCP/IP >&

Re: Instance scale-out

---------- > Aren't we supposed to see just a port number here? > > Cheers > Claudio > > > 2009/2/5 John Daisley > >> An interface by definition is a point of interconnection. >> >> Maybe

Re: Instance scale-out

An interface by definition is a point of interconnection. Maybe its a bit of a grey area where the interpretation can be different depending on whether you think in terms of hardware or software. Its the port which is used to communicate with the MySQL (or indeed any other) server software so the

Re: Instance scale-out

I think you are confusing a network interface (such as a tcp port) with a physical network device (such as a LAN card). For me the study guide is correct. > I succesfully install multiple instances on the same host since many years > (good old 3.23), > my rule of the game is: different os user, di

Re: WHERE vs. ON

Never tried it in MySQL and Im not in a position to do so at the moment but in Oracle you can do a left outer join in the where clause something like this SELECT t1.col1, t2.col2 FROM table1 t1, table2 t2 WHERE t1.join_col_name = t2.join_col_name(+) Does this not work in MySQL? Never tried it be

Re: Recommended MySQLDump options

ether that output is usable to you. '--opt' is default so doesn't need specifying and seems to meet most peoples requirements as it includes many of the most commonly needed options together. John Daisley Email: john.dais...@butterflysystems.co.uk Mobile: 07812 451238

  1   2   >