Hi,
as far as we are waiting for 3.23.50 this sounds as a stable version to
do a backup. :-)
But I wonder weather there is also a binary backup for this case? Lets
say copy all tables and store in a zip (for ISAM tables ok but
InnoDB???), or make a mysqlhotcopy.
Adib.
Chetan Lavti wrote:
äÏÂÒÙÊ ÄÅÎØ.
| table_cache | 256 |
+---+---+
m1# mysql -e show status like 'Open%'
+---+---+
| Variable_name | Value |
+---+---+
| Open_tables | 256 |
| Open_files| 446 |
| Open_streams | 0 |
| Opened_tables
On Sat, 2002-03-23 at 15:19, Hans Kind wrote:
Hi,
What is the correct syntax to use to backup all databases in the
/usr/local/mysql/var directory.
We tried a number of different options, but at best we get only 1 database,
backup completely. Using a wildcard, *, only creates the
hi everyone,
i have a field call state...data inside this field separate by
comma...johor,kl,ipoh.i want to query out data from state field which
content johor,ipoh dosen't matter if there is other state name.is it
possible.can anyone help me.
thanks in advance
Hi,
The command you need is: INSERT INTO USERS (Host,User,Password,
privileges) VALUES ('%','Your_username', 'Your_passwd', privileges)
This will give you what you want.
Regards
Dean
At 22:12 24/03/2002 -0500, you wrote:
Hi,
I am wondering is there a way to set up user that can log in from
Hi!
FOREIGN KEY definitions are stored inside InnoDB data files. Thus, if you
make a 'binary' backup, it will preserve foreign key definitions.
Starting from 3.23.50 and 4.0.2 mysqldump dumps also foreign key
definitions. Previously it forgot them because it did not read them from
inside
Hi!
Please look in section 9.1 of http://www.innodb.com/ibman.html
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
-Original Message-
From: [EMAIL
Chuck,
Monday, March 25, 2002, 5:12:51 AM, you wrote:
CPP I am wondering is there a way to set up user that can log in from anyplace?
CPP I know I need to set this user up with the %(I hope this is the wildcard
CPP for) mysql.
Yes, you are right. '%' is a wild card for any host in MySQL. How
sigit,
Saturday, March 23, 2002, 3:45:15 PM, you wrote:
ss I'm new here and very newbie in mysql. I couldn't
ss start mysql :
ss [root@localhost mysqll]# Starting mysqld daemon with
ss databases from /var/lib/mysql020323 19:12:59 mysqld
ss ended
ss COuld anyone give me some suggestions to do
Felik,
Monday, March 25, 2002, 8:44:01 AM, you wrote:
FH pls tell me how to create user group in mysql?
What about using combination 'db' and 'host' tables in the database
'mysql'? You can allow several hosts to connect to a database for a
user.
You can read more about it at:
es2,
Monday, March 25, 2002, 4:52:16 AM, you wrote:
e I have installed MySQLGUI ( Win32 static binary of MySQLGUI 1.7.5-2
e ../Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip ) and have been
e able to connect the the server successfully.
e platform used: Win95
e The Help function is not
Hans,
Saturday, March 23, 2002, 5:19:22 PM, you wrote:
HK What is the correct syntax to use to backup all databases in the
HK /usr/local/mysql/var directory.
mysqlhotcopy has '--regexp' option to copy all database with the names
matching regexp.
You can find more info about mysqlhotcopy at:
Dodol,
Monday, March 25, 2002, 3:50:25 AM, you wrote:
D I am new member here, and I would like to ask about connection at
D Mysql. I have MySQL on linux server and I want to connect that MySQL
D engine from windows, how can I connect to that mysql
D now I've been install Mysql-ODBC and
I have a problem. I want to connect to MySQL only from localhost
(127.0.0.1) and from one another ip-address, but I can't.
I can connect to MySQL only from localhost (127.0.0.1) or from one
another ip-address,
because --bind-address=IP (/etc/my.cnf) can use only one IP.
If I don't use
Hello
I have followed problem:
Table:
CREATE TABLE test (
field1 mediumtext
);
Insert:
INSERT INTO test VALUES ('222(100 Kb of '2')222');
Select1:
SELECT field1 FROM test;
OK. I get 100 Kb of '2'.
Select2:
SET CHARACTER SET cp1251_koi8;
SELECT field1 FROM test;
??? I get only 34465 byte.
Hi
I have a first ( very alpha ) version of an UDF that allow users to
write they own functions in PHP.
In the package there is an example of a function that execute a query
and check the results something like:
SELECT * FROM table WHERE field1 IN ( SELECT field1 FROM table2 );
The UDF is
Richard,
Saturday, March 23, 2002, 10:15:10 PM, you wrote:
RR I have downloaded mysql 3.23.49a source. When I run ./configure
RR --without-server it hangs. After several minutes I interupt it with
RR Cntrl - C. No makefile has been created neither has config.cache. I
RR then try
Paul,
Saturday, March 23, 2002, 5:02:36 PM, you wrote:
PG My question should have been like this ?
PG I am running Apache, MySql and PHP on a Linux server.
PG What I want to do is to open a MySql database that
PG reside on a Windows2000 computer. I don't want to
PG use Samba for security
Sherzod,
Saturday, March 23, 2002, 7:27:59 PM, you wrote:
SBR Is there a function or a way to find out how many days/hours/mins/secs
SBR have elapsed since date n?
SBR For example, i need to be able to get the answer like: 2 days and 3
SBR hours have passed since date [some_date]
Some of
Hi,
I am pretty new guy dealing with mysql database, and I am sorry if this has
being asked before.
Are their any doc explaining how to integrate snort and mysql ?
Best regards,
Idan Dolev
-
Before posting, please check:
Does anyone know what is wrong with my syntax? (the sql statement works in
mssql server)?
SELECT user.*, wbs.name
FROM wbs INNER JOIN (user INNER JOIN user_wbs ON user.id =
user_wbs.user_id) ON wbs.id = user_wbs.wbs_id
Thanks,
Scott
Description:
mysql_install_db fails if ansi specified in my.cnf
Appears to be related to columns called User in mysql database.
How-To-Repeat:
install database; set ansi mode in my.cnf; run mysql_install_db
to rebuild security database
Fix:
goldim,
Monday, March 25, 2002, 2:57:14 PM, you wrote:
g I have a problem. I want to connect to MySQL only from localhost
g (127.0.0.1) and from one another ip-address, but I can't.
g I can connect to MySQL only from localhost (127.0.0.1) or from one
g another ip-address,
g because
Ray,
Sunday, March 24, 2002, 8:55:47 PM, you wrote:
RDW Hello. I would value your help in resolving a problem I had which makes it
impossible for me to install MySQL on my system. I would like to report that :
RDW rpm --rebuild MySQL-3.23.49-1.src.rpm
RDW FAILED on my system - Redhat 6.2 on
Hi
I need to set up the character coding of a field
to UTF-8 in our MySQL 3.23.49a.
The database now runs on ISO 8859-2 and I don't
want to set the new character coding on the
whole database just on the field.
Can I do it somehow?
Thanks in advance!
Regards;
Istvan
Hi,
try this
SELECT user.*, wbs.name
FROM
user_wbs INNER JOIN user ON user.id = user_wbs.user_id INNER JOIN
wbs ON wbs.id = user_wbs.wbs_id
that should do the same as your select
just MySQL doesnt like nested joins/selects
hope this will be sorted out in 4.1
Tommy
-Original
USE db2;
alan4100 wrote:
mysql
Paul,
I was afraid to hear that. It had said about line 2 in the error message.
This line #2 looks normal.
May I ask you to check this script below, but I am afraid it may be
annoying. I will eventually put this on posting. Remember I use Windows XP.
I would
Hi List
I'm new to MySQL and I need help on how to pass shell parameter to a mysql
script file (bash/SuSE 7.2)
I have one file called run_db_load and I called it from the command line as
# date_proc=25032002
# export date_proc
# ./run_db_load $date_proc
Inside the run_db_load file I have:
Thanks Alec,
That is exactly what I was looking for.
Dan
I think what you want is a FULLTEXT index with the MATCH operator - see
http://www.mysql.com/doc/F/u/Fulltext_Search.html .
Particularl.y, see the new developments in fulltext in V4.0.1 half way doen
the page
Alec Cawley
None of these selects will use an index.
1. An index can not be used for LIKE '$something'.
2. An index will not be used if 1/3 of the entries match.
3. See #1.
Jaime Teng wrote:
Hi,
I have this table:
mysql describe eventlog;
Hi Oswaldo..
You have the parameter inside the sql file , not in the script itself.
Try this:
#!/bin/bash
QUERY=load data infile '/home/loader/txt/file_${date_proc}.txt into table
debits
fields terminated by ';'
mysql -u user -ppass -D dbname -e $QUERY
Gurhan
-Original Message-
Hello,
I am very interesting in this work. Please continue it :)
Alexander
PS
Any chance to get the sources?
--
Server version: 4.0.2-alpha-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset:cp1251
Server
Try:
echo
load data infile '/home/loader/txt/file_${date_proc}.txt' into table debits
fields terminated by ';'
| mysql -u user -ppass dbname
Oswaldo Castro wrote:
Hi List
I'm new to MySQL and I need help on how to pass shell parameter to a mysql
script file (bash/SuSE 7.2)
I have one
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 2:51 PM
To: Chuck Roberts
Cc: Mysql; Mark Stringham
Subject: RE: MySQL, MyODBC and MS Access
Chuck -
I am looking for a way for both MS access and MySQL to
share realtime
data so
mysql
Paul,
Sure you did clear up the whole thing... :)
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: alan4100 [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, March 24, 2002 10:31 PM
Subject: Re: Grant all on my mysql.*
At 21:32 -0500 3/24/02, alan4100 wrote:
Michael,
Paul explained.
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: alan4100 [EMAIL PROTECTED]
Sent: Sunday, March 24, 2002 11:31 PM
Subject: Re: Grant all on my mysql.*
On Sun, 24 Mar 2002, alan4100 wrote:
mysql
Michael,
This time it went
At 10:40 -0500 3/25/02, alan4100 wrote:
mysql
Gerald,
I will try that; Paul had suggested USE db_name. ..I will try both ways..USE
db2 and USE db_xxx .. Will keep you both posted.
Gerald's suggestion and mine are the *same*: The USE keyword followed by
the name of the database you want to use.
Hi All! New list member here.
I was wondering if I could get a little help with a problem I am having when
I load a databse into a Solaris mysql instance.
I had populated a database that acts as a content repository for a web site
on my personal PC (Windows) as a proof of concept. The site
Paul,
Okay.:)
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: alan4100 [EMAIL PROTECTED]; Gerald Clark
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, March 25, 2002 10:56 AM
Subject: Re: Table created on script Err
At 10:40 -0500 3/25/02, alan4100 wrote:
Hi,
I want to set up my home computer (PIII,Win2000) for development and
testing of php/mysql work.
I know that both will install and work on a Win2000 box, my questions
are about potential conflicts:
My Win2000 came with IIS, are there any hitches to using php/mysql with
IIS? Should I install
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 25 March 2002 07:59
To: Sean O'Donnell
Subject: Re: InnoDB books
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
Chris,
The first thing to do is try and access the data from the database on
the Solaris box. This will show you if there is a problem with MySql. As
for the data, there isn't anything you need to do it except make sure the
permissions are correct on the data directory and its contents.
Yep, all that stuff works. I can list the contents of any table, etc.
One thing I did notice is that in phpMyAdmin that the total sizes of both
tables are different - out by a few kb for some of the larger tables with
the Solaris ones being smaller.
I dunno, it's weird - the mysql selects that
I am trying to automate the fairly simple task of flushing the bin logs on
both the master and slaves without blowing up replication. I managed the
trick once, but have been unable to duplicate it. Do I need to write lock
the tables first? When it worked I just used
flush slave;
flush master;
Takacs,
Monday, March 25, 2002, 3:51:43 PM, you wrote:
TI I need to set up the character coding of a field
TI to UTF-8 in our MySQL 3.23.49a.
TI The database now runs on ISO 8859-2 and I don't
TI want to set the new character coding on the
TI whole database just on the field.
TI Can I do it
Rance,
Saturday, March 23, 2002, 1:27:37 AM, you wrote:
RH Egor:
RH Yes, im sure that the host.xxx tables are in the directory I specified to
RH the mysql_install_db script.
RH One thing to note..
RH This is a software package for my distro... I did not compile from source so
RH I dont know
Hi there,
If you could please answer this question impartially as I know a lot of you
use UNIX, Linux and Win machines...
I am building a website with mySQL and Cold Fusion, and was wondering if
there were any 'issues' with running it from a Mac OSX web server. I am
aware that Cold Fusion is
Any advice, or links to useful docs would be appreciated.
You did say *any* advice. Keep that in mind...
My advice to you is to load some popular flavor of UNIX on that machine,
such as Linux or OpenBSD, in order to have a more standard environment for
this. Windows may work, but you're
Core MySQL
ISBN: 0130661902
http://shop.barnesandnoble.com/booksearch/isbnInquiry.asp?isbn=0130661902
[EMAIL PROTECTED] wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 25 March 2002 07:59
To: Sean O'Donnell
Subject: Re: InnoDB books
Your message
Chris,
Can you access the Solaris DB from your Windows box?
mysql -u user -h ip_of_solaris_box -p
Also, what is the error your getting exactly? Are you running the web
server on the Solaris box as well? If so drop this into the document root:
?
phpinfo();
?
and call it something
I've been watching the mysql.com downloads page for a while and it
doesn't seem like there's a build of 3.23.49 coming soon. The manual on
mysql.com talks about a 3.23.50, is that the latest source distribution?
What is 3.23.49a, which is listed for the downloads?
I'd like to get a build of
We've been using MySQL 3.23 in OSX on our production servers for about 6
months now. The system was in development for over a year prior to that.
We have a legacy application in RealBASIC (it's not my fault!) that uses
ODBC to issue numerous REPLACE queries to the database on an hourly
basis
|
| Can you access the Solaris DB from your Windows box?
|
| mysql -u user -h ip_of_solaris_box -p
|
Yep.
| Also, what is the error your getting exactly? Are you
| running the web
| server on the Solaris box as well? If so drop this into
| the document root:
| ?
what is snort?
Curtis
Idan Dolev said:
Hi,
I am pretty new guy dealing with mysql database, and I am sorry if this
has being asked before.
Are their any doc explaining how to integrate snort and mysql ?
Best regards,
Idan Dolev
The only problem with Win2K is that a lot of the components for PHP aren't
there. Also PHP will run as an ISAPI module, but its not recommended. The
preferred method is as a CGI (read 25% performance hit). Win2K doesn't
multi-task/multi-thread as well as either of the *nix's mentioned and its
Here is a though:
I know that replication requires identical table definitions, but does
that also include identical indexes?
So, could I setup a master database without a fulltext index on a
particularly large table I have and then setup a slave server with the
fulltext index and then do all
Paul,
You are right. :)
USE alan03 works.
USE db_alan03 works.
But it created two separate databases. They are not the same. But both
works just the same.
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: alan4100 [EMAIL PROTECTED]; Gerald Clark
[EMAIL PROTECTED]
Cc:
At 12:35 -0500 3/25/02, alan4100 wrote:
Paul,
You are right. :)
USE alan03 works.
USE db_alan03 works.
But it created two separate databases. They are not the same. But both
works just the same.
That doesn't make any sense. USE doesn't create anything.
- Original Message -
As far as OS's are concerned, I'm an equal opportunity bigot, I hate them
all. :)
Using these tools on your home PC running some flavour of Windows will work
fine. That's the way I work, devel on the WinXP box, ftp the files/changes
to my Linux web server. Everything seems to work - excepting
At 12:01 -0500 3/25/02, Gabriel Ricard wrote:
I've been watching the mysql.com downloads page for a while and it
doesn't seem like there's a build of 3.23.49 coming soon. The manual
on mysql.com talks about a 3.23.50, is that the latest source
distribution? What is 3.23.49a, which is listed
IIS: Kill the services, and disable them If you need to know which
ones let me know.
Oracle8i: No, they use different ports. I run Oracle8, mySQL, SQL
Server7 without any problems
-Original Message-
From: Andrew Hazen [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002
I have found Win2k completely stable with Apache/PHP/mySQL. Not one
issue!
If you are talking IIS combo, then yes issues will arise. I don't see
any performance hit on this setup as a CGI. I think you are being a bit
bias towards Windoze. Windows 2k is quite stable. The thing about
win2k is
Helo list,
I don't recall if it was here that I heard of this mySQLMan package. I
think so. http://www.gossamer-threads.com/scripts/mysqlman/index.htm has
quickly saved me lots of hair, and will soon enable me to go live with
mySQL... My use and interest in mySQL has just taken a quantum leap
Hello everyone,
This is starting to drive me mad now and I can't find a way round. I have
installed the service pack and updates suggested in the manual, am running
MyODBC 3.51 and MySQL 3.23.46 have added timestamp fields and enabled return
matching rows. But still when I add a new record an
I got problems deleting a user which I've created before.
mysql delete from user where user=wus;
ERROR 1054: Unknown column 'wus' in 'where clause'
mysql
Can anyone provide some help?
Thanks,
Manuel
--
667: The neighbor of the beast.
IIS Services to kill:
IIS Admin
FTP Publishing Service
World Wide Wb Publishing Service
If my memory serves me right, if you stop the IIS admin service the rest
will stop as well. But remember to disable them by going into Start |
Admin Tools | Services
And right click on them chose
Chris,
That is very weird, and I don't have any real help :-(
but there are a couple of things I will suggest:
1. Run mysiamchk (assuming these are MyISAM tables) from the Solaris box
and retry, its possible that there is a character in your data that the
Windows box is allowing, but
Hi, if you think that IIS and Apache are going to have problems
co-habitating then, yes, please tell me which services to kill. On the
other hand, I'm not using IIS for anything else, maybe I should try to
uninstall it before installing Apache???
Thanks.
Andrew Hazen
Spam filter: mysql
delete from user where user=wus;
-Original Message-
From: Manuel Hendel [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 12:24 PM
To: MYSQL List
Subject: problems deleting a user from user db
I got problems deleting a user which I've created before.
mysql delete from user
I didn't receive any response so thought I'd repost with some more
questions.
Is my problem so rare no one knew what to say? or Is there some obvious
solution here and everyone thought *someone else* would straighten me out?
Any pointers and help is appreciated.
Thanks,
Lance
Does anyone have
No help, just a me too. If you respond with something helpful to this,
please either post it to the list or copy me on it because I'm fed up with
MS Access / myODBC / MySQL combo as well (not necessarily the individual
components, just the combination).
At 19:23 +0100 3/25/02, Manuel Hendel wrote:
I got problems deleting a user which I've created before.
mysql delete from user where user=wus;
ERROR 1054: Unknown column 'wus' in 'where clause'
mysql
Can anyone provide some help?
wus is a string. Surround it in quotes.
Thanks,
Manuel
From: Manuel Hendel [EMAIL PROTECTED]
I got problems deleting a user which I've created before.
mysql delete from user where user=wus;
ERROR 1054: Unknown column 'wus' in 'where clause'
mysql
Can anyone provide some help?
Try this:
delete from user where user='wus';
--
denonymous
I got problems deleting a user which I've created before.
mysql delete from user where user=wus;
ERROR 1054: Unknown column 'wus' in 'where clause'
mysql
How about quoting a string type:
delete from user where user='wus';
-Lance
Sean,
since InnoDB development progresses rapidly, no book except the InnoDB
online manual is fully up-to-date.
The page http://www.innodb.com/books.html contains a link to Michael
Kofler's MySQL book which treats InnoDB and BDB in appendixes. There is also
a link to a recent Terra Lycos
Ack
Case sensitivity of table names gets screwed up when doing stuff with
PHP/MySQL on Windows!! (Windows 95 in this case - yes, more
paleo-computing!).
I am using this set of canned scripts: phpslice v 0.2.0. The scripts have
been installed successfully in multiple places on UNIX, been
Due to problems with the Binary release for AIX (Dependent module libz.a
count not be found),
I decided to compile our own from source.
The resulting mysql works fine for the AIX machine where it was compiled,
but does not run on
SOME other AIX machines. The error reported is: Dependent module
At 14:34 -0500 3/25/02, Alexander, Chris wrote:
Ack
Case sensitivity of table names gets screwed up when doing stuff with
PHP/MySQL on Windows!! (Windows 95 in this case - yes, more
paleo-computing!).
I am using this set of canned scripts: phpslice v 0.2.0. The scripts have
been installed
I have created a table with a Primary Key that is an auto_incrementing
field. I was able to receive the auto_increment values by issuing a
last_insert_id(). When I added a timestamp to this table, the
last_insert_id() no longer returned any value except 0.
Is there a MySQL rule that you can
At 14:54 -0500 3/25/02, Eric Baines wrote:
I have created a table with a Primary Key that is an auto_incrementing
field. I was able to receive the auto_increment values by issuing a
last_insert_id(). When I added a timestamp to this table, the
last_insert_id() no longer returned any value
Hello all.
For my first post to the list, I have a very strange problem. (And yes,
I have perused the archives. I haven't found anything similar.)
Here's the situation:
I've got 6 machines that that make requests to a 7th machine, which is
running mysql-3.23.47. All the machines are
I'm nearing the end of my rope trying to figure this one out. I have
some queries run against a table that is a log of hits from a web
server. No matter how simple I've tried to make my query, MySQL sill
does not choose an index. Even use index has no effect.
My table:
CREATE TABLE
What percentage of your database contains rows where status = 200? It looks
to me like MySQL is estimating that perhaps 1/3 or more of the rows have that
status and therefore, it is faster to simply do a table scan rather than
using an index.
On Monday 25 March 2002 1:08 pm, Michael C. Neel
Ok I have a MySQL server.
And I have another MySQL server which is the replication
of the other DB server.
What I want to know is:
Is there a way to know if the replication server has finished
replicating the master server.
I think my DB has been corupted. ( A process on another
machine wrote
This seems to be something, running it with a where
domain=somedomain.com will use the domain index. Well, I'll bring out
the gimp...
Full query:
SELECT *, access_log.domain as host_domain, access_log.server as server,
DATE_FORMAT(MIN(date),'%M %e, %Y %r') as disp_date, access_log.username
as
I just went in looked at mySQLMan, and I must say, I'm not very
impressed with it. If you like that package, you should really try out
phpMyAdmin. You can download it at http://phpmyadmin.sourceforge.net.
It's completely free, quite secure, and very easy to use.
Matthew Walker
Ecommerce Project
Hi, I saw your discussion and i was wondering if any of you know if there is
a way to stop mySQL from ignoring 3-letter words in the AGAINST statement
when you use the MATCH operator?
Thanks,
-Tal-ee
-Original Message-
From: Dan Tappin [mailto:[EMAIL PROTECTED]]
Sent: Monday, March
3.23.50 is referenced in the documentation but not available
for download. Should it be there?
Don't mean to nag, but I'm itching for that autoextend feature.
PS. mysql,query,table
--
Michael Bacarella | Netgraft Corporation
| 545 Eighth Ave #401
Systems Analysis | New
Are the first three machines closing their connections correctly?
Duncan
--
Duncan Salada | Titan | www.titan.com/testeval
Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216
-Original Message-
From: Gabriel [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002
Greetings. I would thank some feedback on this issue. The doubt is:
Should i create a table, with about 40-65 fields (ID, 3 or 4 of text, the
reamining of small/tiny int), or should i split it in about 4-6 tables,
dividing the fields between them?
Info:
The database would be read/write by PHP,
On Mon, Mar 25, 2002 at 02:56:58PM -0600, Michael Bacarella wrote:
3.23.50 is referenced in the documentation but not available for
download. Should it be there?
Not yet. :-)
Don't mean to nag, but I'm itching for that autoextend feature.
Based on previous posts, it'll be there in a week
I failed mention that I am using the ODBC driver to access this database.
Everything works great using the Unix client but not the ODBC driver. It
seems to have something to do with using DAO. I tried RDO and the
last_insert_id() is now working.
Can anybody confirm this?
Check in the slave's master.info file
In the first line you'll see a filename for the master's binary log an
in the second line you'll see the position.
Look at the file on the master server and compare the byte -size to the
position.
I wrote a little perl script/netsaint plugin that takes
Here are the 5 Rules of Data Normalization --
http://www.datamodel.org/NormalizationRules.html
Eliminate Repeating Groups
- Make a separate table for each set of related attributes, and give
each table a primary key.
Eliminate Redundant Data
- If an attribute depends on only
mysqladmin version
mysqladmin Ver 8.21 Distrib 3.23.42, for apple-darwin1.4 on powerpc
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL
You need a where clause at the end to tell it which row to update.
[EMAIL PROTECTED] wrote:
. mysqladmin version
mysqladmin Ver 8.21 Distrib 3.23.42, for apple-darwin1.4 on powerpc
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with ABSOLUTELY NO
Actually, the column you're referring to is a TIMESTAMP. As the manual
states, the first TIMESTAMP field in any table is automatically updated
whenever a change occurs. If you don't want this value to change, you should
use a DATETIME field instead. However, keep in mind that you'll have to
Is there anyway to drop a group of tables with a wildcard in MySql? I have
tried:
DROP TABLE IF EXISTS division1s*
and
DROP TABLE IF EXISTS division1s(*)
but neither one works. I am hoping that there is a good useable answer to
this.
Thanks in advance
Steve Buehler
Occasionally with MyODBC, MySQL and Access I am getting an error when
trying to close a window stating 'This action will reset the current
code in break mode. Do you want to stop the running code-Yes/No'. It
becomes impossible to close the window because it wont allow me to
select Yes. The
I agree; theres no reason to use anything but phpMyAdmin for database
maintenance over the web. The guys at phpwizard.net keep adding more
and more features which strengthen its position as THE package to use
for this application. I wouldn't use anything else.
$0.02
-Original Message-
1 - 100 of 141 matches
Mail list logo