Archive for ‘ MySQL ’

“Phalcon is a web framework implemented as a C extension offering high performance and lower resource consumption”. From the benchmark page, “The compiled nature of Phalcon offers extraordinary performance that outperforms all other frameworks measured in these benchmarks”. Personally i find it very easy to work with, less dirs and files for the project. And […]

Read more

In the last article we discuss how to backup data in csv format via PHP and command line. In this part we will backup MySQL databases via mysqldump command. I assume you are logged in to your Amazon instance. How to backup: 1- Normal database backup mysqldump -u root -p databasename > /var/www/html/databasename.sql Enter your […]

Read more

In the previous article we discuss how to “Backup MySQL data into CSV” in terminal. In this post we will discuss how to create csv file with PHP and force it to download. We will be pulling data from MySQL database. 1st of all we will need connection to database, for that we will use […]

Read more

In my last article i showed you how to “Setup web server on Amazon AMI or CentOS“, to continue that article further i will discuss how to backup MySQL data into CSV format. So let’s start, login into your machine through terminal and login to MySQL server and choose database by command ‘use databasename‘.  Let’s […]

Read more

If you are using Amazon aws with ec2 instances, then i assume you already have the pem file to connect to the instances. Normally you will have different instances for your projects. I normally setup either Amazon AMI or Cent OS, prefer Amazon AMI as it is also based on Cent OS. Cent OS is […]

Read more

MySQL have this load data function, where we can insert data to a table from external files like csv, txt etc. The process is quite simple, 1st lets login to mysql via terminal/console. mysql -u root -p Enter your MySQL password. Change root to any username(MySQL users) you would wish to login to MySQL. mysql> […]

Read more

Search

Articles

What's Hot

Recent Comments