--- Best ISP for MySQL PHP ???

2003-01-17 Thread Will Standley
Gang,

I'm looking for an ISP to host a couple of MySQL db's...

Will be using PHP as the scripting language...

Want to use PhpMyAdmin to administer the db.

Are there certain ISP's who specialize in hosting such sites?

Thanks for any info.

Will


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Will PhpMyAdmin run on Linux-Apache-MySQL box ?

2003-01-16 Thread Will Standley

I installed PhpMyAdmin on a Windows box using EasyPhp...

Will PhpMyAdmin run on a Linux/Apache/MySQL server? (I've got one on my desk
up 
running)

If so which version should I download?

(.php files)
- Download phpMyAdmin-2.3.3pl1-php.tar.bz2
- Download phpMyAdmin-2.3.3pl1-php.tar.gz
- Download phpMyAdmin-2.3.3pl1-php.zip
(.php3 files)
- Download phpMyAdmin-2.3.3pl1-php3.tar.bz2
- Download phpMyAdmin-2.3.3pl1-php3.tar.gz
- Download phpMyAdmin-2.3.3pl1-php3.zip

(Yes, I'm a Linux newbie.)

Finally, is it a fairly easy install for a Linux newbie?

thanks for any help.

Will





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




--- How to query results of a query?

2003-01-15 Thread Will Standley
How do you query the table that is the results of a query?

Must you ask MySQL to...
...create a temporary table form the results of the first query
...then query that temporary table
...then delete the temp table when you are done?

(and if so how do you ask MySQL to create a temp table from the results of a
query?)

Is there a better and faster way to do this with minimum burden on the web
server with the db on it?

Thanks for any help.

Will


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Will PhpMyAdmin do more than just create a MySQL db ???

2003-01-15 Thread Will Standley
Will PhpMyAdmin do more than simply create a MySQL db ?

Please cc me directly on any post at [EMAIL PROTECTED]

Thanks for any help.

Will


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




How to get MySQL to list current db's ?

2002-12-09 Thread Will Standley
I have two sample MySQL db's running on a local Linux box w/Apache...

Once I enter mysql from the Linux command line...

Is there a way to ask MySQL to list the db's that are currently created?

Thanks,

Will


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




How is DBTools Software?

2002-12-07 Thread Will Standley
Has anyone used DBTools Software? (http://www.dbtools.com.br/EN/)

It is a free utility for managing MySQL  other db's.

I also discovered Intelligent Converters at www.convert-in.com

Both look good.

The first is free and does more than convert Access to MySQL.

The second converts more stuff... like Excel to MySQL.

All comments encouraged.

Thanks,

Will


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Compiling a list of MySQL tools - Please contribute.

2002-12-07 Thread Will Standley
I'm just getting into MySQL and have discovered two tools so far...

- DBToolsFreeware   www.dbtools.com.br/EN/  Manage 
MySQL  Convert Access
 more
- Intelligent Converters Shareware  www.convert-in.com  Converts from 
Access,
Excel  more

Please contribute to the list.

Thanks,

Will






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: What are basic db files MySQL creates?

2002-12-06 Thread Will Standley
Roger,

Are the files that you mentioned stored in the directory for the db ?

thanks for the help,

Will

-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 06, 2002 6:31 AM
To: [EMAIL PROTECTED]
Cc: Will Standley
Subject: Re: What are basic db files MySQL creates?


* Will Standley
 Question:

 When I create a new db using MySQL...

 What files does MySQL create?

None. It creates a new directory only.

When you create a table, and the used table handler is MyIsam, three new
files are created: *.frm, *.MYI (index) and *.MYD (data). If the table
handler is InnoDb, only the *.frm file is created, the indexes and data are
stored in innodb tablespace.

--
Roger
sql


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




How to delete MySQL db ?

2002-12-06 Thread Will Standley
I have a couple of test MySQL data bases on my Linux/Apache box and want
to delete them for a clean start...

How do I delete all the files associated with the two db's ?

Thanks,

Will


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




How to tell MySQL where to store db files ??

2002-12-05 Thread Will Standley
1 - When I create a new db using MySQL...

Can I tell MySQL where (what path  directory) to store the new db files?

And...

2 - To back up the db... can I just copy the files in that directory to a
backup device like a CD or floppy?

Thanks,

Will


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




What are basic db files MySQL creates?

2002-12-05 Thread Will Standley
Question:

When I create a new db using MySQL...

What files does MySQL create?

I'm asking because a MySQL sample db was created on the machine I am using
and they don't seem to be where I think they should be... and I want to
search for them...

(I looked in root/var/lib/mysql/ and didn't see them... or at lease I did
not recognize them.)

Thanks,

Will


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




$$ Wanted: MySQL PHP expert assistance

2002-11-19 Thread Will Standley
W am looking for some expert assistance using MySQL  PHP on a Linux/Apache
based internet site development project.

The project shouldn't take a knowledgeable  experienced professional long
so you should be able to work it in your schedule without stopping
everything forever.

Interested parties should reply directly to my email.

Ideal candidate will be located in SE USA, but will consider all.

Email [EMAIL PROTECTED]

thanks.

Will Standley
NetPV, Inc.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php