Several ways to reset MySQL root password
Several ways to reset MySQL password
This post provides instructions that helps to reset MySQL root user account password, regardless of what reason you have for resetting it.
Read more…
Archive
Posts Tagged ‘mysql’
Backup and restore a single MySQL table
Dump a single table to a SQL file:
mysqldump -uuser -ppassword dbName tableName > backup.sqlEnabling InnoDB storage engine in MySQL
MySQL is capable to store data in a variety of formats. The default format is MyISAM which offers performance and it is used by most web services. InnoDB is transactional and it is used in heavy environments thanks to row-level locking.
Last days I tried to install a PHP application on server and I got the error "InnoDB storage engine is not supported".
To enable InnoDB – follow these steps:
Recent Comments