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)
Check Out this Related Man Page
ONEVDC(1)onevdc(1)-- manages OpenNebula Virtual DataCenters ONEVDC(1)NAME
onevdc
SYNOPSIS
onevdc command [args] [options]
OPTIONS -f, --force Force the usage of Hosts in more than one VDC
-j, --json Show the resource in JSON format
-s, --hosts 1,2,3 Host IDs
-d, --datastores 1,2,3 Datastore IDs
-n, --networks 1,2,3 Network IDs
-v, --verbose Verbose mode
-h, --help Show this message
-V, --version Show version and copyright information
COMMANDS
o create file
Create a new VDC
valid options: force
o show vdcid
Show information of a particular VDC
valid options: json
o list
Lists VDCs in the pool
valid options: json
o delete vdcid
Deletes a VDC
o add vdcid
Adds the set of resources to the VDC
valid options: force, hosts, datastores, networks
o del vdcid
Deletes the set of resources from the VDC
valid options: hosts, datastores, networks
ARGUMENT FORMATS
o file
Path to a file
o range
List of id's in the form 1,8..15
o text
String
o vdcid
VDC ID
LICENSE
OpenNebula 3.4.1 Copyright 2002-2012, OpenNebula Project Leads (OpenNebula.org)
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may
obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0
April 2012 ONEVDC(1)
I have backups that run in a cron @ midnight. Does the backup utility make sure that the system is quiet --(no users are logged on) or do I need to add some stuff to make sure nobody is accessing those file while they are being backed up. (3 Replies)
I am needing to "un-block" port 3306 so that I can access MySQL from another PC.
When I installed Mandrake 8.1, I set the security level to high because it is going to be a web server. I believe I have to allow access to my ports now and I do not know the commands to do that.
If anyone... (4 Replies)
I've been running Django on MySQL on a Linux server for about 3 months w/o any problem. Suddenly a couple days ago, the server Django began throwing errors about not being able to connect to MySQL, at which point the entire server seizes up. The Apache Web server stops serving pages and SSH seizes... (3 Replies)
Hello,
I run a web hosting company, and I'm wondering how I can use cPanel's Cron Jobs so that a copy of my entire home directory and a copy all of my MySQL databases can be compressed and emailed to me. I know nothing about Linux, Unix, or whatever that thing with the penguin is called. :)
... (7 Replies)
Basically, I'm wondering if there's an easy way to encrypt the password to a username and store it in MySQL. But being able to authenticate to it. (3 Replies)
I have serveral servers that are at AIX 6.1 tl4 sp1 and want to move them to new hardware and upgrade them at the same time. Using NIM and sysback images I want to backup the current server with sysback and restore it and upgrade it to AIX 6.1 tl4 sp6 to the new hardware using my NIM server. My... (4 Replies)
i have an AIX server and planning to upgrade the operating system, before that i want to take a system backup which can be used in case of upgrade failure. i dont have NIM server t hold the mksysb backups. so i have the only option of taking the backup on DVD. i have the following optical drive... (5 Replies)
I'm afraid I'm going to have to migrate our entire website from Linux. There have been a number of irregularities in our MySQL database and the system that we have set up -probably isn't scalable.
Since my manager is re-envisioning (taking the moment to re-engineer) -he wants to move the... (5 Replies)
Hello sir,
i have used this for taking the database backup
5 * * * * \usr\bin\sh\mysqldump -h localhost -u username-ppassword cms> /home/dbbackup.sql.
but it creates a zero size database and in mail it gives error like command not found.
Please Help me (3 Replies)
Hello all again,
How do you guys backup your MySQL databases?
I have a few programs that have an default back up that make an .sql file which is great but I also use OpenX which runs on PHP and has a database. That does not have an auto-back-up feature so do I just download the... (2 Replies)
Hi All,
I have written a shell script that creates a backup of my MySQL database. The script performs the following functions:
Creates a Backup of the MySQL database
Compresses the Backup
Copies the Backup to a Remote Server
Send an E-Mail displaying the size of the Backup
Removes any... (6 Replies)
Hi @all!
In my MySQL-backup-script I backup and compress every single table with this command:
/usr/bin/mysqldump --opt database_x table_y | /usr/bin/pbzip2 -c > "/media/BackUpDrive/Backup/table_x.gz"Unfortunately these files need modification - they have to start with the following line(s):... (7 Replies)
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... (12 Replies)
I just wanted to share what a great MySQL (and other SQL) GUI DevArt provides.
3 years ago our company adopted a new ERP system that's entirely LAMP based. UGGG! Seriously? SQL Server *upgrade* to MySQL!???
This ERP is entirely vendor supported, but I have a replica database for data... (3 Replies)