[PHP-DB] Re: Database backup
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 ?
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.
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
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