Label:When a new version of MySQL is used, the old version of MySQL is connected, and it is possible to report:ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication Protocol refUsed (client option ' Secure_auth ' enabled) this error.The reason for this is that the server-side password Management protocol is obsolete, using the old user password format storage, but the client upgrade followed by a new password format. The new version of M
1. Online Backup error:
sql> alter tablespace ZY begin backup;
Alter TABLESPACE users begin backup
*
ERROR at line 1:
Ora-01123:cannot Start online backup;media recovery not enabled
2. Find the cause of the error:Alter TABLESPACE XXX begin backup cannot be done in noarchive mode, and online backups can only be made in the Archivelog mode in which the database is located.
3. Look at the archiving situation:Sql>
Archive Log ListDatabase log mode No Arch
additions to the site configuration in httpd.conf:Addoutputfilterbytype DEFLATE text/html text/plain text/css text/xmlDeflatecompressionlevel 9Setoutputfilter DEFLATEThe first line represents what content is enabled for gzip compression, the second line represents the compression level, and the third line enables the Deflate module to gzip the output of this site (that is, to enable compression for all outputs)OK, complete pull, restart Apache httpd
Ask:
Hello, Scripting Guy! How do I know if ActiveX is enabled in Internet Explorer?
--JV
For:
Hello, JV. You must ask the question, won't you? In fact, this is not a particularly difficult question to answer, but a little complicated. However, that is closely related to how Internet Explorer is configured, and is not relevant to retrieving this information by writing a script.
First, Internet Explorer does not have a manage
Media stream It means that a business uses a video delivery server to send a program as a packet. To the network, but Windows7 system users find that when setting up a homegroup, one of the two computers that prompts "media streaming is disabled by administrator-defined Group Policy" or media stream is not enabled, how does this work?
Cause Analysis: This may be the result of the use of Third-party optimizer software accidentally disabling the Window
reused in the process of connecting to the database, and what are the differences in SQL Server?For example, if you add Pooling=false to the connection string, the connection pool is not enabled.As follows, two consecutive database accesses are performed, and two database accesses are added to the connection string Pooling=false; Indicates that connection pooling is not enabled The following is the observation of the connection action in profile,
Failure phenomenon:
How does the Optimus model identify whether a stand-alone video card is enabled?
Reason Analysis:
The new NVIDIA graphics driver has a GPU activity hint icon in the notification area to see if the Nvidia standalone video card is currently open.
Solution:
1. The desktop blank area clicks the right mouse button, chooses "The Nvidia Control Panel";
2. Select "Desktop" in the menu, check "Display GPU activity icon in
Win7 system my WiFi feature shows disabled status cannot be enabled How to do? Let's look at the detailed solution together.
Workaround:
1, first check the Device Manager, and then directly open the Microsoft Virtual Wifi miniport Adpter. If you have Microsoft Virtual Wifi miniport Adpter#2, you should also open it in time;
2, open my WiFi function, the wireless of this machine should be opened in time. If the computer has been connec
AR9344 support two uart, the usual debugging serial port is UART0, the driver is using 8250, today because the project needs to enable UART1, the configuration process needs to pay attention to several points1.9344 Gpio Port is multiplexed, can flexibly configure most of the supported features, need to find two Gpio, configured as UART1_TD and UART1_RD function (if using hardware flow control, need to find two Gpio configured as CTS and RTS)2. The driver can use AR93XX_UART.C, if not using the h
1. Check if the FTP-related RPM package is installed (if the following prompts indicate that the relevant RPM package has been installed) [email protected] ~]# which VSFTPD/usr/sbin/vsftpd[Email protected] ~]# Rpm-qa | grep vsftpdvsftpd-2.2.2-14.el6.x86_64.rpm2. If the RPM package is not installed, you can go to the mirror to install the vsftpd-2.2.2-14.el6.x86_64.rpm Package[Email protected] ~]# df-h(see which directory the image is mounted in)Filesystem Size used Avail use% mounted on/dev/
First, the questionBecause I need to play opennebula, but now I have only one notebook, how to play? Of course is vmvare, so installed a few Ubuntu virtual machine, but look at installing Opennebula premise requirements areThe host CPU installed must support virtualization, so I used the command to see if the CPU supports virtualizationCat/proc/cpuinfo | grep VMXFor example, nothing is returnedNo return indicates that the CPU does not support virtualization, that is, in the virtual machine can n
MS SQL Server 2008 When you are finished building a table, you are prompted to insert any column:When a user changes the table structure in SQL Server 2008 Enterprise Manager, you must delete the original table and re-create the new table to complete the changes to the table, and if you force the change, you will receive the following prompt: Save changes are not allowed. Your changes require that the following tables be deleted and recreated. You made changes to the label that could not be recr
Setting up a temporary session usually shows the following condition. QQ on the site as a customer service, you must set up a temporary session.
(1)
(2)
(3) or after clicking, ask to add as a friend to be able to talk.
the steps to solve this problem are as follows :
One, landed Tencent official website: http://wp.qq.com/
Second, after landing, point "settings", as shown in the figure, all tick. This must be set, not set, can not be temporary session, will show "not
It is found that three workarounds can be used to change the state of the element that is placed to disabled to Enabled.
First: Change the Boolean state of the disabled, the specific code and interpretation as follows:
Copy Code code as follows:
$ ("Button:eq (2)"). Click (function () {
var text2=$ ("Input:text:eq (2)");
if (text2.attr ("disabled") ==false) {
Set the third text input box disabled property to True by setting the B
This morning 11:35~11:40 around, due to load balance in the two cloud server CPU occupied suddenly to 100%, resulting in 5 minutes of the site can not be normal access, please bring trouble, please understand!
(The red curve in the image above indicates CPU usage)
After analysis, we confirmed that the CPU 100% problem is related to enabling Windows virtual memory.
The original two cloud servers were disabled for virtual memory, but yesterday caused the server to restart automatically due
--enable or disable all foreign KEY constraints on the specified tableAlter TableTbnameNOCHECK constraint All Alter TableTbnameCHECK constraint All--View ConstraintsSelectName, is_disabled fromSys.foreign_keysOrder byname--DisabledALTER TABLETbname DISABLETRIGGERTrigname--RecoveryALTER TABLETbname ENABLETRIGGERTrigname--disable all triggers on a tableALTER TABLETbname DISABLETRIGGER All --to enable all triggers on a tableALTER TABLETbname ENABLETRIGGER All--Add primary KeyAlter TableTbname
In the process of installing SQL Server 2012 on a Windows Server 2012 server, an error was reported, an installation failed,In the process of installing SQL 2012. The following error occurred: An error occurred while enabling Windows feature NetFx3, error code:-2146498298.Try to enable Windows features NetFx3 from Windows Management Tools, and then execute setup again.For specific information about how to enable Windows features, seelinkid=227143 "target=" _blank ">http://go.microsoft.com/fwlink
;"
Mv/data/mysql/mysql/innodb_index_stats.ibd/tmp
mv/data/mysql/mysql/innodb_table_stats.ibd/tmp
mv/data/ Mysql/mysql/gtid_slave_pos.ibd/tmp
mysql-uroot-p123456-e "use Mysql;source/root/innodb_index_stats.sql;"
Mysql-uroot-p123456-e "Use Mysql;source/root/innodb_table_stats.sql;"
Mysql-uroot-p123456-e "Use Mysql;source/root/gtid_slave_pos.sql;"
/etc/init.d/mysql restartThis article is from the "burning Years of Passion" blog, please be sure to keep this source http://liuzhengwei521.blog.51cto.co
Tags: Linux SQL Server PHPConnecting to a SQL Server 2012 databaseHttp://www.freetds.org/userguide/choosingtdsprotocol.htmDownload and install ftp://ftp.freetds.org/pub/freetds/stable/freetds-1.00.20.tar.gz./configure--prefix=/usr/local/freetds--with-tdsver=7.4--enable-msdblibMake make installVerifying version/usr/local/freetds/bin/tsql-cConnecting to a SQL Server 2012 database/usr/local/freetds/bin/tsql-h 192.168.1.200-p 1433-u username-p PasswordInstallation and expansionMssql/usr/local/php/b
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.