[PHP-DB] Re: Database backup

2003-08-27 Thread Roberto Dragva Filho
Try mysqldump

mysqldump -u username -p'password' -A  backup_file_name.dump

you can copy backup_file_name.dump to CD.

roberto


Chris Payne [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
Hi there everyone,

Is there a quick way I can backup all my databases on Linux so I can
download them to my HD/Burn them onto CD?

I've started a very large travel project and there is going to be over 100
DB's in the end, each with who knows how many tables and going through
PHPMyADMIN and exporting 1 DB at a time is going to take forever.

My Server is the Rehat Linux 8.0 with Apache and MySQL and PHP.

Thanks, any help would be really appreciated (And save me alot of
headaches).

Chris


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Re: Failure to interact with MySQL in Redhat 9 ?

2003-08-22 Thread Roberto Dragva Filho
Hello david,

do you set register_globals  to ON  in /usr/local/lib/php.ini ?
try it.

Roberto

David Haines [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
 Hello all. I hope this is the best place to ask this (!)

 Problem: verified that PHP, MySQL and Apache are all working fine.
 My first little project, and search.html and results.php is not working in
 Redhat 9.
 If I fail to enter a search term, I get the expected error message, but
that
 is just Apache, it's not even executing any PHP. When I enter a search
term,
 the results.php page loads with the proper page title, but the rest of the
 page is blank.

 **However**, the exact same project files work just as expected on my Mac
 running OS X though... hmm: which is running Apache 1.3, PHP 4.1.2 and
MySQL
 4.1.2

 So I have to wonder, what am I missing in Redhat ?

 What I've done, what I'm doing:

 I am learning MySQL and PHP, working through a lovely O'Reilly text.

 I have MySQL and PHP and Apache all working fine on an istall of Redhat
 Linux 9. I can work with MySQL in the terminal (command-line), and have
even
 installed MySQL Control Center (a fairly nice GUI).

 My hello.php loads fine and returns Hellow world in my web-browser
when
 I load http://localhost/hello.php

 The default Apache page loads, as do a simple index.html file when I put
one
 in place.

 Apache 2 is running, PHP is version 4.2.2, MySQL is 4.0
 
 I checked permissions and ownership of the search.html and results.php
 files. My results.php file is setup the same (ownership  executable
 flags) as my hello.php file (which does work).

 My Apache error log offers nothing helpful. I cannot find any MySQL error
 log in Redhat (checked and triple-checked), and
 I can't seem to find any php error log. The php.ini file really doesn't
 help, in terms of knowing where to look for an error log

 ===
 I know this is long, but I've been as thorough as I know how to be -
please
 help ! (TIA)




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Re: Transferring MySQL data.

2003-08-21 Thread Roberto Dragva Filho
You can use phpmyadmin.
see http://www.phpmyadmin.net/
roberto

Hugh Dickinson [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
This is probably a stupid question, but I'm pretty new at this!

Having built test MySQL databases for my website on my home machine, is it
possible to transfer the data straight to a web hosting company's server or
do I need to rebuild the databases again from scratch?

Thanks for any input,

Hugh Dickinson


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Seach for data calling function in field

2003-07-31 Thread Roberto Dragva Filho
Hello,

how can i search for a data in Mysql database calling a PHP function  in
field propeties ??
example:

?php echoinput type='text' name='ID' size='20' onBlur=SEARCH_ID(); ;?

is this valid ??

thanks
roberto



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php