MySQL: Backup and Restore

To take the entire backup of a database:
> mysqldump -u user_name -p database_name > dumped_file_name

To Restore the backup
> mysql -u user_name -p database_name < dumped_file_name

Technorati: Mysql

Searchmash: Another Google product

Searchmash mixes (mashes) the various types of searches from Google products like web sites, videos from You Tube and Google Video, images, blogs. The wikipedia search results are also mixed with it. It has a simpler interface and some useful user friendly features. There is a small “Ajax feedback” form too.

Technorati : google, searchmash

Spring Framework 2.0.3 Released

Spring’s this version is a bugfix and enhancement release in the Spring 2.0 series, including about 200 (!) refinements and fixes. Furthermore, this release introduces support for the JSR-166 (java.util.concurrent) backport project and basic support for JCA 1.5 (ResourceAdapter bootstrap, WorkManager support), as well as extended support for IBM WebSphere and Oracle OC4J.

Source : here

Technoarti: Spring 2.0

Uninstalling the Previous MySQL Installation in Linux

When we install the new version of mysql in linux then, if there is any old version is existing, it will show some conflict. So we have to remove the old files before proceeding further. The following commands will help you to do this.

# rpm -qa | grep -i mysql
libdbi-dbd-mysql-0.6.5-7
MySQL-python-0.9.1-9
perl-DBD-MySQL-2.9002-1
mod_auth_mysql-20030510-3
php-mysql-4.3.3-6
mysql-3.23.58-4
mysql-bench-3.23.58-4
mysql-server-3.23.58-4
freeradius-mysql-0.9.1-1
mysql-devel-3.23.58-4
qt-MySQL-3.1.2-14

You will want to uninstall any release of MySQL before continueing with the installation of latest MySQL version.

You can use RPM to uninstall the above packages as follows:

# rpm -e libdbi-dbd-mysql
# rpm -e MySQL-python
# rpm -e mod_auth_mysql
# rpm -e php-mysql
# rpm -e mysql-bench
# rpm -e mysql-server
# rpm -e freeradius-mysql
# rpm -e mysql-devel
# rpm -e mysql perl-DBD-MySQL MyODBC qt-MySQL

In addition to removing all MySQL packages, you will also want to remove any mysql group and user that may already be created. The following command will remove both the mysql group as well as the mysql group:

# userdel mysql

Reference here


Technorati : , ,

Design a site like this with WordPress.com
Get started