MySQL backup and restore
MySQL backup and restore
Backing up MySQL
mysqldump is an easy to use tool for creating MySQL backups. This tool will create a text file full of the sql statements needed to create your database as it was at the time of executing mysqldump. Please note that these files can get very big so it’s not recommended to open the backup in a text edit...
Resetting a forgotten MySQL server passwords
Change MySQL password for other users
To change a normal user password you need to type:
mysqladmin -u user-name -p old password newpass
Resetting forgotten root password
Step # 1 : Stop the MySQL service:
/etc/init.d/mysql stop
Output:
Stopping MySQL database server: mysqld.
Step # 2: Start the MySQL server w/o password:
mysqld_safe --sk...