hicham schrieb:
Hello
I'm new bie user of mysql, I need to create a database and import
some frm .myd .myi files
to that database , also if you can point me to some easy to start
tutorial for how to create user account in mysql , create a database ,
etc
Thanks for replying
Hicham
htt
boll schrieb:
Hi-
Using MySQL 4.1.11 on Fedora 4.
I moved my data directory to a FAT partition in order to share it with
Windows dual-boot.
Now when I try to start mysqld normally, it fails with these messages in
the log:
060420 18:16:03 mysqld started
060420 18:16:03 [Warning] Can't create
Hi
I'd like to know if there is anything to kill connections from a
specific client ip that came to the server on a specific interface.
I do not want to block them on layer 2 (which could easily be done with
netfilter), I would like to be able to kill active connections.
For example: I would
I am not really sure why you would need this , but I am just throwing in
a possible solution..
First I would say since you need to kill connections on a specific
interface (eth0), It would be fair to assume that you have more than one
interface, if thats the case and you don't have the "--bind
I experience that my slave gets blocked after a while (a couple of slave
stop and slave start happen in the meantime). In errorlog I see
Slave I/O thread: error reconnecting to master
'[EMAIL PROTECTED]:3306': Error: 'Host 'myhost.mydomain.de' is
blocked because of many connection errors; unbl
another question on this error message:
is it possible to see the count of errors for each host from some table
or file?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sheeri kritzer schrieb:
If your server has log-warnings set to ON, you can check the error
logs, and use a script to count how many times for each host, in a
row, this happens.
+---+---+
| Variable_name | Value |
+---+---+
| log_warnings | 1 |
I did not tur
Hi,
for recovery purposes I need to know what exactly is in the master.info
file. Especially the log position. Is it Read_Master_Log_Pos or
Exec_Master_Log_Pos?
Another question: Does "stop slave;" only stop reading the log from
master or does it also stop executing the log that has been rea
Hi everyone
I'm wondering about the "--single-transaction" option on mysqldump.
Documentation says
---
This option issues a BEGIN SQL statement before dumping data from the
server. ...
---
So does this include the entire dump in one transaction? Or is it one
transaction per database (or even
How can I solve this problem?
This might be a filesystem problem. Some filesystem (in certain
configurations) cannot hold files larger than a particular size.
Do you have any files larger than that cut dumpfile on that partition?
--
MySQL General Mailing List
For list archives: http://lists.
How do you usually check automatically that slaves are up and running ?
echo "show slave status\G"|mysql -u user -ppassword|grep -i
"slave.*running"|grep -i no && mail -s "MySQL Slave stopped" [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
echo "show slave status\G"|mysql -u user -ppassword|grep -i
"slave.*running"|grep -i no && mail -s "MySQL Slave stopped"
[EMAIL PROTECTED]
well, actually
echo "show slave status\G"|mysql -u user -ppassword|grep -i
"slave.*running"|grep -i no && echo "."|mail -s "MySQL Slave stopped"
[EMAIL
Recently I deleted ~200.000.000 rows out of a history table. Still there
are 20.000.000 rows in the table.
So now I want to clear some discspace by copying the table, dropping the
old one and renaming the copy afterwards.
Is there another (faster) way to do that and how does one copy such a
Thank you very much. I did not know this command. Well at least I never
looked up what it does.
I'll give it a try and see how it works out.
Why not just use an OPTIMIZE TABLE ? This will map to an ALTER table
command for an InnoDB table which will free the now unused space. From
the manua
Replication setup:
A -> B -> A
|
C
One thing I can't remember is do I have to set an option somewhere to
tell the masters to ignore the queries in the binlog that oringated from
them?
Make sure you set different Server IDs on each machine and you should be
just fine.
--
MySQ
My question is : do I have to follow the upgrade procedure from 4.0 to
4.1 or can I juste installed the new binaries? We are not ready yet for
the version 5.
As always when upgrading: Make sure you have a backup :)
Then install the new version and move (copy if you have the space) the
data-dir
Hi Thomas
I try to configure replication from master to one slave for a database
with various table types (InnoDB, MyISAM) without stopping the master.
Therefore I make a mysqldump on the slave from master with this options:
mysqldump
-h master-db \
-udummyuser \
-pd
Hello
When I re-insert dumped data with "mysql < file.sql", I can simply put
"set foreign_key_checks=0;" at the beginning of the file and this works
fine.
How can I achieve this when inserting a text file that is read with
mysqlimport?
I tried to put the mentioned sql-statement in the txt-
Use "old-passwords" on the server or upgrade your client library.
Regards
Dominik
[localhost] ERROR 1251: Client does not support authentication protocol
requested by server; consider upgrading MySQL client
You have something similar about mysql client last week but what about
MysqlCC?
--
M
Gabriel PREDA schrieb:
Try:
ALTER TABLE `tbl_name` DISABLE KEYS;
-- now insert in the TXT file
ALTER TABLE `tbl_name` ENABLE KEYS;
I think this is what you were looking for !
That would have been a possibility. I did it this way now:
...
echo "set sql_log_bin=0; set foreign_key_checks=0; u
mysqldump -u [user] -h [host] -p [database] [table] > fixme.sql
This is for one table.
As I need it for all my tables in all my databases, I'd have to write a
script for that.
And as --tab uses less space, I prefer --tab option for mysqldump.
--
MySQL General Mailing List
For list archives:
Michael M. schrieb:
I'm attempting to take a brand new mysql server build on gentoo and set up
replication.
I'm using
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO
'repl'@"192.168.1.0/255.255.255.0" IDENTIFIED BY 'secret';
I'm not sure if this is correct syntax.
Use the specific IP
Simo Sentissi schrieb:
Hello there
I just finished installing mysql 5 on my linux server and I reset the root
password as an initial post-install setting.
now that i try to connnect from other machines in the network I always get a
message similar to the following:
C:\Documents and Settings\m
I am getting the below error
[EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt
drupal
mysqldump: Got error: 1: Can't create/write to file
'/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when
executing 'SELECT INTO OUTFILE'
Change the owner of that direct
> [EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/
--opt
> drupal
> mysqldump: Got error: 1: Can't create/write to file
> '/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when
> executing 'SELECT INTO OUTFILE'
Change the owner of that directory so the mysql serve
I have specified
log-slow-queries
long-query-time=10
in my.cnf and restarted my server. After that I see statements logged
into the slow-log-file.
But it seems that mysql logs too much into that file.
When executing this statement:
mysql> show variables like "%tx%";
+---+---
In the destination database the table doesn't exist. Please let me know,
if there is any way to do it.
CREATE TABLE DB2.tblname LIKE DB1.tblname;
INSERT INTO DB2.tblname SELECT * FROM DB1.tblname;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
most of my Storage enines is MyISAM i wanna change them all to|InnoDB
how do i do this >?
ALTER TABLE tblname ENGINE="innodb";
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The problem is now the slave is saying there are duplicate key entries.
Im not sure
how this is possible. Any thoughts ?
Your procedure looks right. Do you use innodb tables?
Otherwise, single-transaction does not work as you expect.
--
MySQL General Mailing List
For list archives: http://l
Is there a possibility to have some tables write-protected while others
in the same db are not (and yet the write-protected ones are updatable
through the replication mechanism, ie. there are tables on a slave
server). I guess that both, LOCK TABLES and read-only in my.cnf, don't
get this resul
* now i can access with [EMAIL PROTECTED] but i can't create databases
What does "show grants" display when you login as root?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
For adjusting "max allowed packet" value, I need to know the maximum
size of my blob fields.
How can I get that?
Dominik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a table with primary key "id". Another field is "date". Now I
want the last n entries, sorted by "date".
Is this possible in one SQL statement?
Thanks for your help
Dominik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Chris Sansom schrieb:
At 10:41 +0200 15/9/06, Dominik Klein wrote:
I have a table with primary key "id". Another field is "date". Now I
want the last n entries, sorted by "date".
Is this possible in one SQL statement?
ORDER BY `date` DESC LIMIT n
Last n
Peter Lauri schrieb:
SELECT * FROM table WHERE id=(SELECT id FROM table ORDER BY id DESC) ORDER
BY date
This does not limit it to n entries (order by date limit n is not
sufficient as I need last (highest) n ids). And afaik, limit is not
allowed in sub-queries.
--
MySQL General Mailing List
Diese Zeit muss verringert werden ~ 3 Sekunden wären noch akzeptabel.
Idee o. MySQL Optimierungen?
Du kannst versuchen, alle Zeilen in einem Statement einzufügen.
also so etwa:
insert into test values (1),(2),(3),...,(n);
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
You can only specify one IP address to bind to.
If you omit this option, mysqld will bind to all addresses on the
machine. If this is not what you want, you could block mysql-access with
a packet filter for the IP addresses you do not want to bind to.
--
MySQL General Mailing List
For list a
Is there a hardware/software loadbalancer for multiple mysql servers
servicing read transactions?
You might want to take a look at www.linuxvirtualserver.org and
www.keepalived.org
Dominik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
Sounds like a very nice idea to me, but this could be a problem if temp
tables need to be bigger than RAM+Swap, which could easily be the case
in a table with 100,000,000 rows.
Gabriel PREDA schrieb:
For this table this is to late... leave it running...
If you want to do this on another table
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
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
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
The error message I receive is the following:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
This message indicates you tried to login without giving a password.
Add "-p" to your commandline. It will then prompt you for your password
and log you in if the p
Unfortunately, that is not the reason, why I get this message. I have
tried 'mysql', 'mysql -uroot', mysql -u root', 'mysql -uroot -p', 'mysql
-uroot -pMY_PASSWORD', but anything fails.
When I am using the password option, the error message is like this:
ERROR 1045 (28000): Access denied for us
John M.Brown schrieb:
Thanks for the info, but my question is how many databases, not so much how many rows per table or how
big the database can be... I mean, how many "create database ABC" can I do
before MySQL says "sorry, you can't have more than X databases".
Say I create 1000 empty MySQL
Hi
is there a way to see how far the slave has replicated from the master
machine?
I know I can issue show slave status on slave, but is there any command
on the MASTER to see information on what the slave has read already?
Regards
Dominik
--
MySQL General Mailing List
For list archives: h
You could also use a temp table, put data into it page-by-page and
insert the complete row after a last check into the "real" table.
This temp table might have an additional timestamp field according to
which evth. older than 1h(or some other time period) could easily be
deleted by a cronjob.
I get various errors from my php based applications and php building that
all refer to the need to upgrade my mysqlclient.
Did you try "old-passwords" in /etc/my.cnf ?
Old clients use an old authentication protocol, which is not the default
on modern mysql servers. For compatibility, "old-pass
[addon to my previous mail]
I have not found
instructions on where to get the client software to build or upgrade a
client.
just use an up-to-date binary mysql distribution for your OS.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
[EMAIL PROTECTED] ~]$ mysqlshow
+---+
| Databases |
+---+
| test |
+---+
In standard setup, there is a user without a name and password, who can
connect from localhost to database "test".
So, accessing with this user gives you a list of the databases this user
can
Thanks. This gets me going.
Re proper file permissions: there seem to be mysql files all over the
place. Do I have to find them all and change permissions on all of them?
The MySQL manual I downloaded lists about eight different directories as
including MySQL files, and I'll already seen at least
or what I although could do to
start my Server in another than the SYSTEM timezone?
I use the MySQL 5.0.18 Server on a Suse Linux 10.0
From:
http://dev.mysql.com/doc/refman/5.0/en/timezone-problems.html
You can set the time zone for the server with the
--timezone=timezone_name option to mysq
I need to take the backup of a query, is it possible.
If yes how.
man mysqldump:
-w|--where=
dump only selected records; QUOTES mandatory!
Regards,
Dominik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This was done as root and shows that TZ works.
dk:/usr/local/mysql # bin/mysql -V
bin/mysql Ver 14.12 Distrib 5.0.18, for pc-linux-gnu (i686) using
readline 5.0
dk:/usr/local/mysql # echo $TZ
dk:/usr/local/mysql # bin/mysqld_safe --user=mysql &
[1] 802
dk:/usr/local/mysql # Starting mysqld da
[EMAIL PROTECTED] schrieb:
after changing my system timezone from UTC to MSD i have the following
problem: after restarting mysql server its timezone has not changet at
all:
mysql> show variables like '%zone%';
+--++
| Variable_name| Value |
+--+--
Post output of the commands
uname -a
and
/lib/libc.so.6|head -1
What do you plan on doing with MySQL? Clustering or "rather normal" DB
usage?
Then we can tell you - or actually you should at least then be able to
decide yourself ;)
balaraju mandala schrieb:
Hi Comunity,
I have some probl
please read what i wrote and do so - I cannot help you without this info
as I do not know any "Linux Enter prise ver4"
please post your replies to the mysql mailing list, not to my email-address
balaraju mandala schrieb:
Hi DK,
I just want use MySql for personal use. But i am confused which
The user -a output is :
uname -a, but anyway ...
Linux wizon.secureserver.net 2.6.9-11.EL #1 Fri May 20 18:17:57 EDT 2005
i686 i6
I didn't understand what is secound command is.
You should have just pasted it into your command line and paste back the
output into your mail.
i686 i6
Tha
mysql> mysqldump --no-data osc -u admin;
ERROR 1064: You have an error in your SQL syntax near 'mysqldump
--no-data osc -u admin' at line 1
You are supposed to execute that from a shell, not from within mysql Client.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
[EMAIL PROTECTED] schrieb:
http://www.blue-fly.co.uk/screen.jpg
I cannot seem to add a server..anyone shed any light on it?
Just edit config.inc.php
It has good documentation comments, so it should not be a problem.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
Is there a query that will, say, trim a table down to a million rows (with
some sort order, of course, as I'm interested in deleting the oldest ones)?
If you have got a datecolumn, you might also want to delete anything
that is older than x days (2 in my example):
DELETE FROM database.table W
Hi.
I have a question regarding mysql replication and mysqldump.
I have a master (A). All my clients insert/update/delete only to this
master. Then I have a Slave (B). This slave only replicates the master.
There are no other processes changing/inserting data into the Slave. The
slave also logs b
Hi
in a 5.0.45 linux master-master replication setup, I see the error
message from the subject every now and then. Sometimes it does not
happen for a couple of months, then it happens a couple of times a day.
I cannot see any network problems otherwise, and a memtest did not bring
up any memo
Hi.
Juan Eduardo Moreno wrote:
Sorry, what is your setting for max_allowed_packet variable?
mysql> show variables like "%allowed%";
++--+
| Variable_name | Value|
++--+
| max_allowed_packet | 16776192 |
++
Francisco Rodrigo Cortinas Maseda wrote:
Hi,
I have experienced similar problems to the one you have; the problem you have
is that the time gap between the failure and now is so big that you cannot
resume replication, because of the big data portion you have to replicate.
Well, that was yest
Hi
I upgraded from 5.0.45 to 5.0.51b yesterday.
After installing the files, I just copied the var directory and started
the database.
mysql> show create table cc\G
*** 1. row ***
Table: cc
Create Table: CREATE TABLE `cc` (
`id` varchar(
Upgrade to 5.0.51b seems to have solved the problem. On wednesday, I saw
the problem about a dozen times during a peak time. Upgraded wednesday
night and have not seen the error since.
Thanks
Dominik
Juan Eduardo Moreno wrote:
Hi,
This error occur when slave servers could incorrectly interpre
Hello mysql list
I posted this problem to the list earlier this month:
Error reading packet from server: Out of memory (Needed 6560 bytes) (
server_errno=5)
I was then told to upgrade to the newest version, which I did and which
seemed to solve the problem. Today, I got this in my log:
080
Moon's Father schrieb:
You can manually restart the slave process.
Sure I can.
But that's not sufficient. For now, I scripted some log watch thing that
re-starts the slave in the particular situation. But this is not good.
On Wed, May 21, 2008 at 9:11 PM, Dominik Klein <[EM
Hi
I have a new machine to put mysql onto. It has 16 GB of RAM. I don't
have exactly the best experience with 64bit operating system, so I'd
personally like to stick to 32 bit.
Does it make sense to install it with a 32 bit PAE kernel? Will mysql be
able to use the full amount of memory? Fro
Hi
I installed a 64bit Linux and compiled and installed 5.0.51b. This is to
be an innodb only system.
The machine has 16 GB of memory and I can see all of that with "free".
Except for mysql, there is nothing running on that system.
free -m
total used free shared
Unfortunately, right now I can't.
Someone mentioned getting rid of myisam configuration values might help.
Which ones would that be?
Regards
Dominik
Xuekun Hu wrote:
I can alloc 14GB to innodb_buffer_pool_size, even 15GB on my 16GB
system. However I used mysql6.0, not mysql5.0. Maybe you can
Hi
I have a testview defined as
mysql> create table testview (a int);
Query OK, 0 rows affected (0.01 sec)
mysql> create view view_of_testview as (select * from testview);
Query OK, 0 rows affected (0.00 sec)
I create a dump of this view definition with
mysqldump --tab=/tmp test view_of_testv
Is there a way to allow the
SQL_THREAD to write while holding everything else ?
iptables -A INPUT -p tcp --dport 3306 -s MASTER_IP -j ACCEPT
iptables -A INPUT -p tcp --dport 3306 -j REJECT
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
My innodb_buffer_pool_size is:
innodb_buffer_pool_size | 8388608
That looks like 8MB... that sounds small if I have a DB with over 1M
rows to process. No?
Yes, that's extremely small. I'd go for at least 256M, and maybe 512M
if your machine will primarily be doing mysql duties.
Did
[EMAIL PROTECTED] schrieb:
Hello,
my question refers to the user "root" in MySQL 5.0.22.
Is the standard MySQL root user really required with the name "root" or can I rename the
root user for example to "myroot"?
Our software vendor affirms that MySQL need the User "root" always but I argue
1. 'mysqldump' the current database, drop it and create a new database.
Move the dumped data into the new database.
This should work with any engine.
2. Stop mysqld. Rename the database folder in the datadirectory. Start
the server and grant access permissions
This does imho only work for
Michael Stearne schrieb:
We have 5.0.27 installed on a CentOS machine that doesn't have a ton
of disk space. Is it possible to point the data directory to lie on a
samba connected share? The samba share does not support Unix file
permissions so it is not possible to set mysql as the owner of th
Here's another howto on this using keepalived instead:
http://www.austintek.com/LVS/LVS-HOWTO/HOWTO/LVS-HOWTO.failover.html#ha_mysql
Kishore Jalleda schrieb:
HB, MON, IPFail would work well for this , here is some info from my
website
that I wrote very long ago, hope it helps
http://kjalleda.
Hi
when I execute
mysql> show slave status\G
I see this:
...
Last_Errno: 1175
Last_Error: Error 'You are using safe update mode and
you tried to update a table without a WHERE that uses a KEY column' on
query. Default database: 'xxx'. Query: 'delete from xxx
This helped:
http://forums.mysql.com/read.php?26,133157,136626
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi
I use mysql-5.0.45 on opensuse 10.2 linux x86.
The following reproducably breaks replication:
node A is master
node B is slave
A mysql> use anydb;
A mysql> drop view asdasdasd;
ERROR 1051 (42S02): Unknown table 'asdasdasd'
The name of the view does not matter. It does not exist, so mysql g
82 matches
Mail list logo
