Is there a way to have a permalink to pages in phpMyAdmin,
particularly record editing pages?
I successfully did it -- for a while -- by simply copying the URL when
I was on a record editing page and replacing the obvious key GET
parameter with a variable. But that URL has a GET parameter c
On Mon, Feb 9, 2009 at 6:10 PM, Lucio Chiappetti wrote:
> I used to make Unix soft links of mysql tables back on mysql 3.23.
>
> [...]
>
> But I wonder if there is anything intrinsically wrong in the usage of
> soft-links, or whether this might be an indication instead of h
I used to make Unix soft links of mysql tables back on mysql 3.23.
Say that I do an arbitrary sequence of CREATE TABLE, LOAD LOCAL DATA
INFILE, INSERT, UPDATE etc. on a table "x".
At some stage (after the CREATE) I do (outside of mysql)
foreach i (MYD MYI frm)
ln -s x.$i x
hi all,
I read
http://dev.mysql.com/doc/refman/5.0/en/symbolic-links-to-databases.html
but on MySQL 4.0.24_Debian-10ubuntu2 server , in my my.conf file:
datadir = /var/lib/mysql
"ls" show as：
lrwxrwxrwx 1 mysql mysql 67 2006-03-12 22:42 mnogosearch3235 ->
/home/user
What does it take to get something like http://dabodev.com listed on the
MySql site? (This not a request to have it listed, just wondering on
behalf of the dabo team.)
http://solutions.mysql.com/program/faq.html#b2
B3. What is the entry level membership fee in the Partner Program?
The entry lev
Hello,
We would like to exchange links between your site http://wwweth.cern.ch and
our new exciting casino web site.
Our site do NOT offer online gambling, it have information about different
aspects of gambling and so it's very good and informative from our point of
view.
We require
Varakorn Ungvichian wrote:
--- Michael Stassen <[EMAIL PROTECTED]>
wrote:
Varakorn Ungvichian wrote:
Just realised something: my table was MyIsam. I
switched it to InnoDB (which support FKs), but
now:
1. "Show Create Table" still doesn't show
reference
links, and
Well, of
--- Michael Stassen <[EMAIL PROTECTED]>
wrote:
>
> Varakorn Ungvichian wrote:
> > Just realised something: my table was MyIsam. I
> > switched it to InnoDB (which support FKs), but
> now:
> > 1. "Show Create Table" still doesn't show
> ref
Varakorn Ungvichian wrote:
Just realised something: my table was MyIsam. I
switched it to InnoDB (which support FKs), but now:
1. "Show Create Table" still doesn't show reference
links, and
Well, of course not. It won't show them until you create them, which you
haven't
> Just realised something: my table was MyIsam. I
> switched it to InnoDB (which support FKs), but now:
> 1. "Show Create Table" still doesn't show reference
> links, and
> 2. I can't seem to make foreign keys, because it
> generates the error: "ER
Just realised something: my table was MyIsam. I
switched it to InnoDB (which support FKs), but now:
1. "Show Create Table" still doesn't show reference
links, and
2. I can't seem to make foreign keys, because it
generates the error: "ERROR 1005: Can't create table
&
'0',
PRIMARY KEY (`employee_id`),
UNIQUE KEY `employee_id` (`employee_id`)
) TYPE=MyISAM
No mention of foreign keys (or even any reference
links) at all. What I'd like is a command that returns
what foreign keys (or reference links) exist in a
given table (or database even). In my exam
Hello,
> You can use:
>
> show create table employee;
>
> or
>
> show table status like 'employee';
> in the column "comment" you have the information you are looking for.
I don't think "comment" works properly - it's too small if you have
multiple foreign key constraints.
With regards,
Martijn
bre 2004 09:32
À : [EMAIL PROTECTED]
Objet : How to retrieve constraints and links from MySQL tables?
So, I'm running a MySQL database (version: 4.0.21) for
a personal project of mine, and I would like to learn
how to retrieve constraints and links from the table
after it's been created
> So, I'm running a MySQL database (version: 4.0.21) for
> a personal project of mine, and I would like to learn
> how to retrieve constraints and links from the table
> after it's been created. The create statements read
> thusly:
> When I run "show col
So, I'm running a MySQL database (version: 4.0.21) for
a personal project of mine, and I would like to learn
how to retrieve constraints and links from the table
after it's been created. The create statements read
thusly:
CREATE TABLE positions (
position_id tinyint(4) DEFAULT &#
;[EMAIL PROTECTED]> wrote:
> 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 fie
Just put the href into the database.
When you output it to html in PHP wrap it wth the rest.
$href=$sql->data['href'];
echo "The Link\n";
leegold wrote:
I have to put html links inside varchar and text fields. They have to be
(somehow) fulltext searchable (of course a subs
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?
Is this more of a
Have you looked at InnoDB tables?
-Original Message-
From: Michael Mason
To: 'MySQL Mailing List'
Sent: 7/16/04 2:06 AM
Subject: Creating Relational Links
Hi everyone.
It occurred to me that I may need a table in my database related to the
primary table to hold such thing
Hi everyone.
It occurred to me that I may need a table in my database
related to the primary table to hold such things as login time and date etc.
Creating the table is straight forward enough but how do I create
the relational link or do I simply ensure that the foreign key is assi
In the last episode (May 22), Bruce Ferrell said:
> I'm using 3.23.49a-max-log and as a temporary fix for a disk space
> problem, I shut mysql down,, moved some database files to different
> partitions on the system and symlinked them back into the datadir.
>
> Everything seems to work ok... So fa
Hi all,
I'm using 3.23.49a-max-log and as a temporary fix for a disk space
problem, I shut mysql down,, moved some database files to different
partitions on the system and symlinked them back into the datadir.
Everything seems to work ok... So far... Mysql came up with no errors,
selects and in
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, December 12, 2003 4:54 AM
Subject: RE: using (hard?) links for tables
What if you were to make a 3rd database, containing shared elements, such as
your user table (I presume we're not talking the MySQ
bases...
> -Original Message-
> From: Moritz von Schweinitz [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 11, 2003 9:26 AM
> To: [EMAIL PROTECTED]
> Subject: using (hard?) links for tables
>
>
> hi there!
>
> i have two databases on the same serve
It's not recommended since it might cause file locking issues internally.
how 'maybe' would that be? (that table almost never get written to, but
when it is written to, the other one should be updated AFAP. both tables
would almost never be written to at the same time)
Why not just set up a repl
hi there!
i have two databases on the same server, and one of the tables ('users')
should be the same in both databases. since this is very specific to
this one server, and other servers running similar databases don't need
that functionality, i'm looking for the easiest way to do this, so i wa
At 18:06 3/6/2003 -0700, Charles L. Nelson wrote:
Hi,
I recently posted an email about 'Inoperable Symbolic Links in Win2K Pro '
and I subsequently subscribed to the belief that MySQL would fail when
installed in a location that was different that the default location. I
tried a myriad
6月 4日 水曜日 10:06、Charles L. Nelson さんは書きました:
> Hi,
>
> I recently posted an email about 'Inoperable Symbolic Links in Win2K Pro '
> and I subsequently subscribed to the belief that MySQL would fail when
> installed in a location that was different that the default location.
Hi,
I recently posted an email about 'Inoperable Symbolic Links in Win2K Pro '
and I subsequently subscribed to the belief that MySQL would fail when
installed in a location that was different that the default location. I
tried a myriad of things to get the database system to function
It worked.
Thanks!
-Steve
> At 10:52 -0500 6/3/03, Steve Marquez wrote:
>> I have a links page that has categories.
>>
>> I am attempting to place category links on one side, and the actual links on
>> the other.
>>
>> However when I do this, I get
At 10:52 -0500 6/3/03, Steve Marquez wrote:
I have a links page that has categories.
I am attempting to place category links on one side, and the actual links on
the other.
However when I do this, I get the following result:
category1
category1
category1
category2
Here is the code I am using
I have a links page that has categories.
I am attempting to place category links on one side, and the actual links on
the other.
However when I do this, I get the following result:
category1
category1
category1
category2
Here is the code I am using:
\n";
while ($table
On Tuesday 11 March 2003 14:26, jarausch at igpm dot rwth-aachen dot de wrote:
> it seems as if all links on
> http://www.mysql.com/Downloads/mysqlgui/
> are broken.
Link for downloading MySQLGUI is
http://www.mysql.com/downloads/gui-mysqlgui.html
--
For technical support
Hello,
it seems as if all links on
http://www.mysql.com/Downloads/mysqlgui/
are broken.
Many thanks for a hint,
regards,
Helmut Jarausch
Lehrstuhl fuer Numerische Mathematik
RWTH - Aachen University
D 52056 Aachen, Germany
On Sat, Nov 23, 2002 at 04:37:01AM +0200, Octavian Rasnita wrote:
> I can do all the job with Perl, but if the link contains a "?" sign, it is
> replaced by the string "NULL" in the MySQL database and the link stored will
> be something like:
Just look up $dbh->quote(...) in the documentation.
$
I have the same problem with inserting the links in MySQL using Perl.
I can do all the job with Perl, but if the link contains a "?" sign, it is
replaced by the string "NULL" in the MySQL database and the link stored will
be something like:
http://www.server.com/cgi-bin/scr
On Fri, Nov 22, 2002 at 07:40:26AM -0800, tmb wrote:
> Does PHP have to do all the work here...
>
> 1 - fetch the url from the db
> 2 - fetch the link name from the db
> 3 - construct the html code to display it
Yes; what else had you imagined?
If you do it right, it will probably look something
At 7:40 -0800 11/22/02, tmb wrote:
I want to store some web links in a MySQL db...
than later using PHP retreive them and put them on a
web page...
Does PHP have to do all the work here...
1 - fetch the url from the db
2 - fetch the link name from the db
3 - construct the html code to display
On Fri, 2002-11-22 at 10:40, tmb wrote:
> I want to store some web links in a MySQL db...
>
> than later using PHP retreive them and put them on a
> web page...
>
> Does PHP have to do all the work here...
>
Personally I would use Perl to do this.. :-P :-)
Yeah... yo
I want to store some web links in a MySQL db...
than later using PHP retreive them and put them on a
web page...
Does PHP have to do all the work here...
1 - fetch the url from the db
2 - fetch the link name from the db
3 - construct the html code to display it
or is there a better way
William,
Tuesday, September 24, 2002, 4:48:51 AM, you wrote:
WM> Can anyone tell me if I can make dynamic links between tables. Example.
WM> std_price in main_table = std_price in table2.
WM> So that if I change the price in the main table, It will be reflected
WM> throughout
Hello All,
Can anyone tell me if I can make dynamic links between tables. Example.
std_price in main_table = std_price in table2.
So that if I change the price in the main table, It will be reflected
throughout the database.
Thank you in advance for your help.
William
(Filter: MySQL, SQL
- Original Message -
From: <[EMAIL PROTECTED]>
To: "William Martell" <[EMAIL PROTECTED]>
Sent: Thursday, September 19, 2002 2:33 PM
Subject: Re: Dynamic Links
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our
At 09:38 30/7/2002 -0400, Ray Elenteny wrote:
Hi,
>I just moved from 4.0.1 to 4.0.2 on Windows 2000 and my databases that
>had been accessed through "Windows symbolic links" could no longer be
>accessed. I had to add the use-symbolic-links directive back to my
>my.ini fi
I just moved from 4.0.1 to 4.0.2 on Windows 2000 and my databases that
had been accessed through "Windows symbolic links" could no longer be
accessed. I had to add the use-symbolic-links directive back to my
my.ini file to get them to work?
The docs still state that in MySQL 4.0 th
amolsonaikar,
Friday, July 12, 2002, 9:46:45 AM, you wrote:
a> I am an oracle dba and will be shifting to mysql. I have the documentation(html)
downloaded with me and mysql on my PC (on linux) however I need to find out where
exactly I ll get the info related
a> to mysql database administration
Hi all
I am an oracle dba and will be shifting to mysql. I have the documentation(html)
downloaded with me and mysql on my PC (on linux) however I need to find out where
exactly I ll get the info related to mysql database administration? Is it as difficult
as oracle? The html downloaded is qui
From: "Will K." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, April 14, 2002 23:21
Subject: Scanning Directory/Inserting Image Links to DB
> Can someone recommend a Perl script/technique that will scan a Unix
> directory of ima
Greets Folks,
Can someone recommend a Perl script/technique that will scan a Unix
directory of image/text files, and then insert the links into a MySQL
database? I used to have a good one, but it got misplaced... Doh!
Thanks,
Will
01 1:06 AM
Subject: Re: Symbolic Links to Data
> Martyn Wendon wrote:
>
> > Hi Edward,
> >
> > No problems in general with the installation. Everything has been
working
> > fine, I need to move the database files as I am running out of space on
the
> > /var
Hi,
There is an faq on using symbolic links to move databases at
http://www.mysql.com/doc/S/y/Symbolic_links.html which covers the details.
The gotcha that I fell into was that the mysql user (usually "mysql") needs
to have rights to the directories that you move the data to. So if
Jan,
Thanks for the pointer, indeed it was a rights issue, and all sorted now.
Regards,
Martyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Martyn Wendon" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, November 25, 2001 7:53 PM
Subject
Martyn,
On Sun, 25 Nov 2001, Martyn Wendon wrote:
> No problems in general with the installation. Everything has been working
> fine, I need to move the database files as I am running out of space on the
> /var partition.
This is surely an access rights problem. If you'd su to the user running
lt;[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, November 25, 2001 4:53 PM
Subject: Re: Symbolic Links to Data
> Martyn Wendon wrote:
>
> > Hello,
> >
> > I'm having some trouble in re-locating my MySQL databases to a different
> > directory.
Martyn Wendon wrote:
> Hello,
>
> I'm having some trouble in re-locating my MySQL databases to a different
> directory. My scenario is:
>
> Platform: Red Hat Linux 6.2
> MySQL: 3.23.43
>
> MySQL data currently stored in /var/lib/mysql
> The database name is "music" (so files are therefore in
> /
Hello,
I'm having some trouble in re-locating my MySQL databases to a different
directory. My scenario is:
Platform: Red Hat Linux 6.2
MySQL: 3.23.43
MySQL data currently stored in /var/lib/mysql
The database name is "music" (so files are therefore in
/var/lib/mysql/music)
I wish to move the
-Original Message-
From: mysql-digest-help [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 3:44 PM
To: mysql
Cc: johnlucas
Subject: MS Access Links to Mysql
Hello again folks
I am using MS Access as the front end to my database, but after a while
of
use, I get a prompt as follows
Hello again folks
I am using MS Access as the front end to my database, but after a while of
use, I get a prompt as follows, when I try to close a table in datasheet
view or when I try to close a form:
"The action will reset the current code in break mode {blah blah blah}"
Then I have to choose
Date |Tue, 31 Jul 2001 16:40:06 -0400
>From |"ROSS MCCORMICK" <[EMAIL PROTECTED]>
Hello!
RM> What about having symbolic links in the same directory as the original file? I
have a situation where a broken Windoze application has different queries embedded,
with some usin
Hi,
I have the following entries in a table:-
http://www2.mysite.com/location1/sublocation2
http://www2.mysite.com
http://www2.mysite.com/location1
All I want to do is try for a global change from www2 to www, is it
possible and how would I go about it?
Thanks for the help..
---
What about having symbolic links in the same directory as the original file? I have a
situation where a broken Windoze application has different queries embedded, with some
using tablename(lower case), and some using TABLENAME(upper case). The database
actually resides on a Linux server, so
Hey Everybody,
I have an online database where I use a CGI script that uses the DBI to return values
from Mysql.
How do I return a LINK?
For example, if I have a database for hockey players, and I return the name "Wayne
Gretzky." Is
there a way to make that a link that will go to say, NHL.com
> The problem has been resolved. There is apparently an
> undocumented option
> (at least it's not documented in the HTML manual for 3.23.38)
> required in
> the my.cnf file - "use-symbolic-links". I was using all
> default values, so
> I wasn&#x
I am testing mysql for merge tables and symbolic links
on NT4. But it seems not working.
First I tried doing exactly what is there in the
manual, then searched mailing list and added
use-symbolic-link in my.cnf file in C:\ directory.
Mysql recognise that there is a database but can't
The problem has been resolved. There is apparently an undocumented option
(at least it's not documented in the HTML manual for 3.23.38) required in
the my.cnf file - "use-symbolic-links". I was using all default values, so
I wasn't even using a my.cnf or a my.ini file.
The problem has been resolved. There is apparently an undocumented option
(at least it's not documented in the HTML manual for 3.23.38) required in
the my.cnf file - "use-symbolic-links". I was using all default values, so
I wasn't even using a my.cnf or a my.ini file.
After following a promising lead, I'm at a dead end again.
1. Downloaded and installed binary distribution for MySQL 3.23.38 as
recommended (originally tested with 3.23.37).
2. Installed mysqld-max-nt.exe service under Windows NT 4.0 SP 4.
3. perl script successfully executed:
$dbh = DB
You can also download Junction from
http://www.sysinternals.com/ntw2k/source/misc.shtml#junction which does the
same thing.
sql
> Hello Tom,
>
> If you're using Windows 2000 it has junction points. It's almost the
> same as symbolic links in UNIX. Except it works only for
Hello Tom,
If you're using Windows 2000 it has junction points. It's almost the
same as symbolic links in UNIX. Except it works only for directories.
Try to find access to Windows 2000 Resource Kit, there should be a
utility called linkd.exe. If you running NT 4.0, you can try to app
I am trying to move my database (the directory) to another location, but
the symbolic link option described in the documentation isn't working for
me. I'm using the binary distribution of version 3.23.37.
I created a text file in the c:\mysql\data directory, called mydb.sym, with
the string c:
ced where the same value of the 'realpath' call for the 'index' portion of th!
e f!
> ile, is being re-used to locate the data portion (instead of another call to get the
>'realpath' of the data portion).
>
> >How-To-Repeat:
> Creat
he
f!
ile, is being re-used to locate the data portion (instead of another call to get the
'realpath' of the data portion).
>How-To-Repeat:
Create a table, and place the index portion (.MYI) in one directory, and the
'form' (.frm) and data portion (.MYD) i
From: "Christian Hammers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 11:51 AM
Subject: BUG: alter table destroys symbolic links!
> Hello
>
> If table xyz is a symbolic link (recommended in the manual for very big
files
> that do not
Hello
If table xyz is a symbolic link (recommended in the manual for very big files
that do not fit on a single partition) then "ALTER TABLE xyz TYPE=ISAM;"
ignores this, removes the link and recreate the table on the data directory.
I consider it a bug, as it is
a) not what the user expects,
Some people use the method you are describing without using a
database. This is especially useful when working with tables. As most
know, using tables is great, however, you end up duplicating a lot of code
for the menus. This makes updating the menu someone difficult. Rather
than go through
On my website, http://www.cdn.f2s.com
The links under the 'Network' menu (Home, Affiliates, Contact, & Get Hosted)
are trying to call from MySQL to receive a link specified in the column
which it is calling from.
I have no idea what I am doing though. I have seen other websites wi
In section 12.2.2.1 of the manual it states that MySQL will
allow one to move a table and symbolically link it. Then MySQL
uses realpath() to find the absolute path.
I have done this and all is fine until someone does a DELETE FROM
or a ALTER TABLE . When these are done the symbolic links are
They didn't work 'onsite'/live, or when downloaded. They *used* to work
for both.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reque
The end of this quote is a link. When I loaded the whole manual in my
browser NS4.7x, I expected the link to move through the manual copy in
my browser's cache. Instead, it tried to link to a copy on the MySQL
site and gave a 404 error message from the MySQL site.
>From manual (Section 5.1):
>Us
gopinath ([EMAIL PROTECTED]) writes:
> Please let us know about the correct link for download MySQL for WIn NT. =
> We want to know about the exact links for ODBC and the program also.
Try http://www.mysql.com/downloads/mysql-3.23.html
--
Ed Carp, N7EKG [EMAIL PROTECTED]
Hi,
Please let us know about the correct link for download MySQL for WIn NT. We want to
know about the exact links for ODBC and the program also.
Regards
Gopinath
I found a problem with MyODBC when linking tables to Access97. It considers
DECIMAL type as TEXT (and you know you can't change that without going into
code). I changed the column type into FLOAT and it fixed the problem, but
at the same time it would be nice if MyODBC either gave you a choice
83 matches
Mail list logo
