in reply to Perl and MySql
The "-p" tells mysqldump to prompt you for the db account password. If the existing db is in use while you do this (inserts and updates are being done), you'll want to check the manual for mysqldump about additional options about locking things while the dump is in progress, so you get a coherent set of data.mysqldump -h existing.db.hostname -p -u dbusername dbname > full_db.du +mp
|
|---|