Creating MySQL Backups With AutoMySQLBackup

5 More Discussions You Might Find Interesting

1. Ubuntu

Prevent xed editor from creating backups

This is the oddest thing I've seen in any text editor in the three OSes I've used since buying my first home computer in 1993. Short version: "where's the switch?" the xed GUI (version 1.0.6) appears to have no Option to keep it from creating backups (~-marked files) if a text or ASCII file...

2. Shell Programming and Scripting

Run Shell Commands after creating MYSQL Connection

Hi, I am trying to make a Shell Script using which I will update around 10K records in MySQL db each night. For that, I am currently doing the following command in FOR LOOP: mysql -D $MASTER_DB_NAME -h $MASTER_DB_HOST -u $MASTER_DB_USER -p$MASTER_DB_PASSWD -e "$SQL_Query" This command is...

3. Web Development

MYSQL: Creating Dynamic Table Names 5.1

Hey everyone. Thanks for looking at this. I'm trying to create a table with the dynamic name of TableName + today's date. My variables are all happily created but the system chokes when I try to create the new table name example: Set @BFBW = CONCAT("BFBW", CURDATE()); Select @BFBW; ...

4. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)...

5. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

MySQL on my server is down.... I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock Any suggestions? Here's what I can't do: can't be root don't have physical access (do stuff via SSH) reinstall MySQL (need to keep the current MySQL...

LEARN ABOUT LINUX

mysql_secure_installation

MYSQL_SECURE_INST(1)					       MySQL Database System					      MYSQL_SECURE_INST(1)

NAME

       mysql_secure_installation - improve MySQL installation security

SYNOPSIS

       mysql_secure_installation

DESCRIPTION

       This program enables you to improve the security of your MySQL installation in the following ways:

       o   You can set a password for root accounts.

       o   You can remove root accounts that are accessible from outside the local host.

       o   You can remove anonymous-user accounts.

       o   You can remove the test database (which by default can be accessed by all users, even anonymous users), and privileges that permit
	   anyone to access databases with names that start with test_.

       mysql_secure_installation helps you implement security recommendations similar to those described at Section 2.10.2, "Securing the Initial
       MySQL Accounts".

       Invoke mysql_secure_installation without arguments:

	   shell> mysql_secure_installation

       When executed, the script prompts you to determine which actions to perform.

COPYRIGHT

       Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
       published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

SEE ALSO

       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
       at http://dev.mysql.com/doc/.

AUTHOR

       Oracle Corporation (http://dev.mysql.com/).

MySQL 5.5							    01/30/2014						      MYSQL_SECURE_INST(1)

Solaris BigAdmin RSS