Skip to main content

Import Mysql File Using Command LIne

By depratama
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
or

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
Labels:

Popular posts from this blog

Install ffmpeg on Centos

By depratama
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
Post a Comment
Read more

15 Linux lsof Command Examples (Identify Open Files)

By depratama
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 ...
Read more

Extend a LVM partition after increasing its virtual disk on Virtualbox

By depratama
No Linux machine at work? the easy way could be to simply install Virtualbox in one of the PC, create a VDI and install Ubuntu 14.04 in it. But the day will come when you need more space! Here is how to resize it: Resize Virtualbox VDI Open Virtualbox, make sure to shutdown your virtual machine. Then open a terminal (here windows): 1 2 3 4 cd “ C : \ Program Files \ Oracle \ VirtualBox ” VBoxManage list vms VBoxManage clonehd uuid 0000000000000000 backup . vdi VBoxManage modifyhd uuid 0000000000000000 -- resize 204800 This is the Virtualbox official manual  of available commands. And  this is a website  to convert Gb into Mb (–resize takes Mb as input, 200Gb = 204800Mb). Boot Gparted to resize the partition After a default install of Ubuntu Server on one physical disk, you will have a SWAP partition, and then an extended partition in which you’ll have your LVM partition (So 3 partitions).  Download Gparted  .iso,...
Read more