You are heretech

tech


Moving MySQL Database from Windows to Ubuntu Linux without mysqldump

This may work with other distros too.

The question is can it be done. My reply is yes… terms and condition applies.

Terms and conditions :
1. The mySQL DBMS for both the server must use same version.
2. Database only uses MyISAM tables, strictly no INNODB please.
3. Refer to line 1 and 2 :P

Workflow :
1. Stop the mySQL service on the windows server. Make sure that the mySQL service is really dead.
2. Go to the mysql database data path, Windows usually will be in “C:\MySQL\Data” or "c:\xampp\mysql\data".
3. Zip the directory/folder which shares the same name as the database that you are about to copy over.
4. After that, copy the file over to the Linux server. *use WinSCP at your windows machine if you have SSH installed in your Linux machine.
5. From the linux machine, stop the mySQL service. Yeah you need to make sure it is really dead.
6. Unzip the file and place it into the data path of mysql, my server database location it is at “/var/lib/mysql/" .
7. Change the ownership ("chown mysql:mysql -R") for the newly extract directory folder to mysql . "-R" will update proper files or folders permission too.
8. Re-initiate the mySQL service at the linux server.
9. Use the mysql shell to test :
shell > mysql -uroot -p[password]
mySQL shell > use [dbname]
database changed
mySQL Shell > select * from [table_name];

10. Should step 9 gives you the actual data, give your self a pat on your shoulder. Task is done.

 

(http://www.it-idiot.net/2008/01/moving-mysql-database-from-windows-to-li...)

Useful Ubuntu-linux commands

As of 9.10:

MYSQL

# To install MySql database:

sudo apt-get install mysql-server

# To start MySql server:

/etc/init.d/mysql start

# To stop MySql server:

/etc/init.d/mysql stop

# To restart MySql server:

/etc/init.d/mysql restart

# To check the status of  MySql server:

/etc/init.d/mysql status

Meetai.com corporate site launched.

Meetai logoIn advance to the new wave of talks and agreements on the design and coding sector, we are happy to announce that arielOn.com launched today Meetai's new corporate website.

Meetai is the new brand name that will help to focus our entrepreneural efforts and better communicate to our final clients.

The new webpage will include information about our areas of expertise and how we can help you develop applications with the highest quality at the best rates. You'll also find a Porftolio section with the work done so far.

 

Meetai homepage

We're also launching a Partnership program comprised of Agency Partners and Technology Partners as part of our vision to continue to seek partnerships when our client’s needs call for them.

The role of outsourcing and partnership is becoming an important element in order to keep offering the same quality levels in a competitive market. Find out how we can help you not only keep but also improve the quality of your applications, today.

 

Gartner puts Drupal in visionaries quadrant

In this year's report by Gartner, which was released the end of last month, Drupal was promoted to the 'visionaries' category right next to Google and other big players.  According to Gartner, visionaries align with Gartner's view of how a market will evolve, but they have yet to deliver against that vision.

 





Why does this matter? As most of you know, there are hundreds of web content management systems and not everyone has the time or skill sets to figure out what system to use. Plus, large organizations that are about to invest hundreds of thousands of dollars in a website project, don't want to make the wrong technology choice. Instead, those large businesses call Gartner, or any of the other analyst firms, to get advice on what technologies to adopt.

 

You might notice that neither Joomla! nor Wordpress are to be found on this graph.

 

Mercedes’ Futuristic Formula Zero Sail Racer

Recently Mercedes Benz revealed images of its stunning Formula Zero Racer, a futuristic foray into the next generation of racing. Incorporating elements from luge, yacht, and Formula One vehicles, the zero-emissions racer is propelled by a wind-catching sail in addition to electric motors that are powered by renewable resources. The concept is a tribute to a future where cars will win races based not just upon their speed, but on how energy efficient they are.

 

Read More @ inhabitat.com ->

Windows Vista sync center

Travelling as I am, I use to keep some information in two places, as a backup, just in case. In previous versions of Windows I normally would use the Windows Briefcase for keeping two folders in sync.

 

I'm starting to get used to the new Vista OS and I've found this looking for 'briefcase vista' on Google.

 

http://windowshelp.microsoft.com/Windows/en-US/Help/2f4213e8-4d0f-4f61-a...

Linux, splash screens and fast boot

"[...] splash screens. By the time you see it, we want to be done. The development time that distributions spend on splash screens is much more than the Intel team spent on booting fast enough not to need one."

 

From: Booting Linux in five seconds


arielon
Quantcast

Simple quotes

When we think,

we cannot fight.

 

When we laugh,

we cannot think.

Ari

Comm-uni-k-t!