"optemizer" for mySQL!

Hi All, Didn't know there was an "optemizer" for mySQL. Where can I get it from? Thanks Jim Best regards, Jim Clark Project Manager Multilink Systems Ph: 03 9425 9400 Fax: 03 9425 9811

RE: How to repair a table,

Hi Payne, This should have all the info you need, there is also another command myisamchk which requires the server to be down while it repairs. mysqlcheck does not. http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html Regards --- ***

RE: Backups with MySQL/InnoDB

Fast, incremental, compressed, and no max-size limitations. Must be transaction safe; able to run while transactions are going on without including any started after the backup began; the usual stuff. -Original Message- From: Greg 'groggy' Lehey [mailto:[EMAIL PROTECTED] Sent: Sunday, M

How to repair a table,

hi, I got a table where the myi isn't able to re be read. I tried to run myisam but it give an error about the index. Do I need to drop the table? Can it be repaired? Payne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/

Re: Backups with MySQL/InnoDB

On Sunday, 7 May 2006 at 9:27:31 -0700, Robert DiFalco wrote: > What are people doing for backups on very large MySQL/InnoDB databases? > Say for databases greater than 200 GB. Curious about the backup methods, > procedures, and frequency. A second question, but not for the first time: how would

Re: updates during database dump

Hi, I think there is another usable method to backup databases in MySQL. And that is using a slave server, (that can be running in the same server), and when backuping up the databases you do (in the slave): STOP SLAVE; -- This will stop the replication -- Now

RE: updates during database dump

Hi Luke, Like most backup systems, there is no window unless you are locking the table/database. If the record has been read and passed out to mysqldump, any further updates will not be included until the next backup. The only way to ensure you get complete referential integrity is to stop any ap

updates during database dump

Hi. When mysql is doing a dump, do the updates that happen during the dump get included in the dump. I have a dump that starts at 11pm and goes for 2 hours. If someone updates data at say 11:45pm, does that update get included in the dump? When does the window, on what gets included in a du

Re: importing a dumpfile from with the mysql client

Hi. sheeri kritzer wrote: Ah, I get it.I don't know if there's a way to do that, but why not just put the SQL statements in the file? -Sheeri Thanks George. You're right, that's what I meant. Sheeri, it would be quite possible to put it the dumpfile, if the dumpfile was editable (-: T

Re: novice on SQL

Hi John, I didn't know you can do that! (such a novice indeed!) Thank you for your reply, I will put it to the test first thing when i get back to the office tomo. Cheers "John Hicks" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > tony yau wrote: > > Hello, > > > > I can get a sel

Re: novice on SQL

tony yau wrote: Hello, I can get a select result like the following: (SELECT ID,Changes FROM mytable WHERE somecondition;) IDChanges - 1 10.0 1 10.3 1 12.2 2 31.0 3 1.02 3 4.9 how can I get the above result sets into

Problem installing 5.0.21 on Suse 9E - it fails on me

Hello, (linux novice: windows user migrating to linux) Hoping someone can point me in the right direction. Install of MySQL-server-standard-5.0.21-1.sles9.i586.rpm is failing with following error msg: "mysqld got signal 11". I have 2 Suse 9E systems and mysql installs fine on one but not the oth

novice on SQL

Hello, I can get a select result like the following: (SELECT ID,Changes FROM mytable WHERE somecondition;) IDChanges - 1 10.0 1 10.3 1 12.2 2 31.0 3 1.02 3 4.9 how can I get the above result sets into the following for

Re: How to synchronize two databases

Check this out http://dev.mysql.com/tech-resources/articles/syncman/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to synchronize two databases

You may want to consider automating the synchronization of your databases via replication. Check out the Replication chapter in the MySQL manual (chapter 6 in the MySQL 5.0 manual). I don't know if Replication can cope with changes to the table structure - I've never played with Replication -

Backups with MySQL/InnoDB

What are people doing for backups on very large MySQL/InnoDB databases? Say for databases greater than 200 GB. Curious about the backup methods, procedures, and frequency.

How to synchronize two databases

Dear Friends, I have two databases with the same name and table structure but the content is different, I need to synchronize them i mean the data inside one database need to be updated with the other one leaving the etries which are similar. Let me give a single example: DB1:table1 Rows like : u

Re: Output to a file

On 5/5/06, Rhino <[EMAIL PROTECTED]> wrote: - Original Message - From: "Payne" <[EMAIL PROTECTED]> To: Sent: Friday, May 05, 2006 12:09 AM Subject: Output to a file > Hey, > > been trying to output a select statment to a file, all the books I have > only show how to input from a file

Re: PRINT statement?

- Original Message - From: "Stephen Cook" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Sunday, May 07, 2006 3:53 AM Subject: PRINT statement? Is there a statement similar to PRINT in T-SQL (MicroSoft SQL Server)? It would be handy to debug some scripts. If you're talking about a scr

PRINT statement?

Is there a statement similar to PRINT in T-SQL (MicroSoft SQL Server)? It would be handy to debug some scripts. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]