MYSQL :: WAMP Server Solution

Linux Server V/s Windows Server ( WebServer - LAMP V/s WAMP)
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the
site performance is very slow on windows. I dont know the exact
reasons.

I have seen some benchmark details on internet. But still they are not
having concrete facts to support LAMP as a better alternative to WAMP.
Allmost all the search done on google melts down to IIS vs Apache, My
main concern is "Apache on LINUX" v/s "Apache on Windows" and similarly
for PHP/MySQL.

WAMP Issue Please Help!
I installed wamp onto my laptop (it's new) and everything went fine except that when I try and access the phpmyadmin from the control panel I get the error message 'php tried to connect to the mysql server, and the server rejected the connection. You should check the host, username password in
config.inc.php

then it tells me

#1045 - access denied for user 'gokeeffe' '@' 'localhost' (using password YES)

This is not the password that I set and I checked the config file and everthing seems to be inorder. Does anyone know what is wrong.

Why is mysql + phpadmin so difficult to install?

Phpmyadmin After WAMP
I cannot get into phpmyadmin after a WAMP reinstall - here's the error:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
What do I need to fiddle with to get this to work?

Uploading Tables From Wamp
i have been working on a test project in wamp.
and now i am trying to run it online.
i already uploaded all the html and php files and its now up and running except the databases.

my question is, how do i upload my mysql databases or tables?
on what directory should i put the mysql files?

No Response From MySQL From PHP With WAMP On XP
I am new to PHP/MYSQL and am setting up/running Apache 2 as a development platform on my Win XP pc.

I have succeeded in running php scripts on Apache but when I attempt to connect to mySQL I don't receive any response whatsoever, not even a helpful error message.

I have attempted binding the address in my.ini to 127.0.0.1, and have moved the mysql_connect script various places within my "www" structure.

I understand that certain firewall applications on XP can be problematic. I feel that there is probably a simple fix that I'm overlooking; I'd like to find it before I start tampering with my protection software.

Here's what I'm running into. Running the following script produces only "point 3", which makes me believe that the script is bailing out around the _connect command:

Code:

Connecting To A Database Using WAMP
I'm currently using WAMP to work on existing website and database material. I downloaded the required website, but it didn't run without the database online, so I dumped a copy of the database to my hard drive and imported into phpMyAdmin, but the website still doesn't connect to the database with the address 'localhost'. What would I use? Where do I connect to the database I imported in phpMyAdmin. Here's the code for connecting as well as the error message.

// CODE
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"

$hostname_systemDB = "localhost";
$database_systemDB = "myDatabase";
$username_systemDB = "user";
$password_systemDB = "pass";

$systemDB = mysql_pconnect($hostname_systemDB, $username_systemDB, $password_systemDB) or trigger_error(mysql_error(),E_USER_ERROR);
?>

// ERROR MESSAGE
Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'eid'@'localhost' (using password: YES)

MySQL Import On WAMP
I installed WAMP on XP to use a test server and can't figure out this silly windoze command line thing for MySQL. It seems my linux commands are Klingon to Windows.
I try this..

mysql> username -p database < c:wampwwwfile.sql

and I get a bunch of syntax errors. I tried dual slash and everything and it's not working. The file is 80MB so it has to be done at the command prompt.
Is there anyone out there? Is there anyone listening?
I've searched low and hi and there doesn't seem to be a page with how to do this. I've seen LOAD but that's just for a table.

Best Solution For Unique ID
For any db where you will be entering tons of data and want to create a unique ID for each row, whats the best way of creating a full proof unique ID. Ive used auto incr and md5 hash, I prefer using the auto incr since there are less characters to deal with. Id like to see what other people think

Database Solution
I volunteer for a non-for profit group and they have alot of names in a
multiple databases. the problem is that some people are in multiple
databases. and if they send out a mailing from multiple databases some
people get 2 and 3 of the same thing. my idea was to either make or find a
program that has everyone is 1 database and then make the people part of
multiple groups. (ex: bill is part of group a and b and im doing a mailing
from both group i only want 1 piece of mail to go to him).
It can be a separate program or with access. that use access now but i cant
figure out how to make my idea work.

WAMP Upgrade - Now MYSql Not Working
I have been running WAMP on my local server for sometime but I needed to upgrade so I downloaded the latest version, stopped WAMP and installed the new version. The Php is working ok but the MySQL service won't start and I even tried starting it in the Services. When I browse to MyPhpAdmin I get this error:

Error
MySQL said:

#2003 - The server is not responding

Carry Database From Wamp To Lamp
i created a database in WAMP ON WINDOWS ans now want to put it on my lamp server.but dont now how to do it.MySQL version is 5.0.x.

Backup/Recovery Solution?
I have to configure a working solution for my 24/7 OLTP environment. I currently have a master / slave setup. My concern is that if I lose my master server, and I startup my slave, I would not be able to recover the few transactions that has not been replicated from the binlog yet.

I am considering purchasing Innodb's hot backup because it allows for point-in-time recovery (rolling forward using the master binlog), however it still depends on whether the binlog is avaiable after the master crashes.

The ideal would be to "mirror" the binlogs to another disk/location. (sort of like Oracle's mirrored redo logs) But is this possible in Mysql. I have done extensive research on Mysql backup strategies and did not really see this done before. Anyone done this before?

Solution For Installing MySQL On Mac OS X
Just in case anyone has the same problem. After a few hours, I found
the solution for installing MySQL on Mac OS X. As well as a ton of
other people, I was getting the error...

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Its a problem with permissions. Try this from the terminal, it worked
for me...

sudo chmod 1777 /tmp

and

sudo chown -R mysql:mysql /usr/local/mysql/data

Elegant MySQL Solution
This may be in the wrong forum, so if it is I apologize. I am trying to update multiple tables at once and was wondering if there is an easy way to combine three actions into one SQL statement. Below are examples of the three actions I am performing:

mysql_query("UPDATE listings SET col1='value',col2='value2',col3='value3' WHERE id='4'");
mysql_query("DELETE FROM keywords WHERE id='15' AND id='16' AND id='17'");
mysql_query("INSERT INTO keywords (keyword,listing_id,added_on) VALUES ('key1','4','june 13, 2006');

As you can see, two tables, listings and keywords. Listings has a foreign key relationship with listings. Basically what is happening here is that people are updating a listing as well as the keywords associated with that listing.

What Is The Solution For MySQL Max_user_connections Error
I am constantly getting "max_user_connections" error from the MySQL server, even with the newly created mysql-user.

FYI, i also have used connect instead of pconnect to reduce the persistent connection load.

So are there any ideas on this issue?

Solution For 'repetition Control' (slideshow App. For Web)
Im currently developing a web portal wich will serve, as part, as a customizable slideshow presentation.

The user will have the option to select multiple galleries of images of different subjects, each gallery containing several images.

The slideshow's 'playlist' function plays a certain number of images from one gallery then moves on to the next on. I.e., the playlist have 200 galleries, and will display 5 images per gallery.

Its imperative to the system to have a 'image repetition free environment', to assure that, when a gallery that was previously displayed shows up again in the playlist, the next 5 images of that gallery wont be the same as the ones previously played.

Code:

The Most Time Efficient Solution For Interfacing MySQL?
I have just finished a couple of projects about DB and MySQL, a couple of stand alone applications (.exe). So far, time was not that critical, I did not care too much about efficiency. So, due to my C/C++ background, I used the native MySQL API in C, which I wrapped in some C++ classes. I used the .Net framework in C++ with managed extensions for interfaces. That was what I already knew, no other reasons for this choice!

This combination was not working bad, but it suffered from two main problems: too slow to implement interfaces (data grids, windows, buttons and so on) and a bit too limited in the choice of controls (this may be due to .Net), for instance the data grid controls are very poor, having very few parameters.

I was wondering if using all the "connectors" provided by Java, VB and maybe another language/framework was offering me faster implementation. For instance, I was amazed how fast one can make an interface by using Access, in spite of some flexibility I guess. Then, I was wandering about richer interfaces than .Net. I do not have the old VB6 but someone told me there were more controls.

My goal would be building small/medium stand alone applications, sometimes to integrate them with web oriented versions of them, though this is not the main priority.

Alternate Solution To "intersect" In A Single Table...
I am having a problem getting my desired outcome with my table.

Table: orders

+-------+-------+------+------+------+------+---------+
| ordno | month | cid | aid | pid | qty | dollars |
+-------+-------+------+------+------+------+---------+
| 1011 | jan | c001 | a01 | p01 | 1000 | 450 |
| 1012 | jan | c001 | a01 | p01 | 1000 | 450 |
| 1019 | feb | c001 | a02 | p02 | 400 | 180 |
| 1017 | feb | c001 | a06 | p03 | 600 | 540 |
| 1018 | feb | c001 | a03 | p04 | 600 | 540 |
| 1023 | mar | c001 | a04 | p05 | 500 | 450 |
| 1022 | mar | c001 | a05 | p06 | 400 | 720 |
| 1025 | apr | c001 | a05 | p07 | 800 | 720 |
| 1013 | jan | c002 | a03 | p03 | 1000 | 880 |
| 1026 | may | c002 | a05 | p03 | 800 | 704 |
| 1015 | jan | c003 | a03 | p05 | 1200 | 1104 |
| 1014 | jan | c003 | a03 | p05 | 1200 | 1104 |
| 1021 | feb | c004 | a06 | p01 | 1000 | 460 |
| 1016 | jan | c006 | a01 | p01 | 1000 | 500 |
| 1020 | feb | c006 | a03 | p07 | 600 | 600 |
| 1024 | mar | c006 | a06 | p01 | 800 | 400 |
+-------+-------+------+------+------+------+---------+

What I am trying to do is list only the entries from cid that have both 'p01' and 'p02' in the pid column.

In oracle(sqlplus) I did it like this:

select cid from orders where pid='p01'
intersect select cid from orders where pid='p02';

Transferring Tables From Testing Server To Online Server
I need to copy my tables from a testing server on a local area network to my hosting companies online server. Is this something I can use MySQL Query Browser to do, and if so how?

Lost Connection To MySQL Server During Query / Server Has Gone Away
All of a sudden the server stopped working. When trying to execute a simple INSERT both from PHP and Query Browser, the server crashes and I get either "Lost connection to MySQL server during query" or "Server has gone away" errors.

The problem started on 5.0.18, and upgrading to 5.0.41 didn't help. I'm using Windows XP SP2.

I've seen quite a few posts on similar problems, but no real solutions though. Is that a bug?

Connect From Unix Mysql Server To Ms Access Server
Im wondering is it possible to connect through my mysql db (running on fedora core 4) and access the ms access tables on the ms access server?

I have a connection setup the other way around using an odbc bridge, is it possible to do this the other way around enabling me to view / edit the access tables through mysql.

Copy Data From Database On Server A To One On Server B
In an older version of MySQL that defaulted to MyISAM table types I could simply copy the contents of the MySQL/Data/DbName folder to a similar folder on another server and the MySQL on that server would, following a reboot, see the entire database.

Using the 4.1.12 version of MySQL the default is InnoDB tables ( and I do want to move to transaction save tables anyway ) - which do not respond to the same treatment.

How can I copy and entire database from one server to another ( this new server is at a different site, connected over the VPN )

Both servers are running MySQL 4.1.12 on a Windoz operating system.

How Do You Manage Changes From Development Server To Production Server?
What started out as a simple test of mysql has turned into what is
quickly becoming a replacement for our entire business system and web
site

The bad news is that we are now wrestling with how to we continue
working on development the system without risking down time for users.
If we work on a development server, how can we log the changes to table
structure and then apply them to the live database on the production
server when we are done testing?

Is there some sort of tool or log that would just let us apply table
structure changes to another copy of the database?

Ugrading Win2k Server To Win2k3 Server
I would like to know if there is anything I should watch out for or do before I upgrade my Win2k server to Win2k3 server. I am running MYSQL version 5.0.27 and PHP 4. Which I must admit was a bit of a challenge finding the right combinations of the 2 that work together very well for my setup.

MySQL 4.1.22 And SQL Server 2005 On Same Server?
Is anyone running MySQL and SQL Server on the same machine? We are running SQL Server 2005 on a Win2k3 server and need to add an instance of MySQL for a new PHP site.

SQL Server 2000 To MySQL Server
I'm trying to do an export from an SQL Server 2000 Database to and ODBC driver pointed to a mySQL Server Database. The export works if there is at least one record in the mySQL table. If the mySQL table is empty it gives an error that looks like this:

Insert error, column 1 ('field1', DBTYPE_STR), status 6: Data overflow.

The strange part is that the export works perfectly fine as long as there is one record in the mySQL table, if there are no records in the table, I get the error above.

Server To Server Root Prob
Not to sure if this is the correct forum for my problem, but here it is. I have a site running mySQL and the hosting I would like to keep but is in another country, not UK where I am based.

I have a domain hosted on another server which I would like to use as the main site domain and is a .co.uk which I belive has to be hosted in the UK.

Now when I use the UK domain and link to my overseas SQL data base it changes the path eg /home/www.myurl.com/index.html/..... the /home/ is the problem which causes errors when the database is called..etc.

Mysql Server And Regular Server
I recently decided to get another server to do just mysql, however, I ran into a few problems.
As soon as I switch the script to pull from the other server it creates a huge lag between the two and eventually starts timing out the sites. in my.cnf i did do skip-name-resolve but still the same thing.
Are there any programs or anything that are maybe bottlenecking it because the site will load in the first 10 secs after i switch the mysql (with a lag) but that lag gets bigger and bigger.
The mysql error log doesn't show anything weird either.
To further complicate things, another server that was pulling off it worked for the first few hours, then when traffic started to increase, it started doing the exact same thing. (both server loads were low and max connections was not getting even close). Roughly 600 qps, half to HEAP tables.

Unable To Connect To Database Server. Can't Connect To MySQL Server On 'localhost' (10055)
I am running a PHP application with mySQL . Some times it gives the following error.
I do not understrand why this error occures .

today i am using the application but it is not giving the error but error occures yested day .

Unable to connect to Database Server. Can't connect to MySQL server on 'localhost' (10055).

SQL Server
I have used PHPMyAdmin and MySQLFront for connection to MySQL to create and manage tables.

What tools would I use to connect to a MS SQL Server Database?

How Do I Set Up The Server?
I have tried installing both MySQL and DBDesigner4 but am confounded by the request to sign in -

Invalid Username / Password

So, can anybody tell me how to set up the program so that I can start working with a database?

Are there online manuals anywhere?

UDF Server 4.* 5.*
I noticed that behavior of "create function" depends on server version. Using connection with empty database name In early versions we do not need to write database name befor function name, but in 5.* we MUST write some, eaven if we realy don't have such database.

Question is:
Am I right? and From whoch version such behavior appeared.

Web Server Ram
How do I calculate the memory needed by a webserver (APACHE) connecting
to a mysql server (different box). Is this only related to the select()
operations / data transferred to the webserver?

On the mysql server I assume that I have to calculate the max tabel
size X the number of connections.. but I'm not sure about the web
server size.

On A Different Server
I need to know how do I place my databases on a different server on a different machine(a very remote machine.).

Are there some files that I can just place in some particular directories?

Server
My MySQL server is accessible only through the socket file (I believe).

netstat -lan yields:
cac1bc82 stream 0 0 c1e37378 0 0 0 /tmp/mysql.sock

I can't figure out how to get mysql to listen on 3306. I would like MySQL to listen on 3306 automatically upon boot.

I have gone to mysql.com and have tried everything i can find there.

Server
Error i get:

Can't connect to local MySQL server through socket ''

I am attempting to conect to my mysql database, through a program i'm writing using mysql++.The database is running and my website(also using database) is recieving no problems.

I notice in the error that it can't connect to socket '' which is the empty string which is wierd, looking for solutions on the net gave me plenty of results with the socket being '/tmp/mysql.tmp' or the like, but none with it empty.

Best Server
Could anyone answer my questions :

1. Can VB applications on Windows clients (workgroup)
access MySQL on a dedicated Linux server ?
If Yes, could you tell me how to set the
network for it ?

2. If my application should run from a windows client,
using MySQL, Which server is the best ( speed,stability,
ease of opration and cost ) for running the database :
a. Dedicated Windows server 2002
b. Dedicated Windows XP

Different Server
we have a client who we're designing a website for and we have a shared server so we thought we'd just host it there but we DON'T want to handle their email so I'm assuming this means they're going to have to stick with their current host right? Well ok, but we want to make use of a MySQL database but this would sit on OUR server...so how do I go about this?
Couldn't I just replace the 'localhost' with 'someipaddress/whereeverthedblives' or something like that?
The only other thing I can think to do is to have the specific page that holds the db information actually live on our server, but look like it's living on the same server as everything else.... I'm not even sure that would work....but regardless, I don't know which way to go.

Server A To Server B
I am a web master who up until about a month ago had only worked in ASP using Acess Databases. Now I have a client (in Austria) who I redid his web site using PHP and a mySQL database. To access the his db, I browse to a web site, log in, then manipulate the database that way. I just set up a new hosting account in America and am baffled at how I transfer the database from the current server to the new one? Do I somehow export and import the database? Is there a file created so to speak?

My Sql Server 5
I'm trying to connect to a Win XP instalation of Server 5, from a win 98 PC over our working LAN. The PC's can ping each other and can browse files on each other. I can connect to the sever from the XP PC, under MySQL and ODBC. The Win 98 PC has the ODBC 3.51 connector installed. I can't even get the DSN to connect un the the Create Data Sources.

Moving From One Server To Many
First off Ive never really worked with databases that have been spread out amongst many servers. However I am currently working on a project where we are considering doing so sometime in the near future (in the next 6 to 12 months). So at the moment I really want to investigate how this would be done so I can start planning for this. The project is mainly done in PHP (however I have written a few C extensions to boost the efficiency of some routines). Anyway, I'm just wondering how one goes about doing this. We are thinking of breaking the database up amongst four or five servers to spread out the load. Also, is it possible to do a query that joins tables that are located on multiple servers or would these need to be done as separate queries?

What Not To Do On A Production Server!
So I experienced a hard lesson last night (I can't say learn because I don't know the proper way to handle it in the future). While trying to speed up a large table (5-700,000 rows), I basically killed our server. I was re-indexing the columns so that the most used queries would benefit some more, but I obviously did something wrong. I dropped what used to be a compound index to put the index on a single column, but in doing so, the entire MySQL server was tied up! While this was tied up, other queries queued up, and what resulted was a server nightmare. In the end, after waiting and trying and waiting some more, the server was more or less unusable for over an hour until we took some initiative and restarted the MySQL service on our box. I would still like to get into the server and finish re-indexing the tables, but we can't go through another fiasco like that.

What is the proper way to handle large tables like this on a production machine? I tested the steps on our development databases (which were much smaller unfortunately) and no problems at all. I'm sure there is a proper way to do this, but I am not sure what it would be.

Where Is Mysql.server
CentOS 4.4 amd64

I'm following;
Virtual Users With Postfix, PostfixAdmin, Courier, Mailscanner, ClamAV On CentOS
http://www.howtoforge.com/virtual_us...amav_centos_p4

to build the server. Coming to P-4

# /etc/init.d/mysql.server start

bash: /etc/init.d/mysql.server: No such file or directory
# /etc/init.d/mysqld status

mysqld (pid 3164) is running...
MySQL is running.

At the bottom of P-4
CentOS manner:
/etc/init.d/mysql.server start
/etc/init.d/saslauthd start
/etc/init.d/courier-authlib start
/etc/init.d/courier-imap start
/etc/init.d/postfix start

The other 4 commands worked without problem

MySQL On A FTP Server
How can I install MySQL on a Server that I have FTP access to? It seems that I can only install it on a local hard drive.

IP Address Of The Server
I would like to find the MAC address of the MySQL database server as the result of a query, by using a "select" statement. Is that possible?

Query For Server Name
I am running a mysql cluster with several API nodes. I just setup load balancing and getting ready to do some tests. I want to run a query for something like servername on a loop and see if my load balancer is sending every other query to different API nodes. Is there a select statement I can use to find out the server name?

GO Keyword From SQL Server
In SQL Server I can use GO between statements to execute multiple statements in the query window.

What is the mysql equivalent?

Server-Client
------=_NextPart_000_004C_01C3507A.4005F3F0
Content-Type: text/plain;
charset="windows-1254"
Content-Transfer-Encoding: quoted-printable

Hello,
I coded a program by using VB 6.0 I will use this program on =
network(nearly 12 user). is it necessary to code two different program =
for both of server and client. Or, Can I solve this problem by MYSQL =
Control Center.

H=FCseyin DEM=DDRA=D0
=DDstikbal Furniture =DDnt.

------=_NextPart_000_004C_01C3507A.4005F3F0--