-2001.php?article=tricks-sept-2001kind=trid=2033open=1anc=0view=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]
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]
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.mysql.com/doc/refman/5.0/en/replace.html
--
Greg Donald
Zend Certified
-features.html
snipMySQL only supports one master and many slaves./snip
--
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]
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 Certification
http://destiney.com/
--
MySQL General Mailing
.
--
Greg Donald
Zend Certified Engineer
MySQL Core Certification
http://destiney.com/
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/
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 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-generalm=110547634827453w=2
--
Greg Donald
Zend
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 Donald
Zend
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://lists.mysql.com
://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]
the
documentation and can't figure out where I have gone wrong here.
In the db table, there is one entry for one user (not root). There are no
entries in the host table.
I would appreciate any help you can give me!
Did you flush priveledges after making changes?
--
Greg Donald
http
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 Mailing List
For list archives: http://lists.mysql.com/mysql
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/
--
MySQL General
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]
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]
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://lists.mysql.com/mysql
To unsubscribe:http
things like:
?php
echo strtotime(43145 seconds);
?
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 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/mysql
To unsubscribe
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]
.
--
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:http
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]
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.
what was the value of fieldValue prior to the update?
fieldValue is vertical before the update.
--
Greg Donald
http://destiney.com
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://destiney.com
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,
--
Greg Donald
[EMAIL
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
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 --prefix=/usr
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 option, but
30 matches
Mail list logo