Importing data from CSV to MySQL

In MySQL on January 4th, 2015

For my note: There are couple options to import data from .csv file into table. Mainly, mysqlimport and load data local in file. Also added reference to official MySQL and StackOverflow

Read more...

Segmentation failed with PHP, Magento and PDO

In Magento, MySQL, PHP on March 13th, 2014

The script fails with “Segmentation failed” error. I spent hours to debug this problem and found that some problem during inserting data into `catalog_product_entity_text`.

Read more...

If MySQL keep crashing on Amazon EC2 Micro Instance

In Linux, MySQL on August 16th, 2013

Micro instances have only 612MB of memory, MySQL crashed every now and then because of insufficient memory

Read more...

MySQL export

In MySQL on March 22nd, 2012

How to export data from MySQL select command. Saved for my reference

Read more...

My MySQL favorite dump command

In MySQL on May 4th, 2011

My favorite MySQL command line Dumps whole database table into mydb_mytable.sql file: mysqldump -umyuser -pmypass –skip-lock-tables -h 127.0.0.1 –databases mydb –tables mytable > mydb_mytable.sql Dumps whole database into mydb.sql file: mysqldump -umyuser -pmypass –skip-lock-tables -h 127.0.0.1 –databases mydb > mydb.sql

Read more...