Re: Replication among disconnected Servers
But this slave can not have direct access to the master. Is there a way I can achive this? If the slave cannot have access to Master how can we call it as a Slave. I would rather call that as a server where you want to dump the mysql/data directory of the Master. better write a nightly shell script which simply copies the mysql/data directory from master to backup server. On 4/9/07, Ravi Kumar. [EMAIL PROTECTED] wrote: Can any one help me please? Ravi Kumar. wrote: Hi All, We have a MySQL 5.0 server (master) running on Windows. For backup, I wish to setup another system with same version of MySQL to act as backup / slave. But this slave can not have direct access to the master. Is there a way I can achive this? I do not wish to take a full dump in master. Would it work, if I take the binary replication logs manually from master and provide it to slave? Any other way to achieve desired results. Thanks, Ravi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
PBXT 0.9.86 the MySQL Conference 2007 release!
Hi All! I have just released PrimeBase XT 0.9.86 (http://www.primebase.com/ xt), which will be my last release before the MySQL User Conference this year. The most significant change in this version is the reduction of the number of data logs used per table. This, and a number of other modifications, makes PBXT fit to handle databases with 1000's of tables. If you would like to learn more about the development and design of PBXT then join me for my session at the MySQL User Conference in Santa Clara, on Wed, April 25, 10:45am - 11:45am, Ballroom F: PrimeBase XT: Design and Implementation of a Transactional Storage Engine For more details: http://www.mysqlconf.com/cs/mysqluc2007/view/e_sess/ 10410 Looking ahead, I would also like to invite all who are interested to the Scalable BLOB Streaming Infrastructure BoF: http://www.mysqlconf.com/cs/mysqluc2007/view/e_sess/14125 This will be an informal discussion of our plans for the implementation of scalable BLOB streaming in MySQL, and how this all fits together with PBXT and other engines. We would like as much input as possible at this early stage, so I hope you can make it! I will also be taking part in a number of lightning rounds so check out this page for a complete list of my sessions: http://www.mysqlconf.com/cs/mysqluc2007/view/e_spkr/3104 I'm looking forward to seeing you all there! Best regards, Paul Paul McCullagh SNAP Innovation GmbH http://www.primebase.com/xt http://pbxt.blogspot.com http://sourceforge.net/projects/pbxt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication among disconnected Servers
Ravi Kumar. wrote: Can any one help me please? Ravi Kumar. wrote: Hi All, We have a MySQL 5.0 server (master) running on Windows. For backup, I wish to setup another system with same version of MySQL to act as backup / slave. But this slave can not have direct access to the master. Is there a way I can achive this? I do not wish to take a full dump in master. Would it work, if I take the binary replication logs manually from master and provide it to slave? Any other way to achieve desired results. You could copy the binary logs to the slave manually, then run mysqlbinlog on them and pipe the output directly into the slave: mysqlbinlog master.log | mysql -h slave I have never tried it, but you should be able to copy the binlogs and start the slave from a certain position in them (pretending that they are relay logs, as though the I/O thread had copied them). Look at the manual page for CHANGE MASTER TO. Other options: copy files from the master (rsync may help make this more efficient), data synchronizing programs (http://forums.mysql.com/list.php?27) Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Temporary stored procedure or function?
Is there a way to create temporary stored proc or func so that it is store in memory rather than in the mysql.proc table? The result I am going for is to abstract some encryption functions, but I don't want the encryption process stored in the proc table; I was thinking if there was a way to create a function in memory, I could load it during startup from an init-file. (I know it is still on the file system, but I have my reasons. Really.) Alternatively, is there a way to create a custom global variable? I was hoping it would be as easy as adding it to the my.cnf file, but no such luck. Thanks. David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
charset
Hi, I have this database with utf-8 charset. How can i change it to latin1 ? I've seen the MySQL pages and run in the MySQL prompt: ALTER DATABASE telbit CHARACTER SET latin1 COLLATE latin1_swedish_ci; but i get an error saying that i have an error in my syntax. Any help would be appreciated. Warm Regards -- :wq! Mário Gamito -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Updating 5.1.11 to 5.1.16(or latest)
Has anyone seen any issues updating from 5.1.11 to a later version? We use partitioning extensively and was wondering how badly we’re going to get hosed upgrading. We’re on Fedora Core and used the RPMs to install… I need to be able to turn off general_log… It kills my DB every few days when it grows to 30Gb and fills the partition its on. I plan on using mysqldump to dump all the data to flatfile (for full backup purposes), upgrade to 5.1.16 (or latest available) and restart the db… Is this a sounds idea? -Mike -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.0.0/752 - Release Date: 4/8/2007 8:34 PM
Re: Query needed for this sol.
Not sure how to do it in a single query, but if you run this query repeatedly, eventually you'll have only 10 left of each category. DELETE tableName FROM tableName, (SELECT MAX(ID) deleteID,count(ID) categCount FROM tableName GROUP BY Category HAVING categCount10) AS Smry WHERE tableName.ID=Smry.deleteID - Original Message - From: abhishek jain [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, April 08, 2007 7:26 AM Subject: Query needed for this sol. Hi all, I need a query for the fol. sol. In a table i have 100s of rows with six categories like A,B,C,D,E,F which is marked with a column like Table ID Category 1 A 2 A 3 B 4 B 5 B 6 C 7 C and so on 100 ids for each of six categories , i want to delete all but 10 ids of each category, i wanted to know how to do so, Pl. help Thanks, Abhishek jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query needed for this sol.
Hi Abhishek, In a table i have 100s of rows with six categories like A,B,C,D,E,F which is marked with a column like Table ID Category 1 A 2 A 3 B 4 B 5 B 6 C 7 C and so on 100 ids for each of six categories , i want to delete all but 10 ids of each category, i wanted to know how to do so, This seems easier to solve if you re-word the problem in two steps: 1) find 10 rows in each category 2) delete all other rows First define which 10 rows you want to keep. I will assume you want to keep the ten 'A' rows with the GREATEST id number. Query 1 then becomes: select ID, Category from tbl where ( select count(*) from tbl as f where f.Category = tbl.Category and f.ID tbl.ID ) 10; Try that and see if it finds the rows you want to keep. Now you can use what my colleague calls an 'exclusion join' to delete every other row. Plug query 1 into this and you get Query 2: delete t1.* from tbl as t1 left outer join ( -- same query as above select ID, Category from tbl where ( select count(*) from tbl as f where f.Category = tbl.Category and f.ID tbl.ID ) 10 ) as t2 using(ID, Category) where t2.ID is null; This is likely to run slowly on very large tables. If you need this to be efficient, write back to the list again. I hope this helps, Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql sql query size limit
Hi List, What is the practical limit on size of the sql query in mysql 4.1.x Anil