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

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 unsubscr

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

Script for cleaning data on a regular basis

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

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

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