Custom Search

Thursday, March 28, 2013

How to reproduce MySQL ERROR 1205 Lock wait timeout exceeded

How to reproduce MySQL ERROR 1205 Lock wait timeout exceeded

1)
Goto mysql Prompt and check default value of innodb_lock_wait_timeout
mysql> show variables like 'innodb_lock_wait_timeout';

2)
Open /etc/mysql/my.cnf and add
[mysqld]
innodb_lock_wait_timeout=3

3)
Restart mysql
#/etc/init.d/mysql restart



 
4)
Goto mysql Prompt and check the new value of innodb_lock_wait_timeout
mysql> show variables like 'innodb_lock_wait_timeout';

5)
Open a mysql prompt and select a database, begin a transaction, run a update query (don't commit the transacion).
mysql> use mydb1
mysql> begin;
mysql> update mytable set name="blabla" where id=2;

6)
Open another mysql prompt and select same database, Try to delete the rows which were updated in first mysql prompt.
mysql> use mydb1
mysql> begin;
mysql> delete from mytable where id=2;

Tuesday, March 26, 2013

How to Setup OpenStack Horizon Development Environment

How to Setup OpenStack Horizon Development Environment  

1)
Clone horizon git repo
#git clone https://github.com/openstack/horizon.git

2)
Create Virtualenv and install dependencies
#cd horizon
#python tools/install_venv.py


3)
Horizon development environment setup is complete.
To activate the virtualenv for the extent of your current shell session you can run:
$ source .venv/bin/activate

4)
Start Server
#python manage.py runserver
Development server is running at http://127.0.0.1:8000/


5)
To fix error : AttributeError: 'Settings' object has no attribute 'OPENSTACK_KEYSTONE_URL'

#cp openstack_dashboard/local/
local_settings.py.example openstack_dashboard/local/local_settings.py

6)
Restart Server
#python manage.py runserver
Development server is running at http://127.0.0.1:8000/

7)
To fix error : FilterError: /usr/bin/env: node: No such file or directory
http://www.cloudbase.it/howto-solve-devstack-dashboard-node-error/

Install node
#sudo apt-get install node-less

On Ubuntu 12.10 you will also need nodejs-legacy:
#sudo apt-get install nodejs-legacy

Restart Server
#python manage.py runserver
Development server is running at http://127.0.0.1:8000/

8)
To fix error : "An error occurred authenticating. Please try again later."

Openstack Nova doesn't installed and running on this machine, that is why getting error "An error occurred authenticating. Please try again later." That is, non of openstack services running on this machine

If you have an Openstack server with services are running, then you can specify IP of that server in Openstack_dashboard/local/local_settings.py
For example:
OPENSTACK_HOST = "192.168.12.222"
Then restart server. After that horizon will connect to openstack Nova running on 192.168.12.222.


9)
Goto openstack_dashboard/local/local_settings.py
Then change the openstack host

OPENSTACK_HOST = "192.168.12.222"

Restart Server
#python manage.py runserver
Development server is running at http://127.0.0.1:8000/

Monday, March 25, 2013

Linux How to remove all permissions on a file or directory and protect it

Linux How to remove all permissions on a file or directory and protect it

##Remove all permissions on directory perm_tes of Owner(u), Group(g), others(o) and all(a)
chmod 000 perm_test
or
chmod 0 perm_test
or
chmod a=--- perm_test
or
chmod a=- perm_test


##Open Read permission of Owner on directory perm_tes
chmod 400 perm_test
or
chmod u=r perm_test

##Open Read Write permission of Owner on directory perm_tes
chmod 600 perm_test
or
chmod u=rw perm_test

##Open Read Write Exec permission of Owner on directory perm_tes

chmod 700 perm_test
or
chmod u=rwx perm_test

##Open Read Write Exec permission of Owner on directory perm_tes and its all sub directories and files
chmod 700 perm_test
or
chmod u=rwx perm_test

-------------------

##Remove all permissions on file perm_test/address.txt of Owner
chmod  u=- perm_test/address.txt

##Open Read permission of Owner on file address.txt
chmod  u=r perm_test/address.txt

##Open Read Write permission of Owner on file address.txt
chmod  u=rw perm_test/address.txt

-----------------

##Remove all permissions on file perm_test/address.txt of group
chmod  g=- perm_test/address.txt

##Open Read permission of group on file address.txt
chmod  g=r perm_test/address.txt

##Open Read Write permission of group on file address.txt
chmod  g=rw perm_test/address.txt

-----------------

##Remove all permissions on file perm_test/address.txt of others
chmod  o=- perm_test/address.txt

##Open Read permission of others on file address.txt
chmod  o=r perm_test/address.txt

##Open Read Write permission of others on file address.txt
chmod  o=rw perm_test/address.txt

-----------------

##Remove all permissions on file perm_test/address.txt of owner and group
chmod  ug=- perm_test/address.txt

##Remove all permissions on file perm_test/address.txt of owner,group and others
chmod  ugo=- perm_test/address.txt

##Add Write permissions on file perm_test/address.txt for owner
chmod  u+w perm_test/address.txt

##Add Write permissions on file perm_test/address.txt for owner and group
chmod  ug+w perm_test/address.txt

##Add Read Write permissions on file perm_test/address.txt for owner and group
chmod  ug+rw perm_test/address.txt

##Remove Write permissions on file perm_test/address.txt for owner
chmod  u+w perm_test/address.txt

##Remove write permissions on file perm_test/address.txt for owner and group
chmod  ug-w perm_test/address.txt

##Remove Read Write permissions on file perm_test/address.txt for owner and group

chmod  ug-rw perm_test/address.txt

-----------------

##Add Read Write permissions on file perm_test/address.txt for all (owner,group and others)
chmod  a+rw perm_test/address.txt

##Remove Read Write permissions on file perm_test/address.txt for all (owner,group and others)
chmod  a-rw perm_test/address.txt

-----------------

How to understand and set file permissions on Linux

$ ls -l
drwx------  3 saju saju   4096 Mar 25 12:37 appliance_store
-rw-rw-r--  1 saju saju 223253 Mar 25 15:47 squid.log

The very first column, shows the file type and permissions.The second column shows the number of links (directory entries that refer to the file), the third one shows the owner of the file, and the fourth one shows the group the file belongs to. The other columns show the file's size in bytes, date and time of last modification, and the file name.

The first column, is organized into four separate groups.
The first group consists of only one character, and it shows the file's type.
For example, The first character can be any of these:

d = directory
- = regular file
l = symbolic link
s = Unix domain socket
p = named pipe
c = character device file
b = block device file

The next nine characters show the file's permissions, divided into three groups, each consisting of three characters. The first group of three characters shows the read, write, and execute permissions for user, the owner of the file. The next group shows the read, write, and execute permissions for the group of the file. Similarly, the last group of three characters shows the permissions for other, everyone else. In each group, the first character means the read permission, the second one write permission, and the third one execute permission.

The characters are pretty easy to remember.

r = read permission
w = write permission
x = execute permission
- = no permission


How to set file permissions - symbolic mode
===============================


Which user?
u     user/owner
g     group
o     other
a     all


What to do?
+     add this permission
-     remove this permission
=     set exactly this permission


Which permissions?
r     read
w     write
x     execute


How to set file permissions - numeric mode
===============================


4 = read (r)
2 = write (w)
1 = execute (x)
0 = no permission (-)


Which number?
0     ---
1     --x
2     -w-
3     -wx
4     r--
5     r-x
6     rw-
7     rwx

Wednesday, March 20, 2013

How to use Zorin OS 6.1

How to use Zorin OS 6.1



How To Setup Xen Hypervisor on Ubuntu Virtual Machine

How To Setup Xen Hypervisor on Ubuntu Virtual Machine


How to Configure Network on Xen hypervisor running on Ubuntu Virtual Machine


How To Create PV Guest VM on Xen Hypervisor running on Ubuntu Virtual Machine


Friday, March 15, 2013

How to Start or Stop VMware Web Service on ESXi host

1) SSH to ESXi host
#ssh root@esxi-host

2)  Stop Web Service
#/etc/init.d/hostd stop
Goto http://esxi-host for check

3)  Start Web Service
#/etc/init.d/hostd start
Goto http://esxi-host for check

Thursday, March 14, 2013

How to Setup OpenStack Development Environment

How to Setup OpenStack Development Environment

1)
Setting development environment using devstack
http://devstack.org



2)
http://docs.openstack.org/developer/openstack-projects.html

Setting up a Nova development environment
http://docs.openstack.org/developer/nova/devref/development.environment.html 

Setting up a Keystone development environment
http://docs.openstack.org/developer/keystone/setup.html

Setting up a Glance development environment
http://docs.openstack.org/developer/glance/installing.html

Setting up a Horizon development environment
http://docs.openstack.org/developer/horizon/quickstart.html

Programming OpenStack Compute API with Shell and Python
http://docs.openstack.org/api/openstack-compute/programmer/content/
http://docs.openstack.org/api/

3)
https://answers.launchpad.net/nova/+question/184580

4)
http://uksysadmin.wordpress.com/2011/02/17/running-openstack-under-virtualbox-a-complete-guide/

http://cssoss.wordpress.com/2011/04/27/openstack-beginners-guide-for-ubuntu-11-04-installation-and-configuration/

How to fix devstack stack.sh nova-api did not start

Solved How to fix devstack stack.sh nova-api did not start

Solution
======
First run ./unstack.sh
Then run ./stack.sh

This way i could bypass following Error

Error
====
+ screen -S stack -p n-api -X stuff 'cd /opt/stack/nova &&
/usr/local/bin/nova-a'i || touch
"/opt/stack/status/stack/n-api.failure"
+ echo 'Waiting for nova-api to start...'
Waiting for nova-api to start...
+ wait_for_service 60 http://192.168.1.5:8774
+ local timeout=60
+ local url=http://192.168.1.5:8774
+ timeout 60 sh -c 'while ! http_proxy= https_proxy= curl -s
http://192.168.1.5:8774 >/dev/null; do sleep 1; done'
+ die 545 'nova-api did not start'
+ local exitcode=0
+ '[' 0 == 0 ']'
+ exitcode=1
+ set +o xtrace
[ERROR] ./stack.sh:545 nova-api did not start
saju@saju-ops:~/devstack$

Success Screen
============



Wednesday, March 13, 2013

shellscript how to check whether a variable is empty or not

shellscript how to check whether a variable is empty or not
$
$ MYVAR=""
$
$
$ if [ -z $MYVAR ]; then echo "Empty"; else echo "Not Empty"; fi
Empty
$
$
$ MYVAR="sometext"
$
$
$ if [ -z $MYVAR ]; then echo "Empty"; else echo "Not Empty"; fi
Not Empty
$
$

Python how to use collections counter

>>>
>>>
>>> print Counter("hello")
Counter({'l': 2, 'h': 1, 'e': 1, 'o': 1})
>>>
>>>
>>> print Counter("hheelloo")
Counter({'h': 2, 'e': 2, 'l': 2, 'o': 2})
>>>
>>>
>>> print Counter("saju")
Counter({'a': 1, 's': 1, 'j': 1, 'u': 1})
>>>
>>>

python how to find all odd or even numbers from a list without list comprehension

python how to find all odd or even numbers from a list without list comprehension

1)
Example-1
===========

>>>
>>>
>>> lst = range(0, 20)
>>>
>>>
>>> lst
[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19]
>>>
>>>
#Get All Odd Numbers Starting from index 1 of list lst
>>>
>>>
>>> lst[1::2]
[1, 3, 5, 7, 9, 11, 13, 15, 17, 19]
>>>
>>>
#Get Even Numbers Starting from index 2 of list lst
>>>
>>>
>>> lst[2::2]
[2, 4, 6, 8, 10, 12, 14, 16, 18, 20]
>>>
>>>
#Get All 3rd th element Starting from index 1 of list lst
>>> lst[1::3]
[1, 4, 7, 10, 13, 16, 19]
>>>
>>>
#Get All 3rd th element Starting from index 0 of list lst
>>> lst[::3]
[0, 3, 6, 9, 12, 15, 18]
>>>
>>>
#Get All 3rd th element Starting from index 0 of list lst
>>> lst[0::3]
[0, 3, 6, 9, 12, 15, 18]
>>>

2)
Example-2
===========

>>>
>>>
>>> lst = range(1, 21)
>>>
>>>
>>> lst
[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20]
>>>
>>>
#Get All Odd Numbers Starting from index 0 of list lst
>>> lst[::2]
[1, 3, 5, 7, 9, 11, 13, 15, 17, 19]
>>>
>>>
#Get Even Numbers Starting from index 1 of list lst
>>> lst[1::2]
[2, 4, 6, 8, 10, 12, 14, 16, 18, 20]
>>>
>>>

Monday, March 11, 2013

How To Install Sublime Package Control

How To Install Sublime Package Control

1)
Installation is through the Sublime Text 2 console. This is accessed via the ctrl+` shortcut. Once open, paste the following command into the console and Press Enter button.

import urllib2,os; pf='Package Control.sublime-package'; ipp=sublime.installed_packages_path(); os.makedirs(ipp) if not os.path.exists(ipp) else None; urllib2.install_opener(urllib2.build_opener(urllib2.ProxyHandler())); open(os.path.join(ipp,pf),'wb').write(urllib2.urlopen('http://sublime.wbond.net/'+pf.replace(' ','%20')).read()); print('Please restart Sublime Text to finish installation')


2)
Restart Sublime Text

3)
Use the shortcut ctrl+shift+p
Then Type "Package Control"

How to Install Sublime Text 2 on Ubuntu using tar file

How to Install Sublime Text 2 on Ubuntu using tar file

1)
Goto http://www.sublimetext.com/
Download tar file Sublime Text 2.0.1 x64.tar.bz2
http://c758482.r82.cf2.rackcdn.com/Sublime%20Text%202.0.1%20x64.tar.bz2

2)
Extract tar file
#tar -xf Sublime\ Text\ 2.0.1\ x64.tar.bz2


3)
Rename Folder to sublime_text_2  (Optional)
#mv Sublime\ Text\ 2/ sublime_text_2

4)
Move to /opt
#sudo mv sublime_text_2 /opt

5)
Create a symbolic link in “/usr/bin"
#sudo ln -s /opt/sublime_text_2/sublime_text /usr/bin/sublime

6)
Start Sublime Text 2
#sublime

How to Install Sublime Text 2 on Ubuntu using apt-get install

 How to Install Sublime Text 2 on Ubuntu using apt-get install

#sudo add-apt-repository ppa:webupd8team/sublime-text-2


#sudo apt-get update

#sudo apt-get install sublime-text

Sunday, March 10, 2013

How To Create a PV Guest VM on Ubuntu Virtual Machine with Xen hypervisor

How To Create a PV Guest VM on Ubuntu Virtual Machine with Xen hypervisor

Manually creating a PV Guest VM
=======================


In this section we will focus on Paravirtualized (or PV) guests.
PV guests are guests that are made Xen-aware and therefore can be optimized for Xen.

As a simple example we'll create a PV guest in LVM logical volume (LV) by doing a network installation of Ubuntu (other distros such as Debian, Fedora, and CentOS can be installed in a similar way).



1)
Install LVM

#sudo apt-get update
#sudo apt-get install lvm2


2)
Create Volume Group and Logical Volume.

#sudo mkdir /mnt/vmdisk
#sudo dd if=/dev/zero of=/mnt/vmdisk/mydisk1 bs=100M count=10
#sudo losetup /dev/loop1 /mnt/vmdisk/mydisk1
#sudo pvcreate /dev/loop1
#sudo vgcreate -s 512M myvolume-group1 /dev/loop1
#sudo lvcreate -L 512M -n mylogical_volume1 myvolume-group1
#ls /dev


3)
Get netboot images

#sudo mkdir -p /var/lib/xen/images/ubuntu-netboot
#cd /var/lib/xen/images/ubuntu-netboot
#sudo wget http://mirror.anl.gov/pub/ubuntu/dists/precise/main/installer-amd64/current/images/netboot/xen/initrd.gz
#sudo wget http://mirror.anl.gov/pub/ubuntu/dists/precise/main/installer-amd64/current/images/netboot/xen/vmlinuz


4)
Set up the initial guest configuration

#vim /etc/xen/ubuntu.cfg
name = "ubuntu"
memory = 256
disk = ['phy:/dev/myvolume-group1/mylogical_volume1,xvda,w']
vif = [' ']
kernel = "/var/lib/xen/images/ubuntu-netboot/vmlinuz"
ramdisk = "/var/lib/xen/images/ubuntu-netboot/initrd.gz"
extra = "debian-installer/exit/always_halt=true -- console=hvc0"


5)
Start the VM and connect to console (-c).

#sudo xm create -c /etc/xen/ubuntu.cfg

6)
List VMs

#sudo xm list

How to Configure Network on Ubuntu Virtual Machine with Xen hypervisor

How to Configure Network on Ubuntu Virtual Machine with Xen hypervisor

Network Configuration
================


This section describes how to set up linux bridging in Xen.
It assumes eth1 is both your primary interface to dom0 and the interface you want your VMs to use.
It also assumes you're using DHCP.

1)
Install Bridge utils

#sudo apt-get install bridge-utils

2)
Stop Network Manager

#sudo /etc/init.d/network-manager stop


3)
Edit Interface

#vim /etc/network/interfaces
auto lo
iface lo inet loopback

auto xenbr0
iface xenbr0 inet dhcp
bridge_ports eth1

auto eth1
iface eth1 inet dhcp


4)
Restart networking to enable xenbr0 bridge.

#sudo /etc/init.d/networking restart

How To Setup Ubuntu Virtual Machine with Xen Hypervisor

How To Setup Ubuntu Virtual Machine with Xen Hypervisor

* First setup Ubuntu 12.04 VM

Installing Xen
==========

1)
Install a 64-bit hypervisor

#sudo apt-get install xen-hypervisor-amd64

2)
Modify GRUB to default to booting Xen.

#sudo sed -i 's/GRUB_DEFAULT=.*\+/GRUB_DEFAULT="Xen 4.1-amd64"/' /etc/default/grub
#sudo update-grub



 
3)
Set the default toolstack to xm (aka xend).

#sudo sed -i 's/TOOLSTACK=.*\+/TOOLSTACK="xm"/' /etc/default/xen

4)
Reboot

#sudo reboot

5)
Verify that the installation has succeeded.

#sudo xm list

6)
Network Configuration
http://fosshelp.blogspot.com/2013/03/how-to-configure-network-on-ubuntu.html 

7)
Create a PV Guest VM 
http://fosshelp.blogspot.com/2013/03/how-to-create-pv-guest-vm-on-ubuntu.html 

 

How to restart horizon(dashboard) alone in devstack

1) Option-1
restart the webserver
#sudo service apache2 restart


2) Option-2
Go to the horizon code and run
#python ./manage.py runserver
It will run another server on separate port, default is 8080 and auto reload every times you made any changes.

Saturday, March 9, 2013

How to libvirt API and virsh reconnect to another remote hypervisor

We can use "connect" URI command to reconnect to another remote hypervisor

1)Open virsh Terminal

#virsh

2) Connect to Remote VMware ESXi Server
virsh #connect esx://192.168.12.153?no_verify=1
or
virsh #connect esx://root@192.168.12.156?no_verify=1


esx : driver or hypervisor
192.168.12.153 : ESXi Server

3) Connect to Remote VMware vCenter Server
virsh #connect vpx://192.168.12.156/vCenter/Cluster-1/192.168.12.153?no_verify=1
or
virsh #connect vpx://root@192.168.12.156/vCenter/Cluster-1/192.168.12.153?no_verify=1


vpx :  driver or hypervisor
192.168.12.156 : vCenter Server
192.168.12.153 : ESXi Server (host)
vCenter : Name of Datacenter
Cluster-1 : Name of Cluster or Compute Resource

http://libvirt.org/uri.html

How to connect to VMware vCenter Server using libvirt API and virsh command


1) First install libvirt 1.0.0
http://fosshelp.blogspot.in/2013/03/how-to-compile-and-install-libvirt-100.html

2) Connect to VMware vCenter Server 
#virsh -c vpx://192.168.12.156/vCenter/Cluster-1/192.168.12.153?no_verify=1
#virsh -c vpx://vcenter-server-name/datacenter-name/cluster-or-computeresource-name/host-name?no_verify=1

or

#virsh -c vpx://192.168.12.156/Datacenters/vCenter/host/Cluster-1/192.168.12.153?no_verify=1
#virsh -c vpx://vcenter-server-name/folder-name/datacenter-name/host/cluster-or-computeresource-name/host-name?no_verify=1

vpx :  driver or hypervisor
192.168.12.156 : vCenter Server
192.168.12.153 : ESXi Server (host)
vCenter : Name of Datacenter
Cluster-1 : Name of Cluster or Compute Resource


#list --all

#list --help

#help

#pool-list

#net-list

#version

#uri

#list --all

#domstate dom-id or dom-name

#dominfo dom-id or dom-name

#start dom-id or dom-name

#shutdown dom-id or dom-name

#reboot dom-id or dom-name

#destroy dom-id or dom-name

#migrate dom-id or dom-name


How to connect to VMware ESXi Server using libvirt API and virsh command


1) First install libvirt 1.0.0
http://fosshelp.blogspot.in/2013/03/how-to-compile-and-install-libvirt-100.html

2) Connect to VMware ESXi Server
#virsh -c esx://192.168.12.153?no_verify=1
or
#virsh -c esx://root@192.168.12.153?no_verify=1

esx : driver or hypervisor
192.168.12.153 : ESXi Server




#list --all

#list --help

#help

Friday, March 8, 2013

SOLVED:configure: error: You must install the YAJL development package in order to compile libvirt

configure: error: You must install the YAJL development package in order to compile libvirt


Install libyajl-dev
#sudo apt-get install libyajl-dev

How to Compile and Install libvirt 1.0.0 on Ubuntu 12.10

1)
Download the libvirt tarball from 
http://libvirt.org/sources/
http://libvirt.org/sources/libvirt-1.0.0.tar.gz

2)
Extract the tarball


3)
Install dependencies
#sudo apt-get install gcc make pkg-config libxml2-dev libgnutls-dev libdevmapper-dev libcurl4-gnutls-dev python-dev libpciaccess-dev libxen-dev libnl-dev libyajl-dev
You can omit the libcurl4-gnutls-dev package if you don’t want ESX support.

4)
run the configure command.
#./configure --prefix=/usr --localstatedir=/var --sysconfdir=/etc --with-esx=yes --with-xen=yes
if you need Xen support, you’ll need to add --with-xen=yes to the command.

5)
#sudo make
#sudo make install

6)
Verify that everything seems to be working as expected.
a)
restart libvirt 
#sudo initctl stop libvirt-bin
#sudo initctl start libvirt-bin

7)
Verify Version
#virsh --version
#libvirtd --version
to verify that you’re running libvirt 1.0.0

SOLVED:configure: error: libnl-devel >= 1.1 is required for macvtap support


configure: error: libnl-devel >= 1.1 is required for macvtap support

Install libnl-dev
#sudo apt-get install libnl-dev

SOLVED:configure: error: You must install the Xen development package to compile Xen driver with -lxenstore


configure: error: You must install the Xen development package to compile Xen driver with -lxenstore

Install libxen-dev
#sudo apt-get install libxen-dev

SOLVED:configure: error: You must install the pciaccess module to build with udev

configure: error: You must install the pciaccess module to build with udev

Install libpciaccess-dev
#sudo apt-get install libpciaccess-dev

How to Compile and Install libvirt 1.0.3 on Ubuntu 12.10

1)
Download the libvirt tarball from
http://libvirt.org/sources/
http://libvirt.org/sources/libvirt-1.0.3.tar.gz


2)
Extract the tarball
#tar -xzf libvirt-1.0.3.tar.gz

3)
Install dependencies
#sudo apt-get install gcc make pkg-config libxml2-dev libgnutls-dev libdevmapper-dev libcurl4-gnutls-dev python-dev libpciaccess-dev libxen-dev libnl-dev
You can omit the libcurl4-gnutls-dev package if you don’t want ESX support.

4)
run the configure command.
#./configure --prefix=/usr --localstatedir=/var --sysconfdir=/etc --with-esx=yes --with-xen=yes
if you need Xen support, you’ll need to add --with-xen=yes to the command.

5)
#sudo make
#sudo make install


6)
Verify that everything seems to be working as expected.
a)
restart libvirt
#initctl stop libvirt-bin
#initctl start libvirt-bin


7)
Verify Version
#virsh --version
#libvirtd --version
to verify that you’re running libvirt 1.0.3

Tuesday, March 5, 2013

How To Backup and restore MySQL databases using MySQL Workbench

How To Backup and restore MySQL databases using MySQL Workbench

A)
How To Backup MySQL databases using MySQL Workbench
----------------------------------------------------

1) Open MySQL Workbench

2) Create "New Server Instance"
* Click on "New Server Instance"

3) Open Backup/Restore window
* Click on "Manage Import/Export"

4) Click on "Data Export"
* Select Database or tables.
* Select one export option.
* Click on "Start Export" Button.

B)
How To Restore MySQL databases using MySQL Workbench
----------------------------------------------------

1) Open MySQL Workbench

2) Open Backup/Restore window
* Click on "Manage Import/Export"

3) Click on "Data Import/Restore"
* Select one import option.
* Click on "Start Import" Button.

Sunday, March 3, 2013

How to create ER Diagram from existing Database using MySQL WorkBench

How to create ER Diagram from existing Database using MySQL WorkBench



Saturday, March 2, 2013

How To use mysql workbench to browse database

How To use mysql workbench to browse database table data