Please help me understand this:
<>~ are supposed to adjust the weight of a word to the
relevancy score, but they only work in BOOLEAN MODE
and BOOLEAN MODE doesn't care about relevancy!
I am really confused. Could anyone kindly explain how
they supposed to work to me?
Thanks so much!
Haitao Ji
Hi,
If You take Your really exellent "MySQL Reference Manual", and search for "timestamp"
or look into chapter 6.2, You fill find what You are looking for.
Best regards
Peter
- Original Message -
From: CurlyBraces Technologies ( Pvt ) Ltd
To: [EMAIL PROTECTED]
Sent: Friday,
Hi!
try using the one installed in /usr/local/mysql/bin/mysql_install_db
Best Regards!
On Wed, 2004-02-25 at 18:45, Kirti S. Bajwa wrote:
> Hello List:
>
> I have installed MySQL Master Server from Binaries 4-5 times without
> problem. Now I am installing MySQL CLIENT from source and have run
Hi!
It seems that you have installed mysql, but you did not run the
mysql_install_db, this script will create mysql "internal" databases(the
ones that carries user and config info), the script is usually in
"install_prefix/bin/mysql_install_db"
If you have no recently installed mysql, and the ser
Hi List,
I'm using mysql-4.0.15a. But we need some specific features present in 4.1.X such as
1. INSERT ... ON DUPLICATE KEY UPDATE query support
2. Innodb multi-table space (one ibdata file per table)
Could someone point me to patches for them for 4.0.15a release. so that I can back
merge the
I don't like your chances of successfully doing this. You could try
pulling the changesets out of the bitkeeper repository by hand but the
fact that 4.1.X was branched from an earlier version of the 4.0.x series
(I think), it might be a bit of a strugle.
Anyways, good luck! :-)
Regards,
Chris
O
Sanjay,
It seems you didn't run mysql_install_db script which is located in /scripts
directory. This script creates Grant tables for you when you first install mysql.
Basically the error says you missing those grant tables, you can re-run the script and
recreate them.
Hope that helps!!
Raza
No change. Any other suggestion?
Thanks.
Kirti
-Original Message-
From: Victor Medina [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 7:26 AM
To: Kirti S. Bajwa
Cc: '[EMAIL PROTECTED]'
Subject: Re: Installation problem!!!
Hi!
try using the one installed in /usr/local/mysql
For anyone who is interested the thing that worked and brought the query
down from 8 minutes to 5 seconds was separating out the JOIN to remove the
OR. I made it into two queries and UNIONed them together and it all works
beautifully now.
Thanks.
At 02:33 PM 2/25/2004 -0800, Daniel Clark wrote
Without seeing the data I am assuming that you are going over the 30%
threshold with your less/greater equal to where clauses. What sort of
criteria are you asking the database engine to search for?
>> Original Message <<
On 2/25/04, 9:44:02 PM, <[EMAIL PROTECTED
Greetings,
I am replicating from 4.0.17 to 4.0.16. I read through the replication
docs, and I didn't see anything relating to what I'm trying.
What I am hoping to do ... is slave the multiple databases ( the whole
thing ), in order to avoid shutting down ( or at least locking ) the
master and ma
"Jennifer Horne" <[EMAIL PROTECTED]> wrote:
> We've recently started using MySQL for customers with a large number of
> records on their systems.
>
> For the first time, one of our customers has gone over the 4 million
> record mark, and we're running into some problems with the MAX_JOIN_SIZE
> a
On Wed, 25 Feb 2004, Sasha Pachev wrote:
> >
> > where dbh is a global MYSQL structure. This code works fine on the old
> > system. If I pull it out into it's own little test program on the new
> > server, it also works fine. But when I put it in with the analog source
> > code, it compiles fi
> Is there a corresponding 'AND' version of the 'UNION' ?
... UNION ALL ...
PB
Keith Thompson wrote:
What is the preferred way of storing a dollar amount in the range
0.00 - 9.99?
double
decimal(11,2)
bigint (storing value*100)
...?
I'm more interested in speed of use as an indexed column (especially
for range searches) than in disk space usage.
bigint sh
Problem: all the mod_perl pages run a few write queries, so they will require a
connection to the main database server. Since around
80% of our queries are reads, would you recommend that each script has two
connections: one for read queries, and one for write
queries? We can determine which quer
Andrea Riela wrote:
Hi folks,
my system: openbsd 3.3
mysql ver: 4.0.18
Well, I was working on phpBB conf, when I've seen errors from mysql:
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't fin
Philip Mak wrote:
Say I have this query:
SELECT *
FROM topics
ORDER BY lastPostTime DESC;
How would I modify it to answer the question "How many rows would be
returned before the row that has topics.id = $x"?
I was thinking of something like this:
$xPostTime = SELECT lastPostTime FROM topics WHER
Chuck Gadd wrote:
I've got a query that I can't seem to get optimized, so I'm
hoping someone here can spot something I've missing!
Table has three columns:
CoordID int unsigned,
Zip_Lo char(9),
Zip_Hi char(9)
Table has 3 million records
indexes:
acg_lo (Zip_Lo)
acg_hi (Zip_Hi)
acg_combined (Zip_Lo
all my mistake I deleted mysql.user this tablewhat can I do to
recover this ?
Plz help~
Best regards,
Vincent fung
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thu, Feb 26, 2004 at 09:50:39AM -0700, Sasha Pachev wrote:
> If I understood the problem correctly, the answer to it is actually
> undefined. If you order by lastPostTime, the records with the same
> lastPostTime value can be returned in any order.
>
> I guess to accomplish your goal you could
Sp.Raja wrote:
Hi List,
I'm using mysql-4.0.15a. But we need some specific features present in 4.1.X such as
1. INSERT ... ON DUPLICATE KEY UPDATE query support
2. Innodb multi-table space (one ibdata file per table)
Could someone point me to patches for them for 4.0.15a release. so that I can ba
Vincent wrote:
all my mistake I deleted mysql.user this tablewhat can I do to
recover this ?
Restore from backup.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
Hello!
I'm using a WLS server and MySQL. Where am I supposed to put the
"mysql-connector-java-3.0.11-stable-bin.jar" to make sure WLS will find it? I've tried
several places ie. under ttk and right under classes. Still WLS doesn't find my
mysql.jar file. It works when I'm compiling it locall
You can also rerun the scripts/mysql_install_db
This will reinstall the mysql.hosts form and allow you to reconnect to your
server.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Philip Mak wrote:
On Thu, Feb 26, 2004 at 09:50:39AM -0700, Sasha Pachev wrote:
If I understood the problem correctly, the answer to it is actually
undefined. If you order by lastPostTime, the records with the same
lastPostTime value can be returned in any order.
I guess to accomplish your goal yo
Jochem van Dieten wrote:
Vincent wrote:
all my mistake I deleted mysql.user this tablewhat can I do to
recover this ?
Restore from backup.
If there is no backup, mysql_install_db will re-recreate the default install
version - just make sure to remove all mysql/user.* files from the datadir
Cliff Addy wrote:
On Wed, 25 Feb 2004, Sasha Pachev wrote:
where dbh is a global MYSQL structure. This code works fine on the old
system. If I pull it out into it's own little test program on the new
server, it also works fine. But when I put it in with the analog source
code, it compiles fine
On Thu, Feb 26, 2004 at 10:49:08AM -0700, Sasha Pachev wrote:
> >SELECT COUNT(*)
> >FROM topics
> >WHERE lastPostTime > $postTime
> >OR (lastPostTime = $postTime AND id > $id);
>
> Can you just add id > $id to the where clause?
No, that won't work because id is only used to disambiguate the order
Hello all:
I have 2 machines, Primary and Secondary. The updates
on the Primary are being replicated on the Secondary
via MySQL Replication.
Additionally there are updates to specific tables
(Alarms) that are more important than other updates.
I do not want the Alarm updates to be queued behind
Hi Matt, thanks for shedding light on the version and key_len issues.
Either phpMyAdmin or MySQL is labelling the return of blank results as an
error, thus my use of the term. The output from phpMyAdmin looks like this:
Error
SQL-query:
SELECT subject FROM entry WHERE MATCH (subject) AGAINST
Hi,
I was just wondering what the valid range for ports is for the MySQL server
in a Windows environment. Obviously, the server won't connect to a port
already in use, but I know some programs disallow ports under 1024.
Thanks,
Matt
--
MySQL General Mailing List
For list archives: http://list
Have one more question - indexing the relevant columns based on the explain
info has made all of our queries immensely faster.
But it appears that new rows are not automatically indexed. Does anyone
know about this and if they are not indexed how do I reindex the tables?
Thanks.
--
MySQL Gen
On 26 Feb 2004 at 13:22, Eric Scuccimarra wrote:
> But it appears that new rows are not automatically indexed. Does
> anyone know about this and if they are not indexed how do I reindex
> the tables?
You're misunderstanding something. When you create an index, all the
rows in the table are inde
Philip Mak wrote:
On Thu, Feb 26, 2004 at 10:49:08AM -0700, Sasha Pachev wrote:
SELECT COUNT(*)
FROM topics
WHERE lastPostTime > $postTime
OR (lastPostTime = $postTime AND id > $id);
Can you just add id > $id to the where clause?
No, that won't work because id is only used to disambiguate the
Eric Scuccimarra wrote:
Have one more question - indexing the relevant columns based on the
explain info has made all of our queries immensely faster.
But it appears that new rows are not automatically indexed. Does anyone
know about this and if they are not indexed how do I reindex the tables?
Matt P. Fuller wrote:
Hi,
I was just wondering what the valid range for ports is for the MySQL
server in a Windows environment. Obviously, the server won't connect to
a port already in use, but I know some programs disallow ports under 1024.
MySQL introduces no port restrictions of its own. If t
Gowtham Jayaram wrote:
Hello all:
I have 2 machines, Primary and Secondary. The updates
on the Primary are being replicated on the Secondary
via MySQL Replication.
Additionally there are updates to specific tables
(Alarms) that are more important than other updates.
I do not want the Alarm updat
I have a .mdb file which I need to import into MySQL. This needs to be
done behind the scenes and with code. Can I use LOAD DATA INFILE where
I use the .mdb file instead of a .txt file?
If not does anyone have any suggestions?
Thanks,
Jacque
Since the connection pool needs to load the driver, putting the driver jar
in WEB-INF is too late. One option is to put in the startWeblogic file and
add it to the classpath there. Depending on the version of WLS there are
various way to accomplish this.
Best regards...
-
Answers to J2EE, J
Hi,
The comments in the fulltext doc page
(http://www.mysql.com/doc/en/Fulltext_Search.html) discuss the issues of
stopwords and over 50% hits, so I did my best to avoid those particular
bombs in my searches.
The "subject" column contains subjects for message posts/entries, and as
such they'r
> I have a .mdb file which I need to import into MySQL. This needs to be
> done behind the scenes and with code. Can I use LOAD DATA INFILE where
> I use the .mdb file instead of a .txt file?
An "mdb" file isn't exactly the same as text, is it?
You might as well use MS Word as the source ;-)
Matt:
Read the port specifications enumerated in the services file in
%SystemRoot%\win32\drivers\etc
Contact your net/sys admin to see which ports he is allowing to cross his
firewall.
Some admins shut off everything except 80 (HTTP)
HTH,
-Martin
- Original Message -
From: "Matt P. Fuller"
Hi =)
How would you approach the design of a database that models the
following information?
- Users
- Invoices
- Purchase Orders
- Sales Orders
- Adjustments
- Products
We were originally working with Users, Purchase Orders, Sales Orders,
and Products. Everything was pretty easy at first... I
Hi All,
If I got one table A_table with many columns, and a second table B_table is
the same but with just primary field and unique field...
How much meaningful is the time difference between these queries?
1. SELECT unique_field FROM A_table WHERE prim_field='val';
2. SELECT unique_field FROM B_t
You might want to append table to table.. in this case you should use UNION
(not JOIN).. but if you got 2 identical tables of type MyISAM, then you can
define a MERGE table like this:
CREATE TABLE new_table (*table definition of the original tables*)
type=MERGE union=(all_by_Payroll,payinc);
then
Your business requirement is not quite clear. Here are some questions
that you need to answer before you finalize your design:
1. How often will the invoice be viewed (and I assume the viewers must
be your web site users?)
2. What's the approximate traffic volume?
3. Will each time the users vie
Does anybody know the product able to serialize multiple similar queries coming from
different sources to the one SQL server? Could
be nice to have something as a SQL proxy with cashing pool, expiration, etc to put the
main server load down and release his
resources.
Thanks in advance for an
I raised tmp_table_size to 1000M and restarted mysql on the slave and still
got the same error. Any other variables I should be looking at?
Thanks,
Brian
"I don't need any of that SQL stuff -- I just want a database!"
-Original Message-
From: Sasha Pachev [mailto:[EMAIL PROTECTED]
Sen
Hi Charles,
Answers:
1. Frequent web viewers
2. Medium... internal website
3. An invoice will get frequent views while it's active, but very few
views after it's completed.
4. About 1200 entries a month.
Are there approaches other than what I described?
-Ed
-Original Message-
Your
I am using this:
Statem=MyQueryResults.ConnectionUsed.createStatement(
java.sql.ResultSet.TYPE_FORWARD_ONLY,
java.sql.ResultSet.CONCUR_READ_ONLY);
Statem.setFetchSize(Integer.MIN_VALUE);
But, it will not allow me to do .first() on the ResultSet...or
Hello All,
Is it possible to define MERGE table on several tables with full-text
indexes?
And to make a select on the MERGE table with MATCH AGAINST?
thanks,
-Lorderon.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
Ed
The MS Access SQL syntax for if() is iif(condition, then stuff, else stuff)
Maybe that's the problem, I am not sure - try it
Freddie
-Ursprüngliche Nachricht-
Von: Ed Reed [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 26. Februar 2004 02:09
An: [EMAIL PROTECTED]
Betreff: Query err
--- Sasha Pachev <[EMAIL PROTECTED]> wrote:
> Gowtham Jayaram wrote:
> > Hello all:
> >
> > I have 2 machines, Primary and Secondary. The
> updates
> > on the Primary are being replicated on the
> Secondary
> > via MySQL Replication.
> >
> > Additionally there are updates to specific tables
> >
Given these two tables:
create table t1 (
id int unsigned auto_increment,
a int,
... [other fields]
primary key (id),
index aid (a,id)
) type=innodb;
create table t2 (
id int unsigned,
b int,
... [other fields]
index id (i
Your resultSet needs to be scrollable. You have created a streaming
resultSet.
>> Original Message <<
On 2/26/04, 12:33:38 PM, Ted Hulick "(nVision" "Software)"
<[EMAIL PROTECTED]> wrote regarding Large
ResultSets/TYPE_SCROLL_INSENSITIVE:
> I am using this:
Hi,
We wanted to keep one of Innodb table on RAM disk in our database design so
that we can get better performance. We were hoping the take adventage of
using MULTIPLE TABLESPACE feature of 4.1.1 but I just found out that InnoDB
stores each table into its own file tablename.ibd in the database dir
I mentioned that at the end of my original message. I've tried it both
ways and it doesn't solve the problem.
The query is good. For some reason though Access or MySQL is removing
the IF statements in the middle of it.
What next?
>>> "Freddie Sorensen" <[EMAIL PROTECTED]> 2/26/04 12:25:03 PM >
It sounds like the following requirement got you thinking about the problem
in the wrong way, though you still came up with a viable solution:
> invoices need to list all purchase orders, sales orders, and
> adjustments for a given time period. I could display the invoice
> and then display pu
hi, Mike.
What do this using an encrypted loopback-device, on which the
/var/lib/mysql stuff resides.
just check "man losetup" for instructions.
i'm NOT sure about the preformance issues, though.
and i am very concerned about filesystem-corruptionby my logic,
there's a double risk, since the
Hello,
I'd like to apologize, I know what I am asking is probably impossibile,
but I would like to know if someone has a way to set up permissions on a row
basis, for example if a certain condition matches (for example, grant select on
row if columnA is NULL).
Anyone has any idea on how to do so?
I
Evelyn:
I need help. I have followed your instructions. Here is my problem:
. Installation
...
...
Shell> Make Install
Shell> scripts/mysql_install_db
bash: scripts/mysql_install_db: No such file or directory
--
Am I following the correct sequence? There is no directory "scripts"!
You could use views but they will not be available until version 5 or 5.1
In the doc you can find :
Views are useful for allowing users to access a set of relations (tables) as
if it were a single table, and limiting their access to just that. Views can
also be used to restrict access to rows (a
This query was pretty fast avg. 1-3 s / search
SELECT m1.id FROM table1 AS t1 JOIN table AS t2 ON m1.textid=m2.id WHERE
match(t2.text) AGAINST('$searchString' IN BOOLEAN MODE);
I also added an index on table1.textid and table2.id.
Is there a way to optimize this query even more?
// Fredrik Car
Hi,
I'm running RedHat Linux 7.2 and I want to install MySQL 4.1. I have downloaded the
following RPM packages to install in the following order:
MySQL-server-4.1.1-1.i386.rpm
MySQL-client-4.1.1-0.i386.rpm
MySQL-devel-4.1.1-0.i386.rpm
MySQL-shared-4.1.1-0.i386.rpm
I try to install the packag
As per the reco of someone on this list, I created a bash script that runs
once a day to do the following:
# set path to final destination
location="/Volumes/foo/sql_dumps/"
# set db_list to the list of databases
db_list=`echo "show databases" | /usr/local/mysql/bin/mysql -N -u
-p`
for d
Ed,
In that case (and I assume your web server and database server are on
the same cluster), your original idea is good: store foreign keys in
your invoice table pointing to all other tables. In other words, once
an order is entered, there is also an entry to the invoice table.
However, you shou
Hi List,
I need to create a complex Select joining 2 tables.
Table Product, I have these fields:
Code (PK)
Description
Records:
01 Product A
02 Product B
Table Price, I have these fields:
Code (PK/FK)
S
How can I add an auto-incrementing primary key to an existing table?
MySQL version 4.0
Thank You
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello
I use SQLyog (http://www.webyog.com/sqlyog) to import
data from my access db to MySQL.
Karam
--- Jacque Scott <[EMAIL PROTECTED]> wrote:
> I have a .mdb file which I need to import into
> MySQL. This needs to be
> done behind the scenes and with code. Can I use
> LOAD DATA INFILE where
>
I need to do this behind the scenes. The user will need to press a
button for the .mdb file to be imported. I can't use a thrid party
program for this.
Thank you any way.
>>> Karam Chand <[EMAIL PROTECTED]> 2/26/2004 5:22:51 PM >>>
Hello
I use SQLyog (http://www.webyog.com/sqlyog) to import
d
Hi Paul,
ALTER TABLE table_name ADD id_column_name INT UNSIGNED NOT NULL
AUTO_INCREMENT PRIMARY KEY FIRST;
The FIRST word at the end just makes it the first column in the table if
that's what you want.
Hope that helps.
Matt
- Original Message -
From: "Paul Maine"
Sent: Thursday, Feb
Lorderon wrote:
Hi All,
If I got one table A_table with many columns, and a second table B_table is
the same but with just primary field and unique field...
How much meaningful is the time difference between these queries?
1. SELECT unique_field FROM A_table WHERE prim_field='val';
2. SELECT uniqu
Colin Lawrence wrote:
Hi,
I'm running RedHat Linux 7.2 and I want to install MySQL 4.1. I have downloaded the following RPM packages to install in the following order:
MySQL-server-4.1.1-1.i386.rpm
MySQL-client-4.1.1-0.i386.rpm
MySQL-devel-4.1.1-0.i386.rpm
MySQL-shared-4.1.1-0.i386.rpm
I try to
I have MySQL Server 3.23.xx running on RedHat Linux 9 with 40GB
harddrive and 256 RAM. I'm using MyISAM table type with around 157
tables.
I think i decided to change MyISAM table to InnoDB table. But, I don't
know how to do that for the first step. I have read a section on MySQL
documentation abo
On Thu, 26 Feb 2004, Lorderon wrote:
> Hi All,
>
> If I got one table A_table with many columns, and a second table B_table is
> the same but with just primary field and unique field...
> How much meaningful is the time difference between these queries?
> 1. SELECT unique_field FROM A_table WHERE
On Thu, 26 Feb 2004, Keith Thompson wrote:
> Given these two tables:
>
> create table t1 (
>id int unsigned auto_increment,
>a int,
>... [other fields]
>primary key (id),
>index aid (a,id)
> ) type=innodb;
>
> create table t2 (
>id int un
Asep Andria I.W. wrote:
I have MySQL Server 3.23.xx running on RedHat Linux 9 with 40GB
harddrive and 256 RAM. I'm using MyISAM table type with around 157
tables.
I think i decided to change MyISAM table to InnoDB table. But, I don't
know how to do that for the first step. I have read a section o
hi ,
i have created datetime field in the field name
"abc".
so i want to get the system date and time
automatically to the abc field for in each records. how can i do that ?can
somebody help me .plz
thanx in advance
curlys
--
MySQL General Mailing List
For list archiv
1) This is mostly an SQL question, although MySQL may have some trick up its
sleeve that would help me.
2) I've searched the archives, and google
3) I've been using SQL for a long time, but can't think of a way to solve this
4) This may not be possible. :)
I am dealing with serial data that is be
Using the latest MySQL 4.
I could use some help on performing a join but not retrieving all the
records of the child table. I have a set of tables, the ones involved
in this are related as follows:
members (one) -< (many) orders (one) -< (many) orderitems
The end result should be a list of ord
- Original Message -
From: CurlyBraces Technologies ( Pvt ) Ltd
To: mos
Sent: Friday, February 27, 2004 11:51 AM
Subject: Re: datetime in mysql
sorry , as u said , i did it . it doesn't work for
me .This table i want to view in the Web. So that date and time must fully
automated
"Mahefa Randimbisoa\\DS-ETU" <[EMAIL PROTECTED]> wrote:
> You should know the meaning of next SQL statements :
>
> SELECT DECODE(field_name, '0', 'Sunday', '1', 'Monday', '2', 'Tuesday')
> FROM table_name
>
> (This should mean : if field_name = '0', return 'Sunday', if field_name =
> '1', returns
Hi,
thanks for your answer.
I tried what you suggested:
select table1.id,table1.name from table1,table2 where
table1.textid=table2.id AND match(table2.text)
AGAINST('$searchString' IN BOOLEAN MODE);
But that query takes for ever to run and uses 100% cpu. Is there a
faster way to do this query?
Duncan Hill <[EMAIL PROTECTED]> wrote:
> Mysql version: 4.1.1
> Platform: Linux, pre-compiled RPMs from mysql.com
>
> My problem:
> Right now, I use a routine that selects the IDs that haven't been seen, and
> promptly does an insert into notifications_seen to flag that it has been
> seen. This
Hi!
You should know the meaning of next SQL statements :
SELECT DECODE(field_name, '0', 'Sunday', '1', 'Monday', '2', 'Tuesday')
FROM table_name
(This should mean : if field_name = '0', return 'Sunday', if field_name =
'1', returns 'Monday', ...)
I try to use this with mysql (in EasyPHP: Apache
"Bing Du" <[EMAIL PROTECTED]> wrote:
>
> Our MySQL server (4.0.13) is currently running with the option
> --skip-networking. We want the server to accept TCP/IP connections. If
> this option were specified in the config file, perhaps I could just modify
> the config file and HUP the server proce
Fredrik Carlsson <[EMAIL PROTECTED]> wrote:
> Hi,
> I have a question regarding to search with fulltext on table and fetch
> the data from another.
>
> Table one:
> id, textid, name, number, url
>
> Table two:
> id, text
>
> On table two there is a fulltext index.
>
> These two tables recentl
John Heitmann <[EMAIL PROTECTED]> wrote:
> >Description:
>
> When a temp table is included twice in a query mysql fails with the
> error:
>
> ERROR 1137 at line 9: Can't reopen table: 'foo'
>
> This happens on both 4.0.17 and 4.0.18. It did not happen on 4.0.14.
>
> >How-To-Repeat:
>
> create
"Soni, Sanjay K" <[EMAIL PROTECTED]> wrote:
> 040225 13:57:20 mysqld started
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 040225 13:57:21 InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full:
As per the reco of someone on this list, I created a bash script that runs
once a day to do the following:
# set path to final destination
location="/Volumes/foo/sql_dumps/"
# set db_list to the list of databases
db_list=`echo "show databases" | /usr/local/mysql/bin/mysql -N -u
-p`
for d
91 matches
Mail list logo
