Hi everybody,
I am trying to compile/configure MySQl 5.0.41 on a Mandrake 10 linux box.
In doing so, I am getting some errors with mysql_install_db (ERROR: 1049
Unknown database 'mysql', Installation of system tables failed!)
Please let me know how to solve the problem.
Thanks in advance for
Hi,
To take consistent backup, it is enough if you go for "mysqldump".
1) $ mysqldump -u user -p [table1,table2] >
-- this itself takes consistent backup. mysqldump utility by default locks
the table.
2) From one terminal issue
mysql> LOCK TABLES WRITE;
From another table, issue $>mysqldump
In the last episode (Jun 15), Edward Kay said:
> I have a table of addresses. Each address is associated with a primary
> entity and a primary entity can have n different addresses. For each primary
> entity, one address is marked as the main address.
>
> I need a query to return all addresses tha
Hi Edward,
Edward Kay wrote:
I have a table of addresses. Each address is associated with a primary
entity and a primary entity can have n different addresses. For each primary
entity, one address is marked as the main address.
I need a query to return all addresses that are the only address as
Hello,
Je peux lire des Français, mais l'écriture qu'il n'est pas comme facile.
Ainsi j'emploie des poissons de Babel pour traduire ceci
d'anglais-français. Ainsi, mes excuses s'il la grammaire est totalement
erroné.
Très intéressant. Je devinerais que le problème s'est produit dans le
tra
I have a table of addresses. Each address is associated with a primary
entity and a primary entity can have n different addresses. For each primary
entity, one address is marked as the main address.
I need a query to return all addresses that are the only address associated
with the primary entity
Hello,
j'ai 2 machines Linux debian etch, avec MySQL 5.0.32
J'ai un problème d'affichage sur l'une des machines :
j'ai créé la même table et chargé le même fichier data
dans une base sur chaque machine, et l'affichage est différent.
Je ne vois pas oú est la différence...
my.cnf idem
locale idem
On Fri, June 15, 2007 16:29, Ben Clewett wrote:
> Dear MySql,
>
> I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with
> date comparisons.
>
> In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00' is True.
> In 5.0.41:'2007-06-15' = '2007-06-15 00:00:00' is False.
> In 5.
Hello,
Did you already check:
http://dev.mysql.com/doc/refman/5.0/en/replication-compatibility.html
"You cannot replicate from a master that uses a newer binary log format
to a slave that uses an older format (for example, from MySQL 5.0 to
MySQL 4.1.)"
Thanks,
Jimmy Guerrero
Sr Product Ma
In the last episode (Jun 15), Ben Clewett said:
> > Are there any reasons why one would NOT use separate ibd files for
> > each table
>
> Fragmentation for one.
>
> A single file can re-use empty space from deleted rows for any added
> rows. A single file can only re-use space from that one
Ben Clewett wrote:
Dear MySql,
I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with
date comparisons.
In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00' is True.
In 5.0.41:'2007-06-15' = '2007-06-15 00:00:00' is False.
In 5.1.6-alpha: '2007-06-15' = '2007-06-15
There was a comment this week about a v5 master having problems connecting
to a v4 slave, or vice versa.
Can someone shed some light on this issue.
A manual reference is good, too.
Thanks,
David
Olaf Stein wrote:
Hi all,
Are there any reasons why one would NOT use separate ibd files for each
table (--innodb_file_per_table). It seems logical to me to separate what
does not belong together logically (different databases), but I as the
shared tablespace is the default I wonder if it has na
> Hi all,
>
> Are there any reasons why one would NOT use separate ibd files for each
> table
Fragmentation for one.
A single file can re-use empty space from deleted rows for any added
rows. A single file can only re-use space from that one file.
Therefore the sum table size will be larger
Dear MySql,
I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with
date comparisons.
In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00' is True.
In 5.0.41:'2007-06-15' = '2007-06-15 00:00:00' is False.
In 5.1.6-alpha: '2007-06-15' = '2007-06-15 00:00:00' is True.
Hi All,
If you specify one file per table, these files would be created under the
database directory of that particular database . So, the benifit with
respect to IO is negative. To have these files placed in different file
system to get IO benifit, you need to use symbolic links.
Please correct
Hi all,
Are there any reasons why one would NOT use separate ibd files for each
table (--innodb_file_per_table). It seems logical to me to separate what
does not belong together logically (different databases), but I as the
shared tablespace is the default I wonder if it has nay advantages I am no
Thanks all for this response.
This mysqlhotcopy take backup of .frm,.myd and .myi files, but my boss wants
what mysqldump does.
So, is it possible to take a consistent backup of myisam tables using
mysqldump.
Regards
anandkl
On 6/15/07, ViSolve DB Team <[EMAIL PROTECTED]> wrote:
Hi
You c
Hi
You can also use "mysqlhotcopy".
like
$ mysqlhotcopy
the option
--addtodest - does not delete/rename the directory if directory> exists; instead it will append the data to the same.
[$mysqlhotcopy --addtodest dbname ]
--allowold - create a new ; if that already exists
renames it to _old
Is it just this line I need to change?
INNER JOIN url_categories uc ON uc.ID=bt.category_ID;
Would it change to something like:
INNER JOIN url_categories uc ON CAST(uc.ID as CHAR)=delimit(bt.category_ID)
Just guessing!
Thanks - that's what I thought. I really don't have much experience with
HI
You can use
$mysqldump dbname table1 [,table2,table3] >dumpfile[path] or $ mysqldump
dbname > dumpfile [path]
or
$ mysqldump --all-databases >dumpfile [path]
--opt will Add a DROP TABLE statement before each CREATE TABLE, Uses the
multiline INSERT syntax,Locks all tables on the server befo
21 matches
Mail list logo