How to take complete backup of mysql database using mysqldump command line utility

If you want to take a full backup i.e., all databases, procedures, routines, and events without interrupting any connections: mysqldump -u [username] -p -A -R -E –triggers –single-transaction > full_backup.sql -A For all databases (you can also use –all-databases) -R For all routines (stored procedures & triggers) -E For all events –single-transaction Without locking the … Read more

copy all files and folders from one drive to another drive using DOS (command prompt)

xcopy “C:\SomeFolderName” “D:\SomeFolderName” /h /i /c /k /e /r /y Use the above command. It will definitely work. In this command data will be copied from c:\ to D:, even folders and system files as well. Here’s what the flags do: /h copies hidden and system files also /i if destination does not exist and … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)