Mysql

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

Related Articles
Javascript Mysql PHP

PHP Radio Button Example With Mysql DB

viveik

Simple PHP Radio button enable and disable textarea textbox example in php using Mysql

PHP Mysql Visitor Counter Script
Mysql PHP PHP Scripts Sample Programs

PHP Mysql Visitor Counter Script

viveik

If you want to add a counter to a web page or a website then use the below simple PHP Counter Script using MySql. It is very easy to implement it and it counts whenever a page is being refreshed and the script won’t reduce page speed, unlike page counter scripts. PHP Visitor Counter Script […]

techfolks mysql tutorials
Current Timezone of database Current Timezone of mysql Current Timezone of mysql database Current Timezone of mysql server Mysql mysql timezone query

How to Get the Current Timezone of Mysql Database

viveik

By running below query you can able to get the Current Timezone of the database server. select timediff(now(),convert_tz(now(),@@session.time_zone,’+00:00′));