How to tell MySQL where to store db files ??

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 ---

What are basic db files MySQL creates?

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 the

RE: What are basic db files MySQL creates?

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

How to delete MySQL db ?

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:/

How is DBTools Software?

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...

Compiling a list of MySQL tools - Please contribute.

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 Ple

How to get MySQL to list current db's ?

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,

--- How to query results of a query?

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 r

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

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

Will PhpMyAdmin run on Linux-Apache-MySQL box ?

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

--- Best ISP for MySQL & PHP ???

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

$$ Wanted: MySQL & PHP expert assistance

. 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://