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 DEBIAN

sql::reservedwords::mysql

SQL::ReservedWords::MySQL(3pm)				User Contributed Perl Documentation			    SQL::ReservedWords::MySQL(3pm)

NAME

       SQL::ReservedWords::MySQL - Reserved SQL words by MySQL

SYNOPSIS

	  if ( SQL::ReservedWords::MySQL->is_reserved( $word ) ) {
	      print "$word is a reserved MySQL word!";
	  }

DESCRIPTION

       Determine if words are reserved by MySQL.

METHODS

       is_reserved( $word )
	   Returns a boolean indicating if $word is reserved by either MySQL 3.2, 4.0, 4.1, 5.0 or 5.1.

       is_reserved_by_mysql3( $word )
	   Returns a boolean indicating if $word is reserved by MySQL 3.2.

       is_reserved_by_mysql4( $word )
	   Returns a boolean indicating if $word is reserved by either MySQL 4.0 or 4.1.

       is_reserved_by_mysql5( $word )
	   Returns a boolean indicating if $word is reserved by either MySQL 5.0 or 5.1.

       reserved_by( $word )
	   Returns a list with MySQL versions that reserves $word.

       words
	   Returns a list with all reserved words.

EXPORTS

       Nothing by default. Following subroutines can be exported:

       is_reserved
       is_reserved_by_mysql3
       is_reserved_by_mysql4
       is_reserved_by_mysql5
       reserved_by
       words

SEE ALSO

       SQL::ReservedWords

       <http://dev.mysql.com/doc/>

AUTHOR

       Christian Hansen "chansen@cpan.org"

COPYRIGHT

       This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.8.8							    2008-03-28					    SQL::ReservedWords::MySQL(3pm)

Solaris BigAdmin RSS