[solved] Backup

[breichert]

I've gotten cacti installed and have 90% of my setup work done. Before I go much further, what is the best way to backup the system? Both a one time backup and a recurring backup?

Thanks,

Brad

[BSOD2600]

http://docs.cacti.net/manual:088:1_inst ... ng#windows

[breichert]

I'm failing to get it backed up. I'm trying:
mysqldump -l -u[root] -p[the password I user to log into cacti] --add-drop-table cacti > mysql.cacti

I'm being told that the password is incorrect. I used the installer that had everything scripted into one install. I don't recall setting a MySQL password but maybe I did. If I reset the root password, am I going to break cacti?

Thanks,

Brad

[breichert]

I can login to the MySQL command line using the same password that I'm trying above.

What am I doing wrong?

Brad

[BSOD2600]

Try without the -p parameter so mysql prompts you instead?

[breichert]

When I try without the -p it simply gives me an error that no password was provided.

Any other ideas?

Thanks,

Brad

[BSOD2600]

Whats the exact command you're specifying? Consulted the mysql command help?

[breichert]

The command in the documentation and the post above:
mysqldump -l -u[root] -p[the password I user to log into cacti] --add-drop-table cacti > mysql.cacti

Brad

[breichert]

I followed the directions at http://dev.mysql.com/doc/mysql-windows- ... ndows.html to reset the root password for MySQL and that didn't help either. Maybe my issue isn't with the password... I don't get it.

Brad

[BSOD2600]

I think we have our self a PEBCAK

mysqladmin - dump.png (2.5 KiB) Viewed 2563 times

[breichert]

I'm happy to admit it's me but clearly I'm not smart enough to figure out what I'm doing wrong! That's why I'm asking for help.

[breichert]

The issue is that I was putting [] around the username...