Adding new disk (space) to mysql box

2013-04-09 Thread a bv
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

Table crashed error

2012-10-19 Thread a bv
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

Restoring database files

2012-06-18 Thread a bv
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

Script for cleaning data on a regular basis

2012-03-06 Thread a bv
...@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

Script need for dropping databases

2011-11-18 Thread a bv
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

2011-10-28 Thread a bv
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:

SQL query for unique values.

2010-02-15 Thread Ravishankar BV .
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

Betr.: Re: How to start the MySQL server

2002-04-03 Thread J van Dijk 'BV Kunststoffenindustrie Attema'
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

deleting logfiles

2002-03-27 Thread J van Dijk 'BV Kunststoffenindustrie Attema'
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

Betr.: ER Program

2002-03-21 Thread J van Dijk 'BV Kunststoffenindustrie Attema'
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