MySQL Slow: Configuration To Blame/fix?
I have MySQL 5 running on a PC, and have grown used to the startling slowness of MySQL joins. The most recent disappointment is a straightforward self-join of a not-too-big (700K rows), indexed (on very-high-cardinality column FILE) table
create table temp2 as
select a.*, b.time as time2,
from temp1 a left join temp1 b
on a.file = b.file
and timestampdiff(HOUR,a.time,b.time) = 1;
that completed in 10 hours. (Indexing resulting table took 20 minutes). If this is not a problem with the programmer, or with MySQL, could it be a result of a mismanaged installation, one that could be fixed with a judicious re-configuration/choice of MySQL options?
View Complete Forum Thread with Replies
Related Forum Messages:
Configuration Of MySQL
Everytime I start a new session of MySQL, it prompts me for my password and then boots me out. After I go through the "MySQL Server Instance Config Wizard" and reconfigure everything and reset my password, MySQL lets me back in. Is there anyway to fix it so I don't have to reconfigure everything?
View Replies !
MySQL Server Configuration
The server is running Windows 2003 Server Enterprise Edition and IIS 6.0 I have installed MySQL successfuly but run into problems when configuring it. I get all the way to the Start Server page and click execute. When I do this I get a tick in the Prepare COnfig and Write Config File boxes but then when it tries to start the server it comes up with the error: 'Could not start the service MySQL'
View Replies !
Mysql Configuration File
I just installed a Mysql server version 4.1. I'm trying to set up replication between two servers. The instructions ask me to modify the my.cnf or my.ini file, but there's no such file in my computer.
View Replies !
MySQL Configuration Error
I am trying to get MySQL set up on my Windows server. The server is running Windows 2003 Server Enterprise Edition and IIS 6.0 I have installed MySQL successfuly but run into problems when configuring it. I get all the way to the Start Server page and click execute. When I do this I get a tick in the Prepare COnfig and Write Config File boxes but then when it tries to start the server it comes up with the error: 'Could not start the service MySQL' .
View Replies !
Problem With MySQL Configuration On IIS With PHP
Everytime I try to read from any MySql database in PHP, I get a blank screen or just a blank response. I dunno what the problem is. is it the configuration? When i use phpinfo(), MySql has its own section, which is shown. doesn't this mean it has been configured already? I have done the configuration of the php.ini file and have removed the quotes before the mysql extensions. I have also included my c:php directory to the path section of my environment variables in control panel and copied libmysql.dll to my windows directory. I just can't seem to get around this problem. I don't think its my code because i have literally copied code listings from this site and pasted them as trials but still the same thing. I would appreciate something like a checklist for configuring mysql to work with iis and php to confirm my configuration.
View Replies !
JNDI Datasource Configuration Fo MySQL 4.1
I am now in charge of of Java web application that is hitting a MySql database version 3.1. We are in the process of setting up a new box with MySql 4.1. The developer who wrote the application is using technology from the Apache foundation to connect to the database via jsp's (ie. no struts). The technology is referred to as Database Connection Pool Configuration.
View Replies !
Configuration MySQL Community Server
I've downloaded MySQL community server, the one without the installer, and I've unzipped it into c:. I need to configure it to work locally, only in this computer. No internet connection. Can someone give a clue.I know nothing about server configuration, neither databases. It's to run a weblog server application in this computer.
View Replies !
PHP5 MySql 4.1 IIS 5.O Configuration Error.
Finally, I decided to go fully into PHP. I downloaded PHP 5 on the PHP site. I also downloaded MySQL 4.1. I'm running IIS on a WinXP professional (SP2) machine. I installed both according to instructions. Tested PHP, it worked fine. Tested MySQL through command prompt and it also worked fine. Now my problem came when trying to get PHP to use MySQL, I got this error Warning: PHP Startup: Unable to load dynamic library 'c:/php/ext/php_mysql.dll' - The specified procedure could not be found. in Unknown on line 0 I googled and discovered this situation was common all over the internet. It looks like it's peculiar to PHP5. I tried all solutions I saw but none worked. I copied all the relevant dlls to C/winnt and C/winnt/system32 as well as uncommenting the path variable in PHP.ini Still,
View Replies !
MySQL 4.0.18 InnoDB Configuration Issues On SuSE 9.1 Pro
I've tried resolving this issue in a SuSE newsgroup, but after trying their suggestions and working on this issue for far too long already, I decided to try this list as it may be a more appropriate discussion area. I've installed and configured MySQL 4.0.18 on a SuSE 9.1 system using the default RPM's that came with the distribution. I created a simple database (one table with InnoDB engine type) and have tried running some ODBC source against it to test transactions, but I get the error that the server does not have transactions enabled. I was directed to enable transactions in the configuration file (/etc/my.cnf) by uncommenting the lines for innoDb use. However, after uncommenting these lines and running mysqld from the commandline (according the online Manual), to generate InnoDB support tables, I get the following error: mysqld: ERROR: unknown variable 'innodb_data_home_dir=/var/lib/mysql/' I've tried removing the RPM's and starting from scratch, but cannot get past this error and successfully test transactions in my unit tests.
View Replies !
MySQL Server Instance Configuration Installation
Hi everyone. I just tried installing MySQL Community Edition, but it has frozen up during the final step (MySQL Server Instance Configuration). I'm installing it on Windows XP, and I used all the default settings, except that I changed "Detailed Configuration" to "Standard Configuration". The installation window now says "Not Responding" and I don't know what to do. I guess if I shut it down manually, MySQL won't be configured properly. I don't know if this will corrupt the installation, or if the installation part has already finished.
View Replies !
MySQL Server Instance Configuration Wizard
I just downloaded and installed MySQL 5.0 on a P4, Windows XP Pro system and followed the Server Instance Configuration Wizard. Once I have selected the default settings, and clicked Execute, I get an error message Cannot create Windows service for MySQL. Error: 0
View Replies !
Configuration Of MySQL - ORDER BY Clause Problems
Edit: Solved! Single quotes around the column name were the problem... red herring... didn't spawn an error, probably because single quotes would be valid for an alias? Anyway, for reference there must be a MySQL setting that tells MySQL to ignore the single quotes in an ORDER BY clause and call the column if there's no matching alias. If anyone knows what *that* setting is, I'm still interested... I'm stumped! A simple PHP application with a filter using ORDER BY has been moved from a remote server on to a local Debian (Etch) machine running XAMPP. On the remote server it worked fine. On the local server the ORDER BY is ignored. It looks like this: SELECT * FROM contacts WHERE Forenames REGEXP '^{name}' ORDER BY '{column_name}' Where {name} is user entered data and {column_name} is determined by which column header in the returned data was clicked in the interface. For example: SELECT * FROM contacts WHERE Forenames REGEXP '^Jake' ORDER BY 'Company' As I say, this *was* fine... but now on the local machine the ORDER BY is totally ignored by MySQL. I know the problem is with MySQL because I get the same result in the MySQL Query Analyser, so it's not a PHP/Apache issue. Is there a config option for switching ORDER BY on/off like there is in MS Access? I'm 99% sure this is a MySQL config problem...
View Replies !
MySQL Entry Level Server Hardware Configuration
We have a web site statistics database running on a dedicated PC (P4 1GB RAM, 1xSATA, Windows Xp 32 bit). It's updated daily and used by a single user to get some reports. While it's mostly SELECTs, some temporary tables can be built. As the database get bigger and bigger (few gigabytes), it works slower and slower. Currently the HDD is the bottleneck, but the PC is not upgradeable, so I'll have to build a new server. Reliability is NOT #1 in my list, while the speed is - it'd be easier (and chipper) for me to copy the data across rather than to build a 4+ dsik monsters. What would be the suggestions for hardware and OS? Or may be a URL to detailed review?
View Replies !
Slow MySQL
mySQL has been running very slowly and I am getting errors. First I did 2 things I raised the ServerLimit number (apache) to allow for more connections, I also raised the max conncetions in my.cnf. I do not know if this took effect? That should have worked. But basically in phpmyadmin i get this error frequently. I am getting more traffic so I think it is that. MySQL said: Documentation #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
View Replies !
Why Does MySQL So Slow
I just changed to use MySQL few days ago but it was a bad idea. My server now is running very slowly with the database. I'm using Perl5 and DBD::Mysql in my script. The system is Linux9, Apache2. I looked at these mysql pid and saw a lot of activities (about 400) while there are more 100 users online at this moment and lots of running under a the same pid number.
View Replies !
MySQL Slow
I had downloaded a few years back mySQL v3.51 installed but never used it. Now I wanted to convert some B-TREE databases to mySQL and did some testing via ODBC to insert 70,000 records: My results: MS ACCESS: ~60,000 msecs MYSQL v3.51 ~18,000 msecs Impressed with the speed, I went ahead and got the latest MySQL v5.1. Uninstalled the older version, I had nothing there to preserve, so I did a simple new install with MySQL v5.1. I noticed the size of the files and BINEXE increasted by 1,000,000%. Ok, Bulky. Not a problem. I reran the same ODBC test, and now I got: MYSQL v5.1: ~450,000 msecs or 7.5 freaking MINUTES! What the hell happen? Nothing was done. I'm knew to MYSQL. I just installed it with all the defaults. I did choose "developer's machine" for the "optimizer wizard" I can't redistribute MYSQL v3.51 and force it down people's throats! I have to use what they are using already, if already installed. Not even my current system takes 1 minute to add 70,000 records. Why 7.5 minutes? All it is simple inserts/free statements.
View Replies !
MySQL Slow Log
I have the long query time set to 15 yet MySQL is still showing results with a query time of 0 in the slow query log. It says enter time in "seconds" in the MySQL Administrator but did it mean in milliseconds??
View Replies !
MySQL Slow In Windows NT4
I am running the Apache web server, MySQL v4, and PHP on an NT4 server. Apache runs great, but the auction software I am using (Web2035 Auction software written in PHP) is very, very slow. Sometimes it takes 20-30 seconds to bring up an auction page from the items table which has less than 200 records in it. Can anyone can give me some pointers on where to start looking? (I don't know if the bottleneck is with MySQL or PHP or what I might need to look at to enhance the performance of either package.)
View Replies !
Slow Mysql Select *,
I have a sql table with more then 20,000 rows in a table called summary and when I run "select * from summary" it returns a exucutions time of 0.5 seconds in php which is kinda slow if you ask me, now I know that the * type for select isnt the fastest way to fetch data but its the most convenient for me.
View Replies !
MySQL Slow Starting Up
I am using a Windows 2003 Web Edition Server running IIS and MySQL 4.1. I had to restart the server the other day and it took MySQL almost 2 hours to come back up. I was watching it on my task manager and it went up to approximately 60,000k in 10k increments before I was able to access MySQL. My CPU usage was hovering around 3% all this time. Everything else came up on the server just fine. This happens every time I have to restart my server. The reason I have to restart my server most of the time, is because MySQL locks up on me. Is there any settings I can change that would help me here? Any help would be greatly appreciated. One more thing to add. I am using the default my.ini file. We have almost 100 different databases on the server and have around 20000 tables within all of these databases combined. All of these tables are InnoDB tables.
View Replies !
MySQL Running Very Slow
I have the following INSERT SQL, which runs very slow (For 2 full days it had not done anything) on a 2 processor Compaq machine running Suse Linux. Code:
View Replies !
MySQL Is Slow, Trying To Optimize
It just seems that my system is slow, adding records, etc. I tried to optimize it, saw that there was a my-medium.ini file, read that is was for medium sized system. I replaced it with my.ini (yes I did make a backup, thankfully) and restarted mysql. Pretty much it hangs. I tried to connect with QueryBrower, did a Select Count(*) and just froze. I admit that I didn't wait for ever, yes I know I Select Count(*) takes a long time but I gave up after waiting 3x as long as I normal did. Also the logs screen froze in administrator.
View Replies !
Slow Running MySQL?
I'm hoping someone may have an idea what could be causing the slow loading pages of my web-site. I'm not positive, but I'm relatively sure that it's related to a problem with MySQL database. I purchased a program called Sam3 for broadcasting our radio signal over the internet. The software requires the use of MySql in order to set up web pages for our web site. The problem is, that while everything works GREAT (requests can be made from the site, songs can be searched, the history of what we've played shows up) the pages load PAINFULLY slow. Other users of this software have had no such problems so I'm at a loss. I know from testing that the PHP script for the web pages is fine, I have plenty of bandwith both upload and download available on my DSL line, and while the computer running MySQL is behind a router I have tried plugging the DSL line DIRECTLY into the host computer and it makes no difference. For all appearances it seems the problem is that it takes MySQL forever to gather and provide the information needed for these pages. Does anyone have any idea what I should be looking at to solve this problem? I do not know the MySQL program at all, so I get somewhat lost when people start throwing out technical terms, but this has been really frustrating because no one else seems to have the problem and everyone so far has just told me to check the things I've already checked.
View Replies !
MySQL Connection Sometimes Slow
I have been developing an application in Visual Basic that accesses a MySQL database either on the local machine, or a remote machine. Locally, database connections run smoothly. However, when I try to connect to the remote system (another computer on my local network) some databases take longer to connect than others (sometimes 10 - 20 seconds). The application usses the myvbql.dll (sorry lost the link, found it through google) wrapper around the libmysql.dll file to perform database actions. The application seems to hang when it tries to actually make the connection to the datatbase. This is only happening on the remote database server, and does not happen on every connection to that server.
View Replies !
Slow Remote MySql
We have a local (client) machine that runs a php application on windows using apache, the database for this application is on a remote server, which the client machine connects to via the servers ip number and the server accepts the connection from the client via the designated ip address (skip-resolve-address is set in MySql server and no dns addresses are used, only ip). However, the php application when dealing with the data from the MySql server is still pretty slow. We've tried query cache, but still slow. When I say slow, I mean page response and reloads take about 5 or 6 seconds. Is this expected from a remote server and using apache as we do for this application? When using a local MySql server the speed is pretty much instantaneous, but we need the remote server! Also, in testing the remote MySql server with a program such as SQLyog, response to requests are very quick and queries take no time. How could we go about testing for where the bottleneck is? Could it be apache and php (and where do we start looking for the problem? Local MySql server is nice and fast)?
View Replies !
MySQL ODBC 3.51 Driver Very Slow!
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time to load making any kind linkage with my Access data virtually useless. I have the MySQL driver setup in as a USER DSN. The MySQL data is sitting out on a server and the Access database is running locally.
View Replies !
Delay, Latency, Slow Mysql
I recently upgraded mysql from 3.23 to 4.0 and found that my websites using the mysql db had a 5 second delay, or latency. I searched for 2 days and found no answer to my latency problem until just a moment ago. I'd like to share the answer in case someone else finds this occurring to them as well. I was using my real static ip in my website mysql address instead of 'localhost', localhost should have been used initially anyways. I am not real sure what my reasoning was when I initially chose to put in my static IP. So, If you are like me and keep your stuff on your local machine, use 'localhost' instead of your static IP. At least it fixed my delay issues.
View Replies !
Mysql -s -u Root Bmd < Db.dump2 Slow
I've been sent a dump of a database and am trying to restore it with the command in the subject line. It's progressing, but very slowly. The problem is that the database is 40GB. Now if mysql is doing database-y thing like allowing access while building tables this might be slowing it a little. Is this the case and is there any way round the problem and slurp the the whole thing in isolation. Background: debian sarge mysql-server-4 4.1.11a-4sarge I really *am* a mysql newbie - tell me I'm silly for starting at 40GB
View Replies !
My MySQL Back-end Works Very Slow
I have installed my MySQL Server in a Window XP platform running in a Pentium4 machine. When I access the database on the machine, it is working in a normal speed. But when I access the database from a client machine (still running in windows platform), it runs very slow.
View Replies !
Mysql 5.0 - Using My.cnf - Unix / Slow-query-log
I installed mysql 5.0 and need to set up slow-query-log and other logging options. Here is what I did. But I dont see it working yet. 1. cd /var/db/mysql 2. chown mysql slowquery.log 3. touch /usr/local/etc/my.cnf 4. chown mysql /usr/local/etc/my.cnf vi my.cnf [mysqld_safe] -u mysql --log-slow-queries=/var/db/mysql/slowquery.log so now when I type: mysqladmin shutdown and than mysqld_safe & my sql restarts but the log files are not being used. also - how do I know if my my.cnf is being used at all?
View Replies !
Remote MySQL Connection Slow
I have a website on a dedicated server that was running really slow, so I got another, much faster server and transferred the MySQL database to this server. However, now when I connect to the faster server's database using the slower server's PHP web pages, the overall page loads much slower than when the database was on the slower server. Any ideas why this would be? Right now the host name is just an IP address. Does it need an actual resolved hostname to be fast? MySQL on the faster server is supposedly tweaked for fast service (my-huge.cnf).
View Replies !
Slow Performance After Falling Back To MySQL 3
Yesterday I have upgraded my linux box with a pair of Xeon 1G CPU and reinstalled everything (it was a sinle Xeon 700). The default RH9 installation comes with MySQL 3.23.54. After the reinstallation I found the machine was not as responsive as before. (It's not very slow, but some lagging is noticed) I was running Mysql-max 4.0.11 and the performance was ok, except the slowness during the peak hours, which was regarded as normal. I would like to know the differences between Mysql 3 and 4. Is the new version making a significant jump in performance? I also noticed the system eats up memory faster than before. With the old setting the system never used up 60% of physical memory, even at extremely high loading (30+). Now it easily used up 70% of memory. Code:
View Replies !
Mysql Running Slow On Mandrake Linux 10.0 For AMD 64
I'm having a problem with a new machine running Mysql version 4.0.18 on the AMD64 version of Mandrake 10.0. The new machine has got 64bit AMD processor and 2GB of RAM. Nearly all queries(updates are especially slow) are running 20/30 or more times slower than on an inferior(32 bit processor, 1.5GB RAM) machine runnning Mysql 3.23.56 on mandrake 9.0. As far as I can tell mysql is configured correctly for the power of the machine. The my.cnf file looks like this: Code:
View Replies !
MySQL Slow To Connect To Remote Database
I was running a PHP/MySQL web site with the database on the local web server. I needed to move the database off the webserver (located in the firewall DMZ) and onto its own machine (behind the firewall on our private network) Now when I run my web site it goes really slow. I ran mysql from the command line on the web server and connected through to the database machine behind the firewall using webserver:/# mysql -h 192.168.1.7 -u www-data -p After I enter the password, it takes around 5-7s before I see the mysql> prompt. Is mysql trying to do reverse dns on the IP address and timing out? I added the machine details to /etc/hosts so it would be recognized but no improvement. Or do I have something wrong with my mysql configuration?
View Replies !
Slow Connect Linux To Windows MySql
I have a Linux box with the latest MySql and another box (Windows 2003 Server) with the latest Mysql. From the unix prompt I do this: mysql -uroot -pmypass -h windowsserver mydbname this take about 4 seconds to connect I do the exact same thing on a windows workstation and its connected instantly.
View Replies !
VER VERY VERY Slow MySQL Query HELP URGENTLY NEEDED
I have the following MySQL query, but it is VERY VERY slow and seems to be crashing the server. There are 300,000+ records in the 'tracker' table. SELECT sites.*, SUM(if(tracker.type='view',1,0)) AS numberOfViews, SUM(if(tracker.type='click',1,0)) AS numberOfClicks, SUM(tracker.revenue) AS totalRevenue FROM sites LEFT JOIN tracker ON tracker.site_id = sites.id GROUP BY sites.id ORDER BY sites.domain_name
View Replies !
MySQL Timing Out? Really Slow Queries, Already Indexed.
For whatever reason, MySQL does not seem to be executing. So, I ran a few stat functions and here is what I got: Uptime: 220372 Threads: 39 Questions: 18748899 Slow queries: 808 Opens: 28723 Flush tables: 1 Open tables: 4096 Queries per second avg: 85.078 The "open tables" worries me for a few reasons. First, because it is 4kb (exactly, since it is divisible by 1024, evenly). This makes me think that maybe I am hitting a ceiling. Second, there are a few variables in MySQL that equal this, and maybe it's a cap on something. Here are the variables that equal 4096: query_cache_min_res_unit = 4096 table_cache = 4096 transaction_prealloc_size = 4096 Do any of those have anything to do with this? Am I even close? Are any of those values from mysql_stat a big deal?
View Replies !
User Admin In Mysql-administrator Slow On Linux
We have a MySQL 5.0.16 server installed on a RedHat 8.0 machine. mysql-administrator v1.0.22 is installed on RH Linux FC3 from the mysql-administrator-1.0.22a-1.rh9.i386.rpm. Everything seems to run fine except User Administration is *extremely* slow. If I click on "User Administration" in the sidebar, it takes about 2 minutes (seems like forever) before the window comes back with the infomation. All the other functions seem to function fine. Is it because I'm using mysql-administrator on a remote host? Do I need to move and rebuild the server to a newer Linux version? mysqlcc doesn't have this problem at all. (It's using the libraries from MySQL 4.1 that the databases were migrated to.)
View Replies !
DSN Configuration
I have Groupmail running on a remote machine with a fixed IP and want to set up a database connection from my Server. I have set up a user but am getting the following error: Access denied for user 'odbcuser'@host<IP> (using password: yes) where odbcuser is the user and IP is my remote machine's IP
View Replies !
Configuration
I'm learning Java and Databases.I need help. I don't know about databases, but I have to use one... I chose a MySql for use. How can I configure a MySql Control Center (GUI) or Where I find a tutorial that show me this configuration?
View Replies !
What Will Be The Best My.cnf Configuration?
I have a MySQL 5.0.27-standard-log slave server running on a server with Processor: Dual Xeon E5372 Quad Core (Clovertown) RAM 12GB Hd1: 120GB OS: Linux - CentOS 4 I have 15GB+ data with MyISAM and InnoDB tables. InnoDB tables are not in much use, we perform user searches on MyISAM tables which have FULLTEXT. Question: What will be the best my.cnf configuration? Below is the current my.cnf ....
View Replies !
Configuration Wizard
I can't seem to find my earlier post about my problem, so I'll post this here. I got the following error (with an 'x' in the 'Apply security settings' part on the final step of the wizard). Hopefully someone knows how to fix this: The security settings could not be applied. Error number 1045. Access denied for user 'root'@'localhost' (using password: YES)
View Replies !
Configuration Of New Database
I zipped up my website from one server and would like to move it to another hosting company. Where in the tree are the configuration files for SQL kept? I see a file called database which is a text document but I do not see the password for the SQL configuration. This all runs under Linux / Apache / MySQL.
View Replies !
Specifying INNODB Without Configuration
Is it a bug or a feature that with the conditions 1. INNODB is not configured in my.cnf 2. Table type is specified as INNODB When you create the table there is no warning, and no syntax error, and the table type silently and Microsoft-like, defaults to MyISAM?Now, if you specify table type as TYPE=bullshit, you get a nice (and expected) syntax error.
View Replies !
Apache Configuration
I was just wondering if anyone could help me to configure my home machine to run as a test server for PHP using MySQL and Apache. I am running WinXP pro and I would really appreciate some help. (I'm trying to learn PHP before paying the moola for a host, only to make a fool of myself while trying to learn PHP. I don't see any logic in paying for time to learn, when I could do it for free at home and then pay for a host...) I would be very thankful if you would imagine that I had just downloaded the files from their appropriate sites, and haven't even opened them yet. A walkthrough of the installation etc... The main part I've been having trouble with is editing the httpd.conf file for Apache;)
View Replies !
FULLTEXT Configuration
I'm currently using the FULLTEXT feature of MySQL to perform faster searches in a table. However, I have noticed that it doesn't index (or consider) words of three characters or less. There are many cases where I actually need to search for words of three characters exactly.Is there a way to modify this configuration in MySQL? The MySQL server is running on a FreeBSD box with Plesk 7.5.
View Replies !
System Configuration
I'm currently rebuilding my home system - a couple of linux boxes with Debian. Although I don't have a high load on any of my systems, I am going to set up a separate box with my mail server and another for my web services. I'm wondering if there is an arguement for or against putting MySQL over on the mail box or even putting it on its own box?Assuming the arguement is for putting MySQL on a different box, are there any pitfalls, tips, tricks I should consider before starting this project?
View Replies !
Server Configuration
I am placing this in the MySQL forum because the apps I run are very MySQL intensive... I have a number of sites running on a dedicated server. Most of these sites run apps built using PHP and MySQL. We have been getting lately very bad performance on our server, especially related to MySQL. One issue is that we need to focus a lot of attention on optomization of our SQL quieries, but we are planning a server upgrade. Now my question is not only for the MySQL experts, but focused on them, what is the best setup for running application intensive sites. Is it a server with powerful processing and memory such like dual Xeon and 2GB memory or is there another configuration like two servers? What are the idealistic and realistic setups that are available?
View Replies !
Configuration Problems?
I've recetly installed MySQL on my Windows 2003 server to use for a few websites im building. I went through the installation for 4.1.8-nt and everything seemed to work fine. I created a couple of databases and played about a bit to get used to things, everything seems to work fine. Now im trying to install a phpbb forum onto my website but when i get to the installation process and fill in all the details its comming up saying "The PHP configuration on your server doesn't support the database type that you chose". Now im pretty sure the configuration is correct and no matter what I try im getting the same reply.
View Replies !
Instance Configuration
i was going through the Mysql Sever Instance Configuration when I got to the end and press execute , every thing went fine untill i got to start service and then it said "cannot create Windows service for MySQL. Error 0"
View Replies !
|