|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
mysql issue
Post 43658 by kduffin on Thursday 20th of November 2003 01:14:12 PM
11-20-2003
Mysql may be on the box, but is php compiled to use mysql?
If you look in your apache libexec directory (or whereever your php module is living (httpd.conf)) - do the following:
dump -C libphp4.so | grep -i mysql
If you don't see any mysql functions, your PHP wasn't compiled with mysql support (ie
In PHP src directory (php-4.0.3pl1/)
# ./configure --with-mysql \
--with-xml \
--enable-track-vars \
--with-apache=../apache_1.3.14 \
# make
# make install
Cheers,
Keith
If you look in your apache libexec directory (or whereever your php module is living (httpd.conf)) - do the following:
dump -C libphp4.so | grep -i mysql
If you don't see any mysql functions, your PHP wasn't compiled with mysql support (ie
In PHP src directory (php-4.0.3pl1/)
# ./configure --with-mysql \
--with-xml \
--enable-track-vars \
--with-apache=../apache_1.3.14 \
# make
# make install
Cheers,
Keith
|
|
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I am moving from a shared hosting environment to a dedicated box. The migration also involves a mySQL database managed using a web-based PHP interface.
I can read the contents of the db (connection is good) but when I try to administer, the form variables aren't going from step 1 (add) to step 2... (0 Replies)
Discussion started by: adrious
0 Replies
2. UNIX and Linux Applications
Hi,
I'm new to mysql, I've installed MYSQL on our unix server and started MYSQL on this server.
I've now downloaded MYSQL Query Browser, when I try to connect to MYSQL server, I get the following error "could not connect to the specified instance" - MySQL Error Number 1130.
From the... (3 Replies)
Discussion started by: venhart
3 Replies
3. Programming
I've tried every type of dereferencing I can think of but I still can't get to array data.
#!/usr/bin/perl
use DBI;
use DBD::mysql;
use DBI qw(:sql_types);
$hostname = "localhost";
$database = "c2";
$username = "user";
$password = "password";
$dbh =... (4 Replies)
Discussion started by: s_becker
4 Replies
4. Web Development
Hi all,
I recently changed the name of my hostname from 'abc123' to 'abc456' (as an example).
I then added a user in my mysql database with the new host and removed references to the old users and hostname.
The strange thing is though, a process using the database still uses the old... (1 Reply)
Discussion started by: muay_tb
1 Replies
5. Linux
Hi,
I have installed mysql in linux box as mysql-5.0.77-4.el5_6.6..
I would like to start the server. But there is no mysql file in this location /etc/init.d/
Please advice how to start the server now !!
Thnaks,
Mani (5 Replies)
Discussion started by: Mani_apr08
5 Replies
6. Programming
I have a data table as follows:
mysql> select * from validations where source = "a03";
+------------+-------+--------+
| date | price | source |
+------------+-------+--------+
| 2001-01-03 | 80 | a03 |
| 2001-01-04 | 82 | a03 |
| 2001-01-05 | 84 | a03 |
| 2001-01-06... (2 Replies)
Discussion started by: figaro
2 Replies
7. Shell Programming and Scripting
i'm trying to write a bash script that executes a mysql statement
mysql -sN -e INSERT INTO "$database"."$tableprefix"users (var1, var2,var3) VALUES (123, '1','')
i don't know where to put the quotes
it doesnt work with this one: `
it seems i can only put double quotes around the... (0 Replies)
Discussion started by: vanessafan99
0 Replies
8. Shell Programming and Scripting
I'm running mysql in a bash script
mysql <<EOF
query
EOF
one query is like this:
UPDATE $dbname.$prefix"config" SET value = $var WHERE "$prefix"config.name = 'table colname';
with variable
but it's giving an error
i'm not sure what to put for
"$prefix"config.name
the table... (3 Replies)
Discussion started by: vanessafan99
3 Replies
LEARN ABOUT DEBIAN
dbix::searchbuilder::handle::mysql
DBIx::SearchBuilder::Handle::mysql(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::mysql(3pm) NAME
DBIx::SearchBuilder::Handle::mysql - A mysql specific Handle object SYNOPSIS
DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of MySQL. METHODS
Insert Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted. If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported. SimpleUpdateFromSelect Customization of "SimpleUpdateFromSelect" in DBIx::SearchBuilder::Handle. Mysql doesn't support update with subqueries when those fetch data from the table that is updated. DatabaseVersion Returns the mysql version, trimming off any -foo identifier CaseSensitive Returns undef, since mysql's searches are not case sensitive by default SimpleDateTimeFunctions Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle. ConvertTimezoneFunction Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle. Use the following query to get list of timezones: SELECT Name FROM mysql.time_zone_name; Read docs about keeping timezone data up to date: http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html AUTHOR
Jesse Vincent, jesse@fsck.com SEE ALSO
DBIx::SearchBuilder, DBIx::SearchBuilder::Handle perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::mysql(3pm)