Re: regular backup database in mysql

hi i do this on windows2000 like that first I create directory Archive on local disk and in that dir some subdirs like mon,tue ... for every weekday then you should create ms-dos batch file e.g. back0.bat in root of disk c:\ and put commands in it: rem BACKUP mysqldump -h192.168.1.1 -uroot

Re: Table full with InnoDB

Well, it will NOT let me add more ibdata files: Any ideas?? Thanks, Spiros Here is hostname.err (On a 2GB RAM, 2x1000 CPU, ) InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 3

Re: [MANY to MANY] relationship with MySQL ???

I guess You could write Your query with JOIN statements to to get all information by one single query, not having to store things in PHP arrays. a simpe one could look like this... /* depending on what criteria is beeing used */ $match = artist.name = $submitted_artist; $match = songs.name

Re: Encrpt/Decrypt

Just want to add a few more things here that might spark your brain cells. All in all I agree with the suggestions presented. Use an encrypt function in your code, for something simple I've created a very basic encryption function in perl using Crypt::Blowfish modules and then I have control of

Re: Math Computations

I agree with the suggestion below strip the character and typecast it if necessary. In JSP I think you can convert it to a number and then typecast it. In PHP, I think the principles might be the same. In addition, it might be a good idea to restrict the columns that require computation to a

MySQL for Digital UNIX V4.0F (Rev. 1229) binary?

We have Digital UNIX V4.0F (Rev. 1229) and we will to run MySQL but only binary is for OSF 5.1 version. This isn't adecvate. Can anybody help us in compiling source or have anybody binary version (just compiled)? Txs -

Re: Installing....

Hi again, Th for the answer, but I still don't understand why do I get this error message. :( EZ mkdir .libs EZ gcc -O3 -DDBUG_OFF -O3 -mpentiumpro -felide-constructors -fno-exceptions EZ -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o EZ libs/mysql mysql.o

Help needed with indexes / optimising query

Heya. Firstly, appologies if this is the wrong maillist to send this too. I'm using a great request tracking software package called RT ( www.fsck.com ) , however my database seems to be a little larger than the ideal config for this system as its not scaling very well, i've tracked most of

Re: MySQL for Digital UNIX V4.0F (Rev. 1229) binary?

On Thu, 18 Apr 2002, Atila Hajnal wrote: We have Digital UNIX V4.0F (Rev. 1229) and we will to run MySQL but only binary is for OSF 5.1 version. This isn't adecvate. Can anybody help us in compiling source or have anybody binary version (just compiled)? I have a version 3.23.18 binary

Foreign keys

Hello! I have a problem: How can I find the FOREIGN KEY definitions for a table? I'm using MySQL 4.0.1 MAX, and I define the table as a InnoDB-table. Someone, pleace help me! Marius - Before posting, please check:

Migration from windows to linux

Hello list, I`m a newbie to mysql and linux and have at the moment a necessity concerning to both that I`m not able to handle due to my lack of knowledge in these fields. The fact is that I need to migrate a mysql database and its tables from windows to linux and haven`t found

Is there a function like for multiplying grouped values ... ?

Say, I have a table (simple case): +--+---+ |id|val| +--+---+ | 1| 10| | 1| 20| | 2| 5| | 2| 5| | 2| 10| +--+---+ SELECT id, MUL(val) FROM above_table GROUP BY id; I would get: ++---+ | id| MUL(val)|

Re: Is there a function like for multiplying grouped values ... ?

SELECT id, MUL(val) FROM above_table GROUP BY id; I would get: ++---+ | id| MUL(val)| ++---+ | 1|200| | 2|250| ++---+ ** I know there is now function MUL(), but is there anything comparable ? Nope, you

Re: Foreign keys

Hi! use mysqlSHOW TABLE STATUS FROM yourdatabasename LIKE 'yourtablename'; Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message

RE: a query from php doen't work

The problem was with the ; I ended my queries on each line (!!!) Not needed for only one query -one for every line. Thanks to you all and to those who send me prive Now runs on server too, only I had to change the filename to upercase.(Linux server) Makis -Original Message- From:

RE: Migration from windows to linux

* Sonia I`m a newbie to mysql and linux and have at the moment a necessity concerning to both that I`m not able to handle due to my lack of knowledge in these fields. The fact is that I need to migrate a mysql database and its tables from windows to linux and haven`t found anything in

mysql client issues

I can get safe_mysqld to run, but when I launch mysql I receive the error message listed below. Any thoughts what cause this issue would be appreciated. ++ E R R

Re: can't init my database for innoDB in mysql

Hi! You have not specified innodb_data_home_dir. Then InnoDB uses the MySQL datadir as the default home dir. But below you are putting absolute file paths to the last two data files: innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdata

AW: User Define Function

I'm having the same problem (Invalid Argument) at the moment. Did you find any solution ? Thanx -Ursprüngliche Nachricht- Von: Elteto Zoltan [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 16. April 2002 11:32 An: [EMAIL PROTECTED] Betreff: User Define Function Hi all, I need to

super-smack

I am trying to compile super-smack on a FreeBSD-4 systems. I have got some thing working but it sill not right. Running it gives me. %super-smack -d mysql select-key-mysql.smack 10 1000 super-smack: Unsupported database type Is my copy just broken? If so what is the best way to compile on

Re: AW: User Define Function

No I have not :((( And believe me I have tried several posibilities... I have on one mysql server such a setup and this works good. So I have made a hardcopy on that server and I have changed the startup paramaters. The only different thing is the database. after that comes CREATE

Optimization

Confucius say: Man who kisses girl's behind gets crack in face. Hi All ! I made a virtual stock exchange using PHP + MySQL. I'm not a programmer, so I don't know how well the sistem behaves itself when it comes to performance. Now, the project: 2 databases: stock players Tables

Re: C API

In fact, i'm trying to read data from a binary file and want to insert that into the database. I guess, it would be easier and more efficient if i use some data structure like we have vectors in C++ API. Thanks, Ritu Singla On Thu, 18 Apr 2002, Robert Cross wrote: you wrote: I want

Version

Anyone know about when will be available the new version of mysql? Alexander A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. - Before posting, please

AW: AW: User Define Function

I found one possible problem. I compiled the udf_exaple.cc with -shared etc. After that I did a ldconfig -l udf_example.so and got: ldconfig: ./udf_example.so is not a shared library I havn't found a solution yet. -Ursprüngliche Nachricht- Von: Elteto Zoltan [mailto:[EMAIL PROTECTED]]

replication and indexes

Hi, I am using replication only for backup. My original database (MASTER) is using quite a lot of indexes. Currently my SLAVE has all the indexes too. I wonder if I can safely drop them on the SLAVE in order to increase replication-performance on the SLAVE? Are there pros and cons? Thanks,

Re: mysql client issues

ld.so.1: mysql: fatal: libncurses.so.5: open failed: No such file or directory What kind of system are you using? Linux? Verify on your system for libncurses.so, it should be in /usr/lib. If you have that library on your system then check for library path Hisseine - Original Message

Installing MySQL via RPM on RH72 (Involves Compiling PHP)

Hi All having a problem with install for PHP. I am trying to compile using --with-mysql=/dir/name I used an RPM to install mysql. during configure I get an error saying that it can not find the header files for mysql. I have used '=/shared' and every directory where there is mysql and mysqld.

RE: LOOKUP

This set of responses is getting away from the original question. The lookup data type in Microsoft Access is not a data type at all. It creates a join with another table underneath the surface. If you try to implement this with ENUM and Alter Table you will destroy the existing data/ENUM

Pubs2/Pubs3 database

Hi All, I am trying to install the Pubs2/Pubs3 database that comes with Sybase on my machine for SQL training and query. 1) I am not really sure how can I do that. 2) I am not where can I get the database dump from. I have tried to email Sybase but I received no response!! Could you help

Newbie: Test for MySQL connection

Dear all, I don't know where to look for this information... Couldn't find it in the manual. How do I test whether a connection has been established so I don't need to open a new one again? e.g. MYSQL tmp; void f1(){ mysql_init(tmp); mysql_real_connect(tmp,...) } void f2(){

Re: Installing MySQL via RPM on RH72 (Involves Compiling PHP)

It isn't generally a good idea to install one piece by rpm and another by compiling and installing. A straight compile and install will put things in different directories from an rpm install. You will have a hard time making it all work. You can go with rpm or compiling from source, but be

Re: Newbie: Test for MySQL connection

Try shell cd YourMysqlInstallationDirectory shell bin/safe_mysqld shell mysql -h host -u user -ppassword Hisseine - Original Message - From: Fei Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 10:36 AM Subject: Newbie: Test for MySQL connection Dear all,

Re: Installing MySQL via RPM on RH72 (Involves Compiling PHP)

Jens and Jim Thank you, this helps alot. Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || Jim Philips | || jcphil@mindsp| ||

SELECT from blob column

Hello everybody, I know it has been covered before. I read the manual, I folow the examples, and I am still having problems. What I want is store a blob in a blob field, so: CREATE TABLE blobtest ( name CHAR(5), myblob MEDIUMBLOB ); Query Ok. INSERT INTO blobtest VALUES ( '1',

how to delete from one table based on external conditions?

hi, i would like to know how i can achieve this kind of query: delete form table1 where table2.x=table1.y I checked the manual, there nothing like that! Am using mysql 3.23.49 SQL SQL SQL SQL SQL _ Send and receive Hotmail on

MySQLDump

Hi; I can't get a dump of a database! I'm in as every user I have and get this: mysql mysqldump --databases nwhotspring a.a; ERROR 1064: You have an error in your SQL syntax near 'mysqldump --databases nwhotspring a.a' at line 1 I can't even run mysqldump --help without getting that error!

Re: MySQLDump

At 08:46 AM 4/18/02 -0700, you wrote: mysql mysqldump --databases nwhotspring a.a; BO ERROR 1064: You have an error in your SQL syntax near 'mysqldump BO --databases nwhotspring a.a' at line 1 BO I can't even run mysqldump --help without getting that error! What am I BO doing wrong? BO TIA, BO

Re: MySQLDump

From: Ben Ocean [EMAIL PROTECTED] I can't even run mysqldump --help without getting that error! What am I doing wrong? 'mysqldump' is a system command, not an SQL command. You need to run it from the command prompt. --- Rodney Broom

MySQL + JBoss

Has anyone out there tried using jboss with mysql? Any luck/problems? Thanks Sean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

RE: MySQLDump

Hi Ben, You need to run mysqldump command in the unix shell prompt, NOT in mysql shell. See: http://www.mysql.com/doc/m/y/mysqldump.html Gurhan -Original Message- From: Ben Ocean [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:45 AM To: [EMAIL PROTECTED] Subject: MySQLDump

Re: Changing international charset for ORDER by sorting

Webmaster33, Wednesday, April 17, 2002, 7:21:55 PM, you wrote: W Anybody knows how can I change the character set, when MySQL is running, W to be able to do ORDER BY using international strings? W I would need to do this without changing config, while I run my perl script. W I would need to do

Re: some good tutorial

Ashish, Wednesday, April 17, 2002, 10:01:24 PM, you wrote: AJ i have just joined the list and wanted to know something about mysql. AJ is there some really good tutorial you think might be good for a AJ starter in mysql. i am a master's student and have some knowledge AJ of databases like ms

Re: Foreign keys

Marius, Thursday, April 18, 2002, 11:43:38 AM, you wrote: MR I have a problem: How can I find the FOREIGN KEY definitions for a table? MR I'm using MySQL 4.0.1 MAX, and I define the table as a InnoDB-table. SHOW TABLE STATUS statement shows you foreign key constraints for a table, look at:

Re: SELECT from blob column

João, Thursday, April 18, 2002, 5:16:26 PM, you wrote: JPV I know it has been covered before. I read the manual, I folow the examples, JPV and I am still having problems. What I want is store a blob in a blob field, JPV so: JPV CREATE TABLE blobtest ( name CHAR(5), myblob MEDIUMBLOB ); JPV

Re: mysql client issues

john, Thursday, April 18, 2002, 12:50:14 PM, you wrote: jv I can get safe_mysqld to run, but when I launch mysql I receive the error jv message listed below. Any thoughts what cause this issue would be jv appreciated. jv

Re: RE: how many tables can I create with one created MySql database?

Roger, Wednesday, April 17, 2002, 6:54:29 PM, you wrote: RB * Egor Egorov RB 1) does this apply to InnoDb tables? Not quite, InnoDB stores tables in the tablespace, that may consists of several files.. RB Yes... but rarely one file per table... RB But what about the .frm files...? Are they

Error in mysql.server?

Hi, I'm about to try out mysql.server to automatically start/stop mysql, but am wondering if there might be a mistake in the instructions which say: # Usually this is put in /etc/init.d (at least on machines SYSV R4 based # systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/S01mysql. #

Re: sigwait problem in mysql -3.23.49 installation to openbsd 3.0 i386

can anyone help with this problem ? i looked mysql manual pages and also openbsd.. but still i cant get any information about this problem. please help me. On Thu, 18 Apr 2002 17:59:42 GMT Unknown wrote: i try to configure mysql 3.23.49 with command line --with-client-ldflags=-all-static

How to start MySQL in Solaris8

Hi all, I just downloaded MySQL package from SUN website and installed it on my unix machine which runs Solaris8. How do I start MySQL in Solaris8? If I need to create a new account to start it then how do I create a new account? Thanks, David

Re: Changing international charset for ORDER by sorting

I understand. Bad to hear. :-( I think there would be important to implement features to be able to set different character sets for each table, or to change character sets dynamically without the need to restart MySQL server. This would be especially important for the ORDER BY string

Re: SELECT from blob column

I have found LOAD_FILE has to be used in an update statement. So to insert a row that includes a blob such as your example you would have the following two statements: INSERT INTO blobtest (name ) VALUES ( '1'); followed by: UPDATE blobtest SET myblob = LOAD_FILE('/root/.profile') WHERE name =

FW: Mysql unresponsive ....

Since I didn't get any response (like mysql server) I am sending it again. thanks Vivek -Original Message- From: CHAUDHARY, Vivek Sent: Wednesday, April 17, 2002 3:34 PM To: '[EMAIL PROTECTED]' Subject: Mysql unresponsive Hi all, Last friday we found that mysql was

BSD: Random unknown database error

All: Recently I've run into a problem where I intermittently receive an Unknown database error while attempting to communicate with a local MySQL server. I read through the mail list archives and discovered that others reported similar problems under BSD, but I didn't see any concrete solutions.

Grant User Persmissions

Hello, Is there any way to grant a user only SELECT permissions on a set of tables in MySQL, but to also allow them to have CREATE, DROP, and INSERT on the Database itself?? What I want is a database where the users cannot modify the core tables, but I want them to be able to CREATE and DROP

MyODBC arrrgghh!

Alright, I'm feeling pretty clueless on this one. I've downloaded and installed MyODBC. I am trying to go from my local WinXP to my database on a unix/apache webserver. (I want to use CodeCharge to build a site). I have asked my ISP to grant remote access and he says he has. I can access from

insert french accent with java

Hi, I want to insert into the Mysql db some text containing French Accent. If I do this using the console (mysql), it work fine. But if I try the same query via Java and JDBC, I loose the French accent. They are replaced by '?'. Any idea ??? Thank a lot

RE: MyODBC arrrgghh!

The mysql.user table requires an entry corresponding to user@IP/hostname corresponding to the XPwkst w/ODBC. -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: MyODBC arrrgghh! Alright, I'm feeling

RE: how many tables can I create with one created MySql database?

* Egor Egorov RB Are you saying that the mysql server will need to open all the tables in a RB database at the same time? When does this happen? When I issue the USE RB command? Roger, number of opened files is not the same as number of files in the directory. When table is created, MySQL

Lock databases

Is there a way to Lock all databases for a couple of minutes and then resume. I don't want to run mysqldump for a backup. I have another utility that I will use to take a snapshot of the databases at that instant and it might take a minute to run so thats way I need them locked.. --

How to build mysql on HP-UX 11.x with GCC 3.0.4

Please help...I'm ready to give up. I cannot get mysql.3.23.42 built on HP-UX 11.x. I'm using gcc 3.0.4 because I cannot find a gcc 2.95.3 or 2.95.2 binary version for HP-UX 11.x anywhere (most of the links I've tried don't work anymore). Here was my configure: CC=gcc CFLAGS=-march=1.1 -DHPUX

RE: MyODBC arrrgghh!

Here's the basics for MySQL database access (seven lines total: use mysql; create database myDB; insert into db values ('myHOST.myDOMAIN.com', 'myDB', 'myUSER', 'Y','Y','Y','Y','N','N','N','N','N','N'); insert into user values ('localhost','myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y',

RE: MyODBC arrrgghh!

Your workstation is 192.168.1.101: insert into user values ('192.168.1.101', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); Allow class C network access with: insert into user values ('192.168.1.%', 'netUSER', Password

Help! With sql date type

Hello, I would like to add a date column to my sql database table that auto-increments the date's week field by 2 weeks for every entry. I have set up the mysql database table to automatically take entries for ad submissions and I want to timestamp each entry with the calculated date. Is this

RE: MyODBC arrrgghh!

Well go figure. Seems like our firewall is blocking things. Guess I'll have to run local for development. Thanks for your help. Andrew Hazen -Original Message- From: Land, Christopher [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 3:12 PM To: [EMAIL PROTECTED] Subject:

Re: Help! With sql date type

A timestamp-datatype automatically updates itself with the current date if the row has changed, so, in this case timestamp is not the preferred datatype. As far as i know, in MySQL Procedures are just for output, Triggers are not implemented...Only method would be to insert this field using

table-building advice requested

Hello, I was hoping to solicit some advice on the structure of the database I am building. Here is a simplified version of my scenario: The application that I am designing, in PHP4.1.2 with MySQL (3.23.46 on RedHat 7.2), has a feature which allows it to keep track of graphics files (JPGs,

SQL-Statement Near

Hi List, I am using MySQL MAX 3.23 on a SuSE Linux System. But my problem is about SQL: Is there a in the near of my result statement that returns the surrounding rows, e.g. SELECT name FROM names WHERE name=foo NEAR(-2,2) which results: ann marie foo bar john? I know, if my keys would be

Re: SELECT from blob column

Well, I found that I can use LOAD_FILE in INSERT statement, and I foud that my text file should be finished with a newline char :( . Well... never mind. Just another question : If i use PHP fread and got all the content of a file in a single var, can I just INSERT the variable ? sql -- João

Re: Lock databases

On Thu, Apr 18, 2002 at 12:54:47PM -0600, Kory Wheatley wrote: Is there a way to Lock all databases for a couple of minutes and then resume. I don't want to run mysqldump for a backup. I have another utility that I will use to take a snapshot of the databases at that instant and it might

Re: super-smack

On Thu, Apr 18, 2002 at 12:09:40PM +0100, Simon Green wrote: I am trying to compile super-smack on a FreeBSD-4 systems. I have got some thing working but it sill not right. Running it gives me. I built it on FreeBSD (after some code changes) about a year ago. Lemme see if I can dig it

Large Index's Fail

Okay, this may well be a LINUX issue I am having, so be kind before you flame. When I try to index a large file, it fails with a write error on the /tmp directory. Now my /tmp directory is on a smaller partition (as sent to me by dell). Can I configure MySQL to use a different area when

Renaming database

Is there a sanctioned way to rename a MySQL 3.23.x database, consisting of MyISAM tables? Thanks, MH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: SELECT from blob column

Well, I found that I can use LOAD_FILE in INSERT statement, and I found that my text file should be finished with a newline char :( . Well... never mind. Would you give an example please? -Grady - Original Message - From: João Paulo Vasconcellos [EMAIL PROTECTED] To: [EMAIL

Re: AW: User Define Function

Hi, You have some problems with the MYSQL LIBRARY PATH.(Check in the /etc/ld.so.conf file) You don't have link to some mysql libraries when you compile the source file. Try to copy all mysql libraryes in /usr/lib. ...or...if you find out what libray is missing, try to add -l namelybrary and after

Automatic Startup of mysqld in Mac OS X

I am having real trouble trying to get mysqld to start automatically when I restart my Mac OS X or Mac OS X Server systems. I am reading the MySQL document, chapter 2.4.3, and have tried many different approaches. I can get mysqld to start manually from the terminal window, as follows su

RE: How to build mysql on HP-UX 11.x with GCC 3.0.4

I've made some progress - I eliminated the problem with the socket header file by changing the CFLAGS and CXXFLAGS to include: -D_XOPEN_SOURCE_EXTENDED -D_HPUX_SOURCE -D_INCLUDE_HPUX_SOURCE -D_INCLUDE_XOPEN_SOURCE_EXTENDED But I still get the following error: Making all in libmysql_r gmake[2]:

Re: SELECT from blob column

In Thursday 18 April 2002 17:56, Grady Drago wrote: Well, I found that I can use LOAD_FILE in INSERT statement, and I found that my text file should be finished with a newline char :( . Well... never mind. Would you give an example please? If you do : $ cat test.file Some text. ^D $

Re: AW: User Define Function

...sorry...i didn't read the previus e-mail to the finish i saw only : ERROR 1126: Can't open shared library 'udf.so' (errno: 22 udf.so: cannot - Original Message - From: Elteto Zoltan [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April

Re: Automatic Startup of mysqld in Mac OS X

Yes. Look in this months digest. There is a thread about this. -RG On Thu, 18 Apr 2002, Jimi Oleksiak wrote: I am having real trouble trying to get mysqld to start automatically when I restart my Mac OS X or Mac OS X Server systems. I am reading the MySQL document, chapter 2.4.3, and have

error during configuration

Trying to configure mysql 3.23.49 on Solaris 8, and I got the error: checking return type of sprintf... configure: error: can not run test program while cross compiling. The last lines of the config.log are: ltconfig:603: checking for object suffix ltconfig:604: gcc -cconftest.c 15

How to upgrade/migrate Mysql Server

Mysql Gurus, We are currently using Mysql (3.22.32) on a Solaris platform. We are looking to upgrade/migrate this current version to 3.23.49a, for utilizing the replication functionality. I would appreciate if anyone can clarify the following: 1) Any known/unknown issues with 3.23.49a 2) What

Mysql Error while starting up

Has anyone encountered the following error, while starting the mysql daemon as a user other than root. Can't create IP Socket: Permission Denied I do not encounter any problem when running the same as root I have checked the permission on /datadir /basedir /tmp, they seem to be OK. Thanks

Re: Mysql Error while starting up

At 17:01 -0500 4/18/02, Sridhar Peddireddy wrote: Has anyone encountered the following error, while starting the mysql daemon as a user other than root. Can't create IP Socket: Permission Denied I do not encounter any problem when running the same as root I have checked the permission on

Re: Automatic Startup of mysqld in Mac OS X

Here is a link to an installer that will install the needed parts to cause MySQL to start on restarts of the computers. http://www2.entropy.ch/download/mysql-startupitem.pkg.tar.gz On 4/18/2002 2:33 PM, Russell E Glaue [EMAIL PROTECTED] wrote: Yes. Look in this months digest. There is a

Help for MYSQL installation

Dear Sir/Madam, I downloaded the latest mysql-3.23.49 and wanted to install MYSQL in my FreeBSD 2.2.7 OS. The configuration (./configure) and Make both went smoothly, but it failed when I installed (make install) and here is the error message: -- mv -f .libs/get_password.lo get_password.lo

vio_is_blocking?

What is vio_is_blocking and why would it cause a client to crash? This is with MySQL 4.0.1 on OS X. It did appear that my connection stuttered right before the crash (or during). I was not at the computer at the time. Exception: EXC_BAD_ACCESS (0x0001) Codes: KERN_INVALID_ADDRESS

RE: how to delete from one table based on external conditions?

Try delete table1.* from table1 inner join table2 on table2.x=table1.y You may not need the .* in table1.* but I know it works with the .*. delete table1.* from table1, table2 where table2.x=table1.y From the manual 6.4.6 DELETE Syntax DELETE [LOW_PRIORITY | QUICK] FROM table_name [WHERE

Really big text - where to get?

Hello developers, When you write another MySQL-based search engine, you obviosly test it issuing queries against big amounts of data which contains more or less sane text. Tell me, where (or how) you usually get the text when you need, say, 10GB of it and, I repeat, it should be a REAL

Downgrade

Are there any steps I need to take to ensure no corruption of the database if I downgrade from say 3.23.49 to 3.23.48 Thanks, Dave query,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual)