Adding new disk (space) to mysql box
Hi, What is the best way and steps to add new disk or SAN to a LVM setuped mysql/linux box?. If there are slots is it better to add a physical one or a SAN space? How would add that at linux /lvm. What to do at the current mysql database? Kernel is 2.6.x.x , any storage size restriction for linux or mysql side? Using LVM and adding a new disk will the current partion of the mysql databases size will rise at the amount of the new added disk space, so there wont be any issue releated to mysql ? Regards
Table crashed error
Hi on a log management server from the web interface i get the below error . What can be the reason and how can i repair it ? Regards Mysql_error: Table ./x/y ' is marked as crashed and should be repaired -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Restoring database files
I have a mysql database , which tables are archived and i remove some files (montly data, .frm .MYD, .MYI) from the servers disk to an external storage. And i also drop or flush these tables from phpmyadmin. If i need to look and query these offline mysql files what i need to do after copying the files back to the mysql path of the server? Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Script for cleaning data on a regular basis
I found some scripts but i have to edit them to give the true table name to drop. Its format is name1_name2_yearmonth which year and month here we are talking about is the year and date before the current day . So how can i give this variable to the script? Regards 2012/1/27 walter harms wha...@bfs.de: Am 26.01.2012 18:45, schrieb HalXsz SXndor: 20120126 10:34 AM +0200, a bv Database contains tables (structures?) which gets montly data , and these tables are named as name1_name2_ yearmonth . I only want to have the whole database system for last 2 years, and automaticly clean the data which became more than 2 years old , so i need a script for this (shell, php etc) . Can you please help me for this script ? and also which mysql command must be used drop, trunk? You can, if you are careful, write an SQL procedure for dropping the appropriate tables. Since MySQL has no table variables, if you do this you will need PREPARE. Therefore, it well may be easier to do it all in PHP, since therewith you can construct statements. The statement SHOW TABLES is also a reference to table INFORMATION_SCHEMA.TABLES; maybe you can use SHOW TABLES for a SELECT statement in PHP; if not, try INFORMATION_SCHEMA.TABLES for their names. This is simple, consult your manual about crontab. and start a script like that: #!/bin/bash mysql -BAN database EOF place my great sql-statemant here If you need some additional informationen like $HOME you can use it also EOF If something goes wrong a mail will be send to the owner (details see man 5 crontab) re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Script need for dropping databases
Hi, I have a linux box running mysql plus phpmyadmin which has tables getting montly data and when a new month starts a new table is created. I want to store only 2 years of data so when a new month starts i need to drop the table which became the data container of 2 years previous data. So to make this job auto, i need a linux/mysql script which will run on cron etc . Can you please help me for a correct script ? (i cant say im a database guy :-) Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Disk space ending with multiple tables
Hi, I have a phpsyslog-ng box with different tables and disk usage is growing so fast nearly no space left. How must i move the old files ? Is it ok to move just like an ordinary file or do something on mysql? Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
SQL query for unique values.
Hi, I'm very new to SQL and databases. I need a query for the following: (I'm sure google would have found the answer, but I could not really frame the sentence for the task I'm looking for. Also, please let me know how do I search in google for such tasks - so that I can try it myself in future). Assume I have a table like: Sl No Fruit Grown in states 1 Apple KA 2 Orange AP 3 Banana TN 4 Jackfruit MH 5 Mango MP 6 Jackfruit MP 7 Banana AP 8 Mango KA 9 Banana TN 10 Apple MH 11 Jackfruit AP 12 Orange MH 13 Mango KA 14 Apple TN 15 Banana MP 16 Banana MH 17 Mango KA 18 Orange MP 19 Jackfruit AP 20 Apple TN From the above table, I want a SQL query which will list me the unique fruits and the states in which they are grown, like: Apple: KA, MH, TN Banana: TN, AP, MP, MH Jackfruit: MH,MP,AP Mango: MP, KA Orange: AP,MH,MP Thanks in advance for the help, Ravi. http://www.mindtree.com/email/disclaimer.html
Betr.: Re: How to start the MySQL server
Hi, See linuxconf, mysql is installed as a service which can be started manually or automatic via linuxconf. JvD [EMAIL PROTECTED] 3-4-02 11:25:19 On Wed, Apr 03, 2002 at 05:18:30PM +0800, Hammer wrote: Dear friends, I'm running RedHat Linux, I just downloaded the ~.tar.gz mysql file in my /usr/local directory and uncompressed it. Now I can get the target directory but I don't know how to start the server. I tried: ./bin/safe_mysqld --user=root but it doesn't work for me. Any help is warmly welcome. Could you first read the README file(s) that were in the .tar.gz file? You'll find the process explained there pretty well. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 54 days, processed 1,515,042,039 queries (319/sec. avg) - 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
deleting logfiles
Hi, I'm running RH Linux 7.0,and Mysql Version: 3.23.22-beta, and the mysqld.log grows very rapidly. Is there a way to turn it off ? Logrotation is not really an option in this case, the only possibilities are not logging or delete it every day. Any hints ? JvD,Netherlands - 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
Betr.: ER Program
Try this: Microsoft VisioModeler 3.1 (FREE) on msdn.microsoft.com/downloads jvd Ricardo Striquer Soares [EMAIL PROTECTED] 21-3-02 13:21:20 i am looking for a ER Design Freeware tool, i'd like to konw if does someone here knows about something like that, the tool name and, if possible, the url for download. currently i am using a DDT (Database Design Tool) V1.5, however i think it's too simple with that i can not create indexes, i saw one named dezign for databases which is a tool indicated by the MySQL AB, although in it's free version i can only create at last 10 entities and in each one i can create about of 10 filds only. thanks advanced. idéias.ual.. Idéias Pontual Desenvolvimento de Software Ltda. Ricardo Striquer Soares CEO e-business Fone: +55 (41) 322-9373 Cel: +55 (41) 9908-3862 Fax: +55 (41) 223-7865 Mr. Lucro : www.mrlucro.com.br _ 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 - 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