xampp import large db file

-
C:\xampp\mysql\bin>mysql -h localhost -u root {DATABASE_NAME}  <  PATH/SQL/FILE

Comments

Post a Comment

Popular posts from this blog

Blogger post using PHP API

-
<?php error_reporting(E_ALL); ini_set('display_errors',1); session_start(); require_once dirname(__FILE__) . '/GoogleClientApi/src/Google/autoload.php'; require_once dirname(__FILE__).'/GoogleClientApi/src/Google/Client.php'; require_once dirname(__FILE__).'/GoogleClientApi/src/Google/Service.php'; require_once dirname(__FILE__).'/GoogleClientApi/src/Google/Model.php'; require_once dirname(__FILE__).'/GoogleClientApi/src/Google/Collection.php'; require_once dirname(__FILE__).'/GoogleClientApi/src/Google/Config.php'; require_once dirname(__FILE__).'/GoogleClientApi/src/Google/Service/Resource.php'; require_once dirname(__FILE__).'/GoogleClientApi/src/Google/Service/Blogger.php'; //echo '<pre>'; $scriptUri = "<redirect url>"; $client = new Google_Client(); $client->setAccessType('online'); // default: offline $client->setApplicationName('<appName...
Read more

php db functions

-
<?php class MarketplaceWebService_DB { function __construct($dbHost,$dbUsername,$dbPassword,$dbName){ // Connect database $conn = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName); if($conn->connect_error){ die("Failed to connect with MySQL: " . $conn->connect_error); }else{ $this->db = $conn; } } function getRecord($table,$where=array()){ $sql = "SELECT * FROM $table Where 1=1"; if(!empty($where)){ foreach($where as $key=>$val){ $sql .=' AND '.$key." = '".$val."'"; } } $query = $this->db->query($sql); $result = $query->fetch_all(); if($result){ return $result; }else{ return false; } } function getSingleRecord($table,$where=array()){ $sql = "SELECT * FROM $table Where 1=1"; if(!empty($where)){ foreach($where as $key=>$val){ $sql .=' AND '.$key." = '".$val."...
Read more

amazon add product xml

-
<?xml version="1.0" encoding="UTF-8"?> <AmazonEnvelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="amzn-envelope.xsd"> <Header> <DocumentVersion>1.01</DocumentVersion> <MerchantIdentifier>{$merchant_id}</MerchantIdentifier> </Header> <MessageType>Product</MessageType> <PurgeAndReplace>false</PurgeAndReplace> <Message>     <MessageID>1</MessageID>     <OperationType>Update</OperationType>     <Product> <SKU>WM-35-00-03-29-17</SKU> <StandardProductID> <Type>ASIN</Type> <Value>B01HN75TCQ</Value> </StandardProductID>         <Condition> <ConditionType>New</ConditionType> </Condition>                 <DescriptionData>       ...
Read more