Re: help urgent please
-- help please please tell me how to extract a script file of a database from mysql commandprompt. s.deepak This life is a hard fact; work your way through it boldly, though it may be adamantine; no matter, the soul is stronger Swami Vivekananda Are you looking for mysqldump?? If you want to produce a dump file of a table: mysqldump -u yourusername -p --add-drop-table dbname tablename tablename.sql to do the whole database: mysqldump -u yourusername -p --add-drop-table dbname dbname.sql also do man mysqldump or see http://dev.mysql.com/doc/mysql/en/mysqldump.html The --add-drop-table will add a DROP TABLE IF EXISTS tablename to your script before creating and populating the tables. This is useful when restoring a possibly corrupt table. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help urgent please
One thing Jim didn't mention is that mysqldump is not a mysql client command but a standalone executable. Run it from a shell prompt (DOS prompt if you are using windows) Shawn Green Database Administrator Unimin Corporation - Spruce Pine Jim Grill [EMAIL PROTECTED] wrote on 09/09/2004 11:47:55 AM: -- help please please tell me how to extract a script file of a database from mysql commandprompt. s.deepak This life is a hard fact; work your way through it boldly, though it may be adamantine; no matter, the soul is stronger Swami Vivekananda Are you looking for mysqldump?? If you want to produce a dump file of a table: mysqldump -u yourusername -p --add-drop-table dbname tablename tablename.sql to do the whole database: mysqldump -u yourusername -p --add-drop-table dbname dbname.sql also do man mysqldump or see http://dev.mysql.com/doc/mysql/en/mysqldump.html The --add-drop-table will add a DROP TABLE IF EXISTS tablename to your script before creating and populating the tables. This is useful when restoring a possibly corrupt table. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help! Urgent!
On Tue, 13 Aug 2002, John Wards wrote: Hi folks i am in a bit of a panic. My server began playing up today and after ruling out apache and php it has come down to mysql. I need to find out what queries the database is running that is making it so slow. I can't figure out the command to use and what format it shoudl be in What about: mysqladmin processlist or mysqladmin status or mysqladmin variables Regards, Thomas - 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
Re: Help Urgent!!!
Eugene wrote: Hello... I got a big problem in MYODBC. I am using myodbc-2.50.31-win95. When I use any MySQL Administrator to query the database that I had created for example:- SELECT * FROM dbname, they come out error like:= Your command could not be completed. MySQL returned the following error: Got error 127 from table handler. There is an error too if I format my PC and reinstall all over again. So, can I know what is going on? Can you me and give me instruction to overcome this problem. Thanks. That means that the table has crashed. Repair it with command: repair table dbname; -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - 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
Re: help (urgent!!!) with a query(SOLVED!!)
hi people this is the correct syntax: delete from TABLE_NAME where DATE_ADD(TIMESTAMP_COLUMN, interval 3 day) now() the function to be used is outside the parenthesis, the column name inside; this way mysql applies the function to the column (using the specified parameters interval... compares it to the current date now() and then deletes the field if the where statement is true; thanks to jamie from the php list for pointing me in the right direction regards; At 03:56 13/08/01, you wrote: dont ya have to specify what to delete? delete * from TABLE where TIMESTAMP='date, interval 3 day' I'm new to this as well but I think this might be closer let me know the answer -C - Original Message - From: hassan el forkani [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 12, 2001 5:47 PM Subject: help (urgent!!!) with a query hello; can someone please help me with this query: delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) now() what i'm tryng to do is to delete all records that are 3 (or more) days old i've looked around in the manual but couldn't find a working answer, date functions are only explained for select queries... mysql version :3.23.33 server error : syntax error near'(date, interval 3 day)... regards - 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 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
RE: help (urgent!!!) with a query
On 13-Aug-2001 hassan el forkani wrote: hello; can someone please help me with this query: delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) now() what i'm tryng to do is to delete all records that are 3 (or more) days old i've looked around in the manual but couldn't find a working answer, date functions are only explained for select queries... mysql version :3.23.33 server error : syntax error near'(date, interval 3 day)... DELETE FROM da_table WHERE da_date DATE_SUB(current_date, INTERVAL 3 DAY); Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) - 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
Re: help (urgent!!!) with a query
On Mon, 13 Aug 2001 02:47:32 +0200, hassan el forkani [EMAIL PROTECTED] wrote: hello; can someone please help me with this query: delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) now() what i'm tryng to do is to delete all records that are 3 (or more) days old i've looked around in the manual but couldn't find a working answer, date functions are only explained for select queries... I believe that should TIMESTAMP_COLUMN(curdate(), interval 3 day) now() Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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
Re: help-urgent
You have provided absolutely no useful information for anyone who may wish to help you. ramamurthy rajeshkumar wrote: hi, We are using mysql as back end in our server.We are getting an problem with Mysql .the problem is mysqld is going down wiht out any error messages.in the log file it has writted as mysql deamon ended no other messages is thr.but we are getting problmem recently previously it was working nice.as the load increases i am getting this problem(one more thin i have all me tables in single database 10 tables wiht recorde in 20,000 will this create problem) I have set max connections as 150. looking for your help in this regards.it will be helpful for me if you reply me ASAP with regardds Rajesh _ http://cinesouth.com - The best for entertainment in South India - 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 - 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
Re: help-urgent
Hello ramamurthy, rr hi, rr We are using mysql as back end in our server.We are getting an problem with Mysql .the problem is mysqld is going down wiht out any error messages.in the log file it has writted as mysql deamon rr ended no other messages is thr.but we are getting problmem recently previously it was working nice.as the load increases i am getting this problem(one more thin i have all me tables in single rr database 10 tables wiht recorde in 20,000 will this create problem) rr I have set max connections as 150. rr looking for your help in this regards.it will be helpful for me if you reply me ASAP Are you running MySQL over Linux, Windoze??? If it's Linux, you sould check system logs, free disk space, etc. (/var for example) If it's Windoze, God save you!!! ;-) As Gerald proposed, give more tech info about system. Good luck, -- Roberto - 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