How to restore or backup database mysql by cmd (command)

Restore
mysql -u user_name -p your_password database_name < file_name.sql
 gzip -dc <database.sql.gz |mysql -u root -p databasename

Backup
mysqldump -u user_name -p your_password databasename > file_name.sql
mysqldump -u user_name -p databasename | gzip > database.sql.gz

Nguyen Si Nhan

How to: reset pass root mysql

1. Stop mysql:
# service mysqld stop
or
#killall mysql

2..mysqld_safe --skip-grant-tables
3.Access mysql without password
4.Create new mysql root password :

UPDATE mysql.user SET Password=PASSWORD('YOUR-NEW-MYSQL-PASSWORD') WHERE User='root';
FLUSH PRIVILEGES;

4.killall mysqld
5.service mysqld start


Nguyen Si Nhan

[Solved] Xenserver: You have reached the maximum number of virtual disks allowed for this virtual machine check your settings and try again

You have a problem can not add more than 3 vhd to VM windows on XenServer ,it return this error :
you have reached the maximum number of virtual disks allowed for this virtual machine
check your settings and try again


Solution :


You just need to installed Xenserver tools to this VM then you can add more than 3 vhd ,enjoy.


Nguyen Si Nhan