Forum for MySQL Administrator http://forums.mysql.com/list.php?34 Wed, 19 Jun 2013 09:26:17 +0000 Phorum 5.2.19 http://forums.mysql.com/read.php?34,587863,587863#msg-587863 http://forums.mysql.com/read.php?34,587863,587863#msg-587863
I would like to implement a mysql backup schedule on my database which is in master / slave replication. My DB is around 10GB, with 1-2 tables about 1GB large. I would like to avoid locking these tables if necessary.

I am backing up the database at 6:00am using mysql dump. Should I be backing up the mysql binlog files hourly to get a point in time (within the hour) recovery? I would be using mysqlbinlog tool to do this and therefore this method I assume would avoid locking the tables appart from @ 6:00am.

Should I flush the mysqlbinlogs after the backup?

What would happen to the replication is I flushed the mysql binlog files?

Many thnaks,
Oli]]> Oliver Leach MySQL Administrator Sun, 02 Jun 2013 11:19:19 +0000 http://forums.mysql.com/read.php?34,587074,587074#msg-587074 http://forums.mysql.com/read.php?34,587074,587074#msg-587074 Will Davis MySQL Administrator Thu, 23 May 2013 15:21:51 +0000 http://forums.mysql.com/read.php?34,586894,586894#msg-586894 http://forums.mysql.com/read.php?34,586894,586894#msg-586894 I faced an issue in mysql dump restoration. Upon debugging found that the backup file had syntactical error in one of the insert lines.
example: There is a datetime value partially written ('2)and again correctly specified as given in below insert statement.

Insert into Tab1 Values (xx,xx,'2, '2013-05-20 00:00:00',....)

Because of this syntax error, the backup file failed to restore.
can anybody share the knowledge how that is possible when mysqldump command is used for backup.

Regards,
Veera]]> Veerasamy Kaunder MySQL Administrator Mon, 20 May 2013 14:38:28 +0000 http://forums.mysql.com/read.php?34,586528,586528#msg-586528 http://forums.mysql.com/read.php?34,586528,586528#msg-586528 Find the list of MySQL servers on given list of hosts.
For each server, collect
1. cnf file path
2. Base Dir
3. DataDir
4. Socket/Port

my inputs are list of hosts and permissions to run commands as sudo user on those hosts.

As MySQL doesnot define any path OR user as standard, mysqld can be run with any user and it can be isntalled on any location. This is same with cnf file too.
I see only one way,i.e to find process list (Linux: ps -aef) and get mysqld. It would be command line arguments passed as start up arguments. At least we can figure cnf file for each mysqld running.

looking for better ideas from you.]]> Ravi Thati MySQL Administrator Sun, 19 May 2013 05:46:44 +0000 http://forums.mysql.com/read.php?34,585302,585302#msg-585302 http://forums.mysql.com/read.php?34,585302,585302#msg-585302 http://mysqlbackupftp.com/ ). MySqlBF allows to schedule backups using a Windows Task Scheduler or a custom windows service for a complex backup scenarios.

It supports connecting securely over an SSH connection and has such a unique feature as creating a backup via phpMyAdmin. The tool allows to archive, encrypt and save backups to HDD, FTP, Network or most popular cloud storage services (Dropbox, Amazon S3, Google Drive, SkyDrive, Box) and sends email notifications on success or failure.

Hope that will help you.]]> Alexander Shagin MySQL Administrator Thu, 02 May 2013 10:47:25 +0000 http://forums.mysql.com/read.php?34,584915,584915#msg-584915 http://forums.mysql.com/read.php?34,584915,584915#msg-584915 We are running the latest version of mysql server CE on a RedHat machine.
In another windows 7 machine, we have the latest mysql workbench.
All of our authentication methods are mysql based.
When I test one of the users connection settings under a windows 7 workbench client, it all go smooth with a "connection parameters are correct" message, but when I try to open the connection to start querying I get this error message:

"Your connection attempt failed for user 'xxx' from your host to server at xxx:3306:
Could not open database"

If I change the user permissions in active directory, granting him domain administrator priviledges, the connection then opens with no problem at all.

What does AD permissions have to do with user authentication in workbench?
Maybe it's a system folder or file write permissions?

Thank you very much]]> Augusto Toledo MySQL Administrator Fri, 26 Apr 2013 19:15:01 +0000 http://forums.mysql.com/read.php?34,583108,583108#msg-583108 http://forums.mysql.com/read.php?34,583108,583108#msg-583108
Devart Team is glad to announce the release of new dbForge Studio for MySQL v6.0. New most intelligent tool includes really required enhancements, which are the result of a close interaction with MySQL oriented users. The main features of dbForge Studio for MySQL will meet the requirements even of the most demanding developers. For more information about dbForge Studio for MySQL, visit the product's web site – www.devart.com/dbforge/mysql/studio/.

For additional information about Devart, visit www.devart.com/company/.]]> Ирина Писклярова MySQL Administrator Thu, 04 Apr 2013 15:18:00 +0000 http://forums.mysql.com/read.php?34,582536,582536#msg-582536 http://forums.mysql.com/read.php?34,582536,582536#msg-582536
so the question is : what should be the result of :

/usr/bin/mysqldump --routines -c -Q -q dbName

if dbName contain crashed table ?]]> Abdelilah Ouass MySQL Administrator Thu, 28 Mar 2013 15:39:23 +0000 http://forums.mysql.com/read.php?34,580591,580591#msg-580591 http://forums.mysql.com/read.php?34,580591,580591#msg-580591 Jacob Silverman MySQL Administrator Tue, 05 Mar 2013 04:19:30 +0000 http://forums.mysql.com/read.php?34,580517,580517#msg-580517 http://forums.mysql.com/read.php?34,580517,580517#msg-580517

mxsqldump Version Mismatch

masqldump.exe is Version 5.5.16 but the MySQL Server to be dumped has Version 5.6.10.....


What should I di about it?

Regards, RoPetri]]> Roland Petri MySQL Administrator Mon, 04 Mar 2013 09:40:28 +0000 http://forums.mysql.com/read.php?34,579976,579976#msg-579976 http://forums.mysql.com/read.php?34,579976,579976#msg-579976 Can not connect to MySQL server on '192 .168.2.150 '(10061). Please any help will be greatly appreciated]]> tania carrillo MySQL Administrator Wed, 15 May 2013 00:56:22 +0000 http://forums.mysql.com/read.php?34,579599,579599#msg-579599 http://forums.mysql.com/read.php?34,579599,579599#msg-579599


I don't think i have any errors but this error can't stop showing up
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''type'( id char(1), libelleType(30), CONTRAINT pk_type PRIMARY KEY (id)' at line 1


Here is my database code that i wrote in SQL :
-- Création d'une table "type"
CREATE TABLE type (
id char(1),
libelleType char(30),
CONSTRAINT pk_type PRIMARY KEY (id)
);
-- Ajout des données dans la table "type"
INSERT INTO type (id,libelleType)
VALUES ('V', 'Visiteur médical'),
('C', 'Comptable');
-- Changement de nom de table
ALTER TABLE visiteur RENAME TO utilisateur ;
-- Ajout du champ dans utilisateur
ALTER TABLE utilisateur ADD COLUMN idType char(1) NOT NULL ;
-- Déclaration de tous les utilisateurs actuels comme des "visiteurs"
UPDATE utilisateur SET idType = 'V';
-- Déclaration de la clé étrangère "idType" en référence à "id" de la table "type"
ALTER TABLE utilisateur
ADD CONSTRAINT fk_type FOREIGN KEY (idType) REFERENCES type (id);

Best Regards;]]> Jack Legrand MySQL Administrator Thu, 21 Feb 2013 16:28:06 +0000 http://forums.mysql.com/read.php?34,579082,579082#msg-579082 http://forums.mysql.com/read.php?34,579082,579082#msg-579082
I have recently enabled my general log file (general-log = 1) to help debug some production performance issues. Since enabling them, I have noticed the log file is filling up rapidly. It seems that where a SQL statement calls a stored procedure, mysql outputs the SQL statement once but also outputs every SET command of the stored procedure along with the values used.
This makes the log file very large and unusable.

Has anyone experienced this issue? is it an issue with stored procedures in mysql?

thanks for any assistance,
Sean]]> Sean OMahony MySQL Administrator Wed, 13 Feb 2013 12:18:23 +0000 http://forums.mysql.com/read.php?34,578720,578720#msg-578720 http://forums.mysql.com/read.php?34,578720,578720#msg-578720 https://www.mysql.com/news-and-events/health-check/]]> Edwin Desouza MySQL Administrator Fri, 08 Feb 2013 04:16:09 +0000 http://forums.mysql.com/read.php?34,578702,578702#msg-578702 http://forums.mysql.com/read.php?34,578702,578702#msg-578702 Other servers don't have the "-log" suffix; for example, 5.5.19.
What does "-log" mean?]]> Aamir Abbas MySQL Administrator Thu, 07 Feb 2013 20:12:22 +0000 http://forums.mysql.com/read.php?34,578142,578142#msg-578142 http://forums.mysql.com/read.php?34,578142,578142#msg-578142 We both use windows autentication on a windows 2003 enterprise x64 with SP 2.
When we log into MYSQL Administrator, we both use the root login.
Is there anyway to get this inormation to show for both?]]> Joe Tigeleiro MySQL Administrator Tue, 29 Jan 2013 15:25:37 +0000 http://forums.mysql.com/read.php?34,576605,576605#msg-576605 http://forums.mysql.com/read.php?34,576605,576605#msg-576605 jose font MySQL Administrator Fri, 28 Dec 2012 16:45:14 +0000 http://forums.mysql.com/read.php?34,576530,576530#msg-576530 http://forums.mysql.com/read.php?34,576530,576530#msg-576530
I am logging into mysql server(installed in windows) in command line client using root user as,
> mysql -u root -p 'password'
it gives, ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server.

I dont have any other user, I have only root user. Now, I have no way to login to mysql server.

Can anybody guide me on how to solve this issue?]]> Navaneethan Marichetty MySQL Administrator Sat, 29 Dec 2012 01:29:59 +0000 http://forums.mysql.com/read.php?34,576211,576211#msg-576211 http://forums.mysql.com/read.php?34,576211,576211#msg-576211 I hope to find help here.
Following situation.
I have running a MySQL 5.0 Server on Computer A (Windows 7).
I have one client (windows XP) to access on the Server. Works fine.
Now got a second client (Windows 7) and I get the "Access denied" Error trying to connect over MySQL Admin & an own programm. Error message like this: "Access denied username'computername' using passwort yes"

I have done the following:
- Set exception on Firewall for Port 3006
- Even deactivated both firewalls on Server and Client to test out
- Activated "piped names" at MySQL Server.

I can ping the Server. Now I don't know what makes block the access. It might be Windows Setting, because on the XP Computer it works fine.

Maybe you can help me?
Best regards,]]> N H MySQL Administrator Mon, 17 Dec 2012 13:26:17 +0000 http://forums.mysql.com/read.php?34,575346,575346#msg-575346 http://forums.mysql.com/read.php?34,575346,575346#msg-575346 first of all i got to say sorry for my bad inglish!

The thing is that i need to do a daily backup of my BD and i want to do it with MySQL Administrator.

I configured a daily backup in my local machinne but seems to been not working.
only work when i used the option backup now.

i dont want to use a script.

Mysql v5.5
SO: Windows 7 / 2003 server

hope u can help me]]> michel peluca MySQL Administrator Wed, 05 Dec 2012 14:53:12 +0000 http://forums.mysql.com/read.php?34,575255,575255#msg-575255 http://forums.mysql.com/read.php?34,575255,575255#msg-575255 People, there is little question about mysql replication
There is a master and slave.
Type bin logs on master - STATEMENT.
If you fall off replication, most online sources recommend the following steps.
on slave
mysql> stop slave;
on the master
mysql> flusr logs;
mysql> show master status;
Here we find the name of bin log on the master and the position in it.

go to slave and specify a new log name and position in it and execute command change master ...
Do on the slave
mysql> start slave;

So, the actual question:
If the slave can not continue to read from the current position in the bin log on the master, it is given a new log name and new position. In this situation, some of the data from the bin logs on the slave may be omitted, because the next binlog we start reading from the new position ignoring the previous data.
Ie it turns out that a certain amount of SQL queries (which are stored in the bin logs) are not met?
Ie it turns out that the data on the slave will not get and therefore lost synchronization database?

Thanks in advance for your help!]]> HEDG ,,, MySQL Administrator Tue, 04 Dec 2012 15:21:22 +0000 http://forums.mysql.com/read.php?34,574917,574917#msg-574917 http://forums.mysql.com/read.php?34,574917,574917#msg-574917
Rodrigo Reis]]> Rodrigo Reis MySQL Administrator Thu, 29 Nov 2012 16:39:49 +0000 http://forums.mysql.com/read.php?34,574753,574753#msg-574753 http://forums.mysql.com/read.php?34,574753,574753#msg-574753
I have installed MySQL Server 5.5.28 on RHEL 5.5 machine.

I created a mysql database prash , user prash and granted prvileges as mentioned below:-

create database prash;

create user 'prash'@'localhost' identified by 'prash';
create user 'prash'@'%' identified by 'prash';
Grant ALL ON prash.* to 'prash'@'%' WITH GRANT OPTION;
GRANT FILE ON *.* to 'prash'@'%' WITH GRANT OPTION;
GRANT SHOW DATABASES ON *.* to 'prash'@'%' WITH GRANT OPTION;
Grant ALL ON prash.* to 'prash'@'localhost' WITH GRANT OPTION;
GRANT FILE ON *.* to 'prash'@'localhost' WITH GRANT OPTION;
GRANT SHOW DATABASES ON *.* to 'prash'@'localhost' WITH GRANT OPTION;
flush privileges;



Now i can login as prash user from any other machine. But on the database machine iam facing behaviour as mentioned below:-

$ mysql -uprash -pprash
--login is successfull

$ mysql -uprash -pprash -hvmlnx3
ERROR:ERROR 1045 (28000): Access denied for user 'prash'@'vmlnx3' (using password: YES)

vmlnx3 -MYSQL Database machine hostname

Not sure why i cannot login using above command as i already created prash@% user as well as prash@localhost user.
I do not want to create another user prash@vmlnx3 as i feel it is not required.

Output of mysql.user table :-
+-------------+------------+-------------------------------------------+
| host | user | password |
+-------------+------------+-------------------------------------------+
| localhost | | |
| vmlnx3 | | |
| % | prash | *9B500343BC52E2911172EB52AE5CF4847604C6E5 |
| localhost | prash | *70FBD2CC61D069A957FB133976C79A26FD14A9C6 |
| 10.32.5.209 | replicator | *D36660B5249B066D7AC5A1A14CECB71D36944CBC |
| localhost | replicator | *D36660B5249B066D7AC5A1A14CECB71D36944CBC |
| vmlnx4 | replicator | *D36660B5249B066D7AC5A1A14CECB71D36944CBC |
| % | root | *F861720E101148897B0F5239DB926E756B1C28B3 |
| 127.0.0.1 | root | |
| ::1 | root | |
| localhost | root | *F861720E101148897B0F5239DB926E756B1C28B3 |
| vmlnx3 | root | *F861720E101148897B0F5239DB926E756B1C28B3 |
+-------------+------------+-------------------------------------------+

Please assist in solving this issue.

Thanks,
Varun Datta]]> Varun Datta MySQL Administrator Wed, 28 Nov 2012 12:59:40 +0000 http://forums.mysql.com/read.php?34,573875,573875#msg-573875 http://forums.mysql.com/read.php?34,573875,573875#msg-573875
Is there a way I can change the error message to be "Syntax error near blah"]]> Keir Vaughan-Taylor MySQL Administrator Thu, 15 Nov 2012 20:52:57 +0000 http://forums.mysql.com/read.php?34,573873,573873#msg-573873 http://forums.mysql.com/read.php?34,573873,573873#msg-573873 http://www.siteground.com/tutorials/php-mysql/mysql_gui_tools.htm#backup_restore

I can see the database in the schemata listed under catalogs at the bottom, it may be called information table or something along those lines. The problem I have is when I click backup and follows the stages through, when I click on the database and then the right arrow button it gives me an error message along the lines of performing this action will cause the server to be unusable / unstable after performing the backup and then prevents me from backing up (execute backup button is greyed out). After several attempts it says the same thing each time.

I have also tried to run the MySQL command line program in an attempt to perform a manual backup. The first line reqeuest for a password but after typing this in the window just closes each time.

Does anybody know what is going wrong and why please?

Many Thanks,
Michael]]> Michael Rodgers MySQL Administrator Thu, 15 Nov 2012 19:34:40 +0000 http://forums.mysql.com/read.php?34,573238,573238#msg-573238 http://forums.mysql.com/read.php?34,573238,573238#msg-573238
Also, i cannot use workbech, so i have to use the console interface. Need a query for that. Googling gave me lots of unusuable results.]]> prateek sharma MySQL Administrator Tue, 27 Nov 2012 08:03:53 +0000 http://forums.mysql.com/read.php?34,572158,572158#msg-572158 http://forums.mysql.com/read.php?34,572158,572158#msg-572158 I am a new to this forum.

When i try to login on mysql server it gives an error

mysql -u root -p

Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Even i tried following command
$ sudo mysqladmin password newpassword

I get same error,

If someone knows how to resolve this problem please help me.

Thanks in advance,
Yesodha]]> Yesodha K MySQL Administrator Mon, 29 Oct 2012 07:43:12 +0000 http://forums.mysql.com/read.php?34,570651,570651#msg-570651 http://forums.mysql.com/read.php?34,570651,570651#msg-570651 Joe Proietti MySQL Administrator Wed, 10 Oct 2012 19:20:28 +0000 http://forums.mysql.com/read.php?34,569356,569356#msg-569356 http://forums.mysql.com/read.php?34,569356,569356#msg-569356
Basically I want something like, if a user made n wrong attempts to loginthen block that account access..

If it is not a standard feature How it can be implemented ?]]> Sqluser A MySQL Administrator Mon, 24 Sep 2012 10:25:06 +0000 http://forums.mysql.com/read.php?34,569031,569031#msg-569031 http://forums.mysql.com/read.php?34,569031,569031#msg-569031
% mysql -h 149.159.169.179 -u tester -p
Enter password:
ERROR 1045 (28000): Access denied for user 'tester@xtest.test.com' (using password: YES)

149.159.169.179 is a fake IP address of xtest.test.com and I logged in to this machine to start MySQL.

bind-address in the config file is set to 149.159.169.179, so I assume it should not be a problem. etc/hosts looks OK.

The version of MySQL is 5.0.77 on Linux.

I am wondering if MySQL can not interpret xtest.test.com to 149.159.169.179.

Any thought????]]> Hiro Nishi MySQL Administrator Mon, 29 Oct 2012 08:06:39 +0000