- The mysqldump command line program does this for you - although the docs are very unclear about this.
- One thing to note is that ~/output/dir has to be writable by the user that owns mysqld. On Mac OS X:
sudo chown -R _mysqld:_mysqld ~/output/dir mysqldump --user=dbuser --password --tab=~/output/dir dbname
- After running the above, you will have one tablename.sql file containing each table's schema create table statement) and tablename.txt file containing the data.
- If you want a dump with schema only, add the --no-data flag:
mysqldump --user=dbuser --password --no-data --tab=~/output/dir dbname
Changing Password - in AD, when you're changing one of your other accounts, not the logged in account
Use Powershell Step 1 - Put your existing password in a Secure String $oldPassword = Read-Host "Your old Password" -AsSecureString Step 2 - Start the password change set-AdAccountPassword -Identity paul-admin -OldPassword $oldPassword Step 3 - Enter your new password You'll be prompted for your new password... Please enter the desired password for 'CN=xxxx,OU=Admin Users,OU=Users,OU=Privileged,DC=CAIS,DC=com,DC=edu,DC=au' Password: ************************** Repeat Password: **************************
Comments
Post a Comment