RE: regular backup database in mysql

EZ... Step 1. Create a BATCH FILE. backup.bat D:\YourPath\Mysql\Bin\mysqldump --opt DB1 > C:/BackupDBS/DB1.sql D:\YourPath\Mysql\Bin\mysqldump --opt DB2 > C:/BackupDBS/DB2.sql D:\YourPath\Mysql\Bin\mysqldump --opt DB3 > C:/BackupDBS/DB2.sql D:\YourPath\Mysql\Bin\mysqldump --opt DB4 > C:/BackupDB

Got error 127 after using the alter table command

Hello, I am using MySQL 3.23.39 (on Windows NT and Windows 2000) and the = mm_mysql 2.0.4 JDBC driver. I encountered following problem: 1. I first create some tables via JDBC 2. then I fill in some data via the command line 3. I execute an alter table command (adding a co

Suggestions to table logging

Hello people, I'm running MySQL (InnoDB + replication) on a Win 2K Advanced Server. Especially three of my tables have a lot of crucial data and I would like to know if it is possible to log any SQL submitted to these tables? So far I've learned that the full logging slows down my webpage, plus

Security

Hi Still fairly new to this and I'm using mysql-front for administration which makes life really easy. Anyway as I'm now adding tables etc should I be creating a new user to access them, I'm thinking of the web users, or can I use the default user set-up by my ISP Regards John Berman [EMAIL

Question about Cross Compiling MySql

Hi EveryOne I Wonder If Cross Comile is Possbile. I was trying to make Makefile by using configure shell script(Mysql 4.0.1 Alpha version). Target was Linux PPC and Compile Platform was Solaris Sparc. But test program could not be runned in cross compile environment. That resulted that Makefile

Re: Security

John: Since you host your application(s) with your ISP, don't worry about it. It's a useful and valid question, but you're not in a position to address it completely while security is in control of someone beside yourself. Look here to make yourself better educated about MySQL security: http://

foreign keys

i tried to use the foreign key feature in mysql 4.0.1 using innodb tables . then i have tried the delete cascade feature but it didn't work . I don't know why ? have you any suggestions ? . - Before posting, please check:

Re: last_insert_id gives 0

Hi Paul On Monday 08 April 2002 12:56 am, Paul DuBois wrote: > You're inserting a specific value into the AUTO_INCREMENT field, which > doesn't result in the creation of a new automatic sequence number. > > If you want to insert a record with a specific value in that column, *and* > you want the

Problem with binlog (bug?)

Hi there! I'm having a little Problem with the mysql binary log which I think could actually be a bug of some sort, though I wasn't able to try it on a new Version of MySQL. My system configuration is: MySQL 3.23.41´, Win32 binary Release WindowsNT 4.0 Service Pack 6 PII, 256 MB Ram I am using t

Re: Problem with binlog (bug?)

> > > UPDATE satzungen SET titel='title', inhalt = 'context', > > content_type='text/plain', data='data',kuerzel='kuerzel', > > kennung='kennung', last_change = NOW() WHERE rowid = @rowid; > > User variables are not replication safe in 3.23 :( MySQL -- _/_/ _/_/_/ - Rafał J

Updated: Lost data problem Was: Corrupt .FRM files

Hi all, Some days ago (March 11) permissions were broken in catalogue of the mySQL database. Even though the permissions were not correct any more, MySQL continued to work. We think MySQL started to work with cache (with image of tables in RAM...) instead and all this time our backup system made

UNIQUE index on nullable collumn - can't alter table

MySQL 3.23.47: I want to change a column that is currently non-indexed. SessionID is a nullable int column: alter table tbl_Orders add unique SessionID(SessionID); results in Column 'SessionID' is used with UNIQUE or INDEX but is defined as NOT NULL (A throwback to version 3.22???) I have

OLAP TOOLS

Good morning friends. We have the a project, what is search the OLAP SYSTEM for SUPORT DECISION. I like to know if anybody have the knwoledge about FREE OLAP SYSTEM TOOL and any what use the MYSQL with DW ? - Before posting,

OpenBSD and MySql

Hi, I am using OpenBSD 2.8 and spent a frustrating evening last night trying to make MySql come to heel. Installed just fine - the first sign of something not right was inability to complete the "run-all-tests" scripts - just hung there gobbling up 95% CPU. Gave up on that eventually, and tr

200 milions records

HI, I want to insert into db 200.000.000 records of type (int6,int6).. the structure is: CREATE TABLE word_page ( IDword mediumint(6) NOT NULL default '0', IDpage mediumint(6) NOT NULL default '0', KEY IDword (IDword) ) TYPE=MyISAM; What do you think of it,, how would be th

ignore the first sting in order

Hi all, I want to order a result with ignore the first word when it begins with a _. Begin the first word with a _ use the next word. Can I do it with SQL? Table example: _The Rock Scary Movie X-Files With order I want the output Scary Movie _The Rock X-Files Thanx Bernd

adding 8-bit character encoding to mysql-max-3.23.49-win

Is it possible to add new 8-bit character encoding to compiled mysql (version 3.23.49-win) without recompiling? I would like to add ISO8859-15 encoding that seems not to be present in default installation. with best wishes, Taavi ---

Which list should I ask

I have a question about a script that generated a SQL script from Access 97. Is this the right list, or do I need to write to another one? Thanks. Jim Swanson - Before posting, please check: http://www.mysql.com/manual.ph

help with asp/mysql

this is driving me mental, I'm using asp and mysql, I'm running a query and getting back these two records when running the query manually through mysqlfront , productid 5325301445 5325301446 when the page executes the query i get back a single result 1030334149 which doesnt actually exist in

RE: help with asp/mysql

whoops, the sql is select distinct product.productid from product,productdetails where product.productid=productdetails.productid and product.recordstatus='O' and product.recordstatus='O' and productdetails.price<= 1234.673264 and productdetails.price>= 0 and (product.instore = 0 or product.insto

mysql_install_db locks after "Installing all prepared tables"

Hi, I'm having some trouble with mysql.. Running the mysql_install_db renders this... Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables At this point the script locks at this

Re: Uninstalling on MacOS X

Your binary distrubution downloaded from mysql.org installs in /usr/local/mysql If you remove everything from that directory, you can just install the binary distribution again into that directory. Don't forget to run the mysql_install_db script after installation so to set up your initia

Re: ignore the first sting in order

Hi, > Table example: > _The Rock > Scary Movie > X-Files > With order I want the output > Scary Movie > _The Rock > X-Files select * from movies order by trim(leading from replace(movetitle, '_', ' ')); Regards, Sasa »mysql, select, database« --

Re: Security

Since you are using a hosted database you probably can't change any of the security. What I would do is create a table of usernames and passwords (and any other releveant user data). When your users login, check their password and proceed accordingly. Craig At 02:44 AM 4/8/2002, you wrote:

Re: ignore the first sting in order

On 8 Apr 2002, at 13:52, Bernd Menzel wrote: > I want to order a result with ignore the first word when it begins with a _. > Begin the first word with a _ use the next word. > > Can I do it with SQL? > > Table example: > _The Rock > Scary Movie > X-Files > > With order I want the output > Sca

Re: Do any of your applications work?

hmmm, it's gotta be a troll. I'm so gullible I don't even know if it is or not. If it is, life is good. My favorite it the church lady who storms the linux groups and demands that they stop supporting this operating system because she has ample proof that it is being run on web servers that

Re: How can I kill the slow query automatically?

Hi Marc, Thanks for the suggestion. I hope you would be kind enought to provide another. My application is "transactional", in the business sense, in that, at the point of sale, the transactions must be quick. So inventory must be updated quickly to move the people through the line. The qu

Re: Can AUTO_INCREMENT return from INSERT function into a table ?

At 21:36 -0700 4/7/02, Son Nguyen wrote: >--- BD <[EMAIL PROTECTED]> wrote: >> Son, >> >> At 09:48 PM 4/7/2002, you wrote: >> >mysql> desc threads; >> >>+-+--+--+-+-++ >> >| Field | Type | Null | Key | Default | Extra

Re: ignore the first sting in order

Hi, > Table example: > _The Rock > Scary Movie > X-Files > With order I want the output > Scary Movie > _The Rock > X-Files After reading your message again, look like this is what you've been searching for. Sorry :( select * from movies order by substring_index(movietitle, '_', -1); And

RE: Do any of your applications work?

>-Original Message- >From: Hugh O'Loughlin [mailto:[EMAIL PROTECTED]] >Sent: Saturday, April 06, 2002 7:32 AM >To: [EMAIL PROTECTED] >Subject: Do any of your applications work? > > >Responsible Person, >We have been asked by a client, to use your products in our intergration >efforts. You

char() function

Hi guys, Our java code blows up when we try to insert a string with a ';' inside of it. So we tried to do a work-around by replacing ';' with '||CHAR(59)||' to insert it, using the char function and the character's respecitve ascii value. So instead of: insert into table (key, field) values (1

Re: 200 milions records

Subject: Re: 200 milions records From: Vic Cekvenich <[EMAIL PROTECTED]> === 1. Use PostgreSQL. 2. Use multi channel disk cache controller 3. Get rid of not NULL. 4. index a primary seqnecy key It should be subsecond. Vic ddd wrote: > HI, > > I want to insert into db 200.000.000 records of

RE: Do any of your applications work?

The only thing I wish is to know who his client was or is and set them straight on MySQL and get some extra work ;). Probably trying to sell them the hacker proof Oracle..LMAO. MySQL Select * - Before posting, please check:

RE: char() function

nevermind...instead of using '||' to concat the fields i needed to use the CONCAT() function. So the syntax should have been: insert into table (key, field) values (1, CONCAT('test',CHAR(59), ' string')); still...I wonder why I got a 'Query OK, 1 row affected' message -Don >

Re: char() function

Hi. Have a look at http://www.mysql.com/doc/E/x/Extensions_to_ANSI.html (rather at the end). || has a different meaning in MySQL started without explicit --ansi. Also see http://www.mysql.com/doc/A/N/ANSI_mode.html. Bye, Benjamin. On Mon, Apr 08, 2002 at 11:08:15AM -0400, [EMAIL PROTEC

mysql@lists.mysql.com

Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - Before

Re: adding 8-bit character encoding to mysql-max-3.23.49-win

Taavi, Monday, April 08, 2002, 3:39:29 PM, you wrote: TT> Is it possible to add new 8-bit character encoding to compiled TT> mysql (version 3.23.49-win) without recompiling? No, you should re-configure and re-compile after adding new character set. You can read instruction how to add new charact

Re: Question about Cross Compiling MySql

豤Èñ, Monday, April 08, 2002, 10:44:47 AM, you wrote: > I Wonder If Cross Comile is Possbile. Yes, it's possible, but this case needs deep involvement and a long-time check-up works... Maybe Monty will clarify something. > I was trying to make Makefile by using configure shell script(Mysql 4

Re: FOREIGN KEY Constraints

Carl, Monday, April 08, 2002, 3:16:26 AM, you wrote: CS> From the mysql docs, it looks like you can only use foreign keys if your CS> tables are type InnoDB. Is this correct? Yes, you are right. In MyISAM tables you can use REFERENCE clause, but it does nothing. CS> Carl -- For t

Re: Help restoring data with mysqlbinlog

I am trying to restore some data from the binary log and I am not sure on b> how to proceed. b> I understand restoring data is a two-stage process: b> 1. You start by restoring data saved with mysqldump. b> 2. Using mysqlbinlog, you restore the data logged in the binary log from the b> point wh

Re: foreign keys

root, Monday, April 08, 2002, 12:24:42 PM, you wrote: r> i tried to use the foreign key feature in mysql 4.0.1 using innodb tables . r> then i have tried the delete cascade feature but it didn't work . I don't r> know why ? have you any suggestions ? . InnoDB does not yet support ON DELETE C

Re: RE: Help with Tables Please

Soheil, Monday, April 08, 2002, 7:09:44 AM, you wrote: SS> Thanks for the tip Dan, SS> I changed it, but it still gives me the same error. SS> Any other suggestion? hm ... I have tested your example and it worked fine ... What version of MySQL server do you use and how did you changed column ty

Re: mysql_install_db locks after

Chris, Monday, April 08, 2002, 4:52:26 PM, you wrote: CL> I'm having some trouble with mysql.. Running the mysql_install_db renders CL> this... CL> Installing all prepared tables CL> At this point the script locks at this point & won't go any further. CL> I am using CL> MySQL-3.23.49a-1.i386

Replication: Slave performance

Hi there, currently I am using a single server for my webapp. Within the next days I get another box which will host the mysql-database (which is currently running on the other server). I want to set up replication between the 2 ones, using my current server as SLAVE and the new on as master. D

Re:

On Monday 08 April 2002 9:49 am, Chuck \"PUP\" Payne wrote: > Ok, I know I am going to get yell about this but how can I do an SQL and > only show to fields from a table. For example I only like to see the names > and birthday? Or will as so all fields for a given table. SELECT field1, field2 FRO

Re:

Chuck, Monday, April 08, 2002, 6:49:20 PM, you wrote: CPP> Ok, I know I am going to get yell about this but how can I do an SQL and CPP> only show to fields from a table. For example I only like to see the names CPP> and birthday? Or will as so all fields for a given table. If you want to see da

mysql

mysql See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual

RE:

SELECT name,birthday FROM mytable -Original Message- From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 10:49 AM To: MySQL Mailing List (E-mail) Subject: Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a tab

Privileges for backups

have got a backup script that locks the MySQL tables then use cp to copy the tables. It then tar, then zips them up. So my queston is what is the minimum privileges that this MySQL back user needs just to lock tables? Thanks Simon Green -- Live Life in

SQL Script stopping

I have a script I'm trying to run through the mysql command. When I run the script, I get a 1064 error, specifically CREATE TABLE 185_s_Prices\g PriceID INT NOT NULL DEFAULT 0, Service CHAR (80); Category CHAR (20),<--- here Can anyone tell me what's wrong with th

Re:

>From the limited info given, I'd say you need to use the WHERE clause in your SELECT statement. SELECT * FROM blank WHERE something=something Mike - Original Message - From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]> To: "MySQL Mailing List (E-mail)" <[EMAIL PROTECTED]> Sent: Monday, April

Re:

select name, birthday from ??? order by name; Along those lines anyway. Chuck \"PUP\" Payne wrote: > * > This Message Was Virus Checked With : SAVI 3.54 Feb 2002 > Last Updated 25th March 2002 >

RE: mysql

SPAM ALERT -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 11:04 AM To: [EMAIL PROTECTED] Subject: mysql mysql See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_02 0201/s

RE: mysql

sometimes, all you can say is LOL and walk away shaking your head...thinking... *...the poor guy actually went to the trouble of defeating the filter, only later to invite the flames of hell upon his head* > -Original Message- > From: va ku [mailto:[EMAIL PROTECTED]] > Sent: Monday, Ap

RE: show to fields from a table

6.6.2 DESCRIBE Syntax (Get Information About Columns) http://www.mysql.com/doc/D/E/DESCRIBE.html ... aka MySQL(homePage)->Search::. C:~ -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 9:04 AM To: 'Chuck "PUP" Payne'; MySQL Mailing List (E-ma

Re:

Thanks, I got it :) I am using phpMySQL and command line and I couldn't see anything because it was showing everything but now I am cool. Again everyone thanks. Chuck Payne On 4/8/02 12:03 PM, "Rick Emery" <[EMAIL PROTECTED]> wrote: > SELECT name,birthday FROM mytable > > -Original Message

Newbie Question on Replication

After a orderly system and MySQL shutdown and restart of both slave and master, replication failed to start on the slave. Any suggestions on how to get replication going again without shutting down, taking a snapshot and starting replication would be greatly appreciated. The error logs on th

Benchmark test

Hello! On your homepage i have seen that you did Benchmark tests with MYSQL and MS Access 2000(on Windows) and compared the Benchmark results. I also want to do this but i dont know how to do such Benchmarktests on MYSQL and Access because i am a beginner in working with these databases. so pleas

RE: RE: Help with Tables Please

Thanks, It worked :) It was my mistake! Thanks again, Soheil Soheil, Monday, April 08, 2002, 7:09:44 AM, you wrote: SS> Thanks for the tip Dan, SS> I changed it, but it still gives me the same error. SS> Any other suggestion? hm ... I have tested your example and it worked fine ... What ver

MySQL won't keep running on my Mac OSX

I'm having trouble keeping MySQL running on my computer (PowerBook G3 -Firewire, 576MB RAM, G3/400 - 40GB HD with plenty free in the main OS X partition). I'm running OS X 10.1.3. 1. I installed MySQL (binary) in \Users\hill\MySQL\ directory (logged in as me/hill, not root) 2. I can run the

Help restoring data with mysqlbinlog

Victoria, Thanks for replying. How does one know what parameter to pass on as "position", in other words how do I know from what point to start the roll-forward from the binlog? What's more what format is this parameter? (timestamp, integer??) Thanks, Balteo. P.S. I tried "mysqlbinlog --help" b

RE: SQL Script stopping

You have a semicolon(;) after the line Service CHAR (80) Besides after CREATE TABLE tablename syntax you have to define the columns and their datatypes in parenthesis. See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html Gurhan -Original Message- From: Jim Swanson [mailto:[EMAIL PROTE

RE: SQL Script stopping

ERROR 1064 at line 1: You have an error in your SQL syntax near ' ' at line 1 - perhaps you'd prefer the semicolon to complete your query - C:~ -Original Message- From: Jim Swanson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 9:07 AM To: [EMAIL PROTECTED] Subject: SQL S

RE: SQL Script stopping

looks to me like the error is with the semicolon at the end of the Service CHAR (80); That would indicate the end of the statement, not that something follows Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -Original Mes

Best field type for ID?

Hi everyone, What is the best field type to use for an ID field which is the primary key and auto-increment? I wanted to use SMALLINT UNSIGNED because its half the bytes of INT but was wondering what happens when it reaches 65535, does the auto-increment go back to 1 or will it cause an error?

Concurrent Connections Ceiling?

Anybody have any idea what kind of concurrent user load MySQL is (or at least should be) capable of handling? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Reg MYSQL and JAVA

Hi, I don't know is this is the correct form. I am looking for some help in developing report on Java. I am using MYSQL and Java for development. I need to generate a formatted output which contains values from database, some paragraphs etc. I am expecting a report in 'doc' or 'rtf' or 'pdf

MySQL and GCC

I have a system here based on Red Hat's 7.2 distribution and I am wanting to get MySQL up and running. After browsing your web page it seems that I will have go to a different version of gcc. Would I be safe to go to the latest version (3.0.4) of gcc? Barry Blatz Pason Systems Corp. (403) 301-3

Re: SQL Script stopping

The semi-colon (;) after "Service CHAR(80)" should be a comma (,). On Mon, 8 Apr 2002, Jim Swanson wrote: > I have a script I'm trying to run through the mysql command. When I run > the script, I get a 1064 error, specifically > > CREATE TABLE 185_s_Prices\g > > PriceID INT NOT NULL DEFAUL

Re: MySQL won't keep running on my Mac OSX

I have the same exact setup down to the hardware (believe it or not). Your best game plan is to install the MySQL binary distro into /usr/local/mysql as the root user. And then run the MySQL server as root. You'll have to start the MySQL Server when you start the laptop. Otherwise, you can log ou

Re: SQL Script stopping

Also, the CREATE TABLE statement doesn't look right. It should probably be: create table 185_s_Prices ( PriceID INT NOT NULL DEFAULT 0, Service CHAR (80), Category CHAR (20) ); See the MySQL Manual section on "CREATE TABLE". On Mon, 8 Apr 2002, Jim Swanson wrote: > I have a script I'm

database setup

Hi, I am setting up a mysql database, with two tables. One keeps the user authentication info such as user name, password and user level. The other table with contains files for upload and download. Is there a good way to setup the user authentication table so it can check appropriate user rights

binlog and replication stuff

Hello. I'm using MySQL-3.23.38 on 5 RedHat 7.1/7.2 servers composed by one master and 4 mysql slave, every write is made on the master and then replicated to the slave. The problem is that if one client crash or must be rebooted i've to: - on the mysql master stop mysql, delete binlogfile, tar

RE: Help with Tables Please

FieldID INT UNSIGNED DEFAULT '0' NOT NULL, -Original Message- From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 07, 2002 11:10 PM To: [EMAIL PROTECTED] Subject: RE: Help with Tables Please Thanks for the tip Dan, I changed it, but it still gives me the same error.

RE: Best field type for ID?

* Luke van Blerk > What is the best field type to use for an ID field which is the > primary key and auto-increment? > > I wanted to use SMALLINT UNSIGNED because its half the bytes of > INT but was > wondering what happens when it reaches 65535, does the auto-increment go > back to 1 or will it

Re: MySQL won't keep running on my Mac OSX

At 12:48 -0400 4/8/02, Jay Hill wrote: >I'm having trouble keeping MySQL running on my computer (PowerBook >G3 -Firewire, 576MB RAM, G3/400 - 40GB HD with plenty free in the >main OS X partition). I'm running OS X 10.1.3. > >1. I installed MySQL (binary) in \Users\hill\MySQL\ directory >(logg

RE: Concurrent Connections Ceiling?

* Tab Alleman > Anybody have any idea what kind of concurrent user load MySQL is (or at > least should be) capable of handling? This depends on a lot of factors, the application and the hardware beeing the most important ones... the recent benchmark test in eweek may give you some hints: http://

RE: database setup

First, I assume that the same value for "userlevel" may be used by multiple users. That is, multiple users can have userlevel equal to 1 or equal to 2 or 3 or whatever. Therefore, you CANNOT use userlevel as PRIMARY KEY. PRIMARY KEY is a UNIQUE identifier. Thus, I recommend that each user be id

CREATE TEMPORARY TABLE

If I want to use temporary tables I know I can create tables that are unique without using "CREATE TEMPORARY TABLE table_name". What I want to know, because it might be more efficient, is if I use "CREATE TEMPORARY TABLE table_name" and more than one person hits the page (I am using PH

RE: FOREIGN KEY Constraints

Hi, Yes, you are right but be aware with the delete cascade feature, maybe in the way?. Regards - Original Message - From: Carl Schmidt <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 07, 2002 7:16 PM Subject: FOREIGN KEY Constraints > From the mysql docs, it looks like

RE: Best field type for ID?

On 8 Apr 2002, at 20:20, Roger Baklund wrote: > The best type to use is the one big enough to hold your expected biggest > value, but not bigger. But when calculating your expected biggest value, keep in mind that the autoincrement counter increases on every attempted insert, even if the inser

Re: char() function

Hello. On Mon, Apr 08, 2002 at 11:24:56AM -0400, [EMAIL PROTECTED] wrote: [...] > still...I wonder why I got a 'Query OK, 1 row affected' message [...] > > insert into table (key, field) values (1, 'test'||CHAR(59)||' string'); > > > > it seems to work initially...(Query OK, 1 row affected (

Uninstall Mysql

Can anyone tell me how can I uninstall mysql. I have done it again. I have messed up my permission. I dont know what is is that i'm doing that makes me loose my previleges. I keep getting the access denied error Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103 Pu

RE: CREATE TEMPORARY TABLE

Thank You. That is what I was hoping for. I would assume that this would be faster than actually coming up with a random name, using srand and rand, for a table, creating it and deleting it when done. Thanks Steve Buehler At 02:19 PM 4/8/2002, you wrote: >Yes a TEMPORARY TABLE is specific to

Re: CREATE TEMPORARY TABLE

On Mon, Apr 08, 2002 at 01:40:02PM -0500, Steve Buehler wrote: > If I want to use temporary tables I know I can create tables > that are unique without using "CREATE TEMPORARY TABLE table_name". > What I want to know, because it might be more efficient, is if I use > "CREATE TEMPORARY TABLE

Running mysql on a certain IP

I need to run two MySQL servers on one machine. One needs to use /var/lib/mysql.sock and the other needs to use /home/mindbender/production/db/mysql.sock One needs to run on one ip address: ie: 10.0.0.10:3306 and the other on 10.0.0.11:3306 how do I tell mysql to run only on a certain IP addre

Re: Running mysql on a certain IP

On Mon, Apr 08, 2002 at 03:04:58PM -0500, Johnny Withers wrote: > > I need to run two MySQL servers on one machine. > > One needs to use /var/lib/mysql.sock > and the other needs to use /home/mindbender/production/db/mysql.sock > > One needs to run on one ip address: > ie: 10.0.0.10:3306 > and

HELP!

Dear all of member, Would you help me, how to install, setup, and configure MySQL in my server with O/S windows 2000 server and IIS v. 5 Thank you, Best Regards, - Before posting, please check: http://www.mysql.com/manual.

Re: Uninstall Mysql

Hi, You give up so quicly? What OS use for MySQL? - Original Message - From: Kathy Reyes <[EMAIL PROTECTED]> To: mysql <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 10:10 PM Subject: Uninstall Mysql > Can anyone tell me how can I uninstall mysql. I have done it again. I have > messe

mysql and java

Hey Guys, I'm not sure if this is the right place to ask this question, but to be honest I didn't know where else to turn since my script deals with mysql. Here's my problem: I am using stylesheets and javascript to display a small blurb about a review on my site and it display is in a stylesheet

MySQL 3.23.43-nt stop working after approx 10 days.

I have a problem with my MySQL server, it has started to stop working after approximately 10 days of uptime. After a reboot it works fine again. The users get the error "can't connect to server on localhost". I also have a testserver with similar setup, on that MySQL has run for 54 days with n

DBD and Mysql

WinXp Crashed my D: drive and I had most everything backup.. So when I reinstalled ActivePerl 5.6.xx I downloaded via PPM (perl package installer) the DBI, DBIx::AnyDBD but could not find DBD:mysql. Where is the package for Windows.. I did find, at CPAN, the mysql.gz.tar version which I use

RE: mysql and java

this is actually OT, btw, but I'll try to answer... > need to make it smaller. Is it possible to somehow store > these descriptions > in a mysql table or on another page and then have them linked > to when you > put your mouse over the link? No. There are methods of accessing databases from t

RE: Running mysql on a certain IP

Yes, I found this about 2 seconds after I sent my email.. However, I still can not get mysql to run on either a) different ip address on port 3306 or b) same ip address on port 3307 Either way, I get the error: 020408 15:47:00 mysqld started 020408 15:47:00 Can't start server: Bind on

Re: Best field type for ID?

Thanks! Thats a great help. I didn't know that about the performance advantage. I was using INT but thought SMALLINT might be better cos it uses less space. Much obliged. - Original Message - From: "Madscientist" <[EMAIL PROTECTED]> To: "'Luke van Blerk'" <[EMAIL PROTECTED]> Sent: Monday

Re: Running mysql on a certain IP

[EMAIL PROTECTED] wrote: > > I read somewhere that mysql reads /etc/my.cnf before it does any > command line options, is this correct? If so, how can I have a my.cnf > file > and then run two servers if I have to have a [mysqld] section in the > my.cnf > file that tells the server which port and

MySQL 3.23.49 and HP-UX 10.20 Install

>Description: 1. Distributed Binary version crashes with scripts/mysql_install_db Output vvv Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Insta

Re: Reg MYSQL and JAVA

Hi, Thanks for the reply. I also need few 'doc' features such as 1. Bold letters 2. Formatted paragraphs The document I want to take a report is a student declaration form where on top it will display student details in the middle the declaration and at the end Signature. The document consists

Strange behavior

I have a table with the following fields: id=autoincrement, int (11) ts_h=decimal ts_pid=int (11) ts_day=text There is a unique record where ts_pid=60 and ts_day="2002032800" (ts_h=0). If I do [update t_timesheet set ts_h=0 where ts_pid=60 and ts_day="2002032800" ],

RE: Reg MYSQL and JAVA

still OT, but here goes anyway... you can in fact use PHP or ASP or whatever to generate PDFs. See http://www.pdflib.com/pdflib/index.html > -Original Message- > From: va ku [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 08, 2002 5:04 PM > To: Christopher Thompson; [EMAIL PROTECTED]

  1   2   >