For backup MySQL MyISAM database, I'm using:
backupdb=siteone
mysqldump -u root -pthepass --lock-tables --add-locks --disable-keys --skip-extended-insert --quick $backupdb > /var/www/html/db2.sql
Even after long time using it, I still dont know what is the name of using nameofmychoice=anyname.
After typing backupdb=siteone I need to know how long it will kept in memory? If I running many lines of command which takes very long time, do I need to type backupdb=siteone again and again from time to time to regenerate the alias?
Is using this way really safe for almost anything? I'm worried of data loss since I'm dealing with database.
