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]

Re: PRINT statement?

- Original Message - From: Stephen Cook [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com 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

Re: Output to a file

On 5/5/06, Rhino [EMAIL PROTECTED] wrote: - Original Message - From: Payne [EMAIL PROTECTED] To: mysql@lists.mysql.com 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

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 :

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.

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 -

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]

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

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

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

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 select result

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 (-:

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

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

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: 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

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:

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,

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

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