root
(recommended)| xz
was added for compressing SQL file to .xz file.xz
at the end of the file as above.[user]
: in most cases, use root
(recommended)[Path]
and [backup_filename]
: any path and filename.xz
extension:-v
: verbose, give more infok
: to keep the compressed file, this will generated the uncompressed file .sql[database-name]
: use the name of the database that you want to backup[/path/backup-database]
and [/path/backup-user]
: any path and filenameroot
account.root
user in the old database has password different than the current mysql root
user, after step 3 above, the root
user password will be changed to the old password.If you don't know the old mysql root
password, follow this tutorial to reset mysql root password.Settings
and then click on Recreate users
. That should reactivate all users and their passwords. root
(recommended).root
(recommended).root
account.root
user in the old database has password different than the current mysql root
user, after step 3 above, the root
user password will be changed to the old password.Settings
and then click on Recreate users
. That should reactivate all users and their passwords. root
(recommended).root
(recommended).root
account.root
user in the old database has password different than the current mysql root
user, after step 3 above, the root
user password will be changed to the old password.Settings
and then click on Recreate users
. That should reactivate all users and their passwords.