How to push files to bitbucket from my windows system?

To upload files to bitbucket from your windows system ,first you need to install git and after have to clone repository to local device with clone git command ,it automatically create folder for you with all your server files.update changes and push your data .Here will discuss each steps

Lets see the steps

1) Download git for windows from https://www.google.co.in/search?q=install+git+on+windows&rlz=1C1CHZL_enIN773IN773&oq=install+git&aqs=chrome.1.69i57j0l5.2500j0j7&sourceid=chrome&ie=UTF-8

2) Install Git

3) Open cmd and try git status

#git

Git

4) move cmd directory to your project folder using #cd D:\newprojetc

5) Clone your bitbucket respository using below command

# git clone https://BITBUCKETUSERNAME@bitbucket.org/PROJECTNAME/RESPOSITORYNAME.git
auto create all your bitbucket files to your system newprojetc folder

6) update the files you needed and and commit using

#git git add .
#git commit -m “initial commit”

7) upload files using Push command

#gift push https://BITBUCKETUSERNAME@bitbucket.org/PROJECTNAME/RESPOSITORYNAME.git

uploaded files to bitbucket from yoursystem

How to export big size csv files mysql database

LOAD DATA LOCAL INFILE 

To export big size csv(e.g 10gb) files in to mysql database using phpmyadmin is difficult . Fortunately we have solution.You can use linux ssh prompt to insert big size csv files mysql database, for that we have MySQL function ” LOAD DATA LOCAL INFILE ” by using this we can insert big gb sql file in to database(export big size csv files in to database) directly, below i have mentioned syntax with example

 

# mysql -u admin -p`cat /etc/psa/.psa.shadow`;

mysql>LOAD DATA LOCAL INFILE ‘FileName.csv’ INTO TABLE table
FIELDS
TERMINATED BY ‘,’
LINES
TERMINATED BY ‘\\n’
IGNORE 1 LINES
(column1, column2, column3…)

see more about SSH