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

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
delete duplicate rows duplicate rows duplicate rows in mysql duplicate rows in oracle sql mysql db2 find duplicate rows in sql get duplicate rows in sql how to get duplicate rows Mysql

How to find duplicate rows in Sql or Mysql

viveik

You can find duplicate rows in the mysql table, just use below select query, to find duplicate rows in Oracle, Sql, Mysql, DB2. SELECT columnName, COUNT(*) as countFROM selectedTableGROUP BY columnNameHAVING COUNT(*) > 1; You came from below query:how to find duplicate rows in sql server 2008how to find duplicate rows in sql and deletehow […]
Mysql

alter table and make id as auto increment

viveik

ALTER TABLE internal MODIFY COLUMN id INT(32) NOT NULL auto_increment PRIMARY KEY;