MySQL Database Forum

Hello, I have ran a script in which I created a temporary table and dropped the table at the end of the script. Unfortuantely not only was this table dropped but all of the other tables in the database were dropped as well. Unfortuantely, the backups are made every day at midnight. So all of the information for the past 23 hours has been...

Hi there, What is big for a MYSQL DB. E.g. I am working on someone elses DB that has a many-many link table that notes what emails are sent out to what users. Therefore each time a message gets sent out from this application, if it got sent to 500 users for example, 500 rows would be added to this table. If the amount of users was...

Help, I have a query in MySQL which gets the details of members of a club. e.g. Select * from members. however, in the same query I want to return the amount of "functions" the member has attended. therefore there is a "functions" table and because functions has a

I just installed Slackware 10.1 Still need to install some missing needed libraries, but I think that's unrelated. Every time it boots up, or I try "/etc/rc.d/rc.mysqld start" I get this: Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysql/mysql.pid mysqld ended

Hi All, can u plz tell me how to import data from mysql to another database. & how to export data from anotherdata base to mysql Thanx for ur Advice Regards Kajol

Is there a way to create a MYSQL table or database using a text file that countains the Field name and the lenght ? that is : fields.txt ----- start ---------- name,10 address,15

We use the MS access database, I want to convert the database to mysql db , could suggest is there any tools / methods that I can export the table and data from access , and import it to the new mysql db ? thx in advance.

I've made a mysql database with php front end which, in part, contains mailing lists. I've used a mailto: link to create a new email with their names in the bcc: field. Unfortunatley their is a limit on the size of a mailto: field that outlook can accept, and so it can't be used to mail more than about 80 people at a time. Our lists go up...

Hi All, I am using server version: 4.1.11-nt on windows 2000. I want to create a table with ID as auto increment and initialise it with a starting value of 1000. I am trying to do following DROP TABLE IF EXISTS `demo`;

I'm running MySQL 4.1 under Linux. I need to have a MyISAM table with more than 4G rows of data. I've read the manual regarding the MAX_ROWS option on tables. This table has a fixed row length, with 17 bytes per row. MySQL simply won't set the ROW_LENGTH greater than 4G. When I use an ALTER TABLE to set it higher, it acts as though it...

Hi! I recently got a strange problem and I have no idea on the solution. I try to do a ORDER BY statement with a fixed order of values, because my client want's it this way. My approach is like this: $the_row = "'A', 'B', 'B b', 'C', 'D d', 'E'";

When I run select now(); or select current_timestamp(), I see the output like "2005-04-19 02:50:14". By reading the documentation I thought the the hour value should be in military format namely 14, but instead I see 02. How can I fix this problem? I have MySQL 4.1.10a database running on RH 9.0 server. Thanks, Yasaswi

Hey there, I would like to execute the following query to perform deletes. Unfortunately it only returns a list of the delete queries without actually performing them. How can I get the deletes to be executed? I am running MySQL 4.0.20-standard. $query = "SELECT concat('DELETE FROM temp WHERE prodid = \'',prod.ProdID, '\';') AS '' FROM...

Hi when I read the documentation about how the query it's doesn't clear my mind about how it can optimize db quering. When I include a SQL_CACHE clause in a query, does the datas are stored in memory or not ? If for exemple I've a series of queries : SELECT FROM WHERE SELECT FROM WHERE

Hi, I am new to MySql and I want to practice querying by playing around a relatively large and complex database without having to enter all the data myself. Is there a publicly available MySql database on the internet which I could download? (the "world" database on the MySql website is really to simple to be useful). Of course, it would...

I have installed MySQL under Linux and it's now running... I have created a DB and a few tables and populated them... How do I query the tables now ? I have enter SQL statements at the command prompt however some are quite complex and surely don't have to be reentered every time ? I found a package called "query browser" but to date...

Hello: Can i update a MySQL database with just copy the files MYI MYD and FRM in the right dir? I know this work. The question is how MySQL manage the user that are usig that database in that moment. Can i close all the connection to that database? How can i tell MySQL deamon that don´t use that database any more? Thank you in advance.

As my other post shows, every once in a while I get MYI corruption (anyone can help with the other post?). Now, how do I emulate MYI corruption on the dev machine. Can I somehow force MYI to become corrupt, how? Dev machine is Windows, deployment machine is Linux. -- Posted using the http://www.dbforumz.com interface, at author's...

I run some large databases on my Linux server, and every once in a while the MYI files get corrupted. Can someone tell me the probable causes of MYI corruption, and how I go about diagnosing/fixing the problem. -- Posted using the http://www.dbforumz.com interface, at author's request Articles individually checked for conformance to...

Hi all! For a match schedule I would like to find all possible combinations of teams playing home and away (without teams playing to themselves of course). I now the simple version works something like this: For a (very) simple table containing three rows like this: row 1: A

M. Michael DYSON DIRECTEUR-ADJOINT SOCIÉTÉ DE SÉCURITÉ SARL. TEL.00229 20 21 80 Cotonou République du Bénin Email:michaeldyson2005@latinmail.com Bonjour . Je sais que mon message sera d’une grande surprise quand t-il vous parviendra. Donc, je vous présente toutes mes excuses. Je vous écris sincèrement dans le but d’obtenir votre...

I have the following table: id | supRef | pmRef | status | ===================== 1 | 1 | 1 | 3 | 2 | 1 | 2 | 2 | 3 | 1 | 3 | 2 | 4 | 1 | 4 | 3 | 5 | 2 | 1 | 2 |

Download MySQL Auto Backup at http://www.swordsky.com to help you. Backups your data automatically from MySQL Database Server Don't worry about your data on MySQL anytime. They will not to be lost because I am running! Powerful data backup function Powerful task scheduler Various auto-run time options

What I want is fairly simpel, but I can't figure it out. Problem: Select the article (the articles) with the highest price for each article group. table articles --------------- id=1, description='article1', price=100, articlegroupid=4 id=2, description='article2', price=200, articlegroupid=5

I am getting this error message when trying to use prepared statements. My code is: /* mysock is an opened MYSQL* connection */ char *querystr = "SELECT * FROM foo"; MYSQL_STMT *stmt = mysql_stmt_init(mysock); /* returns non-null */ if (mysql_stmt_prepare(stmt, querystr, strlen(querystr)) { /* error */