Related Articles
12 Key Points of SEO to Improve Website or Blog Traffic
Below are the best 12 Key Points of SEO which will Improve your Website or Blog Traffic, when posting or publishing an article. 12 Key Points of SEO 1. Domain name should be like a keyword, keep it short you can also use hyphens in domain name, hyphen separates as keyword. 2. Use of H1 […]
Export to Excel Using PHP and Mysql
Below simple program will export mysql data values to excel sheet without using any PHP libraries. Export to Excel Using PHP and Mysql Note: IF you get errors or in excel all the data is in one column, then instead t tab space use, comma ‘,’.
How to take Backup of MYSQL database sql file using MYSQLDUMP Command
For a single database: mysqldump –opt –user=root –password database1 > singledb.sql For multiple Backup of databases: mysqldump –opt –user=root –password –databases database1 database2 > multipledb.sql To import a MYSQL .sql file from one location to particular location : source /home/SSI/process_databases_backup.sql