Archive for ‘ MySQL ’

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

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

We can connect to MySQL the easy way or the other way by writing a MySQL wrapper, that’s upto the programmer. In this post, i will not go for any wrapper or class but will share my approach with PDO, which itself is OO. In the code, i declare a variable this is to switch […]

Read more

SMF forum is quit popular open source forum application used by many websites as their main bulletin board. Some time we need to grab posts,topics from the board and show them on our home/index page or anywhere on our site. To make the things much easier, SMF provides all this in one script where we […]

Read more

Search

Articles

What's Hot

Recent Comments