MySQL Databases Post: 302700915

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Unix and databases

I had a person ask me if a Sql database can be run with Unix? I don't know can this be done? They only have Sql dba's and no oracle dba but want to use a Unix box????

2. UNIX for Dummies Questions & Answers

Checking which databases are installed

I want to check which databases are installed on my FreeBSD installation. This is what I did: pkg_info | grep mysql How do I check all in one go whether also sqlite, postgresql, firebird is installed? Thanks in advance

3. Web Development

Deleting databases in MYSQL problem asking...

Hi, I'm the new user of mysql. I facing one problem to delete one of the database in mysql. Hope can get all of your suggestion and advice. Input: mysql> show databases; +-------------------------+ | Database | +-------------------------+ | information_schema | |...

4. Shell Programming and Scripting

Two databases

Hello, I have two databases one is student_Name and another is student_Name1...Two tabled contain 200 records each..I found that near 30 names are entered in both databases..I would like to remove the duplicates..and i have to keep the name which is newly added..Please hepl how to remove...

5. UNIX for Dummies Questions & Answers

Diff command with databases

How can we compare query results from different databases using Unix diff command from command-line in Ab Initio tool?

6. 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)...

7. Shell Programming and Scripting

Need help in backing up of databases.

Hi Everyone, I am new to DBA stuff. I wonder if anyone can help me. Task is that, I have 10 databases and need to take backups of all the databases using data pump in Unix/Linux, compress them using gzip and use cron to schedule the job twice a day. Appreciate if anyone can help me in...

LEARN ABOUT DEBIAN

onedb

ONEDB(1)					  onedb(1) -- OpenNebula database migration tool					  ONEDB(1)

NAME

       onedb

       This  command  enables the user to manage the OpenNebula database. It provides information about the DB version, means to upgrade it to the
       latest version, and backup tools.

OPTIONS

	-f, --force		  Forces the backup even if the DB exists
	-b, --backup file	  Use this file to store SQL dump
	-v, --verbose		  Verbose mode
	-h, --help		  Show this message
	-V, --version		  Show version and copyright information
	-s, --sqlite file	  SQLite DB file
	-S, --server host	  MySQL server hostname or IP. Defaults to localhost
	-P, --port port 	  MySQL server port. Defaults to 3306
	-u, --username user	  MySQL username
	-p, --password pass	  MySQL password. Leave unset to be prompted for it
	-d, --dbname dbname	  MySQL DB name for OpenNebula

COMMANDS

       o   backup [output_file]

	   Dumps the DB to a file specified in the argument
	   valid options: force

       o   version

	   Prints the current DB version.
	   Use -v flag to see also OpenNebula version

       o   history

	   Prints the upgrades history

       o   restore [backup_file]

	   Restores the DB from a backup file. Only restores backups generated
	   from the same backend (SQLite or MySQL)
	   valid options: force

       o   upgrade [version]

	   Upgrades the DB to the latest version
	   where <version> : DB version (e.g. 1, 3) to upgrade.
			     By default the DB is upgraded to the latest version
	   valid options: force, backup

ARGUMENT FORMATS

       o   file

	   Path to a file

       o   range

	   List of id's in the form 1,8..15

       o   text

	   String

								    April 2012								  ONEDB(1)