To backup MySql Database from command line. mysqldump -u user_name -p Database_Name > backup-file.sql In windows xp, 7, or 8 simply run the above command in CMD. It will place the backup-file.sql in the same direcotry where you run the command from. for more...
If you are running MySql form command line and you like to see list of all the database then simply run this command after login to the mysql show databases; this command will list all the database that are on MySql server. If you like to work with one of the database...
To login to MySql database from a commend line you can use mysql -u root -p; after hitting enter system will ask you for the password or you can use this command mysql -u root -pPassword; Once login to the database you have to select the database to work...
Here is the snytax for it. sp_fulltext_database [@action=] ‘action’ action is an argument and it’s type of varchar(20) and it could be enable or disable To turn on full text indexing in MS SQL server with sp_fulltext_database try this. USE...
If you try to change any property of an application that was build with dot net 1.1 on IIS 7 or IIS 7.5 get an error \\?\C:\Windows\system32\inetsrv\config\applicationHost.config. To fix this issue follow the instruction in this article. This is an error you will...