MySQL Database Forum

Hi, I am using MySQL version 5.0 on Linux Fedora Core 4. I recently got this error message: 060609 11:06:29 InnoDB: ERROR: the age of the last checkpoint is 9433557, InnoDB: which exceeds the log group capacity 9433498. InnoDB: If you are using big BLOB or TEXT rows, you must set the

although i don't think this is do-able using SQL, i would ask and maybe an expert can help me out. assum i have the following table: Date Code Count 2006-06-06 abc 1234 2006-06-06 abc 14 2006-06-06 abc 87 2006-06-06 xyz 1353 2006-06-06 xyz 19 2006-06-06 xyz 86

I'm trying to migrate a Wiki database to another server. I have zero problems backing up the database using multiple methods. But the Mysql restore fails with: ERROR 1064 at line 52: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP on...

Hi I have a strange problem with a mysql database and ASP. I try to retrieve a value from a table I have just created with a very simple sql statement. Ex. SELECT myValue FROM myTable WHERE userID = 'myName' If I type the query in mysql-front it works fine but if I execute it

hello, I have listings with coordinates, i would like to do ORDER BY and display listings with coords first. If they don't have coords the value is blank and the coords go both positive and negative values. So i tried an "ORDER by l_xcoord HAVING l_xcoord<>0" but this is acting like a WHERE statement removing all results with no coords. I...

Having some major issues... Racking my brain. Also it is worthy to note as of 3 weeks ago i have 0 experience with MySQL. So anyway.. HOW DO YOU DO IT?? hehe - I can get multiple services installed and started, but everytime i try to make any edits to them and stop/restart they wont restart. here is my exact .ini file. ...

Hello... Can somebody here help me... I am using the replace function: replace('China and china','china','Hong Kong'); I want to ignore the cases as I compare the strings... How am I suppose to do that? Please help... thanks...

can I put parameters into a view? example CREATE VIEW `dmz_sms`.`vwProva` AS SELECT * FROM tb_sms where id=@ID; I get error 1351, but I don't believe mySql don't allow parameters into views!!!

I am using a simple delete statement in my php script (below) $q = "DELETE FROM commenttype WHERE TypeID=".$_POST; the problem is it doesnt delete the whole row it only deletes the text in one of the fields of the row. Has anyone else had a similar problem? It works when I run the sql directly from a program such as mysqlphp ian

Is it possible to have a dynamic table name within a query or a table name that is a variable? This does not work but gives an example: SELECT * FROM concat('table', 'name') - OR - SET @table = 'a'; SELCT * FROM @table Of course the query can be constructed dynamically but does not exactly

I am using mysql and have some data in my application in the latin1 charset. I have a necessity to support the utf 8 charset. Now I want to migrate the data between these two charset. The normal way I do migration is as follows: Taking a dump of the data with the currently running mysql converting the necessary parameters in the mysql...

Hi, We are in the process of setting my mysql replication on mysql ver 4.1.18. However we have noticed an odd bug that occurs every so often. Every hour we issue flush logs to mysql so that we can move the bin logs to our backup server. In our mysql logs we notice the following; 060526 12:00:02 Failed to open log (file...

Hi people, I've looked around but have not been to find an answer for my question. I'm looking to force a length of 4 on an integer field. Example if the field contains an 11, I would like to show it as 0011, or a 9 to show it as 0009. What do I need to do? Thanks in Advance. John

Hello, I am trying to turn on General logging on mysql server . If I go >mysqld -l filename on shell, it says "command not found". What is the best way to create General log on a live server. Somehow MYSQL server doesn't have a my.cnf file. I have searched all over but there are no signs. Whenever I have to start/stop/restart the...

I havea timestamp field in a table which shows the timestamp of the last update or insert to a given row. Is there a way to temporarily turn that off, such that I can update a row withOUT affecting timestamp? Thanks, Ike

I am using MySQL 5.0 with a number of innodb tables whose ibdata files are growing quite quickly and filling up the /var partition (file is /var/mysql/ibdata1). Earlier on I followed instructions in the docs to create a new ibdata file on a bigger partition /disk2/var/mysql/ibdata2) and set that to autoextend instead. However I would like...

Hi there I am an Access developer, and I have written applications for a 30 telephone call center, using the standard multiuser jet engine, it all works fine, but I want to move our systems onto MySQL, as we get the odd #DELETED# (that old chestnut) so that it is more stable, I have installed mysql and myodbc and configured it in data...

Hi there, Is there a way to list the TEMPORATY tables? I have tried SHOW TABLES, but this command only list the regular tables. Thank you very much for your answer. Regards, Stefan.

I am using a MySql database for chat application. Every 3 seconds the database is searched for various details. I would like to know How many individual can it handle at a time. Say there are 6 users each making a call in 3 second So every second 2 connections are made to database.

About to develop an asp .net site on a windows 2003 server. I am using Visual Basic .net 2005 to constuct the site. What type of connection to mySQL should I use - e.g. ODBC or mySQL's .net connector? Thanks in advance, JJ

Hi All, Just starting out here and setting up several e-commerce sites on a windows 2003 server/IIS with asp .net 2.0. I will be developing the pages on Visual Studio 2005 Pro. My questrion is: BINDING - I have read it is not advised to bind your web controls to you datasource's especaiily when writing applications that will be quite...

I'm trying to understand why MySQL isn't using all parts of the primary key when I add in an OR statement in the query. I have a people database, and a distances database. The people database lists a person's name and their location, the distances database contains the distance between any two points in the country. There are an roughly...

I'm building a dynamic site that has 3 data bases. One DB contains all of my store info ID#, Name, Address, Phone. Another DB contains member info ID, Name, address, email,phone,etc... The 3rd DB Tracks when a user logs in and logs out at a store. This DB has the following columns Store ID, Member ID, log in time,log out time, time in...

Hi there, I have Orders and Payments. Sometimes the Orders do not have Payments. So, I decided to use LEFT JOIN. Furthermore, some Orders have 1 related Payment, and some Orders have 2 or even more related Payments. Now, I want to combine the sum of all Payments and the last Payment in one row. select Orders.SeqNr,

For some bizarre reason, each time I insert or update a row in my table `image`, the field value for "image_width" is fixed at 127, no matter what value I use! Here is the schema: CREATE TABLE /*! IF NOT EXISTS */ image ( id int not null auto_increment, primary key (id), image_path varchar(255) not null,