Have you considered using the console-tool, "mysqldump " ?
You could write a quick script ... say
mysqldump -u adminuser -p adminpass --all-databases > backup.sql
tar -zcvf backup.tar.gz backup.sql
mv backup.sql /somepath/backup.sql
if you're on Winders, a batch file:
mysqldump -u adminuser -
Hello all,
I am developing an Intranet page for my workplace, ATM i use phpmyadmin to
do rutine backups ect, this is cool but i am going on long service leave for
14 weeks and during that time a new guy will attempt to continue to maintain
the site and perform regular "backups"... I tried to show
I think reset() is only for arrays
Terry
--Original Message-
> It worked like a charm. (initially I was trying to use reset() guess it
> was
> the wrong call)
>
> One other thing, The 1st call was supposed to get the Column Headers
> and the
> second to get the results.
Hi,
I'm having a problem convincing my boss of the benefits of using a
database vs just using excel as a way of tracking events.
The boss' stance is that excel is more 'simple' columns can be
expanded as and when it's wanted. You can put links into excel that points
to files resid
It worked like a charm. (initially I was trying to use reset() guess it was
the wrong call)
One other thing, The 1st call was supposed to get the Column Headers and the
second to get the results. I thought they are independent of each other??
Guess not?
thanks very much.
Cheers,
Mun Heng, Ow
H/M
I'm trying to work out an application using the modular example of
Post-Nuke, etc.
But I'm having difficulty understanding how to pass any number of
variables back to the modules. For example, to send data collected in
a user registration form I might use:
user_register($name, $address, $p
hi,
I'm just wondering if it is possible to write to a word document or any
other file type that would allow for easy editing(besides txt) with out
having to copy and past everything in? I'm looking to have a template
perhaps in word and have the code insert variables from the database.
If it is
hi guys,
why don't you store all this array data in the session cookies, unset it
when you r not using it anymore? Because session can store object (include
array)
"Aaron Wolski" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi Guys,
>
> the topic pretty much covers it. I have a
Hi,
I'm writing because I'm having trouble with the pg_lo_read_all function in
PHP. Specifically, on my Mac OS X (latest stable PHP for Mac OS X) when I
try to download a file with pg_lo_read_all it downloads fine but a few
bits are different. I know this because the cmp(1) command tells me that
PHP 5.0 doesn't come with mysql support... You have to get the libraries
yourself... I think u can get them from mysql.com
Might have to pay? I haven't totally figure out the implications of the
no mysql in PHP 5.0 yet, but I know its not there.
Ben
-Original Message-
From: Kai [mailto:[
Hi Guys,
the topic pretty much covers it. I have a script and if it errors out..
I send a bunch of values back to the form. I'm having difficulity
figuring out how to pass array data that is/was selected back to the
form.
I can send the non array values no problem - eg:
header("Location: patt
yeah ofcourse, sometimes u can go blind stairing at the code and still not
see it :D
thanks
"Edward Peloke" <[EMAIL PROTECTED]> skrev i meddelandet
news:[EMAIL PROTECTED]
> you are missing the $ sign on your second mysql_query call
>
> -Original Message-
> From: Patrik Fomin [mailto:[EMAIL
I am having the hardest time getting PHP to install it's MySQL dll handlers,
even tho it's supposed to be embedded, it refuses to do anything with MySQL.
(Constant "PHP Fatal error: Call to undefined function: mysql_connect() in
C:\apache\Apache2\htdocs\example\index.php3 on line 8" killing the
you are missing the $ sign on your second mysql_query call
-Original Message-
From: Patrik Fomin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 4:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] silly problem
$sql = "UPDATE dagensfraga SET nej = '$nej' WHERE id = '$iid' AND
aktue
Typo in your second query call. Should be:
mysql_query($sql);
Rich
> -Original Message-
> From: Patrik Fomin [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 22, 2003 4:41 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] silly problem
>
>
>
> $sql = "UPDATE dagensfraga SET nej = '$nej'
Because you forgot a $ before $sql in the second?
Regards,
Matthew Moldvan
System Administrator
Trilogy International, Inc.
-Original Message-
From: Patrik Fomin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 4:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] silly problem
$s
you can't use COL_NAME = NULL or COL_NAME = 'NULL' and get the desired
results , you have to check for IS NULL/ IS NOT NULLSo, change the
query to
SELECT * FROM TABLE WHERE MY_FIELD IS NULL or,
SELECT * FROM TABLE WHERE MY_FIELD IS NOT NULL
>From my understanding when you check for COL_NAM
$sql = "UPDATE dagensfraga SET nej = '$nej' WHERE id = '$iid' AND
aktuellfraga = '1'";
mysql_query($sql);
$sql = "INSERT INTO dagensfragaip (aid, ip) VALUES('$iid',
'$REMOTE_ADDR')";
mysql_query(sql);
when i run this only the first line is recorded into the databse?,
when i run the second l
Assuming you run MySQL, why don't you just remove the " ' "?
SELECT * FROM MyTable WHERE MyField=NULL
Sincerely
berber
Visit http://www.weberdev.com/ Today!!!
To see where PHP might take you tomorrow.
Share your code : http://addexample.weberdev.com
-Original Message-
From: Ron All
Is your database a shared database? Permissions might have been set
incorrectly so that you saw them; then someone realized that the
permissions were wrong, changed them, and thus you couldn't see them
anymore.
If the database is a shared system, then you might have just seen a
misconfigured acce
DB.php of http://pear.php.net
You can get a very good description of the methods available in the pear
documentation. It should be installed with recent versions of PHP. If
not you can install it with the go-pear script at
http://pear.php.net/go-pear.
HTH
On Tue, 22 Jul 2003, Mohammad Saad wro
Hi Guys,
No need to think about this.
I solved the problem by putting both scripts under one check
If ($patternThreads || $patternFabrics)
{
//DO STUFF HERE
}
Aaron
-Original Message-
From: Aaron Wolski [mailto:[EMAIL PROTECTED]
Sent: July 22, 2003 10:34 AM
To: [EMAI
Well, you're initializing $food to ""; then testing to see if it has a
value, which it never will.
If you're getting the $food variable from a POST or a GET op, you'll need to
grab it from the appropriate array,
$food = $_POST['food'];
echo $food;
to see what is being passed.
Gary Every
Sr.
Hi,
I just installed apache 1.3.12, php 4.2.3 and oracle 8.1.7 on Linux RedHat
7.3
Apache and PHP work fine, oracle works fine.
I copied oci.h from $ORACLE_HOME/rdbms/demo/ to ./php/ext/oci8/
I have configure php to supporte oci8 functions :
configure --with_oracle=$ORACLE_HOME --with_oci8=$OR
Hi All,
I have a form that passes to select box array to my script. Select boxes
are named:
patternThreads[] and patternFabrics[]
My Script:
//Check to see if Threads were selected for this pattern
if ($patternThreads)
{
if (is_array($patternThreads))
{
I know... live and learn... and learn I have...
Good advise there...
We're gonna be moving hosts in a few weeks anyway, to relieve the burden
on little me in these kinda areas...
Passwords are being changed, and patches are being checked for updates
etc...
I have full backups of the site, and mo
Hi
I need help!, I am quite new to php and I am trying to create a condition
that will load a specific page after a form has been submitted to enter
data in my database, I have tried using this code (I created it) but it
wont work, all I get is a messege on the browser that says "the page
addre
On Tuesday 22 July 2003 18:14, [EMAIL PROTECTED] wrote:
> Now I am not an Apache guru, and my PHP/MySQL experience is all based
> around the coding side, not the instilation, security etc...
>
> So when I arrived at work yesterday, and discovered that several databases
> had been deleted, and a ran
Because you have already fetched one row before outputting the record
count. Therefore the row pointer is at the second record before you 'print
out'.
Try putting
mysql_data_seek($result,0);
in place of your second
$result = mysql_query($sql);
This should return the pointer to the first re
On Tuesday 22 July 2003 18:20, Ow Mun Heng wrote:
> Hi,
>
> I have a code that goes like this. Scroll down to the "<--"
> sign. How come I need another $result = mysql_query($sql) at that location?
> If I don't have it, the results coming out will only start printing from
> the 2nd Ro
How would the entire query look
select * from ticket where Type = 'Phone' and ???
"Dirk Kredler" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Am Dienstag, 22. Juli 2003 11:29 schrieb Ron Allen:
> > This is what I have
> > select * from ticket where Type = 'Line' and Closeddate
I use Pear DB
http://pear.php.net/manual/en/package.database.php
its probably already installed in the pear/includes directory as it
comes with the php distribution
pete
Mohammad Saad wrote:
Hello all,
I would like to know what is the best wrapper class for Mysql database interface. I
need a ki
Hi,
I have a code that goes like this. Scroll down to the "<--"
sign. How come I need another $result = mysql_query($sql) at that location?
If I don't have it, the results coming out will only start printing from the
2nd Row.. Omitting the 1st.
Results as wanted
row 1
Now I am not an Apache guru, and my PHP/MySQL experience is all based
around the coding side, not the instilation, security etc...
So when I arrived at work yesterday, and discovered that several databases
had been deleted, and a random database called 'sanij' has been created,
My gut was to su
I am hoping someone maybe has come across this problem before as it is
driving me up the wall!
My web server is RH 7.3 / Apache 1.3.27 / PHP 4.1.3 / unixODBC 2.2.0 /
ODBC dirve 0.5.1 (ex of Easysoft)
When the web site accesses the database it connects correctly fetchs the
data and then closes - o
I am hoping someone maybe has come across this problem before as it is
driving me up the wall!
My web server is RH 7.3 / Apache 1.3.27 / PHP 4.1.3 / unixODBC 2.2.0 /
ODBC dirve 0.5.1 (ex of Easysoft)
When the web site accesses the database it connects correctly fetchs the
data and then closes - o
I am hoping someone maybe has come across this problem before as it is
driving me up the wall!
My web server is RH 7.3 / Apache 1.3.27 / PHP 4.1.3 / unixODBC 2.2.0 /
ODBC dirve 0.5.1 (ex of Easysoft)
When the web site accesses the database it connects correctly fetchs the
data and then closes - o
select * from ticket where Type = 'Line' and (Closeddate IS NULL OR
Closeddate ='')
or
select * from ticket where Type = 'Line' and Closeddate IS NULL
HTH
Peter
-Original Message-
From: Ron Allen [mailto:[EMAIL PROTECTED]
Sent: 22 July 2003 10:29
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
Am Dienstag, 22. Juli 2003 11:29 schrieb Ron Allen:
> This is what I have
> select * from ticket where Type = 'Line' and Closeddate = ' empty space'
> and have tried the following
> select * from ticket where Type = 'Line' and Closeddate = 'Null'
> select * from ticket where Type = 'Line' and Close
I have done this in the past, but for some reason it isn't working now
(maybe a moron). I am trying to select all of the empty or NULL fields in a
column.
This is what I have
select * from ticket where Type = 'Line' and Closeddate = ' empty space'
and have tried the following
select * from ticket
40 matches
Mail list logo