Mysql

H

headstrong

Expert Member
Joined
May 10, 2006
Messages
1,099
Reaction score
0
How exactly does mysql DB work??

I head sumwhere that you can use it to record the amount of traffic each user has used from 1 adsl line but within a Wireless Lan

From what i gather i still need another server or sumthing that connects to mysql... right?

Is mysql windows or linux?.. coz i am running 32 bit windows with a 64 bit AMD processor..

Is mysql a good idea to use as a traffic monitoring tool?

Soz for all the qusetions

Thanks alot

headstrong
 
Not sure this is exactly the right forum section.

MySQL is available for most systems (Win32/Win64/Linux/Unix/etc)...however it is only your database "backend". You need a "frontend" (Could be a website, programs, etc) to actually dump and retrieve data into your database.

You could use it to record your network traffic (I know the Linksys WRT54G using DD-WRT and Rflow Collector has the option of exporting to mySQL) but be warned...the filesizes increase at an alarming rate.

I think you'd be better off with traffic monitoring software especially written for this purpose.
 
You would either need to obtain software or write software that will capture the users usage over the ADSL line, from their it can be pumped into any type of DB, MySQL just being one of them.

But MySQL on it's own aint gonna do nothing.
 
indeed...quite an open ended question you are asking.
There are several components involved which has already been answered by the 1st 2.
I do think tho there are some ADSL routers that does actually pump traffic usage to a certain or several system. You must just set it up and there will be other dependencies, between the adsl router and the syslog server, router, txt file or whatever the method is.
 
mysql is simply a database - as such it can store most any data - it is the frontend you need.

anyway, take a trip over to www.mysql.org and have a look.

mysql FTW!
 
I plan on using rFlow on my linksys wrt54g wit DD-WRT

I installed mysql but i cant seem to run it!

I supposes only programs will be able to access it... like rflow etc, right?

What do u mean that the filesize increases quickly?....Does it keep increasing or stay the same once its reached a certain point?

Thanks
 
headstrong said:
I supposes only programs will be able to access it... like rflow etc, right?
Click to expand...
Download MySQL Administrator and/or MySQL Query Browser... use them to access/create/view databases/tables/queries etc.

headstrong said:
What do u mean that the filesize increases quickly?....Does it keep increasing or stay the same once its reached a certain point?
Click to expand...
If you use it to log all internet accesses, and do not do regular maintenance (throwing away old stats) the size will increase upto 4GB, which is the soft limit of a vanilla installation. After that, it will start giving errors...
 
Why does it increase to 4gb? Does it copy all the data transferred or just keep record of totals??

Thanks ettubrute il download query browser now!
 
No, it won't copy all data transferred. But, all connects and reconnects are logged, with the totals. Obviously, this can grow very fast, depending on the stability of your link...
 
Obviously this is customisable. You will store in the database whatever you want to store.

MySQL is a database engine and server rolled into one, allowing you to perform SQL queries to insert, update, retrieve or delete data. A database is generally a collection of tables whose primary purpose is the storage of data. A table is customised in terms of the name of the table, the name, type and number of collums contained within a table, and also the engine used to manage the table.

To put data into a mysql table, an INSERT query is used. E.g. INSERT INTO tableName (collumn1,collumn2) VALUES ('value1','value2');

To retrieve the data, a SELECT query is used. E.g. SELECT collumn1,collumn2 FROM tableName WHERE collumn1 = 'value1';

That is the basics of a MySQL database. Only the newest versions of MySQL supports automated data entry (by using Triggers and Stored Procedures). Older versions of MySQL databases (anything older than version 5.0), you as the user have to manually add data to the tables.
 
I got the latest verion from the website... I've passed the ICDL exams, so i have a good background with access which sounds similar to mysql.. However i still cant seem to add my own tables into mysql...

Were do i find the triggers and stored procedure...

Thanks
 
Thats the thing...!!! I have know idea wots cookin in the kitchen!!!

Do i need to have a program that uploads the values into the table?

"To put data into a mysql table, an INSERT query is used. E.g. INSERT INTO tableName (collumn1,collumn2) VALUES ('value1','value2');"

Where do i find an insert query?

I'm planning to use a firmware upgrade for my linksys ,wrt54g V5 : DD-wrt's rFlow collector... This requires a mqsyl data base...

I havnt installed the firmware yet as i first want to set up my table.. Etc

Soz if i'm annoying but i am a noob! :)

Thanks
 
headstrong said:
Thats the thing...!!! I have know idea wots cookin in the kitchen!!!

Do i need to have a program that uploads the values into the table?

"To put data into a mysql table, an INSERT query is used. E.g. INSERT INTO tableName (collumn1,collumn2) VALUES ('value1','value2');"

Where do i find an insert query?

I'm planning to use a firmware upgrade for my linksys ,wrt54g V5 : DD-wrt's rFlow collector... This requires a mqsyl data base...

I havnt installed the firmware yet as i first want to set up my table.. Etc

Soz if i'm annoying but i am a noob! :)

Thanks
Click to expand...
Dude, I can write a book on this, but you will probably be better off by trying to get more information regarding the "wrt54g V5 : DD-wrt's rFlow collector" from the manual/FAQs or any readme or help documents that comes with the application?
 
Last edited:
headstrong said:
Thats the thing...!!! I have know idea wots cookin in the kitchen!!!

Do i need to have a program that uploads the values into the table?

"To put data into a mysql table, an INSERT query is used. E.g. INSERT INTO tableName (collumn1,collumn2) VALUES ('value1','value2');"

Where do i find an insert query?

I'm planning to use a firmware upgrade for my linksys ,wrt54g V5 : DD-wrt's rFlow collector... This requires a mqsyl data base...

I havnt installed the firmware yet as i first want to set up my table.. Etc

Soz if i'm annoying but i am a noob! :)

Thanks
Click to expand...

(Firstly, this post may sound patronising, but it is not meant to be - just that text posts lose something - so please do not take it that way :) )

Hmm, it appears as if you need to start at the beginning and not jump to the end.
My suggestion, is to get a solid understanding for what mySQL is and what it does. A suggestion? Download and install mySQL, mySQLAdministrator and mySQLQueryBrowser. Then, download and install PHP, and optionally Apache.

Now, you have some core components.

Google for "PHP forms and mySQL", and set up a simple form to capture web information. Using mySQLQueryBrowser, modify the tables (these would have been created from the Google search tutorials), and play around.

Now, you will have much less problems figuring out the router stuff - the router stuff (in its basic form) will be fairly simple stuff - the biggest problem you seem to be having is with mySQL.

(This discussion feels a lot like trying to explain yachting to someone, and then later realising they have never heard of the ocean).
 
Shot moederloos,

I've got administrator and query browser... Il download PHP forms now
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X