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

Need help w/ re-starting Replication

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]

Charsets and Escaping

=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]

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

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

Question on Unicode/UTF8

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:

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

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

Full-Text Search

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

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

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