Import Mysql File Using Command LIne

Import mysql file using command line on Linux needs several steps.

Step 1: Upload mysql file to server

You can use either ftp or scp to upload mysql file.

Step 2: Login to server

Login to server using ssh application. Example your website domain is pratama.us and username is demby. Type this command to login to your server.

ssh demby@pratama.us

You can change demby to your username and pratama.us to your domain or ip address.

Step 3: Import Mysql File

To import your mysql file to database you can use command below:

mysql -u USERNAME -p -h HOSTNAME DATABASENAME < FILENAME

Example if your mysql USERNAME is demby, HOSTNAME is localhost, DATABASENAME is dembydb and FILENAME is dembydb.sql, type this command to import.

mysql -u demby -p -h localhost dembydb < dembydb.sql

If you using ip address or domain as your hostname then your command become:

mysql -u demby -p -h 118.1.1.1 dembydb < dembydb.sql

mysql -u demby -p -h demby.pratama.us dembydb < dembydb.sql

After that, you can check your database and browse the data. This article is to remind me how to import mysql file to database using command line.

From Email

Rapidshare Premium Link Generator

Rapidshare Premium LINK Generator . Rapidshare.com is one of the biggest site that allow you to upload and share files with vary sizes. From rapidshare, you also can download files that another person upload the re. There are 2 kinds of user can download from rapidshare. First, free user, this user have limit features from rapidshare. Limit bandwidth, limit connection, etc. Second, premium user. Premium user have many features that free user doesn't have. If you want to be a premium user, you have to buy it from the web. You can use this link to buy premium account or from reseller that near you. But if you have not enough money to buy it, you can use Rapidshare Premium Link Generator . This is a website that give free service for anyone to generate rapidshare link from free to premium, so anyone can download with premium feature. &amp;amp;amp;amp;amp;amp;lt;br&amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;lt;br&amp;amp;amp;amp;amp;amp;gt;I...

Install ffmpeg on Centos

I want to install youtube-clone to my server (Centos 5) and it need some files. The important files that i have to install is ffmpeg. Then ask to uncle google where can i find how to install ffmpeg. I found one website that give tutorial how to install ffmpeg on Centos 5. The installation is begin from download the files. First, ffmpeg in rpm and others in tar.gz. Rpm files easy to install. But another have to do some config. You can read the tutorial install ffmpeg on Centos 5 here and here (Centos 4) . Another Link about Centos Guide For CentOS Centos 5 Live CD Password For root

15 Linux lsof Command Examples (Identify Open Files)

lsof stands for List Open Files. It is easy to remember lsof command if you think of it as "ls + of", where ls stands for list, and of stands for open files. It is a command line utility which is used to list the information about the files that are opened by various processes. In unix, everything is a file, ( pipes, sockets, directories, devices, etc.). So by using lsof, you can get the information about any opened files. 1. Introduction to lsof Simply typing lsof will provide a list of all open files belonging to all active processes. # lsof COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME init 1 root cwd DIR 8,1 4096 2 / init 1 root txt REG 8,1 124704 917562 /sbin/init init 1 root 0u CHR 1,3 0t0 4369 /dev/null init 1 root 1u CHR 1,3 0t0 4369 /dev/null init 1 root 2u CHR ...

Computer and Internet

Search This Blog