Posts tagged with ‘mysql command’

Common MySQL database maintenance command

advertisement

mysql, mysql databaseThis post is a note for me to remember the common MySQL maintenance command. These MySQL maintenance command (check table, repair table, analyze table and optimize table) is very useful to ensure the MySQL database run smoothly and error free. Understanding these MySQL maintenance command will allow you to perform the right operation at the right time.

Here are the MySQL maintenance command simple brief:-

Continue reading Common MySQL database maintenance command »

How to restore MySQL database from sql dump file?

advertisement

mysql, mysql database, sql database, sql, database server, server, sql database server, mysql database server
There are 2 ways to restore your MySQL database from sql dump file.

1st way to restore mysql database from sql dump file is using mysql web control panel – phpMyAdmin
– Log into phpMyAdmin.
– Select your preference database on the left database navigation drop down list.

Continue reading How to restore MySQL database from sql dump file? »