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

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

Word 2003 “This document couldnot be registered. It will not be possible to create links from other documents to this document.”

By depratama
One day when i open a document in Ms. Word 2003, I get the message “ This document could not be registered. It will not be possible to create links from other documents to this document .” After searching using google.com and open some website, i have one solution. It’s only one maybe two step that i have to do. I open my services panel and activated my DCOM Server Process Launcher . And, it works, the message no longer show again when i open my document using word 2003. That’s all. I hope it works to you too, if you have same problem. Nb: Open services panel, just open Run (Start–> Run) and type services.msc then Enter .
Post a Comment
Read more

Website Using HTTPS Protocol

By depratama
Last week, I changed protocol of my website from http to https. There were steps that i had to do. First, I installed openssl package and mod_ssl # yum install mod_ssl openssl Then, I configured the openssl  and created certificate # cd /etc/pki/tls/certs # make server.key # openssl rsa -in server.key -out server.key # make server.csr # openssl x509 -in server.csr -out server.crt -req -signkey server.key -days 3650 # chmod 400 server.* After that, I changed configuration of httpd/apache #nano /etc/httpd/conf.d/ssl.conf DocumentRoot "/var/www/html" ServerName www.server.world:443 SSLCertificateFile /etc/pki/tls/certs/server.crt SSLCertificateKeyFile /etc/pki/tls/certs/server.key Last, I restarted the webserver #service httpd restart That's all what i did last week to change my website protocol from http to https.
Read more