My SQL backup From Linux Console

To schedule a mysql database backup it is necessary to take the back up from Console with out prompting pasword,
to call crom scheduler crontab
Use the following to backup to sql script
]# mysqldump -h localhost -u root -pabcd db> joomla_bup.sql

to backup in the name of dates

]# mysqldump -h localhost -u root -pabcd db> joomla_bup.sql$(date)
  • Meet Author

    S.Abhilash, started this blog in the later half of 2009 as a self hosting site for all his previous blogging attempts. , My way of writing and frequency of publishing may not be uniform as my resources are my projects nd issues i came across. For the last few years this blog is reacing 100 s of unique visitors each day, thanks wordpress and google for such a perfection in their software and services.

    Head to Authors Page | Abhilash on Facebook



Category Linux, MySQL     Tags , , , , , , , , , , , , , , , , , , , , , , , , , ,

Comment on Facebook

Comments are closed.

Community



FREE News Letter

Enter your email address

See Also

Resources

Please Submit your Email Address to Get Latest Technology News As it Happens


Enter your email address


Read previous post:
Joomla Admin page is Showing a Blank screen

Its a serious issue in joomla, happened generally when we install third party plugins and its not compatible with current installation solution...

Close