MYSQL :: Create A Directory-search

Unable To Create Full Text Search Index On A Column
I have installed MySQL 5.0 on my WinXP machine. I have created a test schema in which I have created a test table as follows:

Test_Table
{
Id => Integer and Primary Key
Name => Char(255)
Address => Char(255)
Tags => TEXT
}

Now I want to create a full text seach index on column Tags, but when ever I try to execute following SQL statement:

ALTER TABLE `TEST_TABLE` ADD FULLTEXT `Index_FTS`(`Tags`);

I get following error:

Error while executing query:
ALTER TABLE `TEST_TABLE` ADD FULLTEXT `Index_FTS`(`Tags`);
MySQL Error Number 1283
Column 'Tags' cannot be part of FULLTEXT index.

My table is MyISAM based table.

What Directory For Basedir ?
What should i set my basedir to ? I thought /var/lib/mysql would work.

I am trying to run /mysql_upgrade script but it keeps on bitching about the basedir - can't find the mysql command line client. Which file does this refer to ? Code:

NAS Vs SAN For Data Directory
I am trying to decide which storage I should use for the "Data Directory".
My application has lots of 'SELECT's (80%) and fewer
UPDATEs/INSERTs(20 %).

I have the following choices of Data storage

1) Xiotech SAN (66 Mhz FCAL)
2) NAS
3) Internal SCSI 3 RAID 5

Will I achieve any better performance using one storage vs the other
storage?

In the past (for about 2 years), I have I used SAN with 33Mhz FCAL, and
the performance has been quite exceptional. And I have encountered no
problems.

Directory Name Invalid
For testing purposes I have PHP installed and I have MySQL installed on my local laptop. Windows XP Pro

I am just learning both of them. I have read quite a few chapters in the MySQL Manual. Enough to allow me to get around in MySQL and directly create tables an view information in them, upload .txt files into the tables, etc etc.

I am receiving an error when I try to connect to MySQL via a PHP script.
I have no problem connecting to MySQL via Command Line.

The error I receive is "The directory name is invalid."

Here is my code... I am not sure where to put the directory name or where to put the directory path in order to make it valid. I am not sure what directory it is talking about.

<html>
<head><title>Connect to MySQL</title></head>
<body>
<?php
//connecting to the mysql server uses a mysql_connect command.
$link = mysql_connect("locoalhost",$_POST['username'],$_POST['password']) or die("Connect Error: ", . mysql_error());
echo 'Successfully Connected.
';
mysql_close($link);
?>
</body>
</html>

Where exactly would I put the path to the directory or where would I name the directory?

Filerights To Certain Directory
How can I give(grant?) the mysql database rights to write in directory /opt/guide/www.domain.com/HTML/upload/test

How should I set my rights. A local user 'userA' should have the rights. How should I set these privaliges without opening the gate for everybody?

Membership Directory
I know this is probably a dumb question for all the experts out there. But I have to ask because I'm trying diligently to work at home and want to be successful. How difficult is it for someone with an Access background and pretty fair understanding of differing programming lagnuages to build a member directory that currently house 16,000+ members. The client wants it done by 8/1. I have yet to sink my teeth into a real web database, shall I take the chance? I'm a quick study and have taught myself most of what I know. I've basically gone to school to learn little things I've missed to Ace a class on something I already know, but is mandatory for my degree.

Working In A Windows Directory...over The Web
Is there a way to set up a database so it reads a windows directory?

Like the W:/ drive? Or have a function that moves files from W:/ to C:/?

and then have this functionality over the web?

Where do I start? I want this to be simple but all the resources I find are complex or more toward website stuff. Iâ€™d like to develop the frontend with PHP and have it interact with VB as well.

Using INSERT To Write To A Directory
I have a problem that I'm not sure if it can be done. I'm trying to
use the MySQL C API to be able to use a normal sql insert statement
that will send the data or file to a directory and NOT the database.
I'm not sure if there is anything out there that will allow this, but
I've searched everywhere, and I have found no solution.

Errcode 17 In Temporary Directory
I run a web server (on IIS) with a big site on it. It has php5, mysql 5 and odbc 3.51
It has 640MB of ram.

at random times I get this error (not always the same file, but similar):
[MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-log]Can't
create/write to file 'C:EasyPHP mp#sql_3fc0_0.MYD' (Errcode: 17)

If I go to that directory and delete that file, the problem disappears.
But until I do this the pages display a mysql/odbc error and nothin works. So if it happens at night or when I'm out, my website will remain down for a lot. Really annoying problem!!

I googled the errcode 17 and found out that it can be caused by:
- directory permission problem > this is not my case, I've given correct permissions
- an antivirus performing a scan in the temp directory > this is not my case

So what is this?! Code:

I Can't Seem To Find My.ini Anywhere In The /mysql/ Directory
I installed XAMPP but I can't seem to find my.ini anywhere in the /mysql/ directory
any ideas?

MySQL Or Directory Tree?
I'm working on a project where I have about 5 different data structures (objects) consisting of about 15-30 fields each. The size of each object is about 2-4 kB.
The maximum number of objects will be in the range 5000-100000 for each object.

I need possibility to search, add, delete, update and get these objects by ID, NAME, DATE and VERSION only. I have no need for the individual fields of the objects only complete objects as binary files.

When I work with the objects I need access to roughly 5-10% of the objects at a time.
Right now I have all these files in a directory tree under Windows XP with ID, NAME, DATE and VERSION included in the file name. I can do all I need but it becomes too slow sometimes.

Now to my question:
Can I benefit something from moving to a MySQL database when it comes to performance and speed and how should I set up the datbase to make it as fast as possible?

Change Database Directory
I have a linux server and i installed mysql . it's working fine.

But i want to change the mysql database dirctory from /var/lib/mysql
to /db/

how can i do that.

Creating A Community Directory
The goal is to create entries for a Community Directory:

Smith John Sally
8786 Regional Way
Somewhere, OR 97224
Child1 Child2 Child3

Using the following code I've been able to get close, but the records are repeated for each entry in the fam table:

select concat(hld.l,' ', hld.f,' ', hld.sp,'
', hld.ad,'
',hld.city,' ', hld.st,' ', hld.zip,'
',hld.ph,'
', fam.ff,' ', fam.rel,'
') from hld, fam where k = fk order by hld.l, fam.rel

Smith John Sally
8786 Regional Way
Somewhere, OR 97224
Child1

Smith John Sally
8786 Regional Way
Somewhere, OR 97224
Child2

Smith John Sally
8786 Regional Way
Somewhere, OR 97224
Child3

Obviously, I need a way to collect these multiple records into one record like the initial sample above.

List Directory Files
Is there a command in mysql that could list directory files?

Arrays And Altering Directory
I am new to this forum. I intend to share my knowledge of MySQL wid everyone here and also gain more than wat i can share. My queries are:
1.Does MySQL provide arrays.
2.Can i change the directory which stores the databases that are created by the user.
Besides Pls check www.mysql.com homepage abt a security alert regardin MySQL on Windows. there is sum worm call UDF........anyways i hope to obtain a reply soon.

Change Database Directory
I have a linux server and i installed mysql . it's working fine.

But i want to change the mysql database dirctory from /var/lib/mysql
to /db/

how can i do that

Accessing Mysql/bin Directory Problem
This may be very basic question, that I hope some of you can answer very quickly for me. I'm running mysql 4.1 on windows xp just to learn the database, and I'm in a need to run .exe in the bin directory. The problem I'm having is accessing this directory. The path is C:/Program Files/Mysql/Mysql server 4.1/bin but when I get to C:/cd "Program Files/..." I get an error message saying (parameter format not correct - "program) i have tried several things, as well as following a user guide for changing directories that states that if the folder name has spaces use " to access that subfolder...maybe there is a simple tip ...

Optimizing A Large Phone Directory
I have a table with names and contact information for a bunch of people (we'll call it a phone directory -- it's not, but confidentiality prevails ). To get twenty people to display on a single page, I'm using this query:

SELECT * FROM people ORDER BY lastName LIMIT 20
Pretty straightforward, but for some reason, with a few hundred thousand rows, this is taking a very long time (and I do have an index on lastName, which doesn't seem to help). Is there anything I can do to speed this up?

Also, would it be quicker to have separate firstName and lastName lookup tables with firstNameId and lastNameId columns, using this query:

SELECT p.*, f.name as firstname, l.name as lastName FROM people p LEFT JOIN firstNames f ON f.id = p.firstNameId LEFT JOIN lastNames l ON l.id = p.lastNameId ORDER BY l.name LIMIT 20
Unless there's some obvious problem or solution I'm overlooking, the only other thing I can imagine is having ANOTHER table with the alphabetical order of the last names, which might speed things up but seems somewhat unwieldly (though doable, if necessary, since I won't be adding people too often).

Hopefully there's some simple problem I'm not seeing (which may be, since it seems like MySQL should scale better than this).

Changing Database Directory Location
Is there any way to get MySQL to create the directory for a new database
in a specified directory instead of its "data" directory?

Dropped A Database, But It's Still Showing Up In The Directory
I dropped a database used for practice. Although all the tables are gone, the empty database itself is still there. Is this correct? How do I get use of this empty db?

Note: I'm using Mysql version 3.23.49 -nt and I also use mysqlfront although I generally use the command line to work with the dbs.

Storing A Directory Type Structure
I have a requirment to store a directory/group type of structure in a database I have an existing table of items for which i need to be able to store group information in the manner similar to the following:

group 1
subgroup 1
subsubgroup1
item1
item2
item3
subsubgroup2
item4
item5
item6
subgroup 2
item 7
item 8
item 9
group 2
item 10
item 11
item 12

The problem i am having is that an item can be in any level of subgrouping and the total level of subroups is undefined.

Changing Database Directory Location
Is there any way to get MySQL to create the directory for a new database
in a specified directory instead of its "data" directory?

Move Database In Windows To Different Directory
How do I move a database on a Windows 2000 server box. I have MySQL and found where to point the database in the MY.ini file but I cant seem to move it to another partition. If I change the path in the my.ini file the mysql service fails to start. Any help would be greatly appreciated.

I have seen how to do this in unix and linux on this forum but could not find a thread on how to do it in Windows.

Change MySQl Data Directory
I moved the data dirctory to a network drive.... this is why it's not working
Is there a way to house the data directory off a networked drive/share?

Moving Data Base From / Var To Home Directory
I'm successfully running MySql under Debian with the data files
in /var/lib/mysql. I would like to move the data base files to my home
directory and have mysql use them from there. How do I do it? Can I just
copy them to my home directory and start mysql with a parameter which point
to the new locaion? Can I do that with mysql starting at boot time?

I just looked at /etc/init.d/mysql and see that it appears to starts mysql
by calling /usr/bin/mysql_safe but there is no such file.

As an alternative to putting it in my home directory, I would be happy
putting the files in /usr/local. Can I do that without rebuilding mysql?

The reason I want to do this is that I want to install a new version of
Knoppix and that will format and clean out the / partition and I don't want
to loose the data I have in /var/lib/mysql. Could I just
save /var/lib/mysql and restore it after installing the new version of the
system?

How Can I Protect Databases Externally In The Data Directory
My question is how can i protct databases in the data directory externally?

Anyone can copy data from the data directory in mysql server and paste it to another system where another mysql server with same version is loaded. If network security is tightened, still this problem will be there. Because hard disk can be removed and data can be stolen very easily in that case. So is there any solution for this?

Cannot Start Database After Relocating The Data Directory
an error after I have relocated my data directory.I found the pid error-log file "bsd19.err" in the previous data directory and it wrote the following every time when I tried to start my database.

[Error]/usr/local/libexec/mysqld: Can't create/write to file: /usr/local/db2 (Errcode: 21)

[Error]Can't start server: can't create PID file: Is a Directory

I also have "chown" the user as mysql on that directory /usr/local/db2 before I start my database.

Home Directory For Load Data Local Infile?
i have mysql installed in the following directory:

C:Program FilesMySQLMySQL Server 4.1

i wish to import a file using this command:

load data local infile 'Data_Nov06CG1.X001' into table Nov07_File FIELDS TERMINATED BY ' ' LINES TERMINATED BY '
';

but i keep getting this error:

ERROR 2 (HY000): File 'Data_Nov06CG1.X001' not found (Errcode: 2)

i tried putting this file in the 'data' folder and the install directory. What am i doing wrong? I have a database called 'all' that i'm using for these tables, should i put it in that database folder?

Import A Directory Of Text Files Into A Mysql Database With Php?
I have a directory of text files that i'd like to import into a msql
table... I was wondering if there's an easier way to do this with
php/mysql, I'd like to avoid copy/pasting the entire directory
(thousands of files) into the database if i can.

The directory structure of the text files resembles...

somepath/A/Aerosmith/Song Name.txt - (extention varies)

What i'd like to do is use php to scan the directory and input
the file path information and the content from each file into a table
like...

Dir Artist Song Text Type
------------------------------------------------------------------------
A Aerosmith Song Name Fa La La La La (example text) File Ext
B Beatles Song Name Fa La La La La (example text) File Ext

Mysql-administrator And Mysqlcc Install Directory Conventions
What Linux directory ought the mysql-administrator and mysqlcc
executables be installed? Granted, they'll run from anywhere but is
there a common path used by most Linux distributions?

InnoDB: Page Directory Corruption: Supremum Not Pointed To
I was prompted to use the "Stop/Start Service" feature in MySQL Administrator and could not re-start the MySQL Server. I have been given a bunch of advice on how to get it started again like using the command prompt in XP Pro. I did and input "mysqld --standalone", it didn't get MySQL Server started. I was told to check the error log, this is what I found...

050515 11:08:37 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050515 11:08:37 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 47130.
InnoDB: Doing recovery: scanned up to log sequence number 0 47130
InnoDB: Page directory corruption: supremum not pointed to
050515 11:08:37 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex

It seems that the "sepremum" is not pointed to the file it should be pointed to. I don't know what the "sepremum" or if it's preventing MySQL Server from starting.

Which Is The Right Directory To Backup MySQL Database On Linux Opearing System?
Implemented web application using MySQL to maintain inventory of the
office PC's/laptops/Routers/hubs and other stuff, here we are using
MySQL as back-end Database on Linux Operating system. I need to backp
all these Inventory database into CD/Tape/Floppy, which is the right
directory (MySQL database) to backup (incase if the current MySQL
server crashes, then I should be able keep copy of my inventory),

Search: Remove Quotes From Database For Search
I am making a book site and currently in the database are book titles likes "John's Trip" and "Peter's new bike". I have a search function where the customer can type in "Peter's" and it will bring up everything with "Peter's" in it.

But i was wonderind is there any way i can search for "Peters" and "Johns".

Create Another Field After Create Table
i have create a table from CLI, i would like to add another field after create table.
How to do that ?

How To Create Different Namespaces When Using CREATE VIEW?
I'm doing a triple join between tables which have similarly named fields...I was hoping that when using CREATE VIEW, the result would be a table with fields such as a.field, b.field, c.field...but I get an error "Duplicate column name 'field'"

...How can I get around this besides changing the name of the duplicate field in each table?

Could Not Connect To The Database, Please Recheck The Settings You Specified. Also Make Sure That A Database With The Name You Specified Already Exists On The Database Server. PhpAdsNew Will Not Create The Database For You, You Must Create It Manually
The error message I get above is the same everytime when trying to install phpAdsnew. I have tried everything. I am hosted through yahoo! and have actually succesfully installed scripts before even though I know nothing about it. Now that I have a "auto-install", it does not work. Yahoo! also offers php-nuke with the auto-install where you just click a few buttons, and I get a similar error stating that it can not conect to the database.

Please can anyone help me and tell me what I am doing wrong?

I Have A Search Form To Search Through The DB.
I have a DB with 50,000 entries. I have a search form to search through the DB. If the recno=30123456 and you search the recno, you get that one file. what if i want a query that searches alll recno's that contain 30?? Can I do that using mysql or do I need to program that in my java app?

Best Way To Search
I am a little confused on the best way to search a mySQL database with PHP.

Which is better?
1. Search with LIKE and a trimmed term

SELECT * FROM tablename WHERE field1 LIKE "%$trimm%" OR field2 LIKE "%$trimm%" OR field3 LIKE "%$trimm%" ORDER BY field1 DESC
2. Using mySQL's 'match against'

Search WHERE SUM
What would be the proper way of generating a query like the following;

SELECT id FROM sales WHERE SUM( totalsales) <= '20000' GROUP BY id;

Assuming the table looks like this;
Sales:

Id| totalsales| monthyear
1 | 100| 2003-09
1 | 10000| 2003-08
1 | 2000| 2003-07
2 | 30000| 2003-05
3 | 10000| 2003-06
3 | 10000| 2003-05

I want the query to return id 1 and 2 as the sum of their totalsales is
smaller then 20000.

DB Search
I am working a search tool for users to find members based on First Character of lastname.
How can I have mysql or PHP only look at the first character of the string?

Search
I have an ASP page that searches a database. Although the entire database is searched, I use a filter on certain fields. The below filter (I could only use a little bit for the post to work)is for a field [LEDef_ActiveInd] that has either the number 1 or 2 or the text of true or false and it works and returns all "LEDef_ActiveInd" that carries the value of true.
..strQS = ..strL & "...LEDef_ActiveInd+true nd all+" & Trim(strR)

What I would like to do is also filter a field [LEDef_Cd] which has text data such as "10-Name" or "40-Name", etc. I need a filter/code that would return the results of all the "10-Names".

My SQL Search
I'm currently using the following mysql statement to perform a search. Right now it is only returning the results which are found in the description field. How do I modify this statement so that it is searching

the following fields: company_name, product_name, description.

SELECT product_id, company_name, product_name, url, description
FROM product, company
WHERE product.product_id = company.company_id AND description regexp
'#FORM.query#

Search
i have several tables. they have some fields in common, but some different ones.

table 1

id author title journal year
1 brown java computing 2005
2 black sql database 2000

table 2

id author title publisher year
1 brown c++ pen 2006

how do i search both tables for i.e. author ? the author can exist in only the one table or both. so if i search brown i get:

id author title journal year
1 brown java computing 2005

id author title publisher year
1 brown c++ pen 2006

if i search black i just get :

id author title publisher year
2 black sql database 2000

Search
I have a search box on my site which works fine but I would like to improve. at the moment it will not return a result for a two word search unless those words are adjacent ie red box but not for return for red big box I would like to make it give results for multiple word searches when the:

words are found
In this order

all words in search adjacent
all words in search (not neccesarily adjacent)
any of the words

I assume the following tells it what to look for and how to display results (I hope so any way) Code:

Search Box
I am trying to have a search box on every web page in the site - like everybody seems to have these days, anyway, according to DW help the search page results holds the key to how it searches the database, but the trouble I am having is what to put in the sql box for the query?

I know SELECT * FROM table will select everything and I know SELECT * FROM table WHERE location = 'town' ORDER BY price etc,etc. But what I need to know is how to have the results page display one set of results if a user enters one topic in the search box and another set of results if something else is entered. And if there is nothing to display, how do you configure that?

SQL To Use For Search
I am creating a script that searches the table "sites" in the database "actionhostsearch".

I have a column in my table called "keywords" and i want to check that against my entered text, I am currently using LIKE but don't get a good result, is there a way I can refine it?

The keywords are space separated, but i want it to search like multiple keywords. Is there anyway of doing this or would i have to separate the keywords out using php?

Create A Directory-search

I'd like to create a form to search in my database that is a directory. It contains an important list of persons with their names, firstnames, telephone numbers etc. Do you know where I could find a script to help me? I'd like to create a multi-criterions form.