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 talking about a script that is running SQL, you can simply use the SELECT statement without any FROM, WHERE, ORDER BY, GROUP BY or HAVING clauses. For example: select Creating Foo table as Action; will produce the following output: +--+ | Action | +--+ | Creating Foo table | +--+ 1 row in set (0.00 sec) If you're talking about an OS script, you can use OS commands to display things. For example, I have some BASH scripts on our Linux server so I can use the BASH echo command, like this: #!/bin/bash report_date=`/bin/date` echo Report Date: $report_date; to produce this output: Report Date: Sun May 7 09:42:57 EDT 2006 -- Rhino -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.5/333 - Release Date: 05/05/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 from a file, what is the correct way I thought I could do select * from my_toy `/tmp/my_toys` But I get an error. Here is a snippet from some documentation about MySQL which I wrote for myself. It shows a different technique for capturing output from a batch file into an output file; if the batch file contains 'select * from my_toy', it will capture the output in a file. It's not exactly what you want but maybe it will be close enough. Running a script from OS prompt If you are connected to the database and are at an OS prompt, use this pattern: mysql batch-file output-file For example, if I want to run a script or batch file named my_batch_file.sql and write the output of the script to a file named my_batch_file.out, I'd need to do this: mysql my_batch_file.sql my_batch_file.out If you are NOT connected to the database, use this pattern: mysql -u username -p batch_file output_file For example, if your user name is 'fred' and your password is 'dino' and you want to run a script or batch file named my_batch_file.sql against database 'barf' and write the output to a file called my_batch_file.out, you'll need to do this: mysql barf -u fred -p my_batch_file.sql my_batch_file.out [Be sure to supply the password when prompted.] -- Rhino -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.4/332 - Release Date: 04/05/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] select * into outfile '/tmp/new.txt' from tablename where condition = '1'; looks to me a good option. Best Regards, Abhishek Jain
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 : userid name Ist row 1 abhishek IInd row 2 jain III row 3 rahul DB2:table1 Rows like : userid name Ist row 1 abhishek IInd row 2 amitabh III row 3 vijay Now i want like : Rows like : userid name Ist row 1 abhishek IInd row 2 jain III row 3 rahul IV row 4 amitabh V row 5 vijay NOTE: Here DB1 = database names , table1 = table name . How can i do that via mysql or that i need to prepare a script for this can anyone help. Regards, Abhishek Jain
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 - but the manual should tell you whether this is a problem or is handled well by MySQL. -- Rhino - Original Message - From: abhishek jain [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, May 07, 2006 11:41 AM Subject: 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 : userid name Ist row 1 abhishek IInd row 2 jain III row 3 rahul DB2:table1 Rows like : userid name Ist row 1 abhishek IInd row 2 amitabh III row 3 vijay Now i want like : Rows like : userid name Ist row 1 abhishek IInd row 2 jain III row 3 rahul IV row 4 amitabh V row 5 vijay NOTE: Here DB1 = database names , table1 = table name . How can i do that via mysql or that i need to prepare a script for this can anyone help. Regards, Abhishek Jain No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.5/333 - Release Date: 05/05/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.5/333 - Release Date: 05/05/2006 -- 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
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 format (columns 'Changes1','Changes2',... are all from 'Changes') IDChanges1Changes2Changes3 (limits of 5) 1 10.010.312.2 2 31.0 3 1.024.9 I have got a method that works (I think) by first do a SELECT getting DISTINCT id values and then foreach of these ID I do another SELECT to get the Changes values and then just massage the display. Is there another way of doing this by using a single SQL query? any help or hints will be very much appreciated. Thanks -- Tony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 other. Both systems are new installs and have the same software installed (all rpms are same except kernel). kernel: 2.6.5-7.97-default -- installs okay here AMD Athlon64 kernel: 2.6.5-7.97-smp -- fails here Intel Dual Xeons MySQL-server-standard-5.0.19-0.sles9.i586.rpm installs perfectly on both systems. MySQL-server-standard-5.0.20a-0.sles9.i586.rpm also fails on the Intel Xeon system but installs fine on the AMD system. I think it has to do with my network configuration or the yaSSL features in 5.0.20+ I tried doing resolve_stack_dump but I am no linux programming expert. Any help would be appreciated. Details below JohnC full error msg --- MySQL-server-standard-5.0.21-1.sles9.i586.rpm mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=0 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 217599 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=(nil) Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbffbcae4, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8183f80 0xe420 New value of fp=(nil) failed sanity check, terminating stack trace! - - - Tried doing: resolve_stack_dump -s mysqld.sym -n mysqld.stack2 0x8183f80 handle_segfault + 656 0xe420 _end + -140375984 full error msg --- MySQL-server-standard-5.0.19-0.sles9.i586.rpm 060506 09:05:31 mysqld started mysqld: socket_wrapper.cpp:114: uint yaSSL::Socket::send(const byte*, unsigned int, int) const: Assertion `socket_ != INVALID_SOCKET' failed. mysqld got signal 6; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=0 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 217599 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=(nil) Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbffbc9bc, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8182090 0xe420 (nil) 0x400c9cd3 0x8401dd1 0x83f6e91 0x84017ad 0x83eb843 0x40209809 0x40209ad8 0x401caa9c 0x401cc671 0x401c382e Stack trace seems successful - bottom reached - Tried doing: resolve_stack_dump -s mysqld.sym -n mysqld.stack 0x8183f80 handle_segfault + 656 0xe420 _end + -140375984 (nil) 0x400c9cd3 _end + 934199555 0x84038a1 _ZNK5yaSSL6Socket4sendEPKhji + 97 0x83f8961 _ZN5yaSSL3SSL4SendEPKhj + 49 0x840327d _ZN5yaSSL15sendClientHelloERNS_3SSLE + 317 0x83ed313 SSL_connect + 19 0x40209809 _end + 935509049 0x40209ad8 _end + 935509768 0x401caa9c _end + 935251660 0x401cc671 _end + 935258785 0x401c382e _end + 935222366 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 the following format (columns 'Changes1','Changes2',... are all from 'Changes') IDChanges1Changes2Changes3 (limits of 5) 1 10.010.312.2 2 31.0 3 1.024.9 I have got a method that works (I think) by first do a SELECT getting DISTINCT id values and then foreach of these ID I do another SELECT to get the Changes values and then just massage the display. Is there another way of doing this by using a single SQL query? There may be a simpler way, but this should work: select Table.ID, Table1.Changes as Changes1, Table2.Changes as Changes2, Table3.Changes as Changes3 from Table, Table as Table1, Table as Table2, Table as Table3 where Table.ID = Table1.ID and Table.ID = Table2.ID and Table.ID = Table3.ID and Table1.[condition for Changes1] and Table2.[condition for Changes2] and Table3.[condition for Changes3] order by table.ID --J -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 format (columns 'Changes1','Changes2',... are all from 'Changes') IDChanges1Changes2Changes3 (limits of 5) 1 10.010.312.2 2 31.0 3 1.024.9 I have got a method that works (I think) by first do a SELECT getting DISTINCT id values and then foreach of these ID I do another SELECT to get the Changes values and then just massage the display. Is there another way of doing this by using a single SQL query? There may be a simpler way, but this should work: select Table.ID, Table1.Changes as Changes1, Table2.Changes as Changes2, Table3.Changes as Changes3 from Table, Table as Table1, Table as Table2, Table as Table3 where Table.ID = Table1.ID and Table.ID = Table2.ID and Table.ID = Table3.ID and Table1.[condition for Changes1] and Table2.[condition for Changes2] and Table3.[condition for Changes3] order by table.ID --J -- 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]
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 (-: The dumpfile we are using is so large that I can't open it with any editor. So again the question is: If the remote session is still active but I haven't carried out those commands and the database has been updated, modified, manipulated etc. in the meantime, is there a danger in closing the session or carrying out the commands several days later ? The commands that I am talking about are: mysql SET FOREIGN_KEY_CHECKS = 1; mysql COMMIT; Thanks. Kind regards. On 5/5/06, George Law [EMAIL PROTECTED] wrote: I think what he is saying is that be began the transaction in a command line client session from one location but was not able to give the mysql SET FOREIGN_KEY_CHECKS = 1; mysql COMMIT; commands in the same session. (ie - I owe, I owe, its off to work I go :) ) This is a good question, one I have wondered about myself. Is there a way in mysql to attach to session to issue a commit? -Original Message- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 3:02 PM To: Luke Vanderfluit Cc: MySQL List Subject: Re: importing a dumpfile from with the mysql client On 5/4/06, Luke Vanderfluit [EMAIL PROTECTED] wrote: [snip] I started this process remotely then went to the site to finish it. But when the dump finished (several hours later) I was not able to execute the following commands from my original location. mysql SET FOREIGN_KEY_CHECKS = 1; mysql COMMIT; What do you mean you were not able? Did you get an error? Was the server hung? Did the keyboard stick to make you unable to type the commands? My question is: Since the import completed the database has grown in size and been backed up etc. Yet from the original session I have not executed those 2 commands. Is it safe to execute them? Or would executing them cause corruption or other unforseen stuff? Is it unnecessary to execute them? Is it safe to kill that original mysql session? Those 2 commands, in and of themselves, aren't dangerous. It's what's in the script that could be the problem. However, since you really didn't mention what error you got, it's not easy to figure out how to fix it. It depends what tables you're running these on. If you're running them on MyISAM tables, deadlocking cannot happen. Then again, transactions are meaningless too. If you're running on InnoDB you have the possibility of deadlocking, but MySQL is pretty good about avoiding that. If other users/applications are writing to the SAME data then there's the possibility of inconsistent data, but I wouldn't expect corruption. if you post what errors you actually got, I might be able to help. Also, are you using the same db and tables that other apps/users are using? Does the dumpfile contain DROP TABLE IF EXISTS commands? -Sheeri -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 dump, close? Thanks. Kind regards. -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 applications and lock all users out of the database. This is highly impractical in many cases so a hot backup is the only solution. A common solution is to have the database on a mirrored volume, drop the apps, break the mirror, restart the apps and backup from the unused half of the mirror. Rejoin the mirror at the end of the backup. If you are using InnoDB, Innobase have a hot backup product which (I believe) works well. Other than that, I don't know if there is any product currently for the MyISAM engine but I believe there are noises afoot from MySQL in this regard. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Monday, 8 May 2006 8:32 AM To: MySQL List Subject: 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 dump, close? Thanks. Kind regards. -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- 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]
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 you backup the databases (using mysqldump or anything you
prefer) from
the slave server
START SLAVE; -- This will restart the replication
This way you have a consistent snapshot of your database, without stop
the
main database, that is being used to whatever aplication you need.
Hope this help,
themage
On Monday 08 May 2006 00:07, Logan, David (SST - Adelaide) wrote:
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 applications and lock all users out of the database.
This is highly impractical in many cases so a hot backup is the only
solution. A common solution is to have the database on a mirrored
volume, drop the apps, break the mirror, restart the apps and backup
from the unused half of the mirror. Rejoin the mirror at the end of the
backup.
If you are using InnoDB, Innobase have a hot backup product which (I
believe) works well. Other than that, I don't know if there is any
product currently for the MyISAM engine but I believe there are noises
afoot from MySQL in this regard.
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: Luke Vanderfluit [mailto:[EMAIL PROTECTED]
Sent: Monday, 8 May 2006 8:32 AM
To: MySQL List
Subject: 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 dump, close?
Thanks.
Kind regards.
--
Luke Vanderfluit.
Analyst/Programmer.
Internode Systems Pty. Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Merlin, the Mage
http://www.sites-favoritos.com/user/merlin
http://www.cultodavida.com
http://www.code.online.pt
Carpe Vitam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 you *like* to do backups if you had the choice? We're currently in the final stages of the design of an online backup solution, and in the near future I'll publish the specs. I won't mention them now to avoid influencing you, but now's the time to speak up if you want something specific. Greg -- Greg Lehey, Senior Software Engineer MySQL AB, http://www.mysql.com/ Echunga, South Australia Phone: +61-8-8388-8286 Mobile: +61-418-838-708 Are you MySQL certified? http://www.mysql.com/certification/ pgpTiC6AScuNm.pgp Description: PGP signature
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/[EMAIL PROTECTED]
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, May 07, 2006 6:14 PM To: Robert DiFalco Cc: mysql@lists.mysql.com Subject: 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 you *like* to do backups if you had the choice? We're currently in the final stages of the design of an online backup solution, and in the near future I'll publish the specs. I won't mention them now to avoid influencing you, but now's the time to speak up if you want something specific. Greg -- Greg Lehey, Senior Software Engineer MySQL AB, http://www.mysql.com/ Echunga, South Australia Phone: +61-8-8388-8286 Mobile: +61-418-838-708 Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Payne [mailto:[EMAIL PROTECTED] Sent: Monday, 8 May 2006 1:45 PM To: mysql@lists.mysql.com Subject: 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
