 |
|
|
New Portfolio Site | Updated my portfolio to a new design. Most of the items on this website will be working before I go to bed tonight. Look forward to more improvements within the next couple of days.
|
Backup MySQL Database(s) with the Command Line in Windows | Making a backup through the command line is really not that hard. Open up Command Prompt and go to where mysqldump.exe is. (Program FilesMySQLMySQL Server 5.0bin) Once there give thee command:
mysqldump -u [username] -p[password] [database_name] > backup.sql
Now you should have a backup in the bin folder called backup.sql. Note that there is no space between -p and your password. If you would like to make thhe backup in another location it would look something like this.
mysqldump -u [username] -p[password] [database_name] > "C:MySQL Backupsbackup.sql"
Above I am saving my .sql backup in the folder "MySQL Backups".
If you want to make a backup.sql file with multiple databases in side of it all you need to do is add --databases and what databases you would like to back up within the .sql file. Make sure that you separate the databases by a space. Your line should look something like ...
|
|
|
|
