RE: Need help w/ re-starting Replication
No, I don't see sny errors when running SHOW SLAVE STATUS. How should I found out if the slave dropped and created the tables again? Basically, if everything works fine, do I need to do anything in such a case (cleaning master log file, resetting the log position, etc?) Thanks, -Jalil > Original Message > Subject: Re: Need help w/ re-starting Replication > From: Atle Veka <[EMAIL PROTECTED]> > Date: Fri, April 29, 2005 5:20 pm > To: [EMAIL PROTECTED] > Cc: mysql@lists.mysql.com > > On Fri, 29 Apr 2005 [EMAIL PROTECTED] wrote: > > > > > I set up replication and it was working fine but I re-created my master > > database (droped and created empty tables) and now my replication > > doesn't work. I checked the status of master and slave and they think > > they are in sync but when I add a new record to master I don't see it > > in slave. It used to work fine. > > > > Is there anyway to clean the binary log files and positions master and > > slave use and start the sync process again? > > Have you checked the slave to see if it dropped and created the table? > Does 'SHOW SLAVE STATUS\G' show any errors? > > > Atle > - > Flying Crocodile Inc, Unix Systems Administrator > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help w/ re-starting Replication
I set up replication and it was working fine but I re-created my master database (droped and created empty tables) and now my replication doesn't work. I checked the status of master and slave and they think they are in sync but when I add a new record to master I don't see it in slave. It used to work fine. Is there anyway to clean the binary log files and positions master and slave use and start the sync process again? Thanks, -Jalil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LongText Warning
I have a table with a field that has a field of type LONGTEXT. I try to insert a utf8 string with a length of 114544 and I get a warning that text got truncated. According to the doc, the size of LONGTEXT is much bigger than this. Any reason I get this warning? -Jalil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Charsets and Escaping
What is the relationship b/w the charset we use and the connection escape function? I have a few tables that use utf8 as encoding and I want to make sure the escaping works fine as the string I pass to the escape() call are in utf8 already. I use python/apache/MySQLdb and tried specifying unicode="utf8" but I get exceptions as it wants to convert the data returned to unicode which I don't want to happen. -Jalil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Making Slave a Master
We have one master and one slave database and use the slave for reads. If for some reason our master goes down, we would like to make our slave the master and use it for both writes and reads and then switch to the original configuration when the master is up, which includes updating the master copy. Limited downtime/locking of the second database is OK. Is this something that is easy to do or recommended? If so, what steps we need to go through or where can I find isome nformation regarding this? If not, what other approachs are there (assuming we only have two machines w/ above configuration). Thanks, -JF -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question on Unicode/UTF8
I know this issue has been brought up many times and I have tried to search and read as much as possible but still have not been able to resolve my issue. I have a mysql database (not the latest but it supports unicode). I am keeping some columns in utf8 format and only save data that is in utf8. However, when I read the data back (I am using mod_python and mysqldb module) I see characters like the following on my web page: %u0631 Now if I replace "%u" with "&#x" in my python code b/f sending them to browser, everything displays fine! Am I doing something wrong in mysql side? I have just defined the encoding for the columns I want to utf8. Is there anything else I have do in MySQL to get the data from tables in the right format that is displaybed in the broswer (I set the character set to utf-8 by Apache in my http headers). I have tried many different things (including setting client or connection character set) but have not been able so far to get the data back the way I want from mysql. Or, is this the job of the python to do the conversion. I appreciate any help. -Jalil
Data Storage
Are there any way to configure MySQL 4.1 to use more than one drive for data files (for example, in a RAID 5 solution)? If so, could somebody point me at the right information. Regards, -JF -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Order By When Grouping
Let's say I have a table w/ three rows: ID, Time, and Name. when I do: select Time, Name group by Name Order By Time MySQL selects one of the Time fields if there are rows with the same Name and then does the ordering using this selected field (I am not sure what is the logic but it seems it is the one that was inserted first in the table). I would like to sort on the original Time field and not the one selected by MySQL. For example, if: IDTimeName 1 2 X 2 3X 3 1Y I want to see: 3 X 1 Y But I get: 2X 1Y Any way to do this? Thanks, -JF
RE: Full-Text Search
Brent, Thanks for the reply. 1. Is there any way to sort the boolean full-text search results in orther of relevance as in non-bolean mode? I think it is very important. 2. Yes, that is what I meant. You are right. I look into grep. Thanks, -Jalil -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 6:30 AM To: Jalil Feghhi Cc: [EMAIL PROTECTED] Subject: Re: Full-Text Search 1. The rows are "sorted" in the same order as any other query that doesn't have and order by specified, which means usually in the order they were entered. 2. When you mean "location of matches", do you mean something like highlighting? That's the responsibility of the interface, not the database. Remember, MySQL is really "just" a database engine. It will find your data fast, but it's up to you to present it in a nice format. But, highlighting is fairly easy using grep, which is available in just about any front end you may be using (Perl, Shell, PHP, etc.). On Oct 25, 2004, at 8:37 PM, Jalil Feghhi wrote: > In the MySQL documentation, it says that: Boolean full-text searches > have these characteristics: > > * They do not use the 50% threshold. > > * They do not automatically sort rows in order of decreasing > relevance. You can see this from the preceding query result: The row > with the highest relevance is the one that contains ``MySQL'' twice, > but it is listed last, not first. > > * They can work even without a FULLTEXT index, although this would > be slow. > > * The minimum and maximum word length full-text parameters apply. > > * The stopword list applies. > > I had two questions: > > 1. How are the returned rows sorted in the boolean full-text searches? > > 2. Is there any way to get more information (other than the score) > from MySQL? For example, can we find out the location of matches? > > Regards, > > -Jalil > -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Full-Text Search
In the MySQL documentation, it says that: Boolean full-text searches have these characteristics: * They do not use the 50% threshold. * They do not automatically sort rows in order of decreasing relevance. You can see this from the preceding query result: The row with the highest relevance is the one that contains ``MySQL'' twice, but it is listed last, not first. * They can work even without a FULLTEXT index, although this would be slow. * The minimum and maximum word length full-text parameters apply. * The stopword list applies. I had two questions: 1. How are the returned rows sorted in the boolean full-text searches? 2. Is there any way to get more information (other than the score) from MySQL? For example, can we find out the location of matches? Regards, -Jalil
Select Question
Is there a way to convert the following result set: id f2 --- --- 1 b 1 c to: id f2 -- -- 1 b,c Using a select or any other functions? Basically, I want to put f2 fields together when ids are the same. Thanks, -Jalil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help w/ a Query
I need to get total number of all rows in a table and also select some rows from the same table. I know how to do this using two queries, but was wondering if there is any way to do it in one query (one trip to the database). Thanks, -Jalil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Long blob insert
hi Can anyone please help with regards to long blob data insert. I have a data which more than 1mb which MySQL long blob field refuse to insert. However if my data is less than 1mb there if no problem with insert. What parameter do i need to set up.. Please help thanks in advance regards Roslee - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php