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
Mysql

alter table and make id as auto increment

viveik

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

techfolks php tutorials logo
General Mysql PHP

10 Mistakes Which PHP MySQL Developers Make

viveik

1. Using MyISAM rather than InnoDB MySQL has a number of database engines, but you’re most likely to encounter MyISAM and InnoDB. MyISAM is used by default. However, unless you’re creating a very simple or experimental database, it’s almost certainly the wrong choice! MyISAM doesn’t support foreign key constraints or transactions, which are essential for […]
Mysql

Decimal(5,3) in Mysql is always 99.999

viveik

The maximum value for decimal(5,3) is 99.999, it means 5 digits with 3 digits after decimal, and whenever you try to insert or update more than 99.999 value it is automatically capped to 9.99 in mysql. This Try decimal(5, 2) Decimal(5,3) is used for financial values or less than 100% values. If you want to […]