gustavobgama

<?php
$url     = 'https://hostserver.com/gateway/remote_send';
$payload = array(
    'profile_name'  => 'username',
    'profile_pw'    => 'password1234',
    'attached_type' => 'action_1'
);
$file = realpath('/home/username/tests/test1234qwerty.csv');

// build multipart

gustavobgama

# GET
curl -i -u user:password http://localhost/productimage/create

# POST
curl -i -u user:password --data "param1=value1&param2=value2" http://localhost/productimage/create

gustavobgama

SELECT
  *
FROM
  table
INTO OUTFILE
  '/tmp/file.csv'
FIELDS TERMINATED BY
  ','
ENCLOSED BY
  '"'

gustavobgama

Get mounted partitions

$ sudo mount -l

Get creation date of file

$ debugfs -R 'stat <path_to_file>' <momunted_partition_path>

momunted_partition_path is the partition mouting path of path_file

gustavobgama

SELECT table_name,table_schema FROM INFORMATION_SCHEMA.COLUMNS
    WHERE column_name='column_name';

gustavobgama

# compact
tar -zcvf file.tar.gz source-folder

# extract
tar -zxvf file.tar.gz

gustavobgama

tac file | grep -m 1 term

gustavobgama

SELECT `AUTO_INCREMENT`
  FROM `information_schema`.`TABLES`
 WHERE `TABLE_SCHEMA` = SCHEMA()
   AND `TABLE_NAME` = 'tbl_name';

gustavobgama

# Reference: http://webcheatsheet.com/sql/mysql_backup_restore.php

# import without compression
mysql --host=host --user=user --password=password database < path_to_file.sql

# import with compression
gunzip < path_to_file.sql.gz | mysql --host=host --user=user --password=password database

# export wihtout compression
mysqldump --host=host --user=user --password=password database table --where="condition" > path_to_file.sql

gustavobgama

RESET QUERY CACHE;