MySQL Database Forum

Hi there I have a database with about 20 or so tables, maybe a few thousand rows in each. I am starting to do more complex things with my insertions etc, and I want to start to use transactions, so I imagine I should change some table types in the database from MyISAM to InnoDB. I know that InnoDB tables are a completely different beast...

Hi, I want to create an auto creation date and update date in my mysql table. I am using the "MySQL Cookbook" approach, using the TIMESTAMP field which basically is: - create 2 new fields in the table (t_create and t_update) - both NULL - when a new record is created they both will register a common timestamp - when the record is modified...

Are there any utilities out there to parse useful information out of the general query log? I'm looking for the basic - who logged in when and for how long. Other than rolling your own log parsing utility, of course :-) Thomas Bartkus

Does mySQL have lite version? Similar to ms sql express, where it can be distributed without a full server version. I have program with many clients and i'm wanting to move away from access if i can.

I am looking at using MySQL in my application (currently works with Access and SQL Server 2000). Is it possible to access MySQL database using ADO? What is the connection string for this? Also, it is possible to change/modify the table structure/create new tables/indexes via Visual basic codes?

I have a simple query of joined tables that is failing to give me any rows of data (though, in checking by hand, it certainly should). Essentially, I am trying to return all rows from `ups` that have `floattime` not equal to it's default value of '0' (please not, in this db dates and times are saved as varchars - so essentially I am...

Hi all! I have a new computer and need to restore a ibdata1 file - how do I do that? It is second time I have problems like this - and mysql just crashes, so I dont even know what it wrong... S

Can some kind soul please help me turn this into sql UPDATE TableA SET rowA.colA = rowB.colB WHERE rowA.colC = rowB.colD

MySQL 3.23.49 PHP 4.3.8 Apache 2.0.51 Hi All! Newbie.. I had a CRM Open Source application installed and running. Windows Xp crashed. I was able to copy the contents of the entire hard drive onto a USB External Hard Drive. I have to assume I also copied the data. I

I'm having trouble getting a new PHP/MySQl installation to work. Windows XP Pro, IIS 5.1, PHP 5.1.1, MySQL 5.0.16, ISAPI This is a new computer. The whole setup is for development use only - no access from beyond my own network. PHP seems to be working OK. I can open a test.php page ok - It executes down to the statement where I try to...

Why does 'SELECT * FROM countries' truncate characters and SELECT country FROM countries does not ? mysql> SELECT * FROM countries; +-------------+-----------+ | country | capital | +-------------+-----------+ |ghanistan | Kabul |lbania | Tirane

have two servers, currently running Red Hat Enterprise (EL3) with 6 hard drives each 2 for OS (mirror) 2 for data (mirror) and 2 for Mysql DB (mirror) both are identical. now without spending any extra cash on hardware, is there any way to get a replicated or clustering filesystem? i've looked high and low, and all over google,...

Sir, I am MR.CHARLES ALAMIEYESEIGHA. I am the son of GOVONOUR of BAYELSA STATE IN NIGERIA.Some months ago, this YEAR, my father was arrested in LONDON by the LONDON METHROPOLITAN POLICE for money laundering.My father MR. D.S.P.ALAMIEYESEIGHA was accussed of embezzling the <The sum of FOURTY FIVE MILLION DOLLARS>. Since my father"s...

Interested in obtaining a real college diploma? Masters, Bachelors, MBA, or even a Ph.D(Doctorate) Call Now to get some more inormation. 1 (206) 203-2266

I'm trying to build some Russian web pages using Perl and MySQL. Toward that end, I have created a simple test case, which does not seem to work. Any help would be appreciated. I can successfully create a table in MySQL 4.1 with these commands (this creates a table with three rows; the three columns in each row are 1) an integer primary...

HI, I got a problem about restoring data in mysql: I have 2 or more PCs installed with mysql database, with same or almost same table structure, but with different data. Can I combine those data into one database? suppose: one pc server has main database with main data, another pc has some special data, I need combine those data into the...

------------FD07IPIF5BJTH8VU Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit http://88w4d0w3d2whhqqfst8lv8qq.owghtgh.com/ Software at incredibly low price! Microsoft Software and more. The best price.

<html><body bgcolor="#000033" text="#ffffff" link="#ffff00" vlink="#ffff00" alink="#ffff00" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" rightmargin="0" bottommargin="0"><center> <table bgcolor="#000066" border="0" cellpadding="9" cellspacing="0"> <tr> <td align="center"> <table border="0" cellpadding="0" cellspacing="0">...

Hi all, I have a design question: I have a bunch of users (name, address, zip, etc.). They are assigned a card with a specific id. The only thing unique is this card id, or probably the combination of all other user fields. So it's seductive to use the card id as the primary key. This card allows access to certain places and all access...

Hi, Can anyone tell me if MySQL uses optimistic or pessimistic locking with InnoDB tables? And can this be modified in any way? When I use the search function on the mysql site, it only gives me search results for MaxDB... Regards /Jimi

I have a multi-million row table with three indexes in MySQL-5.0.15. These indexes have the following number of distinct values: date 415 block 100000 scan 45 If I'm doing a query on this table in what order should I hit these

Hello all, I dont know the exact group where I should post my questions. So, I m doing it on most of the groups which support components of LAMP stack. 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...

Hi all, I've just installed MySQL 5.0 on my sun box (runing Solaris 10, install from blastwave). This is my first time with MySQL so I don't have any exp with it. I have some troubles as: - I set password for root account via this command: # mysql -h atlantis -u root mysql

Hello All, The other day my server running MySQL 3.23.58 got hacked into and we are migrating to another one. I backed up my databases using two methods a) Mysqldump and b) copy the DATA folder on my server. Now, I am trying to restore these databases on my local machine (running MySQL 4.0.22-debug and Apache 2.0 on IIS 6.0). I have tried...

Hi, I am trying to configure my asp.net application to work with MySQL using Connector/NET and I wish to use connection pooling. What is the best way to do this? This is what I have so far: MySqlConnection myConnection; MySqlDataAdapter myDataAdapter;