Command to see Memory Space available in GB on Linux df -h How to start restart linux: just enter restart How to start Mysql on Centos Linux server: /etc/init.d/mysqld start Restart Mysql on Linux Centos: /etc/init.d/mysqld restart Stop Mysql on Linux Centos: /etc/init.d/mysqld stop Check status of Mysql on Linux Centos: /etc/init.d/mysqld status How to […]
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
Below is a simple program which shows email verification confirmation using a unique code, implemented in PHP,Mysql, Codeigniter. PHP Codeigniter Email Verification Step 1 :Create a table as shown below with email_verification_code as necessary column: [mysql] CREATE TABLE `users` ( `user_id` int(10) NOT NULL auto_increment, `first_name` varchar(45) NOT NULL, `last_name` varchar(45) NOT NULL, `email_verification_code` varchar(45) […]
