Re: MySQL/InnoDB Hot Backups - What's a "binlog segment?"

Steve, - Original Message - From: "Orr, Steve" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 3:27 AM Subject: RE: MySQL/InnoDB Hot Backups - What's a "binlog segment?" > Thanks Heikki, > > I knew about the binlogs but tha

possible to add a record number to a query?

I would like to have a column returned in a query that tells you which record I'm looking at? Sort of like an auto_increment? IOW, the query results would look like: record first last 1 johndoe 2 joe blow 3 carol fisher The table only has first and last, but

Re: how to increase max connections above 1024 in Linux

On Thu, 13 Jun 2002, Patrick Hsieh wrote: > Hello, > > I want to raise the max connections in mysql. Due to the linux limix > thread limitation, I can only increase the number to around 1024. How > can I break the limitation? This is topic of glibc (assuming you are using kernel 2.4 at least).

Re: mysqlaccess

On 13 Jun 2002 at 7:25, [EMAIL PROTECTED] forced electron flow into: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just rep

Design: General DB Question

Greets Folks, Are there any good online tutorials for DB design in MySQL? I'm not necessarily interested just in the programming per se, but in DB design theory in general. Thanks! =) Will _ Get your FREE download of MSN Expl

Re: creating a relational database: how to plan?

check out this article and try a google search for database normalization. http://www.phpbuilder.com/columns/barry2731.php3 when you have a better idea - try the list with your questions. These 4-5 page articles will definitely help you out. olinux --- David T-G <[EMAIL PROTECTED]> wrote

RE: [Fwd: Studying mysql]

In addition, does your apache's "DocumentRoot" point to the correct directory where your .php files are being housed? The default setting is at "\var\www\html". Also run phpinfo() to check your php settings. best regards, >>> Neville Lewis <[EMAIL PROTECTED]> 06/12/02 03:06PM >>> seems to b

Re: Autocommit

You're right Serge, there should be a global option to allow you to set AUTOCOMMIT to 0. InnoDB is used for transactional paradigm, so it's obvious you watn to do yourself the "commit", this should be the default behavior for transactional tables. If you get the answer to this problem plea

Permissions -- After grant all on *.* to admin@localhost ---> I got access denied

Hi, I added a table to my phpnuke database, all connections to this db work perfectly, except this custom table, it gets data from a form. Before I was using it just to show data was succesfully retrieved, and it was working now I added these lines: TIA, Rick -

how to increase max connections above 1024 in Linux

Hello, I want to raise the max connections in mysql. Due to the linux limix thread limitation, I can only increase the number to around 1024. How can I break the limitation? -- Patrick Hsieh <[EMAIL PROTECTED]> GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg

MyCC 0.8.4 released.

Hi! MySQL Control Center (MyCC) 0.8.4 alpha has been released. MyCC is the new GUI client developed and provided by MySQL AB which is a platform independent MySQL administration client based on Trolltech's QT toolkit. Currently Linux and Windows are supported. MyCC 0.8.4 is a bugfix release. MyC

Re: ACCESS to MySQL

look for a program called DBTools, best in it's category for this kinda thing. - Original Message - From: "Ahmed Farouk" <[EMAIL PROTECTED]> To: "César Aracena" <[EMAIL PROTECTED]>; "'MySQL General'" <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 7:06 AM Subject: Re: ACCESS to MySQL

Re: undefined symbol: _dig_vec

very likely, /usr/local/lib is not in your library path. you could either create a symbolic of libodbcinst.so.1 under /usr/lib or configure /usr/local/lib/ using ldconfig. Hoa Doan wrote: > > So I ldd /usr/local/MyODBC/lib/libmyodbc.so and this is the result: > > libodbcinst.so.1 => not found >

Re: undefined symbol: _dig_vec

You will have to get libodbcinst.so.1. This library file is needed by libmyodbc.so. You should be able to download it from the net. Here is one link that might help http://www.slac.stanford.edu/grp/eg/minos/external/installation/lib/libodbci nst.so.1 - Original Message - From: "Hoa Doan" <

aix 4.3.3 and mysql

I found a version on the UCLA server that is compiled correctly and seems to be working on 4.3.3 - if anyone else is having problems with the downloads on the mysql site - try this one: http://aixpdslib.seas.ucla.edu/packages/mysql.html -

Re: undefined symbol: _dig_vec

So I ldd /usr/local/MyODBC/lib/libmyodbc.so and this is the result: libodbcinst.so.1 => not found libz.so.1 => /usr/lib etc... I did a find on libodbcinst.so.1 and found it in /usr/local/lib. What do I do from here? Hoa >From: Bhavin Vyas <[EMAIL PROTECTED]> >To: Hoa Doan <[EMAIL PROTECTED]>

Re: Installation Help

Stephen: The *best* help for the kind of questions you have is in the MySQL Manual. Gerald Jensen - Original Message - From: "Stephen Brown" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 8:22 PM Subject: Installation Help I am installing MYsql under linux

Installation Help

I am installing MYsql under linux and need some one on one help if somoeone is willing.. Thanks, Stephen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Help Optimizing Query...

I need help optimizing the query below. I've included the query, the table declerations, and the output of explain. Any help would be greatly appreciated. What I'd really like is to find out how to get it to use a key on the lineitems table. I've tried adding indexes on the OrderID and MerchantID

Installation Help

I am installing MYsql under linux and need some one on one help if somoeone is willing.. Thanks, Stephen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Auto-increment across multiple tables / Atomicity of updatestatements

Hi Andy, On Thu, 2002-06-13 at 05:02, Andy Sy wrote: > I want to use an auto-incrementing value that works > across multiple tables. For example I have 3 tables > forumA, forumB, forumC, each of which has a primary > key field called 'msgnum'. However, if I declare > 'msgnum' auto_increment,

RE: MySQL/InnoDB Hot Backups - What's a "binlog segment?"

Thanks Heikki, I knew about the binlogs but that "segment" word confused me. Now if I may "pester" you with 2 more questions... :-) Quoting... "From the binlog segment you see if any of the .frm files changed between the moment you took a .frm files backup and the moment ibbackup finished its

Re: table is read only when DB copied from Win to UNIX

Don't copy the physical files. Use mysqldump and mysqlimport instead. Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From: "Francisco Reinaldo" <[EMAIL PROTECTED]> To: "Tonu Samuel" <[EMAIL PROTECTED]> Cc

Re: ACCESS to MySQL

just connect to Access using the odbc driver, then pull data from Access and through it into MySQL, that's it :) Ahmed - Original Message - From: "César Aracena" <[EMAIL PROTECTED]> To: "'MySQL General'" <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 10:04 PM Subject: ACCESS to MySQL

MySQL Statistics

Hi All, some body knows mysql statistics: # Programers in the world # sites with MySQL database # Companies to support MySQL # sites in with MySQL database Thanks for your help Mario - Before posting, please check:

Re: table is read only when DB copied from Win to UNIX

Thanks for the tip but I have added to the table db in mysql database full permission for everybody to that database. I don't think that is a permission thing because when I add a new table, I can insert data into that new table. Besides it does not happen when I copy the database from UNIX to Win

Re: undefined symbol: _dig_vec

if you have the file /usr/local/MyODBC/lib/libmyodbc.so, then do ldd /usr/local/MyODBC/lib/libmyodbc.so and see if all the dependencies are satisfied. Regards, Bhavin. - Original Message - From: "Hoa Doan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 11:52 AM

table is read only when DB copied from Win to UNIX

Hi, I have an installation of MySQL in Windows and another one in UNIX Solaris 2.7. I need to move the databases across system and I have manually ftped a database directory from the Windows MySQL to the UNIX MySQL. Fine, I can see the database, show tables works, selects works. The whole nine y

Re: Irritating Discovery

Paul DuBois wrote: > > At 13:12 -0700 6/12/02, Van wrote: > >Greetings: > > > >Perhaps a bug, even. After about 5 months my mysql log file grew to over > >300MBytes and I figured I'd do something about it as follows: > >tail -n 10 /mysql/why.log > /tmp/why.log && sudo mv /tmp/why.log > >/mys

Re: max_connections

Ok. I think I can say nevermind. There must have been something wrong with my script. Either that or the server must have actually been down/inaccessible. I tried it again, and it seems to work now, even with the host being blocked from accessing mysql (it still manages to connect before it g

Monitoring locks

Candice Bostwick ([EMAIL PROTECTED]) Database Specialist (http://waterdata.usgs.gov/nwis) USGS - National Center Reston, VA 20192 (703) 648-4878 __ We are using MySQL 3.23.42 and having some difficulties with locks. I was wondering if anyone out there has written any neat mo

RE: Sort search results by relevance

This is a new area for me, so it may sound like a stupid question, but what do you mean by FULLTEXT indexes? P.S. the field I am searching is of VARCHAR type. Nick Boldt Computer Network Administrator Track of the Wolf Elk River, MN 55330 Tel: 763-633-2500 Fax: 763-633-2550 www.trackofthewolf.c

Re: Irritating Discovery

At 13:12 -0700 6/12/02, Van wrote: >Greetings: > >Perhaps a bug, even. After about 5 months my mysql log file grew to over >300MBytes and I figured I'd do something about it as follows: >tail -n 10 /mysql/why.log > /tmp/why.log && sudo mv /tmp/why.log >/mysql/ && >mysqladmin -u root flush-lo

Re: Sort search results by relevance

Also, this might help http://www.mysql.com/doc/F/u/Fulltext_Search.html - Original Message - From: "Nick Boldt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 12:49 PM Subject: Sort search results by relevance > I have created a search page which shows all rec

Re: Sort search results by relevance

Are you using FULLTEXT indexes on the search coloumns? They will sort results according to relevance (depending upon the algorithm, that might not be what you want). It will index most of the relevant words in your column (which should be a TEXT or a VARCHAR field) and then search on those words.

Re: help with mysqlhotcopy

> I was wondering if someone could help me out with the syntax to use > mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've > tried a few variations of the command but with no luck so far. The > mysql server is running on RH 7.2 and the DAT tape drive is on that same > machine

Re: MySQL/InnoDB Hot Backups - What's a "binlog segment?"

Steve, the binlog is the MySQL logical log which it writes if you specify [mysqld] log-bin in my.cnf. They are the files called 'hostname'-bin.00x in the datadir of MySQL. They contain all INSERT, UPDATE, etc. SQL statements in an almost human-readable form. The binlog is used to recover from

Re: max_connections

If you are just doing a port scan, that shouldn't be a problem. However, if you are going to the DB server, you will need to grant at least 'usage' permissions to user@host via the GRANT statement. Regards, Bhavin. - Original Message - From: <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECT

Re: ORDER BY date DESC

Never mind ... I made a mistake in the SQL statement !!! :-) Son Nguyen --- Son Nguyen <[EMAIL PROTECTED]> wrote: > mysql> desc albums; > +-+-+--+-+++ > | Field | Type| Null | Key | Default| Extra | > +

migrating user accounts

Hi, I have been watching the list for a while now as I get to know MySQL. I must admit that it is one of the more vibrant communities I have encountered. I have seen many good answers and even better questions, but I haven't seen my particular issues come up. I have two questions, one spec

help with mysqlhotcopy

I was wondering if someone could help me out with the syntax to use mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've tried a few variations of the command but with no luck so far. The mysql server is running on RH 7.2 and the DAT tape drive is on that same machine. Any

ORDER BY date DESC

mysql> desc albums; +-+-+--+-+++ | Field | Type| Null | Key | Default| Extra | +-+-+--+-+++ | album_ID| int(11) | | PRI | NULL | auto_increment | |

Re: ACCESS to MySQL

Has anyone tried before to import data from an Access Table to a MySQL Table? Actually, I just need to insert some of the columns and doing it by hand seems quite a long thing to do? I followed these instructions and it worked to a T http://www.sbu.ac.uk/authoring/mysql/convert.shtml Thank Yo

max_connections

I've written a small port monitor in perl, just to check and make sure something is responding on the port. I don't want to do anything fancy, but it appears that MySQL doesn't like this. It doesnt block connections from localhost (thank goodness), but my remote port monitor gets locked out.

new aix load

Now the new binary (mysql-3.23.51-ibm-aix4.3.3.0-rs6000) gives the following error: fowler2:singleto-/usr/local/mysql> ./bin/safe_mysqld & [1] 28004 fowler2:singleto-/usr/local/mysql> ./bin/safe_mysqld[129]: 3998 Illegal instruction(coredump) Starting mysqld daemon with databases from /usr/lo

RE: Auto-increment across multiple tables / Atomicity of update statements

Andy 2) Locks are by thread. If thread dies, so does it's lock. David > -Original Message- > From: Andy Sy [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 12:03 PM > To: [EMAIL PROTECTED] > Subject: Auto-increment across multiple tables / Atomicity of update > statements

Irritating Discovery

Greetings: Perhaps a bug, even. After about 5 months my mysql log file grew to over 300MBytes and I figured I'd do something about it as follows: tail -n 10 /mysql/why.log > /tmp/why.log && sudo mv /tmp/why.log /mysql/ && mysqladmin -u root flush-logs Unfortunately, this set the permissions

Sort search results by relevance

I have created a search page which shows all records from a table that include one or more words of the search string. Is there a way I can have MySQL sort the results according to relevance, and only display each recordset once? I am using ASP with IIS 5 txtSearch = Request("txtSearch") ar

RE: Tables in MySQL

thanks all! as Danny Meidell had pointed out for me, the space between MAX and (ID) i.e. MAX (ID) vs. MAX(ID) had caused the problem. After removing the space the query works fine. TA Bill -Original Message- From: Alan Munter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 12:01

Monitoring locks

__ We are using MySQL 3.23.42 on Linux and having some difficulties with locks. I was wondering if anyone out there has written any neat monitoring tools or knows of one that will alarm and send email when locks are excessive/persistent. Thanks, in advance Candy Bostwick Ca

ACCESS to MySQL

Hi all, Has anyone tried before to import data from an Access Table to a MySQL Table? Actually, I just need to insert some of the columns and doing it by hand seems quite a long thing to do… Thanks in advance, Cesar Aracena CE / MCSE+I Neuquen, Argentina +54.299.6356688 +54.299.4466621

help with mysqlhotcopy

I was wondering if someone could help me out with the syntax to use mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've tried a few variations of the command but with no luck so far. The mysql server is running on RH 7.2 and the DAT tape drive is on that same machine. Any

Auto-increment across multiple tables / Atomicity of update statements

In MySQL, I want to use an auto-incrementing value that works across multiple tables. For example I have 3 tables forumA, forumB, forumC, each of which has a primary key field called 'msgnum'. However, if I declare 'msgnum' auto_increment, 'msgnum' will not be unique across the 3 tables. T

undefined symbol: _dig_vec

Hi, I'm using the unixODBC driver manager and MyODBC driver and trying to connect to my clients database on the MySQL server. But it can't connect. This is the message I get: "Can't open lib /usr/local/MyODBC/lib/libmyodbc.so" : undefined symbol: _dig_vec How do I fix this? -Hoa

creating a relational database: how to plan?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- I'm finally jumping into playing with mysql, and talking to it with perl, and I find that even though I did well in classes years ago in school I really have no idea what I'm doing :-) I've been working up the script to simply parse my da

mysql conference

Does anyone know when and where will be the next mysql conference? Danilo Djokic - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ

Re: Unable to Install MyODBC on Windows 98 PC

Hi, Are at least 2 possibilities: 1.Is another process which maintain open this file. 2.MFC30.DLL it's corrupt. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMA

Table with creattime and modtime columns-how to?

Hello, How does one create a MySQL table with a columns named something like "creattime" and "modtime" where the creattime value for a record is set to the current time when the record is created and the modtime value for a record is set to the current time whenever the record is modified? T

RE: SET query question (was ENUM query question)

Yes! My apologies; didn't have my coffee this morning. The column is of type SET. Jeff > -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 12:50 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: ENUM query question > > > At 12

Re: Table with creattime and modtime columns-how to?

At 11:10 -0700 6/12/02, pixelandink.com wrote: >Hello, > >How does one create a MySQL table with a columns named something >like "creattime" and "modtime" where the creattime value for a >record is set to the current time when the record is created and the >modtime value for a record is set to

Re: Unable to Install MyODBC on Windows 98 PC

I have an sql database on my Verio hosted web site using MySQL. In order to do an sql query I need the MyODBC on my computer. I downloaded the current version of MyODBC (myodbc-2.50.39-win95.zip) and ran setup.exe. The installation stopped dead with the following error message: An error occurr

Table with creattime and modtime columns-how to?

Hello, How does one create a MySQL table with a columns named something like "creattime" and "modtime" where the creattime value for a record is set to the current time when the record is created and the modtime value for a record is set to the current time whenever the record is modified? T

help with mysqlhotcopy

I was wondering if someone could help me out with the syntax to use mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've tried a few variations of the command but with no luck so far. The mysql server is running on RH 7.2 and the DAT tape drive is on that same machine. Any

calculate size of a record in mysql

Does anyone know when and where will be the next mysql conference? Danilo Djokic - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ

Re: ENUM query question

At 12:42 -0500 6/12/02, Jeff Field wrote: >I have a quick question regarding queries that involve values in ENUM >columns. Here's the scenario: > >I have an ENUM column (category) that can have the values ('Gambling', >'Geographic', 'Medical', 'Sports'). Most of the records have only one of >the

ENUM query question

I have a quick question regarding queries that involve values in ENUM columns. Here's the scenario: I have an ENUM column (category) that can have the values ('Gambling', 'Geographic', 'Medical', 'Sports'). Most of the records have only one of the category descriptions but some are categorized

Re: Tables in MySQL

Putting the efficiency issues aside to the extent we already have, I don't see why you can't just use a simple join table for this purpose. You do have the minor complication of symmetry, but with a simple ordering operation against your original insertion join even this can be overcome. Let's wri

need help with restoring privileges

I modified the mysql.users table incorrectly, changing domain "localhost" for user "root" to "%" for user "root" without giving any other permissions... Now I can't get at any of my databases. What are the possible solutions? is there a way to restore the default privileges table? reinititialize

FW: MySQL/InnoDB Hot Backups - What's a "binlog segment?"

Isn't there an administrator on this list that can fix this? Who is "w3e3demo" and why can't he/she be zapped? -Original Message- From: Mailer-Daemon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:34 AM To: Orr, Steve Subject: NDN: MySQL/InnoDB Hot Backups - What's a "binlog

MySQL/InnoDB Hot Backups - What's a "binlog segment?"

I'm confused about the meaning of the help text from ibbackup --help. Here's the text: "You should make backups of the .frm files... both BEFORE and AFTER ibbackup finishes its work, and also store the MySQL binlog segment which is generated between the moment you copy the .frm files to a backup

Prompt

At Wednesday 12/06/02 17:47, you wrote: >good morninig > > >how can i get like this prompt in my session: > > # (exemple #) > >Mysql >Think you - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Tables in MySQL

Don't do it this way. Do something like the following: Assume two tables, "transaction" and "itemlist". transaction --- transaction_id customer_id purchase_date whatever other junk is relevant to a given transaction... itemlist transaction_id item

Re: Mysql Windows Client Install

I use urSQL from http://www.urbanresearch.com/ursql. On Wed, 12 Jun 2002 [EMAIL PROTECTED] wrote: > There are several graphical Windows clients available for mysql. The one I'm > using at the moment is from http://www.anse.de/mysqlfront/ and it's very > good. There's a newer one out though (sor

MySQL/InnoDB-3.23.51 is released

Hi! The download mirrors at www.mysql.com for the MySQL-Max version 3.23.51 do not work yet, but let us hope the mirrors get up to date in a few hours. InnoDB is a table type in MySQL which provides transactions, foreign key constraints, and for which there exists a non-locking hot backup utilit

having problems with installation of mysql 4.0 alpha version, andI have a reason (not a good one) for not using mysqlbug

I apologize greatly for this... but being so new to the UNIX enviornment and Mac OS X, I couldn't figure out how to make mysqlbug actually send out the report I generated from it. So I copy-and-pasted the whole bug report (including comments) into an email editor I am familiar with and emaile

RE: RE: MySQl price

I wasn't asking a question. I was trying to answer one. I obviously didn't do a very good job...:>) --Walt -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 10:01 AM To: [EMAIL PROTECTED] Subject: Re: RE: MySQl price Weaver, Tu

Re: FW: MYSQL Auto-Increment Field

Kaan, Wednesday, June 12, 2002, 2:10:08 PM, you wrote: >> I have set up a table with 3 fields. But I have forgetten to add a primary >> key (I'm not sure if its a primary key I want, I just want a >> auto-Increamentig field at the begging of the table. >> can anyone tell me how I do this. Take a

Re: Mysql Windows Client Install

Morris, Wednesday, June 12, 2002, 5:04:09 PM, you wrote: MF> Is there a mysql Windows client side binary MF> install available? Where can I get it? If you mean command-line mysql client program, it is in the Windows installation package. MySQL binary distribution for Win includes all client-side

Re: make backup

aburbello, Wednesday, June 12, 2002, 4:08:23 PM, you wrote: a> When I try to make a backup executing the sql: a> backup tb_name1, tb_name2 to 'c:\temp' a> and I have a error like a> "Failed copying .frm file: errno =3D 2" a> What I have to do in this case. Use slash '/' or double slash '\\'

Re: RE: MySQl price

Weaver, Tuesday, June 11, 2002, 4:16:10 PM, you wrote: W> Well, I'm under the impression that if the application you're selling W> provides links to MySQL but not the database itself you don't have to pay W> for a license for each sale; it's up to the buyer of the app to obtain a W> MySQL license

Re: about default privileges 2

slz, Wednesday, June 12, 2002, 5:29:52 AM, you wrote: s> mysqlproblem still.prompt:"error 1045: access denied for s> user:'@localhost'(using password:no)".i do 'status' from the mysql s> prompt,it display current user:odbc@localhost,but i dont creat the s> odbc user. If you don't use user name a

Re: Re: license...

Jared, Tuesday, June 11, 2002, 5:34:41 PM, you wrote: JR> - Original Message - JR> From: "Victoria Reznichenko" <[EMAIL PROTECTED]> JR> To: <[EMAIL PROTECTED]> JR> Sent: Tuesday, June 11, 2002 10:03 AM JR> Subject: Re: license... JR> | Silmara, JR> | Monday, June 10, 2002, 10:19:28 PM,

Re: Re: MySqlDump

Terence, Wednesday, June 12, 2002, 1:22:09 PM, you wrote: T> merge/union...which i guess is the problem? is it not fully supported by T> mysqldump yet? MERGE tables only since 4.0 support INSERTs. If you look into dump file you can see INSERTs for your MERGE table. http://www.mysql.com/doc/

Re: Autocommit

Hello Oliver, Thanks for the suggestion but that was not what I am looking for. I know about the command SET AUTOCOMMIT=0 but that is a session level solution. I want transactions to be on always on the database for every session. i.e. the default to 0 rather than the default of 1 as it

MySQL 3.23.51 is released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, first of all, I would like to take this opportunity to introduce myself: my name is Lenz Grimmer and I have started working for MySQL as a product and release engineer in April. For the last four years, I have been working for the distribution de

Tables in MySQL

Hi, im currently developing a Webshop system. One of the new features of it should be a "Costumers that bought this product also bought" feature - concerning this im currently unsure how to implement it - (LAMPS) - my current thought is following: Costumer A buys Products with NO: 12, 13 , 2

Re: table is read only when DB copied from Win to UNIX

On Wed, 12 Jun 2002, Francisco Reinaldo wrote: > Fine, I can see the database, show tables works, > selects works. The whole nine yards? Nope! I cannot > insert any values in that database. I get the > following error: "Table xxx is read only". I have > checked the OS permission for that direct

table is read only when DB copied from Win to UNIX

Hi, I have an installation of MySQL in Windows and another one in UNIX Solaris 2.7. I need to move the databases across system and I have manually ftped a database directory from the Windows MySQL to the UNIX MySQL. Fine, I can see the database, show tables works, selects works. The whole nine y

Re: Sql Alter Table error handling

In the last episode (Jun 12), leonardo klarmann porto said: > HI, > I would like to know how can i resume errors in a Alter Table sentence. > I am doing a script that uses alter table to drop some columns of some > tables in my converted access to mysql database. > The problem is

Re: make backup

* [EMAIL PROTECTED] > When I try to make a backup executing the sql: > backup tb_name1, tb_name2 to 'c:\temp' > > and I have a error like > > "Failed copying .frm file: errno =3D 2" Strange... I get: mysql> backup tb_name1, tb_name2 to 'c:\temp'; ERROR 1064: You have an error in your SQL syntax

Sql Alter Table error handling

HI, I would like to know how can i resume errors in a Alter Table sentence. I am doing a script that uses alter table to drop some columns of some tables in my converted access to mysql database. The problem is that if a column doesn´t exists in a certain table, the script

Re: Question about compiling mysql-source

Yes, you can compile from source, just make sure you specify the proper directories in ./configure. try ./configure --help | less to see all the options. Make sure you know where your mysql is installed now and where it's data is now. Then specify those on the ./configure line. With a little

Re: make backup

Either shut your mysql server down before making the backup or exclude your mysql directory from the backup and use mysqldump to dump the contents. (Which is what I do every night.) Then backup the dump. Even if nobody is using the server, mysql still holds the files open. There are ways to back

Re: Mysql Windows Client Install

There are several graphical Windows clients available for mysql. The one I'm using at the moment is from http://www.anse.de/mysqlfront/ and it's very good. There's a newer one out though (sorry, don't have the URL) that is more like MS SQL Query Analyzer. I have it installed on my desktop machin

Re: MYSQL Auto-Increment Field increment by itself

ÅÇ´f¼Ù(Borus.Kung) a écrit : > > Hi all, > > I have a serious problem. > I have a production system just launch using MySQL. > auto increment field is used in the system by ASP, Visual Basic and C. > System is using AIX 4.3.3, MySQL 3.23.49 > gcc 2.9 source code compiled MySQL > > There are so

Re: make backup

but it this a problem from the mysql?? I need to use this sql. I can't use mysqldump. What is the solution for this problem?? Alexander -- Mensagem Original -- >use mysqldump > >Agris > >agc> When I try to make a backup executing the sql: >agc> backup tb_name1, tb_name2 to 'c:\temp' > >agc>

Mysql Windows Client Install

Is there a mysql Windows client side binary install available? Where can I get it? Morris Ford __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com ---

Re: auto-increment across multiple tables / Atomicity of update statements

In MySQL, I want to use an auto-incrementing value that works across multiple tables. For example I have 3 tables forumA, forumB, forumC, each of which has a primary key field called 'msgnum'. However, if I declare 'msgnum' auto_increment, 'msgnum' will not be unique across the 3 tables.

Re: Mysql..Python..

> > Python has the ability to produce ( with modules) graphics for my > database > interface, outside of the Browser enviorment. Seems, from what I have > read PHP > is restricted to the Browser, is this correct? > Just to answer the question about PHP being restricted to the browser, the answe

make backup

When I try to make a backup executing the sql: backup tb_name1, tb_name2 to 'c:\temp' and I have a error like "Failed copying .frm file: errno =3D 2" What I have to do in this case. Regards Alexander A busca mais veloz e precisa da internet. Ace

  1   2   >