Cannot Load Mysql Extension
I posted this to the sourceforge phpMyAdmin ng, but there was a comment
that it was properly a php question, so I'm posting it here.
I'm on Windows XP, and have just installed Apache, php 5, and
phpMyadmin from zipped binaries. The only thing irregular thing I’m
conscious of doing is unpack phpMyadmin, files and directories,
directly into Apache2htdocs, because that was the only place I knew I
could reach with the <http://localhost> syntax. The phpMyadmin book I’m
using focuses on domains, and not local file-based installations, so
I’m floundering a bit here.
I believe I have php flying, because I can use Firefox to browse to
http://localhost/phpinfo.php and see the HTML-like display in the
browser. I created a little echo-the-date .php and put it in
Apache2htdocs, it renders the date in Firefox properly. The
_SERVER["SERVER_SOFTWARE"] entry reported by phpinfo is “Apache/2.0.52
(Win32) PHP/5.0.2.”
I have uncommented extension=php_mysql.dll in php.ini, and set
extension_dir to "c:php5ext". I copied libmysql.dll and php_mysql.dll
to ..system32. In fact, I have nine copies of libmysql.dll in six
different file sizes on my system. (Could that be the problem-battling
DLLs?)
Per page 18 of Jason Gilmore’s “Beginning PHP 5 and MySQL,” I added
“index.php” to httpd.conf’s DirectoryIndex entry.
However, when I attempt to browse to <http://localhost/index.php>,
which is the configuration test for phpMyadmin, I get the dread--
cannot load mysql extension, please check PHP Configuration Documentation
I imagine this is some little thing in my.ini, httpd.conf, or php.ini.
Any suggestions?
View Complete Forum Thread with Replies
Related Forum Messages:
Cannot Load MySQL Extension.
This is prolly the third windows box I've set up PHP/MySQL on, but for some reason this one is giving me greif. Anywho, PHP is successfully installed and running, apache works fine, and MySQL is running as a service. All sql/php modules are loaded up fine in apache's conf file, but when I try running phpmyadmin, I get this error: 'cannot load MySQL extension' phpmyadmin documentation says: "Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar. " Now, I haven't been able to find this software package. Anyone know what could be causing this? I've never had this problem before.
View Replies !
Cannot Load A Mysql Extension
this simple matter but ý need a urgent need. ý tried set phpMyAdmin on RedHat9 mysql3.23.54 php4.2.2 and apache 2.0.40 but when try to reach index page of PhpMyAdmin it gives me an error as "cannot load a mysql extension check php config" even if mysql.so is under lib/php4/. What thing must change php config file?
View Replies !
Myadmin Cannot Load Mysql Extension
i download php-5.2.3-win32-installer.msi, there's a missing ext directory. now i encounter so many error. phpmyadmin error: cannot load mysql extension; please check PHP configuration Documentation open php.ini comment off extension_dir = "C:PHPext" extension=php_msql.dll extension=php_mssql.dll extension=php_mysql.dll still not working
View Replies !
PhpMyAdmin - Cannot Load Mysql Extension
when I try to open phpMyAdmin administration page I got this error: 'Cannot load mysql extension, please check your PHP configuration' I cannot sort out what's the source of the problem, cause: 1. In the php.ini file I commented out the line 'extension=php_mysql.dll' and properly set the path to extension directory: extension_dir = "c:phpext" 2. MySQL is running 3. In the config.inc.php file I set $cfg['PmaAbsoluteUri'] to http://localhost/phpMyAdmin/ and $cfg['servers'][$i]['extension'] to mysql 4. I tried also copying php_mysql.dll and libmysql.dll modules to system folders: system i system32 but it didn't work. I'm using following versions of software (under Windows XP): PHP 5.0.5 phpMyAdmin 2.6.4-pl3 Apache 2.0.54 MySQL 5.0.15
View Replies !
PHPMyAdmin ? Error - Cannot Load Mysql Extension
Good Day: I installed my php5, mysql5, and Apaceh2.2. and my configurations was: PHP: (php.ini): ----------------- extension_dir = "C:php5ext" Uncomment this line: extension=php_mysql.dll Apache: (httpd.conf): ---------------------- AddType application/x-httpd-php .php AddType application/x-httpd-php-source .phps LoadModule php5_module "C:/php5/php5apache2_2.dll" **it works As i write a simple program with php, i tried to use PHPMyAdmin after downloading it & put the folder of htdocs. But it gives me that error. ---------------------------------- phpMyAdmin - Error Cannot load mysql extension. Please check your PHP configuration. - Documentation ----------------------------- what about configuring phpMyadmin?
View Replies !
Cannot Load Mysql Extension Error With WAMP
i just intalled WAMP and when i try to open phpmyadmin this shows. Cannot load mysql extension. Please check your PHP configuration. i seen a few trouble shoot and they all say to change the path in windows and all of that but every where i look is set up right WAMP sets everything to work in the directory that is set up i dont know why this shows.
View Replies !
Cannot Load Mysql Extension. Please Check Your Configuration. - Documentation
I am Polish/Canadian I was born in Poland and I live in Canada I get this message error Cannot load mysql extension. Please check your PHP configuration. - Documentation I did the PHPINiDiR Directive in httpd.conf and as well I tried already the enviromental tables right clicking the my computer. I have the extensions loaded as well in php.ini, and yes there is the fullpath in ext in php.ini I have php 5.20 snapshot The problem is with phpMyAdmin.
View Replies !
Myadmin Error "Cannot Load Mysql Extension"
I have been trying to get a php, mySQL install to work and talk together on Windows XP SP2 with IIS. So far I installed and received a responce from php(V5 - manual install) though the: <?php phpinfo(); ?> command which prints out the current settings of the php install.
View Replies !
HELP "Cannot Load Mysql Extension"
Fedora Core 2 server with httpd-2.0.54-10.2 php-4.3.10-2.4 php-mysql-4.3.10-2.4 It had MySQL 3.23.58.something on it, but the PHP websites were using a 4.something MySQL on another machine. I updated the MySQL on this machine to mysql-4.1.20-1.FC4.1 and now no PHP sites come up. But mysql.so is right where it's always been: [root@web1 abtech]# ls -l /usr/lib/php4/mysql.so -rwxr-xr-x 1 root root 44364 Dec 21 2004 /usr/lib/php4/mysql.so And the extension line has been commented out of /etc/php.ini and Apache restarted.
View Replies !
Cannot Load Php_mysql.dll Extension
I have installed PHP 5.2, MySQL 5.0, and Apache 2.2. Everything works fine except the error mentioned in the subject. Here is the error log for Apache which shows the problem... [Mon May 28 03:11:03 2007] [notice] Apache/2.2.4 (Win32) PHP/5.2.2 configured -- resuming normal operations [Mon May 28 03:11:03 2007] [notice] Server built: Jan 9 2007 23:17:20 [Mon May 28 03:11:03 2007] [notice] Parent: Created child process 2076 PHP Warning: PHP Startup: Unable to load dynamic library 'C:PHPext php_mysql.dll' - Invalid access to memory location. in Unknown on line 0 [Mon May 28 03:11:03 2007] [notice] Child 2076: Child process is running [Mon May 28 03:11:03 2007] [notice] Child 2076: Acquired the start mutex. [Mon May 28 03:11:03 2007] [notice] Child 2076: Starting 250 worker threads. [Mon May 28 03:11:03 2007] [notice] Child 2076: Starting thread to listen on port 80. [Mon May 28 03:11:12 2007] [notice] Parent: Received shutdown signal -- Shutting down the server. [Mon May 28 03:11:12 2007] [notice] Child 2076: Exit event signaled. Child process is ending. [Mon May 28 03:11:13 2007] [notice] Child 2076: Released the start mutex [Mon May 28 03:11:14 2007] [notice] Child 2076: Waiting for 250 worker threads to exit. [Mon May 28 03:11:14 2007] [notice] Child 2076: All worker threads have exited. [Mon May 28 03:11:14 2007] [notice] Child 2076: Child process is exiting [Mon May 28 03:11:14 2007] [notice] Parent: Child process exited successfully.
View Replies !
I Can't Get Extension=_mysql.dll To Load
I can get anything else to load tho. =( Pertinent Parts of Php.ini extension_dir = "C:PHPext" extension=php_mysql.dll ... (figured you didn't need the entire list) extension=php_xmlrpc.dll extension=php_xsl.dll I've deleted the the old copy of libmysql.dll and added C:PHP to PATH (It has the current libmysql.dll for PHP).
View Replies !
Cannot Load Imap Extension In Win98
I removed the ; before "extension=php_imap.dll" in php.ini, and when I start Apache 1.3 I get the following error message: Unknown():Unable to load dynamic library 'c:phpextensionsphp_imap.dll". Uno de los dispositivos vinculados al sistema no funciona (Translation: one of the devices attached to the system doesn't work). I already checked the extension_dir directive, and copied php_imap.dll to c:windows just in case. I am using Windows98 SE with php 4.3.3 as module in Apache 1.3
View Replies !
Unable To Load Module... 2 Extension Directories Possible? (WINDOWS)
I had the PHP Startup: Unable to load dynamic library: 'C:phpextphp_json.dll' - The specified module could not be found. I finally figured out the error. The problem is that the DLL relies on several other DLLs found in the C:WINDOWSsystem32 folder. Now, the problem is this... I do not want to copy 20+ extensions to my system32 folder, nor do I want to copy 50+ DLLs from my system32 to my extension directory. Does anyone know of a method to get around this? Something along the lines of having it check both the extension directory and the system32 folder for the associated DLLs?
View Replies !
MySQL Extension
I recently installed phpMyAdmin, as well as Apache, PHP, and MySQL; however whenever I try to load the phpMyAdmin page, it gives me the error: Cannot load mysql extension. Please check your PHP configuration. - Documentation I have the .dll's in my PHP directory, which is also in the system path. As well as my "WINDOWS/System32" directory.
View Replies !
Enable The Mysql Extension
I am trying to install phpadsnew on my computer. It has Win XP Professional, PHP 5, MySQL serve 4.0 and IIS. When I try to install phpadsnew it gives me the following error. "The version of PHP you are using doesn't have support for connecting to a MySQL database server. You need to enable the PHP MySQL extension before you can proceed." What do I need to do?
View Replies !
Adding The MySQL Extension (debian)
I *always* have trouble getting LAMP up on a new distribution I'm trying out -- this is the chief reason for a bad case of upgrade-o-phobia that i have. This week it's Debian (Ubuntu). I successfully apt-getted apache2, mysql, and php4, but the latter did not include the mysql extension. Have been looking around for a place to download this so I can just plug it in and I thought I'd ask here if anyone knew of such a place. Right now I'm seeing if apt-get install php4-mysql will do it... couldn't find package. ick.
View Replies !
Loading MySQL Extension Error
I am currently trying to work through a PHP & MySQL book. My knowledge is very limited, but I'll try and explain what problem I am having. I've made it through the Apache/PHP installation section without problems. However, now I'm trying to add the php_mysql.dll extension in the php.ini file. I remove the semi-colon before the extension in the php.ini file, and when I go to start Apache I get the following message: PHP Startup: Unable to load dynamic library './php_mysql.dll' - The specified module could not be found. My php.ini file is located in C:Windows. The book stated that if there were problems getting it to work, then you should move the libmysql.dll file to the C:Windows directory. I have tried this and am still having problems. The version of PHP is 5.
View Replies !
MySQL Load With PHP
Would a medium sized (~500 pages) database driven website, search engine and mailing list be too much for one MySQL database? Instead of making using different databases I would use different tables. I would use PHP for all of this.
View Replies !
Load XML To MySQL
I am trying to post xml data into a MySQL database and I'm stuck on what to do on the web site. The xml is built using a ado recordset on an Access database and then I'm using xmlHTTPPost(strPostToURL, strXML). However, I don't know how to write the php program to process the xml so that it loads the data into a MySQL database. Could anyone supply me with some sample code to do this? I've searched high and low but I've not been successful in coming up with anything.
View Replies !
Mysql> LOAD INTO
trying to load a csv into mysql via the shell and i keep getting errors. After logging into the DB server I do:use database to switch to the database, at this point I type: LOAD DATA INFILE '/path/to/data_file.csv' INTO TABLE `table_name` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '' LINES TERMINATED BY ' ' And I get an error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "table_name" at line 1
View Replies !
Load Data Into MySQL
I have a table in which its primary key is auto-incremented. Yet, when I try to load data using load data infile, this column will not auto-increment. I am leaving that column blank in my file to be uploaded, yet it fills this value in with a zero for all records. Should I be using a php script to load this file? Why isnt this updating correctly?
View Replies !
Is It Better To Load The Data Into XML From Say Mysql/php?
if i have a large amount of data is it better to load the data into XML from say mysql/php? then i can simple dump to a file to be read by flash easier than loadvars. I have been looking at flash/php/xml using xml send and load which i am finding hard to understand. They say for large amounts of data from mysql use XML from the data loaded into php sever file.
View Replies !
LOAD DATA MySQL
I have been struggling to get an idea of how to achieve the task in hand. What I am trying to do... I have a MySQL database, I am trying to create php page to pick a file (browse to file required) and either upload the file to the server or if possible use the location path of the file to be a variable in a...
View Replies !
Load MySQL Data
Is it possible to load MySQL data into JavaScript array? I want to do this as I want to use a javascript autocomplete function for a textbox. The problem is I need to load all the mySQL data into a JavaScript array. I have the code working using a listbox (load all my MySQL data into a listbox), however it just seems to slow. I'm assuming if they are in an Array, they will be a lot quicker.
View Replies !
Load Csv Into Mysql From Script
Was wondering if anyone has experience loading a csv into mysql via shell script? Just looking to do something pretty basic. - Empty the table - Load csv into said table Values are comma seperated and enclosed in ", rows end with a return
View Replies !
Cannot Get The Mysql Module To Load With 5.2.4
I am trying to get php, mysql and apache installed and working. I am having a big problem with php and mysql. I install it, turn on the mysql modules and everything seems allright except the mysql module doesn't seem to load at all. It doesn't show mysql on phpinfo(). I have tried reinstalling php and turning on all sql related modules (Except for mssql which I am sure I don't need), SqlLite shows on the list of installed modules but mysql still doesn't. PHP is working fine and so is apache. Anybody got any ideas. I have tried copying php.ini to the windows directory but that didn't change anything. I am going mad here with something that it is supposed to be simple.
View Replies !
CPU Load Problem On A Php/MySQL Linksite
I got a CPU load problem on my Php/MySQL based Link site. Site gets 6000-10.000 unique visitor and 120.000-180.000 page hits. Its not too many traffic I think. After my hosting (Shared) complained about CPU load 2 months ago I reduced MySQL queries and remove some sections on site. And indexed some table columns in my databas. But its not worked. Then I used a Cache system and included cached files on the site. Queries decreased 80%. But thats not decreased CPU load too. I have learnt "ob_start()" function uses CPU to compress file. I was using it for a long time and I removed it. Guess what,that's not worked too. I wonder that how can I be sure what's making this CPU load. Which part of site or which code, function? In the logs MySQL skip-locking has most of the (CPU) resources . I heard some debug tool, benchmark tests. Is there a way to know whats going on in the code? What tool (script) do you recommend? On my site outgoing links open in a new window and every link has a frame to count hits, commenting and voting. So every click makes a database connection to UPDATE hit value. I think this can make that CPU load problem. But I tried to write these hit values to text file and import it to database time to time with cronjobs. But nothing has changed. Same old heavy site. Now I'm going to try write whole database to the static pages. Like this forum every heavy traffic site uses this in there days. But I dont have that huge traffic I think. In this case I dont really understand this: If I write 100.000 pages from database in every 10 minutes isn't that a big cpu and HDD load too? What is the catch? I read in a forum search engine bots makes a really heavy traffic. I use mod_rewrite (Search Engine Friendly urls) on my site to spiders visit whole site. And I see that I got very frequent Google,Yahoo,MSN and other bot visits. But everyone wants that huh? Should I ban these bots with robots text or meta tags? I dont understand how can 10.000 visitors make that problem. I see that in Cpanel up to %700 cpu load with a red sign. Shared hostings say they allow "10%-20%" CPU usage maximum. But my server's Root admin says 99% of system resources are free on Linux command line! So which one is true? But cpanel resets the server after some time with this cpu load. So hosting providers dont want my site... Please help me to get rid off this problem. Especially I want to know what is my site's problem? I tried 3 hosting provider and same problem comes up. Do I need a dedicated host for this site? (!)
View Replies !
Load Multiple Pictures Into MySQL?
I'm trying to create a picture database for a site that I'm working on and I would like to do the following: - (main goal) Have a php script load an entire directory of photos into my mysql database in one swoop. - Display thumbnails on a general viewing page. - allow for viewing individual pictures by clicking on the thumbnails. <?php error_reporting(E_ALL); $id = $_REQUEST["iid"]; $link = mysql_connect("localhost", "root", "") or die("Could not connect: " . mysql_error()); mysql_select_db("mysql") or die(mysql_error()); $sql = "SELECT b1 FROM t1 where id in (1,2,3)"; $result = mysql_query("$sql") or die("Invalid query: " . mysql_error()); header("Content-type: image/jpeg"); while ($row = mysql_fetch_array($result)) { $fileContent = $row['b1']; $im = imagecreatefromstring($fileContent); $width = imagesx($im); $height = imagesy($im); $imgw = 50; $imgh = $height / $width * $imgw; $thumb = ImageCreate($imgw,$imgh); ImageCopyResized($thumb,$im,0,0,0,0,$imgw,$imgh,Im ageSX($im),ImageSY($im)); ImagejpeG($thumb); imagedestroy ($im); imagedestroy ($thumb); mysql_close ($link); } ?> It is only displaying one image.
View Replies !
Load Data From MySQL In Combo Box
I am trying to grab the data from a data table in MySQL and and add a column to the selectable values of a combo box. From there I will grab that value selected stored in a variable and run a query for more data.
View Replies !
MySQL LOAD DATA INFILE
I was told by an expert that there are serious security issues with using LOAD DATA INFILE. He runs a hosting company and has FILE privileges disabled.
View Replies !
Importing To Mysql Without LOAD DATA LOCAL
I've just gone through the learning curve of realizing most virtual hosts have "LOAD DATA LOCAL" disabled :( I have a two meg delimited ascii file I need to import on a regular basis (26 fields) Anyone have a nice import routine using fopen they are willing to share before I attempt to hack one out myself? I can't seem to find such an animal out there (though some are close). Such a shame, from what I have read, load data is much faster...
View Replies !
Using MySQL Command Load Data Infile
When I execute this SQL statement in my PHP code, I get an error "File '.Address.txt' not found (Errcode: 2)" $File = addslashes(".Address.txt"); $SQL = "Load Data InFile "" . $File . "" into table addresses"; $result = mysql_query($SQL) or die(mysql_error()); The file is located in the same directory as my .PHP file. How do I generate a relative address for this file so that it can be found? I'm running on XP Prof..
View Replies !
List Box - Automatically Load From A Mysql Table
i have a form with a drop down menu on it where the user can select a team from a list. how do i get this list to be automatically on page load from a mysql table called teams on the page load? I have tried several things before but i always seem to get the php code just appearing on the page rather than going off and processing the code. and i have used the <?php ?> tags.
View Replies !
Combining MySQL Queries For Less Server Load
I have table1 holding all my posts, then I have table2 holding all my comments and inside table2 I have a field where the matching post ID is inserted so it knows what comments goto what post. When the script goes to print out all the posts it has to run a query for each post to count how many comments there are for it. So for example if I have 500 posts stored I have to run about 501 queries on the main page (the first query to gather all the posts and then a query in each while() loop to count the comments). I don't really like this because on sites that get upwards of 70,000 uniques daily it is stressing the server (so I hear). Is there any way possible to lessen the amount of queries?
View Replies !
Load Csv File In To Mysql Table Using MyAdmin.
iam using this code ,to load my csv file in to mysql table using PHPmyAdmin. LOAD DATA LOCAL INFILE 'C:/Program Files/EasyPHP1-8/www/ tools/xball_6066f.csv' INTO TABLE temp_2g FIELDS TERMINATED BY '' ENCLOSED BY '"' LINES TERMINATED B by using this query my file is loaded , but when i import values from my csv file, , but iam getting NULL values, can anybody help me out on this, more over my CSV file is not null.
View Replies !
Mysql LOAD DATA Loads Server
im trying to load a large file into mysql, it has over 60 million records. So I split it into 60 files of 1m records and im using this to load the files.. LOAD DATA LOCAL INFILE 'file.name' INTO TABLE dbname; However its very slow taking upto an hour to insert 1m records and server loads go sky high. How could I optimize mysql, is there anything I can put in my.cnf?
View Replies !
MySQL Makes A Server Load And Crashes
As you see server load is too much and its getting more then mysql service stops and everything is normal. This happens for 2 days, hosting company made a Linux kernel update maybe that can be the reason. My VPS load was always too high and there is only 1 site got 10.000 unique visitors. I did so many optimizations on the mysql queries and also php. I cant afford a dedicated server at this time and I dont think it's not so much traffic.
View Replies !
Load Variables From Cookies That Are Connected To A MySql Database
I'm just getting my feet wet with PHP. I'm trying to load variables from cookies that are connected to a MySql database. I have a php login script already and am trying to create a flash interface for it. I can't seem to get the variables to load into flash from the cookie that is in the top of the html page. If anyone knows the process I would be totally in your debt.
View Replies !
Optimizing MySQL To Make Site Load Quicker
I recently coded a site that is based mainly off of mysql. I currently query the database 4 times in two for() loops I'm not sure how to change it, because I see no other way. I can't put the queries outside of the loops because in the loop it queries something different every time. I want some help optimizing it! However, I don't want to post all my code here, because it's basically the main part of my site, and I don't want others copying me.
View Replies !
Common Prob With Mysql LOAD DATA LOCAL INFILE ...
i have most recent php & mysql versions running on a linuxmachine i want to use LOAD DATA LOCAL INFILE and pass it from php to mysql. - the file i load is given with full path and the directory is readble - On MySQL local-infile = ON - From PHP i connect using client flag (128) to allow passing a file over that connection: mysq_connect( $host, $usr, $pwd, false, 128) Ive followed all advice from php & mysql sites and deja.com ... But i still get the message: The command is not allowed with this MySql Version or something ... any ideas where i should look further? what are *all* the requirements for a LOAD DATA LOCAL INFILE to work seamingly?
View Replies !
How Can I Load Load Additional Extensions ?
My OS is Winxp . My web server is apache 2 which is installed as a NT service . My php version is 4.32 , and I extracted it into "c:php" . I run php as a apache module . I want to load Additional extensions .They are php_mbstring.dll, php_xslt.dll and php_domxml.dll . I have made changes to php.ini as follow. extension_dir = "c:phpextensions" extension=php_mbstring.dll extension=php_xslt.dll extension=php_domxml.dll then I restarted apache2 . but it told me that the modules could not be located .
View Replies !
SSI With .php Extension
Is is possible to call an ssi script with a .php extension? Here is the line of code in the webpage: <!--#EXEC CGI="/cgin-bin/script.pl"--> Currently I have the page named index.shtml and it executes the above script fine, but when I rename it to index.php it doesn't work. Is there anyway this can be done in a php page? Anyone who can help, I would greatly appreciate!
View Replies !
|
TRACKER
