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

How to create Twitter tell a friend API

Twitter provided lot of api to share your website, here am going to show you how to create Twitter tell a friend API.

1) Create a tell a friend share action page

e.g refer-login.php

In this page you add twitter meta tag like image and content.

e.g

<meta name=”twitter:card” content=”photo” />

<meta name=”twitter:site” content=”@technomania” />

<meta name=”twitter:title” content=”To create Twitter tell a friend” />

<meta name=”twitter:description” content=”description” />

<meta name=”twitter:image” content=”image path” />

2)  Then in tell a friend page link twitter tell a friend share button to https://twitter.com/intent/tweet?text=share message&url=refer-login.php&via=sitename.  This will automatically fetch image from meta tag in refer-login.php and display in users tweet.

Location of php.ini file in plesk server

Location of php.ini file in plesk server is inside etc folder. you can login using your details (provided by hosting provider) in to ssh login prompt after you can type below commant to edit your php.in file.

# vim /etc/php.ini

you can type “i” key to make this file editale, you can use “esc” command to escape from editable mode .To save you can use “wq:”.

you can always use phpinfo(); to check the exact location of php in server.

create a php file e.g info.php with below conntent

echo phpinfo();

save this and upload in your root folder

check “domain.com/info.php” it will show you exact location of “php.ini ” files.Also it will show all the details about your php version.