Taking backup of all mysql databases >mysqldump -uroot -p –all-databases >> all_database_dump.sql; for single database mysqldump -uroot -p public_wordpressmu wp_1_posts > one.sql database import from sql file mysql –verbose -uroot -p public_wordpressmu wp_1_posts < one.sql Creating Trigger create trigger DROP … Continue reading
MySQL provides a SHOW statement that has several variant forms that display information about databases and the tables in them. SHOW is helpful for keeping track of the contents of your databases and for reminding yourself about the structure of … Continue reading
As of MySQL 4.1, the list of table types is available directly through the SHOW TABLE TYPES statement: mysql> SHOW TABLE TYPES; +——–+———+———————————————————–+ | Type | Support | Comment | +——–+———+———————————————————–+ | MyISAM | DEFAULT | Default type from 3.23 … Continue reading