MYSQL :: How To Setup A MySQL Table To Keep Track Of Stats?

Trying To Conceptualize Table Design For Stats
I have a stats page my users can go to so they can view how much traffic their listing has received.

Creating this for the total views is straight forward and I have that working. But I want to add two more features to this:

1. See the total views for just today
2. See a history for the listing over the duration of the post (ie. 30 days).

I am at a lost how I would create a table or several tables to accomplish this. I am looking for some guidance to get me thinking about the best way to do this.

Conceptualize Table Design For Stats
I have a stats page my users can go to so they can view how much traffic their listing has received.Creating this for the total view stat is straight forward and I have that working. But I want to also add two more features to this:

CODE1. See the total views for just today
2.See a history for the listing over the duration of the post (ie. 30 days).

Table Design For Storing Item Stats
I've created quite the database for my app, and I'm familiar with normalization and general db design. However, I'm ready to design my tables for recording all sorts of stats for my db items.

I want to be able to view stats for each item, such as number of small views, number of large views, number of downloads, ratings and so on. I also want to be able to view these items by periods of time, such as by day, week, month, by multiple months, by year, etc. So, I'm trying to figure out what the most efficient way of recording this data, so that I can keep my tables as small as possible. I'm wondering if I will have to insert a row for every stat, or if I should enter a row for every day, or only a day if there is activity, etc.

Keep Track Of Table Changes
I just had a question concerning change-logging. Basically, I am trying to come up with a weblogging system that uses Perl, XML/XSLT, and MySQL to generate content. I want to have all the necessary XML files as updated as possible with new information from MySQL, but I don't want to have to generate these XML files on-the-fly everytime they are needed.

Therefore, I require some way of doing a quick query on the table the XML draws it's data from, just to see if there have been any modifications. I am concerned not only with additions or deletions, but also with modifications of existing records, so a simple num_rows function wouldn't cut it. Is there any feature in MySQL that keeps track of when a table has been changed in any way, and perhaps stores the most recent change date?

Keeping Track Of Post Views Every Day (Table Structure)
I was thinking of having a table to keep track of post count every day.

For example, i have the following table structure:

CREATE TABLE `wp_views` (
`post_id` bigint(20) NOT NULL,
`year` tinyint(4) NOT NULL,
`month` tinyint(2) NOT NULL,
`month_hits` int(7) NOT NULL default Ɔ',
`day_1` int(6) NOT NULL default Ɔ',
`day_2` int(6) NOT NULL default Ɔ',
`day_3` int(6) NOT NULL default Ɔ',
`day_4` int(6) NOT NULL default Ɔ',
`day_5` int(6) NOT NULL default Ɔ',
`day_6` int(6) NOT NULL default Ɔ',
`day_7` int(6) NOT NULL default Ɔ',
`day_8` int(6) NOT NULL default Ɔ',
`day_9` int(6) NOT NULL default Ɔ',
`day_10` int(6) NOT NULL default Ɔ',
`day_11` int(6) NOT NULL default Ɔ',
`day_12` int(6) NOT NULL default Ɔ',
`day_13` int(6) NOT NULL default Ɔ',
`day_14` int(6) NOT NULL default Ɔ',
`day_15` int(6) NOT NULL default Ɔ',
`day_16` int(6) NOT NULL default Ɔ',
`day_17` int(6) NOT NULL default Ɔ',
`day_18` int(6) NOT NULL default Ɔ',
`day_19` int(6) NOT NULL default Ɔ',
`day_20` int(6) NOT NULL default Ɔ',
`day_21` int(6) NOT NULL default Ɔ',
`day_22` int(6) NOT NULL default Ɔ',
`day_23` int(6) NOT NULL default Ɔ',
`day_24` int(6) NOT NULL default Ɔ',
`day_25` int(6) NOT NULL default Ɔ',
`day_26` int(6) NOT NULL default Ɔ',
`day_27` int(6) NOT NULL default Ɔ',
`day_28` int(6) NOT NULL default Ɔ',
`day_29` int(6) NOT NULL default Ɔ',
`day_30` int(6) NOT NULL default Ɔ',
`day_31` int(6) NOT NULL default Ɔ',
UNIQUE KEY `post_id` (`post_id`),
UNIQUE KEY `year` (`year`),
UNIQUE KEY `month` (`month`)
)
Let say, today is the 20th July 2007, so my insert query will be like

INSERT INTO wp_views (post_id, year, month, month_hits) VALUES (1, 2007, 7, 1) ON DUPLICATE KEY UPDATE month_hits += 1, day_20 +=1;
Is my table structure alright? or is there a more efficient way of doing this?

New To MySQL. Am I On The Right Track?
I am building an application - and if it works, i may roll it out as company wide.

I wish to make an Electronic Log book for keeping records on equipment at various customer sites.

I have 60 engineers that will need access to the database and this in turn will store things like arrival/ departure / down time and also what was done to fix the fault.

Is MySQL the way to go?

Using Mysql To Keep Track Of Changes
I want to keep track of changes in my Unix environment by using a mysql database.

I have setup a DB in order to populate it with the data I'm gathering from the machines. This is going good. I have no problem updating the DB by overwriting the actual (old) data with the new data set. I'm doing this thru "LOAD DATA INFILE". It's a small file of about 28KB.

My problem is when I need to update the records for any of the machines in the database, I need to keep the old data somewhere in order to query for the changes. I need to keep data for many months/years.

How should I go about creating my DB in order to do that?

Table / DB Setup
I will potentially have 1-3 tables that may be written too 1,000's of times per second. Eventually becoming very very large tables. What methods and suggestions would you make on how to properly handle a task of this nature? I need to be conscerned about performance on pulling many records back as well for statistics.

Table Setup
I have one database with two tables. One is named users, and other is named posts.

User table contains this fields

UserId(key) Username

When user writes a post it is stored in Posts table with this fields
Post Table contains this fields
PostID(key) UserId Post

Now, this is really simple question, but is that a proper way to store posts made by user, so that userId gets stored as well as PostId?

I read a bunch of stuff, and this is how i figured it goes, so if you have experience with creating more tables and on a way how to join them together,

Table Setup
I need to track settings on my system on a per directory and per user basis. In this case,I am refering to directories that all users can see and sort.

I would like user A to be able to sort the same directory as user B and have their sort choices be independent.

So my table needs to have at a minimum:
userid: varchar
directory: varchar
sortmethod: int

What table type should I choose? What Indexes should I have?

Setup Table
I'm working on this script where users can add another users to their friends list. Basically, user add another user as friend and must be approved by another user in order to be called friend. The problem is I don't know how to setup a table for this.

Setup Messaging Table Structure
My goal is to make an efficient way to send and store messages for users of my web site. I want the basic functionality of users sending messages (subject,body,date...) to one or more other users. And i also want the option to reply or reply to all. This part seems somewhat easy, but then i want any replies to be part of the same thread so i can show message reply histories.

Advice On Table Setup To Maximize Efficiency
My table set is is garbage .. I knew this when I created the table a couple of years ago. Now that I have tonnes of data in it the queries are taking forever. So it's about time I constructed a more efficient table. I am turning to this forum for some advice.

My table stores RSS feed content in it -- every 15 minutes a cron job INSERTs data from 300+ feeds and dumps it into the table.

The table structure consists of:

id
dateUnix
headline - headline of the article
permalink - URL to the article
body - TEXT type - body of the article
author - person who wrote the article
authorURL - URL to the person's website
favico
sitetype - I categorize the types of sites (0 = news media, 1 = blogs, 2= videos, 3= podcasts)
vote - users vote on stories
verified - 1 = verified, 0 = censored/banned story
newsCat - 20 different categories
newsSubcat - 50 different subcategories

I think the best way to make this table more efficient would be to break it up into 3-4 different tables using the id as the key.

ps: my cron job checks for duplicate entries and does not insert duplicates -- so duplicate stories are not entered

Stats Query - If You Are Pro, Help Me :D
I've taken over developing a statistics page for a client.
The statistics are recorded in a table named 'visitors'.
This table is about 35,000+ records at the moment.
I need to be able to display total site hits and new visitor hits for periods such as today, this week, month and year.

It creates a new record on every page thats visited on the website.
The table has 7 fields:
-----------------------------
ID
REMOTE_ADDR - logs visitors ip address
HTTP_USER_AGENT - logs browser
HTTP_REFERER - logs referal if exists
SESSION_ID - logs visitors session id
PAGE - logs page visited
DATE_ADDED - date record created - timestamp
-----------------------------

Currently the ID fields are used to test if the current remote_addr has a previous record. This is very resource intensive to test each 35,000 rows against each other. Can anyone suggest a better system or a solution?

Thanks in advanced!

I've added an example of the code the previous developer was working on.
The sql below is meant to split up the day by hour showing total hits and new visitors for a specific day.
I've tested the SQL and it times out on the new visitor 'if function'.

SELECT
CONCAT(
DATE_FORMAT(date_added, '%k'),
':00 - ',
DATE_FORMAT(date_added, '%k'),
':59'
) as `day`,

DATE_FORMAT(date_added, '%W %e %M %Y') AS act_day,

COUNT( DISTINCT REMOTE_ADDR ) AS un_total,
COUNT( DISTINCT session_id) AS site_hits,

COUNT(IF(
v1.REMOTE_ADDR IN (
SELECT v2.REMOTE_ADDR
FROM visitors AS v2
WHERE v2.id < v1.id
GROUP BY REMOTE_ADDR
),
NULL,
1
) ) AS un_new,

FROM visitors AS v1
WHERE DATE(date_added) = DATE('".$_GET['day']."')
AND page != 'REFERAL'
GROUP BY HOUR(date_added)
ORDER BY date_added DESC;

Stats Not Logging
My stats arnt being logged. Page loads with no errors..

$update = "UPDATE `log` SET hits='hits + 1' WHERE ip='$ip' AND date='$date'";
if (mysql_query($update) or die(mysql_error()) ) {
} elseif($logged[username]) {
mysql_query("INSERT into log (ip, hits, date, user) VALUES ('$ip', '1', '$date', '$logged[username]'" or die(mysql_error()) );
}
else{
mysql_query("INSERT into log (ip, hits, date, user) VALUES ('$ip', '1', '$date', '$user'" or die(mysql_error()) );
}?

Index Use Stats
Is there some way to obtain some sort of statistics of how often, or how much is any given index used for queries? What I want to know is if an index is not used so it can be erased or changed, because it is being of no help, and just wastes space and slows down insertions.

Running Update Stats
I am trying to run an update stats command but keep getting a syntax error:
Looking at the doco it looks like I can use:

update stats <table_name>;

but when I use:

mysql> update stats x_balance;
ERROR 1064: You have an error in your SQL syntax near 'x_balance' at line 1

What am I doing wrong.

Running Stats On Data
I have a table (artist_nodes) that refers to a number of keywords (around 100) (nodes table) associated with a number of artists (artists table) i.e.

artist_nodes table

col 1 - id_artist_node (primary key)

col 2 nodeID_artist_nodes

col 3 artistID_artist_nodes

the content of each column is a number code that relates to the primary keys of content in the artists and nodes tables.

Is there a method for counting the number of distinct values in the nodeID_artist_nodes column, summing these values, and calculating how often values occur with each other?

So for example, if 1 = installation, and 45=interior and 46= exterior

i am looking for the number of instances of 1, 45, and 46, and also how often each occurs with the others when associated with the same artistID (as a percentage)

so the output i am looking for in php would be something like

installation (1) = 35 instances (3% of sample)

interior (45) = 23 instances (1% of sample)

exterior (46) = 30 instances (2%)

installation with interior = 10 instances (x %)
installation with exterior = 20 instances (y %)
installation with exterior and interior = 4 instances (z %)

is there a way of doing the inverse of this, i.e seeing which keywords never occur together?

Post Stats For Every File Looked Up?
I have 909,000 plus files in my database. Is it possible to post the amount of look ups , stats, for every file looked up?

Example:
People searching my database via my web site.

If 700 people looked at a file, while viewing that file, it also tells you 700 look ups as part of the results? Code:

Keep Track
I need to UNION two table,but i'd love to have a field that keeps track of wich table the row came from.

Mysql Setup
I am working on setting up a postfix email server with Currier IMAP and Mysql with a squirl mail front end. I am currently having difficulties with the mysql end of the process.

I am installing using the source, not the rpm package since i want to get a feel for how to do this way, and I have been unsuccessful at running:

./mysql start

the error i get is

Can't connet to local MySQL server through socke '/tmp/mysql.sock' (111)

Also, according to the install readme, I need the client access libraries. I have been out to mysql's website and I have been unable to locate these files. I have found a tag that will setup only the client access files,

--without-server

but i'm not sure if this will not allow me to setup both the libraries and the server with an additional tag.

I CAN'T RUN SETUP.EXE OF MYSQL
I downloaded mysql-4.1.22-win32.zip and I run the setup.exe of mysql but the install stopped because it show to me the windows installer with parameters and do nothing.

MySQL Setup
I have a Windows 2000 Server preinstalled with mySql, and have tried to run a basic connection test though the ODBC manager for the mySql Server Driver, and it continues to say it can not find mySQL.

When setting up a standard database through the ODBC Manager, here is the basic info it provides. Code:

MySQL Setup
I've downloaded the mySQL files from the http://www.mysql.com website, and have unzipped them into my c: drive, although, i wish to be able to use this in addition in my PHP programming with my Apache Server. How would I do somthing like this?

MySQL Setup
I'm going through the PHP/MySQL tutorial on Webmonkey, and I got to the part where we create a DB - I'm getting this error though...

C:MYSQLBIN>mysqladmin -u root create mydb
MYSQLADMIN: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (
Check that mysqld is running on localhost and that the
You can check this by doing 'telnet localhost 3306'

MySQL Setup
i got my Apache and PHP to work. only problem is mysql. i just cant get it to work. my localhost is http://localhost:8080. whenever i try to create a database i get the following error:
Access denied for user: '@localhost' to database 'customers'
should mysq be using the same port (8080) as my apache server. right now mysql is using 3306.
its a winXP system.

Track And Trace
I work for a 5 man company selling track and trace service over the
internet.
I'm the only full time software guy.

We are growing, and I can see soon we are going to start hitting BIG
problems, we aren't make any money yet. This doesn't help as I think
we need a real MYSQL + Internet guru guy.

So my option was this hoping to get some simple answers I can use to
before It get out of hand.

We have one server running our software and we just bought another.

So can it be setup that both servers have there own database, and
update each others database. This means if something happens to one
server this other can take over the other.

I was thinking to make it customer based with server to logon to.

Keep Track Of Threads
I'm wondering what is the most efficient way for a forum to keep track of whether or not a member has viewed a thread or not, and that updates when a new post is made in the thread.

Seems like a lot of data to keep track of lol. I mean, I could create a table with member ids, thread id and a switch if it's viewed or not. And then everytime a new post is made I'd have to go through and reset the switch for every user and for every thread number. That seems like the table could get pretty massive pretty fast.
Had anyone dealt with this or have a clue as to the most efficient way to do it is?

Recover Or Track
i have been working on a project online and three people had access to the panel, Client, my co-programmer and Me.
we had created database and that was fully working with website on saturday when we left our office. Client has been playing with panel as sometimes he created new tables and sometimes he tested ready made softwares available in panel.
when we checked today all the tables from database has been deleted and there is no table. which means a lot of work for us again to create that database.
Can I track who has deleted tables and when? I am sure Client has done this while trying his bad skills.
Also is there anyway to recover those deleted tables? i have phpmyadmin installed on panel.

How To Track Error
We are currently running about 50 databases on MySQL 4.0.14. Occasionally
our users will get the error:

Couldn't select database. Message: Commands out of sync; You can't run this
command now Message Number: 2014

When this happens to one customer, it affects them all. We end up having to
restart the MySQL services to clean things up. Our goal is to eliminate
whatever is causing this, but cannot determine the cause.
I have checked the online help on MySQL and we are not calling the functions
normally associated with the error

Question About MySQL Setup On A Mac
I'm a fairly experienced web designer, but a newbie to PHP/MySQL. I have the Sitepoint book by Kevin Yank called "Build Your Own Database Driven Website Using PHP and MySQL" and I'm ready to start learning!

I already have a mySQL db setup through my web host and I can access it using PHPMyAdmin via the web. However, the book recommends (and gives instructions for) setting up Apache, PHP, and MySQL locally and says that for learning purposes it is better NOT to use PHPMyAdmin.

I hear that, but at the same time, for security reasons, I'm not all that hip on turning on Personal Web Sharing and making my computer into a server. It seems to allow access to my Sites folder which is where I have my local copies of sites I'm working on and I don't really want anyone else to access those...

I'm hoping someone here can tell me which way to go... is using PHPMyAdmin really going to hamper my learning experience, or should I just use it (and feel safer)? Or are my security concerns really not that much of an issue?

If anyone can give me any guidance on this, much appreciated.

Is This An Efficient MySQL Setup?
I would like to offload the MySQL server from my dedicated box in order to speed up page loads.

I don't have an additional dedicated server so my only option is to get a VPS.
But is offloading the MySQL server to a VPS, albeit a modest one, even worthwhile?

I understand this is a very broad question because I am not providing any details but that being the case I am expecting a broad answer

Error With Mysql Setup
After an installation of Namo WebBoard messed up my MySQL installation - I
have been unable to get it fully working again.
My setup is as follows:
Apache 1.3 / MySQL 4 / PHP 4

When I use phpmyadmin I get the following error:
#1045 - Access denied for user: root@localhost' (Using password: YES)

MySQL Setup Error
While installing mysql server on a windows 2000 machine without a
firewall, I get an error numbered 1045. Access is denied for user
'root'@'localhost' (using password: NO).

Inital Setup Of Mysql
I'm trying to get mysql working on redhat 9.0,

Origionaly I got "can't connect to local mysql server
through socket /var/lib/mysql/mysql.sock"

I ran /usr/bin/mysql_install_db which corrected this!

Then it started and immediatly stopped using the command
/usr/bin/safe_mysqld.

I looked at the error log in /var/log/mysqld.log
which said can't initialize innodb_data_file.
No idea what that meant so I put:-
[mysqld]
skip-innodb
in the file /etc/my.cnf

Now the only error says /usr/libexec/mysql: can't find file ./mysql/host.frm

I've created a file called /usr/bin/host.frm and set the permission the
same as the other files in there, but it still cant find it? The name
of the machine which is just localhost is in there, anyone know what
needs doing next?

Mysql Interoffice Setup
I know that I can setup an intranet using MySQL. That's not my question. I prefer to develop in PHP/MySQL, even for internal corporate applications, but my client wants to use MSAccess as their DB shell.

Is there a way to integrate Access to an ODBC (with which I have no experience) or something like it, in order to maintain a DB internally- still allowing for this DB to be used on the website? (servers are all in-house)

Download.php Setup With Mysql
I am trying to make a download.php which would let users to download files after 5 seconds.

The only problem is that my /download directory has many sub directory.

For example if someone wants to download FireFox, then firefox.exe is located in /download/FireFox/firefox.exe

and I want somewhat like this www.domain.com/download.php?fi... as an output URL to download. I know that I can use MySQL and setup a nice database to do something like this as long as fileid is unique.

Any ideas on how to setup the MySQL database so that I can easily add multiple files from different sub directory at the same time.

Setup/configure Mysql On W2k
1) According a book I have (Beginning JSP 2.0), I should run the following command:

mysql> delete from user where host = 'localhost' and user=''

However, when I check how many users in table user, I got:

C:Program FilesMySQLMySQL Server 4.1in>mysql -u root -p123abc
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 7 to server version: 4.1.9-nt

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> use mysql;
Database changed
mysql> select host, user from user;
+-----------+------+
| host      | user |
+-----------+------+
| %         |      |
| localhost | root |
+-----------+------+
2 rows in set (0.00 sec)

It indicates that only one user in this table. Is this normal?

2. According to the same book, I should also run the following 2 commands:

> mysqladmin reload
> mysqladim -u root password {my_new_passwd}

However, I got these error messages:

C:Program FilesMySQLMySQL Server 4.1in>mysqladmin reload
mysqladmin: reload failed; error: 'Access denied; you need the RELOAD privilege for this operation'

A Scrimmage Setup With MySQL
I have only dealt with MySQL databases in the past, so I'm not sure if this is the best way to go about this or not, but feel free to inform me otherwise. What my plans are is to create a web-based form (I assume using AJAX) that will allow you to enter multiple fields of data, which will then go into the database, and when another person submits data that compliments yours (i.e. they match up to create a scrimmage,) then both parties will be notified and the data will be deleted from the table. Is it possible to do with PHP and MySQL

MySQL Setup On XP Localhost
I have got the server working on Win XP Pro according to Winmysqladmin.exe.
I have a password in my.ini but when I go to CMD to login to root, it gives
me: "ERROR 1045: Access denied for user: 'root@localhost' <Using password:
YES>"

I am the system admin. I am however not using 'localhost' as such since I
am behind a router that has assigned this workstation: 192.168.0.3. The
USER and HOST are clearly shown in winmysqladmin.exe, like it knows about
it, but the mySQL.user database shows only root USERS on "Build & Localhost"
and two blanks also...the only way I can currently log on.

Is this a no Win situation? I've been at this for 3 days going in circles
and I suspect UNIX developers are exceeding happy to hear this. Yeah, I'm
using IIS 5.1 instead of Apache too.

MySQL Relication Setup
I have 3 servers each of them have MySQL DB- Primary, secondary and tertiary. There is another application that will access the database. It will always try to connect to the primary, if primary is down it will try to access the secondary, if secondary is down then the third one.

I'm planning to set this up in this way. Say the servers are S1, S2 and S3. There will be 3 real time sync links
S1 ---> S2 Master-Slave Setup
S2 ---> S3 Master Slave Setup
S1 --->S3 Master Slave setup (This link will be active only if S2-->S3 link is down.

Any thoughts on this. Would this suffice? Any possibility of data corruption and are there better ways of doing this?

Best Way To Track Online Users?
I'm currently using a custom-made login class that basically sends a REPLACE INTO online_user SET id=$userid every time a page with a registered session is loaded

Track Changes, Audit And Rollback
does any one can have me some references or advices on how to control on changes in the DB, audit them and have the ability to rollback.

Detect And Track Updates
I'm trying a develop a connector (or synchronizer) between MySQL and OpenLDAP(very similar to Metadirectory connector). The connector has to detect any updates made to the mysql database and should replicate that in OpenLDAP. The first part of it, is how to detect changes in MySQL? I thought of the option of using a Timestamp variable as an additional column in my DB table. But it won't work for 'delete' detection. Please let me know how to do that or point me to any source regarding that. Please reply soon as this is a part of my project.

Mysql Setup Compared To Oracle
I'm new to mysql. Coming from the oracle database a couple of questions
came up. Perhaps somebody, who has also experience in oracle, can set me
on the tracks.

Questions:

1. is mysql simular organized as oracle: instance/users/tables,
so that I have to connect to chossen instance and user?
2. does mysql also use the term tablespace and can it administrated in the
same way?
3. when creating a mysql database, how to determine where the datafiles
are located?
4. is there something like a init.ora?
5. is it possible to start several databases from the same installation?
6. is there something like ORACLE_HOME and ORACLE_SID?

Hope you can give me details prepared for a newbie and point me to the
suitable commands or docs.

Optimizing MySQL For A New Server Setup
We are currently switching over to a newer more powerful server. I am wondering if anyone could give me their input on what would be the optimal configuration of MySQL for the following conditions....

Dual Intel Woodcrest Dual Core
4 GB RAM
NCQ SCSI SAS RAID drive
MySQL 5.0.45
PHP 5.2.3

There are 2 databases on the server which combined total approximately 4 million records across 120 tables with a disk footprint of about 1GB.

Traffic fluctuates from between 3,000-6,500 page views per day. After we finish the upgrade we expect traffic to grow by 1.5 to 2 times that since the server will not be overwhelmed as much. Code:

Difference In Server MySQL Setup?
I have two versions of the same database - one is here local on my development set-up, the other on the live server. I literally just dumped the dev db and used the resultant SQL to create the live version, so they're about as exact as I can make them. Both have a record in "tblphotogs" with the value of the "addr" column equal to "123 Here Street".

However, the query "SELECT id FROM tblphotogs WHERE addr = '123 Here Street';" only works on the dev db. Is this some bizzare setup thing that I've just never come across before? In both db's, the addr column is VARCHAR set to 250 characters. I've tried using an index and a fulltext on the addr column on the live server and it still doesn't work.

I assume I'm missing something very simple, but I'm about to start ripping out my hair. This is the last thing I need to suss out before I can bill out my final invoice on a large site. I like the project, but I'm ready to move on, you know? Anybody come across this before? Have any idea what's going on?

I should state that - with the exception of this specific query - everything else has ported seamlessly between development server and live server. Both systems are using MySQL 4.1.13, I believe...

MySQL Setup On Advanced Server
Anyone ever setup MySQL on MS Advanced Server 2000? I have MySQL installed but it is not connecting to the server.

How To Setup Mysql Zip Package (XP,Apache,PHP 5.2)
I downloaded mysql-noinstall-4.1.22-win32.zip, and mysql manual also.

When i read the manual i found quite a few modifications that i have to do in order to run my database properly. I don't want to use installer, couse my apache, php setup is on partition that i never format, and i need to make just one modification when i reinstall windows.

I would like to do the same thing with MySQL, i mean, i don't want to do install it wrong way, and just need couple of advices on how to properly make all modifications to *.ini files, so i can store them somewhere safe, so when i format my computer i can set them back to the folders, and just run mysql from Bin folder.

my folder is on D partition in folder www.
Here's the structure

d:wwwApache2htdocs <- apache htdocs folder
d:wwwphp <- php folder
d:wwwmysql <- mysql folder

My database can use as much processor and memory power it needs to run a heavy scripting tool.