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]
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]
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
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
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]
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/
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/
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 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
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
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
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]
re is a Y under all for root). I have searched 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!
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]
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]
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/
--
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
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
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 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
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]
> 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:
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]
ec)
> > Rows matched: 1 Changed: 0 Warnings: 0
> >
> > MySQL doesn't produce an error.. but I think maybe 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
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]
> 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
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
> 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 --prefi
> 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
30 matches
Mail list logo
