Hello Ow Mun,
there are various ways to backup InnoDB tables
1. SELECT ... INTO OUTFILE statement for your tables and reimport them
2. ibbackup (a commercial tool to copy InnoDB Databases while the server is
running
3. Stop the server, copy the innodb tablespace files and logfiles to the new
loc
On Fri, 2006-10-13 at 08:22 +0200, Rocco Di Leo wrote:
> Hello Ow Mun,
>
> there are various ways to backup InnoDB tables
>
> 1. SELECT ... INTO OUTFILE statement for your tables and reimport them
> 2. ibbackup (a commercial tool to copy InnoDB Databases while the
> server is running
> 3. Stop t
Hello Low Kian,
first, you cannot attach files to this mailing list, however from the error,
i assume that you have not specified different socks and ports for each
MySQL instance. You need to put that information into your configuration
file for each server , e.g.:
#server 1 option file
port=33
On Thu, 2006-10-12 at 23:43 -0500, Brian Ivins wrote:
> If the tables are myisam (not innodb), and you're moving them to a system
> with the same or newer version of mysql,
> it should work. You have the best chance of it working if the tables aren't
> being accessed, and you do a "flush tables
Dear all,
I am trying to run two mysql instances on one server using the
mysqld_multi command. Attached is my configuration file. The data
directory is at /var/lib/mysql and /var/lib/mysql2. When i try to run
mysqld_multi start 2,3 it won't start up and the error i get is that
something else is a
Hi,
Create the initial databases and start the database with the following
commands:
shell> mysql_install_db --datadir=/var/lib/mysql2
shell> mysqld_safe --datadir=/val/lib/mysql2
Thanks
ViSolve DB Team.
- Original Message -
From: "Low Kian Seong" <[EMAIL PROTECTED]>
To:
Sent: Frid
Dear all,
If I am already have a datadir in /var/lib/mysql and I intend to start
a new one in /var/lib/mysql2, how do i do it ?
Thanks in advance,
Low Kian Seong
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTE
Hi All,
Wondering if it's possible for me to just tar up the DB (eg: TEST_DB)
and then move it AS IS to another system?
Is this possible or will I have to do a mysqldump (inclusive of create
tables / data etc)??
It would be good if I can just copy (tar) the DB to another system and
then re-atta
Hi,
You're not using the correct version.
The right one to compile is under "Source and other files" downloads
section at the bottom of the page.
Regards,
Deckard
abraham c wrote:
> Hello,
>
> We are trying to build from source MySQL standard ver. 4.2.1 on an
> Intel-based machine running LINU
Hello,
We are trying to build from source MySQL standard ver. 4.2.1 on an Intel-based
machine running LINUX FEDORA Core 5 without success Using a binary
distribution. No RPMs
Hardware being used: Optiplex GX620 Dell system. Pentium D-based processor and
1 GB of memory. Kernel 2.6.15-1.2045_F
Hello,
We are trying to build from source MySQL standard ver. 4.2.1 on an Intel-based
machine running LINUX FEDORA Core 5 without success Using a binary
distribution. No RPMs
Hardware being used: Optiplex GX620 Dell system. Pentium D-based processor and
1 GB of memory. Kernel 2.6.15-1.2045_
It doesn't. That was one of the multiple wildcard variations I
already tried.
David
On Oct 12, 2006, at 3:13 PM, Anders Lundgren wrote:
I think you should try % that is used as wildcard instead for one
or many characters. Granting on 'foo_%' might work.
Regards,
Anders
--
Anders Lundgre
MAS -
what you may have forgotten to do is tell system C where (or when if
you think of it that way) to start replicating. Either that or system
C wasn't empty when you started replicating into it.
The procedure to set up replication like this would be: freeze master,
flush data, record binlog
I think you should try % that is used as wildcard instead for one or
many characters. Granting on 'foo_%' might work.
Regards,
Anders
--
Anders Lundgren
Master Software Engineer
Viba IT Handelsbolag
Web: http://www.vibait.se
David Felio wrote:
Assume database 'biggie' with 15 tables, 10 of wh
I'd like to know what is the best way to setup the replication on my
system.
I hve all myisam tables and:
- main db on production (master: system A; mysql 4.0.x);
- slave db as backup/backoffice (system B; mysql 4.0.x);
both are working and the replication works well.
- system B is also the
Assume database 'biggie' with 15 tables, 10 of which start with
'foo_'. I want the user 'foouser' to have access only to those tables
that begin with 'foo_'.
I'm hoping that I am just being blind because I don't see anything in
the manual or in the MySQL book on granting to multiple tables
Hi,
I've tested the exact same ASP pages on my local computer, and the pages load
very quickly. Therefore there must be a problem with dedicated windows server.
Any ideas what the problem might be ?
Thanks,Neil
> Date: Sun, 8 Oct 2006 17:17:07 -0500> To: mysql@lists.mysql.com> From: [EMAIL
Actually, the prod_num IS an auto-increment field, so you're suggestion
would work. It would be much better than updated, especially since I found
out that someone was busily updating the old products after the new ones
were put in. I just started down the wrong road and never rethought the
matter.
You're kind of heading down the right road. And this was discussed on the list
not too long ago, how to delete duplicates.
Here's one solution that will find the oldest duplicate(s):
SELECT prod.prod_num,prod.prod_title,prod.updated FROM prod
JOIN (
SELECT prod_title,max(updated) maxdate
FROM pr
It seems to me I ought to be able to construct a query, probably using
sub-SELECTs), that would do what I want. I have a table that looks roughly
like this:
CREATE TABLE prod (prod_num INTEGER UNIQUE, prod_title VARCHAR(255), updated
DATE)
UNIQUE PRIMARY KEY (prod_num);
In this table there migh
On Wed, 2006-10-11 at 16:03 -0700, ADAM CZECH wrote:
> Does anyone know why a mysql alias would not display in the return a
> result?
>
> When I try to access say the first name with it's alias f_name, it is
> blank? , but it works for its column name first_name? This becomes
> more of a problem
Based on my experience, that wouldn't quite work. You'd need to preface each
word with a plus sign:
+olive +oil*
and it would return records regardless of the order in which the two words
appear, nor how far apart they are. That might be desirable, or it might
not.
Regards,
Jerry Schwartz
Globa
Hi ViSolve,
I have tried various combinations with + and *,
and with single and/or double quotes.
But unfortunately I can't get the proper results.
I get the impression that it's not possible ...
Thanks anyway, Cor
- Original Message -
From: "Visolve DB Team" <[EMAIL PROTECTED]>
To: "
You'd have to use another table. I don't believe mysql views will keep your
'moving average' values.
If you're using 5.1, you can automate the select/insert with an event --
it's a cron like tool built into mysql.
If you have a datetime field in either of the tables that represents the
'action'
Heikki
thanks for filing that report. You can close it again.
I had a look at the create-table statements for these 3 tables.
As it turns out, the person who initially created those tables had a
create statement like "create table ... comment='InnoDB free: 6144 kB'"
for some tables.
All my
Dominik,
I have now filed:
http://bugs.mysql.com/bug.php?id=23211
about this. Is there any pattern that could explain why the double print
is only in those 3 tables? What values does it print for the tables
where the printout is wrong, and what values does it print for ok tables?
Best regar
what does SHOW TABLE STATUS show for other tables?
It shows 2 values for about 3 of 260 tables. So most tables are okay. It
does not seem to depend on table size, as the other tables only have a
few hundred rows.
Are you using innodb_file_per_table?
Yes.
--
MySQL General Mailing List
For
Dominik,
what does SHOW TABLE STATUS show for other tables?
Are you using innodb_file_per_table?
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
MyISAM table
Hi,
Try with + and * fulltext boolean operators.
For instance,
MATCH (Description) AGAINST('+olive oil*' IN BOOLEAN MODE)
Thanks,
ViSolve DB Team.
- Original Message -
From: "C.R.Vegelin" <[EMAIL PROTECTED]>
To: "Visolve DB Team" <[EMAIL PROTECTED]>;
Sent: Thursday, October 12, 2006 4
Thanks ViSolve,
So far I have tried the next alternatives, not giving me what I need:
a) ... MATCH (Description) AGAINST('"olive oil"' IN BOOLEAN MODE)
giving only "olive oil" but not "olive oils"
b) ... MATCH (Description) AGAINST('olive oil' IN BOOLEAN MODE)
giving "olive oil" and "olive
Hi
The Boolen Search will itself satisfy your query. If you enclose the phrase
within double quote ('"'), then the characters matches only rows that contain
the phrase literally, as it was typed.
Try removing quotes.
Thanks
ViSolve DB Team.
- Original Message -
From: "C.R.Vegelin" <[
I recently deleted about 7.000.000 rows from a table, there are about
4.000.000 left.
So I want to know how much space is free in table space now and execute:
mysql> show table status like "table"\G
*** 1. row ***
Name: table
En
Hi,
We are thinking of installing MySQL (4.1.x) on 2 nodes sharing the data
over a SAN and using GFS. Is this setup correct, can the 2 nodes run
active/active ?
--
Taymour A El Erian
System Division Manager
RHCE, LPIC, CCNA, MCSE, CNA
TE Data
E-mail: [EMAIL PROTECTED]
Web: www.tedata.net
Hi All,
I want a boolean search on a phrase.
For example on "olive oil", but it should return also "olive oils" etc.
Now I use the following:
SELECT Description FROM products
WHERE MATCH (Description ) AGAINST('"olive oil"' IN BOOLEAN MODE);
This works fine, but it does NOT return rows with "olive
34 matches
Mail list logo
