Install Mysql Dump Windows
Install MySQL via MySQL Installer. To install MySQL using the MySQL installer, double-click on the MySQL installer file and follow the steps below: Install MySQL Step 1: Windows configures MySQL Installer. Install MySQL Step 2 – Welcome Screen: A welcome screen provides several options. Step 10: Choose Install MySQL as a Windows Service and Check “Include BIN Directory in Windows Path” checked as shown below. Step 11: Choose “Root” User password. This is similar to “sa” in SQL Server. Choose a very strong and Secure Password. Summary: This tutorial shows you step by step how to install MySQL on Windows platform using MySQL Installer.After the tutorial, you will have a MySQL database server and its tools up and running in your system for learning and practicing MySQL.
I am a MySQL novice but need to schedule a task to automatically back up my databases.
I have managed to create a backup manually using the following command :-
But I cannot work out how to run the command without having to manually enter my password. I have tried:--
Which appears to execute, but the resultant file is only 1kB in size. Whereas the first command generates a file that is 2661kB.
Can anyone help me?
2 Answers
Try the following command, replace 'your_password' with the root password:
Restore Mysql Dump
Even it's a old thread :) For FULL backups including users, access rights (like my case) performance_schema, functions, routines & triggers, you don't need mysqldump at all.
Download & install 7zip on your machine. Stop your mysql server.Open command prompt and use this:
For uncompressed 186MB of /data folder you will get 170KB of 7z archive.You can create a BAT file for appending current datetime to file.
Restoring means to un-compress, delete old /data folder from mysql and replace with the one from backup.
There is a minor drawback... if you forget the root password (like me) you'll have a unusable restore of databases too.
Install Mysqldump Windows
How To Install Mysql Server
That's all.
user1797147
user1797147