Im running FBSD ver 2.2.8 and need to know what version
of mysql installs ans runs best on this platform.
At this time upgrading in not an option.
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Im running FBSD ver 2.2.8 and need to know what version
of mysql installs ans runs best on this platform.
At this time upgrading in not an option.
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (th
7;t know how
accurate that would be. Does anyone have any ideas?
http://www.cryptnet.net/fsp/zipdy/
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rick/tricks-sept-2001.php?article=tricks-sept-2001&kind=tr&id=2033&open=1&anc=0&view=1
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
systems? We are sure the structure of
> the tables are all the same and we need to compare the
> data. Any advice is welcome. Thanks.
mysqldump -l -B db1 > db1.sql
mysqldump -l -B db2 > db2.sql
diff db1.sql db2.sql > diff.sql
--
Greg Donald
Zend Certified Engineer
MySQL Core Certification
http://destiney.com/
ne.
>
> Any help is appreciated.
Add an auto_increment option to your Id field.
--
Greg Donald
Zend Certified Engineer
MySQL Core Certification
http://destiney.com/
http://dev.mysql.com/doc/refman/5.1/en/replication-features.html
MySQL only supports one master and many slaves.
--
Greg Donald
Zend Certified Engineer
MySQL Core Certification
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ariables' returns, plus what databases exist on each server, are there
> any tools that can do that? Can phpMyAdmin manage multiple mysql
> servers?
Additional MySQL servers can be defined in phpMyAdmin's config.inc.php file.
--
Greg Donald
Zend Certified Engineer
MySQL Core Certific
ment (since my ISP limits
> the total number of calls I can make in a day) that will either
> insert a new record if the referring domain is not already in there,
> or simply update the timestamp if the referring domain is already in
> there.
>
> Possible?
REPLACE INTO
http://dev.my
hi, i'm trying to choose a db, and looking at mysql.
here's the problem.
we're looking at storing large blob type objects - up
to 30,000 char's per field, and possibly a table of
1000 records by 300 fields/record.
can i put that all in one table? I have mac osx, so
i'm not worried about the files
On 4/15/05, Scott Haneda <[EMAIL PROTECTED]> wrote:
> How are sites doing the search by zip and coming up with results within x
> miles? Is there some OSS zip code download that has been created for this?
http://marc.theaimsgroup.com/?l=php-general&m=110547634827453&w=2
might check your network cards. Had
this happen to me once. Reseated the card in the database server,
fixed it right up.
--
Greg Donald
Zend Certified Engineer
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Sun, 2004-01-04 at 08:09, Mike Mapsnac wrote:
> I have table with 7 fields. First field is id (auto increment). As I
> understand the value should start from 0 and next value will auto
> increment.
>
> And I shouldn't add insert the value. So the insert
> statemens below gives me an error. E
; I just tried.. Same problem with
> "Duplicate Entry"
>
>
> >From: Donald Henson <[EMAIL PROTECTED]>
> >To: MySQL List <[EMAIL PROTECTED]>
> >Subject: Re: insert: auto increment field
> >Date: Sun, 04 Jan 2004 08:44:56 -0700
> >
> &
2147483647' for key 1.
>
> Why id (primaty , and auto_increment) start from 2147483647 and not from 0
> or 1
>
> Thanks
>
>
> >From: Donald Henson <[EMAIL PROTECTED]>
> >To: MySQL List <[EMAIL PROTECTED]>
> >Subject: Re: insert: auto incr
On Mon, 2004-01-05 at 07:31, Carlos J Souza wrote:
> Hello for all,
>
> Please i need comments about future of MySQL with .NET Plataform
> introduction.
>
> Regards for all
>
> Carlos Souza
I don't know if you're going to get an answer to that query. .NET is not
a very popular subject around h
On Mon, 2004-01-05 at 12:46, Ian O'Rourke wrote:
> I'm very new to MySql and I'm having problems inserting dates into my tables
> (via the Web using Coldfusion). The user can put the following in the field:
>
> 12/09/2003
> But the data returned from the database is:
>
> 2012-09-20 03:00:00.0
>
On Thu, 2004-01-08 at 21:23, EP wrote:
> OK, I need to ask a stupid question.
>
> I normally run MySQL on Apache. I have a second machine [a laptop] which I
> can't get Apache to run on [the ports are restricted/closed]. Is there a
> way to run MySQL without a server like Apache underneath it?
On Wed, 2004-01-07 at 07:09, Chris W wrote:
> I was wondering if anyone could recommend a good web hosting company for
> an Apache - php - MySQL project. I don't need much bandwidth or disk
> space to start out, but may need more if the site gets big. I would
> also like to have ssh access to
On Fri, 2004-01-16 at 17:05, Bryan Koschmann - GKT wrote:
> Hello,
>
> I run an ISP where our web customers have access to the MySQL server. When
> they want a database, they request it through me and I add it. I was just
> curious if this is the common way it is done, or if there is a safe way
>
it's the 'and' in my where
clause that isn't working. I have looked high and low for an example of such a
query but cannot find anything. Any help would be greatly appreciated. Thanks.
--
Greg Donald
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
anything. Any help would be
> > greatly appreciated. Thanks.
>
> what was the value of fieldValue prior to the update?
fieldValue is "vertical" before the update.
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it will reset the auto_incement.
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Is there any way to seed a column set to autoincrement? Say I wanted it to
> begin at 1.
alter table table_name auto_increment = 1;
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
lists. Both have excellent searchable online manuals.
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> I need to know if is there anyway to clone a existing database (structure and
> data)?
I use mysqlhotcopy myself.
http://www.mysql.com/doc/en/mysqlhotcopy.html
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
I have a question that I hope I can explain well enough:
I am trying to figure out a data structure for an inventory system. The
system contains:
Items
Kits(Made from a collection of Items and/or other Kits)
Now my question is:
Is there any way to structure this in a databas
PHPMyAdmin uses the "LOAD DATA LOCAL INFILE" command. Just remove the word
LOCAL and it should work fine.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 2:35 PM
To: [EMAIL PROTECTED]
Subject: mysql LOAD DATA INFILE
When I come across this er
Oh and just a note. This solution won't work if you are uploading the file
to the server through the browser. You will need to put the file on the
server and adjust the commands PATH accordingly.
-Original Message-
From: Donald Tyler [mailto:[EMAIL PROTECTED]
Sent: Friday, Augu
Yes it can. But you should understand the three distinct levels of that
situation.
You need the following:
Database
Web Server
Server-Side Scripting Language
I would suggest using AMP (Apache, MySQL & PHP). If you want to know more
about how these work in conjunction I would suggest the excelle
.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 2:59 PM
To: Donald Tyler; [EMAIL PROTECTED]
Subject: RE: mysql LOAD DATA INFILE
Sorry, that is the error - my mistake. I am getting this:
LOAD DATA LOCAL INFILE '/tmp/php9GOwvw'
iday, August 08, 2003 3:24 PM
To: Donald Tyler; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: mysql LOAD DATA INFILE
Ah. No wonder it dinna work. Neither did specifying the columns as Jay
suggested.
I also have no choice but to do it through the browser - I don't have
command line
On Mon, 4 Oct 2004 21:55:58 +0530, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Is there any suitable command in MySQL 4.0 with out InnoDB for taking the
> backup. Please suggest.
Have you looked at mysqlhotcopy ?
http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html
--
Greg
copy being a Perl script and all. Feel free to try it
and discover the definative answer for yourself.
--
Greg Donald
Zend Certified Engineer
http://gdconsultants.com/
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
s?
> Thanks so much.
This is fixed in the latest version:
http://sourceforge.net/projects/destiney/
If not, let me know and I'll look into it. I'm still maintaining the
0.3 series.
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://li
see
> Mysql. Now I have done this installation 4 or 5 times but th elast time
> was over a year ago.
>
> Any ideas?
Perhaps this will help:
http://www.wampserver.com/en/faq.php#q5
--
Greg Donald
http://gdconsultants.com/
http://destiney.com/
--
MySQL General Mailin
On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas <[EMAIL PROTECTED]> wrote:
> Did you build both php and apache with MySQL support?
I wasn't aware you could build Apache with MySQL support. How is that done?
--
Greg Donald
http://gdconsultants.com/
http://destiney.com/
--
ssions for each database. Unless it's a dev server
behind a firewall or something like that I tend to be pretty
restrictive.
--
Greg Donald
http://gdconsultants.com/
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a server?
I don't believe there is any way to elevate permissions for a given
MySQL login once logged in, no.
--
Greg Donald
http://gdconsultants.com/
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Did you flush priveledges after making changes?
--
Greg Donald
http://gdconsultants.com/
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
might find this of use:
http://pear.php.net/package/LiveUser
--
Greg Donald
http://gdconsultants.com/
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
time(), it can do things like:
1062265296
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am using mysql_connect. But I just changed it to mysql_pconnect and it did
exactly the same thing.
-Original Message-
From: Marek Kilimajer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 10:48 AM
To: Donald Tyler
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Lost Connection to
hell for a week now!
Thanks
Donald
Hi,
I am just learning to use Linux and I am having some problems with
getting MySQL to load.
I have successfully installed & tested both Apache & PHP, so I am pretty
comfortable with the whole configure and make processes.
I followed the MySQL installation docs to the letter, however w
> How would you export your data from the mysql tables to a tab or coma
> delimiter.
There are lots of ways, here are my favorite two:
mysqldump: http://www.mysql.com/doc/en/mysqldump.html
phpMyAdmin : http://phpmyadmin.sourceforge.net/
--
Greg Donald
http://destin
Hi all,
Please excuse any ignorance I may show with this question - as I am not a
programmer and I am trying to do something that is out of my experience. I
feel truly out of my element in this and am hoping that the list expertise
will help me. I have looked at the manual - but still am confus
> I have a database of 5.6 million records and I need to choose 5000 random
> records. What would that query look like?
select * from records order by rand() limit 5000;
destiney - (des-ti-ny) - n. 1. deity of all things "
does someone have a windows based program to manage, create and edit
a database abd table off line
"MikeBlezien" wrote:
> Hi All,
>
> I need to upgrade a server running MySQL v.3.23.38 to .39
> Specs:
> RedHat/Linux 6.2 i386 512RAM
>
> The only databases currently are the default 'test' and the
does anyone have a program to create and manage a database with out
being connected to a server
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arc
ensen" wrote:
> Donald:
>
> It would be a tall order to create and manage a database without a server
> ... but the 'server' I refer to is software, running on a machine you have
> access to.
>
> Check out http://www.mysql.com/ or search the list archives at
> h
MySQL as the
support guy makes it out . But the latter is hard to believe.
Any suggestions on how to make my DB invisible on other Logins ?
Any help will be deeply appreciated .
Regards
Donald
Some guys here lurk around only to get their problems solved and chuck off the
minute any kindred list memeber solves it . For them it just feels so smart thinking
that the list is the best place to get their work done without paying a dime .
So all u guys intending to only take and not gi
y
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost:3306/project?user=Donald&password=Donald";
// If no password assigned to DB
// String url="jdbc:mysql://localhost:3306/project";
con=DriverManag
The "%" in the first command to User table spoils it all. It means logging from ffrom
any host is valid .
Remove that command. It'll work
Cheers
Donald
- Original Message -
From: David Hulka
To: [EMAIL PROTECTED]
Sent: Monday, February 26, 2001 1:28 AM
S
LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]
[(col_name,...)]
The LOAD DATA
> Two things that I am sure will be answered very quickly.
>
> 1) I have a development box that I have successfully installed and
> configured 3 seperate instances. Each instances has its own port
> number.
> When playing around with mysqladmin I know I can specify the port
> number as
> an opti
bases from different machines back onto
one database machine, where the databases from the different machines can be
joined without the use of "daisy chaining" to bring it all back together.
Is there some way to over come the single master replication limitation now?
Thanks,
--
Gre
ldn't depend on it.
They've done a good job but it's not as good as it needs to be. PHP seems
to offer a far easier way of working with a whole community behind the
development of the language so we're moving over to PHP ourselves.
My two pence...
Dan Donald
Reach Multimedia
ay?
To add to the example; We might have a table for 'albums' or 'gigs' and we
refer to the setlists to see which songs were used either for the running
order of the album or for the songs played at a particular gig.
This is the only problem I have with the queries so far so
> I have downloaded the source file mysql-3.23.39.tar.gz
> But when I do
> gunzipmysql-3.23.39.tar.gz
> tar -xvf mysql-3.23.39.tar
>
> I get this eror message "tar: Error exit delayed from previous errors"
> after the tar is done
>
> Then I
> cd mysql-3.23.39
> ./configure --prefi
ploading the database needs to done thro' Telnet . I'm least aware of this
application .
Could anyone pls throw light on any applications which allows to upload the database
in GUI format ? Or the method using Telnet ? Preferably the former .
Any help would be greatly appreciated .
Thank You
Regards
Donald
Start the deamon First
shell>mysqld-XXX
To find out what X means go to the bin directory below and find out . d
stands for daemon
then key
shell>mysql
Cheers
Donald
- Original Message -
From: "soon chee keong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
Hello everyone,
I am trying to create a mysql table to hold either the entire contents
of text or WordPerfect files. I've read about BLOB or TEXT type columns
so I've tried creating a table such as:
CREATE TABLE filetest(fileid int(5) not null, file BLOB null);
I 've created the table and have
64 matches
Mail list logo
