MYSQL :: Symbolic Links With Windows XP Or Option Datadir

Symbolic Links On Windows
I am runnign the latest version of mysql and I desperately need to
move one of my tables from a database so that it is stored on another
drive.

I have read the symbolic links reference but it seems to me that I can
relocate a database but not a table. Which is not useful to me at all.
I have tried anyhow without any success.

Symbolic Links
I'm trying to create a DB in a directory other than the datadir. The manual tells me symbolic links should allow this but I can't make it work. Can anyone confirm whether this feature works or is broken?

How To Setup Symbolic Links To Networked Drives In XP
I want to setup a database symbolic link within Windows XP to a
network drive which has significanlty more space available and can't
seem to get it working. Here is my setup....

- I am running MySQL 4.1.7

- I have tried this with both the 'mysqld-max' and 'mysqld-max-nt'
servers

- Per the MySQL manual (section 7.6.1.3) I setup a 'foo.sym' file in
the C:MySQLdata directory which references the "linked" database
direcotry.

- If I setup the .sym file to reference another disk local to the
machine (e.g. D: running the server it works fine.

- If I setup the .sym file to reference to a networked drive it does
not work.

I have tried referencing the networked drive by the mapped drive
designator ("Z:"), by remote machine name ("
emote_host"), and by
IP address. Has anyone set this up? Is there something I am missing?

Table "hard Links" Under Windows
I am attempting to create "Symbolic" or as windows calls it "hard links" for some tables in a database.
I have 2 databases, db1 has a users table that I created a 'hard link' to in db2.
I created this using this program which ads shell intiration for hard linking: http://www.elsdoerfer.info/=ntfslink

The hard-link appears to work, I tested with a simple .txt file and i can make changes to one file and open the other and see them. The 2 databases were working fine for awile after I created these hard-links, then things started to go wrong.

It seems whenever I try to add a new row to the users table in db2 (with the hard-link) the change doens't show up in the same table in db1. It also corrupts the table. And same the other way, I added a bunch of users into the table in db1, then did a CHECK on the users table in db2 and it gives me this "Size of datafile is: 6872396 Should be: 6874300". So it seems part of the data is being written, since it knows what it should be.

I read that one can do this type of setup in linux with symbolic links, maybe it doens't work with windows hard-links? It seems it should... maybe i'm missing something?

Datadir
I tried to move the default data dir to my data drive, because this is different from the system and program drive.

But it seems that on Windows there is no possiblity to change this. Every time I try it the mysqld-nt service does not start.

I can not belive such behavior! I it really true that on Windows you can't change the database location?

Datadir
I have installed MySQL on windows2k. The present path of datadir is c:mysqldata. Now i want the data to be located somewhere in d:.
Is it possible without uninstalling the MySQL server ?
can i just edit my.ini for datadir and also when i edit the my.ini file shd the mysql server be running or not

DATADIR
I installed MySql with the default settings. But I'd like now to change
the place where I keep my data files. I tried changing the DATADIR
parameter in /etc/my.cfg but the server won't start. Is there any way
to change only the data directory from /var/lib/mysql to
/otherplace/mysql and leave everything else in it's place?

Re MySql Datadir
I lost my password and figured out how to access the mysql server bu shutting it down and reloading it etc. but then the servier points to the wrong directory - that is /var instead of /var/lib/mysql (where all ther mys data files are. How do I change the datadir when loading in safe more (that is I type /usr/libexec/mysqld -Sg --user=root

Changing DATADIR
I installed MySql with the default settings. But I'd like now to change
the place where I keep my data files. I tried changing the DATADIR
parameter in /etc/my.cfg but the server won't start. Is there any way
to change only the data directory from /var/lib/mysql to
/otherplace/mysql and leave everything else in it's place?

Change Datadir In My.cnf
I would like to move my DBs in another directory.
I know that I have to change in my.cnf the datadir path ....

[mysqld]
datadir=/var/lib/mysql

-datadir=/user/mysql/databases

now my question is, can I simple copy all my DBs to the new datadir,
and then restart mysql server ? Or is there something to take care ?

Need To Change The Datadir On Linux
Having a problem changing the datadir to point to a new disk that we installed in the linux machine.

here is the my.cnf file:
Quote:
# Replication Master Server
[client]
port = 3306
socket = /mysql_data/mysql/mysql.sock

[mysqld]
# Replication Master Server (default)
# binary logging is required for replication
log-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id    = 1

datadir=/var/lib/mysql
#datadir=/mysql_data/mysql    'new disk
socket=/var/lib/mysql/mysql.sock
#socket=/mysql_data/mysql/mysql.sock  'new disk

[mysql.server]
user=mysql
basedir=/var/lib
#basedir=/mysql_data

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Can't Change Datadir Path
I'm running MySQL 5.0.45-community-nt under Windows Vista Home Premium without any problems. In my LAN I have an ReadyNAS NV+ which I will like to use for for datadir. When I stop my MySQL instance, change the datadir path to the NAS and try to restart the service I get the following error in the log messages window:

Trying to start the server ...
Could not re-connect to the MySQL Server.
Server could not be started.
Can't create test file P:MySQL_dataASTERIX.lower-test
Can't create test file P:MySQL_dataASTERIX.lower-test
Aborting
C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: Shutdown complete

Does anybody have an idea..

Can't Move MySQL Datadir
I want to do something ridiculously simple and naturally MySQL is presenting me with problems that the manual doesn't even hint at.

Platform is Debian Linux 2.4.21

All I want to do is change the datadir in /etc/mysql/my.cnf from
/var/lib/mysql to /DB.

I attempted this as follows: Code:

Changed Datadir Now Mysql Won't Run
I changed the datadir using mysql administrator (so I could "see it") (I'm using version 5.0.x under OS X 10.4.5 and now mysql won't run and I don't know how to reset the datadir. I've reinstalled mysql and when I try to run it this is what I get:

iBook-G4:/usr/local/mysql michael$ sudo ./bin/mysqld_safe &
[16] 12878
iBook-G4:/usr/local/mysql michael$ Starting mysqld daemon with databases from /Users/michael/Sites
STOPPING server from pid file /Users/michael/Sites/iBook-G4.pid
060329 12:38:24 mysqld ended

Having Links
I want to have file tree structure, but am thinking the easiest way would be to have links (or locations) to files in a mysql table.

Insert Links Into Rc?
I recently installed SuSE 9.3 on x86, and it seems to contain scripts
"apache2" and "mysql" in the /etc/init.d folder. However, these two (Apache
or MySQL) are not running when I fresh reboot the machine. I am having to
execute a "./apache2 start" and "./mysql start" every time I reboot.

I am a newbie when it comes to unix admin, and I am trying to read up about
the rc scripts and how they link into the scripts under the /etc/init.d
folder. Before I rush and do what appears "natural" to me (create a S?? and
K?? links in the rc?.d), I'd like to find out some basic questions it
raises:

1. Why would the install place the apache2 and mysql scripts under the
/etc/init.d but not have any entries in any of the rc scripts?
2. What do I need to do (anything specific to SuSE) to make the apache and
mysql launch on reboot? Which rcN gets it?

Menu And Links
i have a page called menu.php, where it displays data from a db which has fields like id, title and url.

It is placed on the root folder i.e mysite.com/menu.php, now i have the mainpage index.php where i use include line to include my menu.php page. Everything is fine but it didn't work when i include the menu.php in another folder i.e bands/index.php. because the link would appear like bands/bands/index.php.

I don't know if that is the correct method of doing it, but is there an alternate way of doing the menu.php so that it works on all folders. If i dont use the field url in my db, how to do the linking successfully ?

Html-links
Is it possible in a textfield to place a clickable link to a URL?

Links Within MYSQL
when entering data into a table, how do you make the data a link to something? ( a picture for example) when it is viewed in a browser? is that done in MYSQL itself ...or PHP (or similar?)

Links Actually Link To
how I could figure out what linked fields in an existing database link to? There are currently something like 20 tables, with up to a couple hundred columns. I know for a fact that a lot of the fields are linked, but I have no idea what the links are. I've got Access, Excel and MySQL Administrator at my disposal. I've looked around for an answer or a program that would help out

Mysql - Database Links?
does anyone know how I can connect a mysql-database to an oracle view?
Can I create db-links in mysql(version: 3.23.37)?

Mysql Field Links
Im building a database with Mysql and PHP, so ive created the database and tables already, my problem is, in one of the fields of my table I would like to have a clickable link to another page returned to me when I see the results, ive been trying ->>

mysql_query( "SELECT Name, Description, '<a href=' WebSite '</a>' FROM my_tablename" )

But nothing is working, can this be done??.

LINKs For A Data Base
I am trying to create a database that have email addresses. I would lie it so that when some one clicks on the email address, it would open up the email ( mailto:xxxx.xxxxx.com) , yet I want it to display as xxxx.xxxxx.com (as a hyperlink)
The above answer might answer the next quest, but if not please advise on it as well.
I would like to create a link to a different page in a table (pictures of people), again, this should be a hyperlink.

Links Database Structure
I'm creating a 'Favourite Links' function on our Intranet, using PHP/MySQL. I'd really like some advice on the most efficient way of setting this up.
Users login to the site and are either identified by a cookie or by a session. Their favourite links (ID, Title, URL, Description) will be displayed on their personalised homepage.
We have about 230 users. I could set up a a table to hold the links for each user but that seems excessive. I could create the one table of links but with a field that records the owner/users ID but perhaps that would be a very memory-hungry query once the table gets really large.

Ignore Empty Links In Table
I have a set of tables like so:

category -> subcategory - gallery -> gallerylink-> images

each linked by a parentid

category - holds a categoryID
subcategory table is linked to category via categoryid
gallery linked to subcat via subcatid
gallerylink holds galleryid and imageids
images linked to gallery via gallerylink table

Ok so I am trying to get a random imageid(to display a thumbnail) out of my images table for a specific user. At the point I run this query, all I have is the userid. Here is my query:

select CategoryID from category where UserID = 1 ORDER BY RAND() limit 1

I then take the categoryid I get here and my userid and run a more specifc query to get the imageid I need using all the linked tables.

The problem is when I run this categoryid query, it is possible that it grabs a categoryid that has no subcategory assigned yet, or gallery or images. So I only want to look at categoryids to which have a record in the subcat table and the subcat table has a record in the gallery table and it has a record in the gallerylink table.

So the categoryid that is randomly selected has to be linked all the way to an existing image. How do I accomplish this without running 4 separate queries?

Storing Pointers/Links To Files
I have a form that allows users to enter to input data via a text box. It also has the ability to take any of the word(s) entered and create a hyperlink to a file if needed. Everything works great except when this data is written to the database the backslash for the subdirectorys get messed up.

For example, if the directory a file is located in is:
c:mydirectorymyfile

But when written to the database it comes out like this:
c:mydirectory|myfile

How can I get the to insert instead of the | for the pointer?

Html Links Inside Varchar
I have to put html links inside varchar and text fields. They have to be (somehow) fulltext searchable (of course a substring, %keyword% search, would pick them up - I realize that) and they have to render as clickable links when I output the fields via PHP. How would I do this?

Using Limits And Then Links At The Bottom To Continue The Query
I am running a query that has over 100 records in it, I want to limit the queries to 20 per page and then put a link at the bottom to continue till it comes to the end of the query. HOw the do I do this? I know how to use the LIMIT, but what more do I need to add to my query to make this happen.

OPTION Value
Here's the connection string I use commonly with my VFP9 apps connecting to a MySQL5 backend:

DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;UID=mike;PWD=foxrocks;DATABASE=mydb;option=131609

I was wondering what other values for the OPTION parameter folks use? Sometimes, I get some flakiness, so I was searching for a consensus on "best option value to use."

Store Links Inside The Main Text In A Database
we are trying to set up a mySql database while rebuilding a webpage
with lots of content.we actually dont know how to set up the tables for
that and especially how to store links inside the main text?should we
use xml files to store the text with embedded links?

Binary Log Off Option ?
I am using mysql version 4.0.22.
Which file to access and modify If i want to disable binary logs which are created in mysqlvar ?

Sql Option ALLOW_INVALID_DATES
how to implelent 'ALLOW_INVALID_DATES' option for sql mode?
I was able to run

SET GLOBAL sql_mode='ANSI';

but can't get the syntax of ALLOW_INVALID_DATES ...

Can't Set The Table Option
I've use the command CREATE TABLE as follow:

CREATE TABLE test(myid varchar(20)) DEFAULT CHARSET=latin1

and

CREATE TABLE test(myid varchar(20)) DEFAULT CHARACTER SET latin1

I've got an error message with the 2 commands above saying that I've used the wrong syntax near the "DEFAULT CHARSET=latin1" clause. I've read the MySQL Document and figured out those commands have the right syntax, not wrong.

Could anyone please tell me how to create a table with DEFAULT CHARSET=latin1.
( I have use MySQl ver 4.0 ).

Subselect In 4.0.12-max With -- New Option
I was reading the manual and it said that the subselect is only
available in 4.1 or using the 4.0.12 with the mysqld =96new command line
to start it.

But it doesn=92t working!! So I downloaded the 4.1 alpha version with =
the
same problem. The error is:

ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near =85.

Any ideas? I need subselect working.

Unknown Option -- Log-bin
Trying to use the mysql command-line client with a MySQL 5.0.21 database on Windows 2003 Server, and am getting the error message:

mysql: unknown option '--log-bin'

What does this mean and how can I get my command-line client back?

--force Option
I'm using a batch file to insert data into my database.
I read in the manual that using the --force option makes mysql to continue processing the batch file, although there was an error like "table does not exist" or something like that.

However I noticed that mysql still quits if it tries to insert data in a table that not exists.

I'm using mysql 5.0.19 under a windows xp system

the command i'm executing is as follows:

mysql -u root --force databasename < "path/to/batch.sql"

Stored Procedure For Creating Prev-next Links Within Detail Page
how to create previous and next links within a detail page that navigates dynamically by displaying details of each record as contained within the mysql database.

In the tutorial, it had some sql code on creating the stored procedure but i feel it is not for use with mysql since the syntax is different. Code:

MySQL Replacement Option
I want to replace a character "/" with &frasl; in my database, is there any option to do that.

Local-infile Option
I´m using mysql 3.23.58 and I want to enable the local-infile option.
The manual on dev.mysql.com says the following to that:

.....
If you use LOAD DATA LOCAL in Perl scripts or other programs that read
the [client] group from option files, you can add the local-infile=1
option to that group. However, to keep this from causing problems for
programs that do not understand local-infile, specify it using the
loose- prefix:

[client]
loose-local-infile=1
......

But when I do that the I can restart the mysql-Server but starting of
mysqladmin says the following:

Unrecognized option local-infile

The same message with loose-local-infile=1.

When I start the server with --local-infile=1 and then starting the
mysql-Client with --local-infile=1 on the shell everything is OK and I
can use the LOAD DATA LOCAL Syntax.

What is wrong? Why it is an unregognized command? I need the LOAD DATA
LOCAL because I want to use mysql with Perl.

Disable -- User Option
I would like to use unix user names to login to mysql. If I create a mysql user xxadmin and leave the password empty other unix users can use the xxadmin with the --user option . How can I make sure that only the unix user xxadmin can login as mysql user xxadmin ?

Error =SET OPTION SQL_BIG_SELECTS=1
I add a few more test records to my db.... the result the following error message...

Vbscript Runtime error 'ASP 0185 : 3219'

General error: The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok

Well to the best of my knowledge my WHERE could not be more simple and all the tables concerned don't have that many records.

I've scanned the net but cannot find an obvious answer. Any clues... if I need to use "SET OPTION... how do I do this within ASP. Code:

Browse Option Not Shown?
However, some fields won't let me browse what are in the fields. I have full admin access tot the website. If any1 doesn't know what im talking about, I could post a screenshot, if nessessary.

Mysql --force Option
I'm using a batch file to insert data into my database.
I read in the manual that using the --force option makes mysql to continue processing the batch file, although there was an error like "table does not exist" or something like that.

However I noticed that mysql still quits if it tries to insert data in a table that not exists.

I'm using mysql 5.0.19 under a windows xp system

the command i'm executing is as follows:

mysql -u root --force databasename < "path/to/batch.sql"
Xema

Joining User Option Lists
I have a niggly problem that I can't quite work out which I'm sure has a simple answer (have to be missing something).

I have a table of 7 categories, each with a unique ID and name.
A seperate table is a category/user mapping table which maps users to a category.

For example, if a user is a a member of 4/7 categories, they have 4 rows in the mapping table, each one with their userID/catID in it.

What I'm attempting to do is select a list of ALL categories and join (where applicable) the category map so I can present all options regardless of whether the user is a member of a particular category or not (but I do need to know if they are or not).

PHP

SELECT *
FROM categories
LEFT JOIN category_map ON categories.id = category_map.c_id
WHERE category_map.u_id=10

I had some success with adding OR category_map.u_id IS NULL but returns odd results when there are 0 rows present for a user in the category_map table.

Printing A Result After An Option Has Been Submitted
My goal is this.- To print another field value 'scriptcode', of the same row after an option 'scriptnaam' is submitted.

The first part isn't the problem. I do get all the data 'scriptnaam' in a select field.
But to distillate, a result 'scriptcode' out of it ???

If someone could help me a bit further with that, that would be great.
I like to mention, that I've just started with PHP/MYSQL, so my knowledge about it is limited. Code:

Mysql: Unknown Option '--ndbcluster'
Running into some issues while configuring my cluster....

I'm setting up a cluster with two storage nodes and one management node...
The problem I'm having is that when I try to open MySQL on one of the storage nodes I get this error...

mysql: unknown option '--ndbcluster'

but i do not get this error on the other storage node and i am able to access MySQL on it.

The my.cnf file looks like this:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysql_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

#Options for MySQLD process
[MYSQL]
ndbcluster #run ndb engine
ndb-connectstring=x.x.x.x #location of MGM node

#Options for ndbd process
[MYSQL_CLUSTER]
ndb-connectstring=x.x.x.x #location of MGM node

If anyone can let me know what the problem is it would be greatly appreciated...
I'm running Fedora Core 4 and MySQL 5.0.19 MAX

Symbolic Links With Windows XP Or Option Datadir

How do you make symbolic links work ?