phpMyBackupPro: No simpler backup for MySQL

7 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

MySQL & OpenLDAP - file level backup

Hi All, The MySQL & OpenLDAP database on my Debian are very lightly updated. Usually I tar everything on / including the databases. The restore works OK on another machine. I want to know whether its safe to do file level backup of databases like this ? Do the MySQL & OpenLDAP databases...

2. Web Development

Restore MySQL backup

Hello all! First posting here! So be patient with me. I made a clean install with MacOS 10.8 and need to restore my Databases from my external backup drive. Apparently it is not possible, to create the MySQL user and password as before, and simply drag the databases from...

3. Shell Programming and Scripting

MySQL Restoration Backup Script

Hi there, Alright I have this line that I'm working with (bash programming): mysql -u username -pHASH ${args} < /home/site/backups/site.${args}.sql I get this error on that line: ./restore.sh: line 51: syntax error near unexpected token `newline' ./restore.sh: line 51: `mysql -u...

4. Shell Programming and Scripting

Script - Mysql backup and delete

Hello I have a production mysql server and archive server, unfortunitly its not possible to setup repliacation between the two, the reason is that the archive server is using some fancy storage engine which doesn't allow mysql replication. I'm trying to write a script using perl that does...

5. Shell Programming and Scripting

Help with perl mysql backup script

Hi, im trying to make a script that backups mysql databases but apparently I am having trouble with the variables, or simply something I am missing. Would appreciate any help, here is the script #!/usr/bin/perl -w use strict; require File::Spec; #VARIABLES my $databasename =...

6. Shell Programming and Scripting

How to backup a particular Database in MYSQL?

Hi All, Thanks in Advance!! How to backup a particular Databases..through Bash script!! For example i have 6 databases; Anish linux Software Questions Rhce Google these are the databases i have from that i want to take "Anish" and "questions" database backup regularly....

7. UNIX for Advanced & Expert Users

MYSQL command to take a backup of the database in Redhat linux 7.2

I am new to mysql database , we have a mysql database running on linux , and we use mysql database for bugzilla, so we wanted to take a backup . what is the command for taking the entire database backup from the command prompt with all options. Thanks in advance Bache Gowda

LEARN ABOUT DEBIAN

grass-mesql

grass-mesql(1grass)						Grass User's Manual					       grass-mesql(1grass)

NAME

       grass-mesql - MySQL embedded driver

       MySQL  embedded	driver	MySQL  embedded  driver  in GRASS MySQL database driver in GRASS enables GRASS to store vector attributes in MySQL
       embedded database without necessity to run MySQL server.

Driver and database name
       GRASS modules require 2 parameters to connect to a database.  Those parameters are 'driver' and 'database'. For MySQL embedded  driver  the
       parameter  'driver'  should  be	set  to value 'mesql'.	The parameter 'database' is a full path to the directory where database tables are
       stored. The best place is a directory in the mapset. The directory must be created before use of the driver. In the name of database it	is
       possible to use 3 variables:

		      $GISDBASE - path to current GISBASE

		      $LOCATION_NAME - name of current location

		      $MAPSET - name of current mapset

       Examples of connection parameters:
	 db.connect driver=mesql database='$GISDBASE/$LOCATION_NAME/$MAPSET/mysql'
	 db.connect driver=mesql database=/home/user1/db

Data types, indexes
       For more informations about supported data types and indexes see the documentation for MySQL (mysql) driver

Database type
       Because	database  closing  was	found  very  slow if InnoDB was used, the InnoDB storage is disabled by default (hardcoded '--skip-innodb'
       server option).

Note
       The embedded server is started with hardcoded '--bootstrap' option to avoid warning about missing mysql.time_zone_leap_second  table.  This
       can be fixed in future.

SEE ALSO

	db.connect, SQL support in GRASS GIS

Credits
       Development of the driver was sponsored by Faunalia (Italy) as part of a project for ATAC.

AUTHOR

       Radim Blazek

       Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
       Help Index

GRASS 6.4.2														       grass-mesql(1grass)

UNIX and Linux RSS News